Oracle Apps R12 Technical Related Scripts

create or replace function fin_year(date1 date) return varchar2 as fin_yr varchar2(200) :=null; begin   if (to_char(date1,'MM')<=3)    then fin_yr :=' APR '||to_char(to_char(date1,'YYYY')-1)||' - '||' MAR '||to_char(to_char(date1,'YYYY'));   else         fin_yr := ' APR '||to_char(to_char(date1,'YYYY'))||' - '||' MAR '||to_char(to_char(date1,'YYYY')+1);     end if;   return(fin_yr); end fin_year; / select fin_year(sysdate) from dual;

begin fnd_program.delete_program('SHORTNAME','APPLICATION'); fnd_program.delete_executable('SHORTNAME','APPLICATION'); end;

 select organization_id   from hr_operating_units where name = :p_name; exec mo_global.set_policy_context('S',:p_org_id); select u.user_id user_id, r.responsibility_id resp_id,        r.application_id resp_appl_id, r.responsibility_key,        sg.security_group_id security_group_id   from fnd_user u,        fnd_user_resp_groups ur,        fnd_responsibility r,        fnd_security_groups sg  where u.user_name          = :p_user_name    and r.responsibility_key = :p_responsibility_name    and ur.responsibility_id = r.responsibility_id    and ur.user_id           = u.user_id    and ur.security_group_id = sg.security_group_id; begin   fnd_global.apps_initialize     (  user_id                ...

select  ffvv.flex_value   from  fnd_flex_values_vl ffvv,fnd_flex_value_sets ffvs  where  ffvs.flex_value_set_name = :p_value_set_name    and  ffvv.flex_value_set_id   = ffvs.flex_value_set_id    and  ffvv.enabled_flag        = 'Y'  order by 1

select   fa.application_id "Application ID",             fat.application_name "Application Name",             fa.application_short_name "Application Short Name",             fa.basepath "Basepath"    from fnd_application fa, fnd_application_tl fat  where fa.application_id  = fat.application_id      and fat.language         = userenv ('LANG') order by fat.application_name;