223: SELECT HOU.name
224: FROM HR_OPERATING_UNITS HOU
225: WHERE HOU.organization_id = p_org_id;
226:
227: l_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
228:
229: l_org_name VARCHAR2(300);
230: l_orcl_logo VARCHAR2(300);
231: l_term_heading VARCHAR2(300);
682: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
683: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
684: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
685: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
686: mo_global.get_current_org_id()
687: FROM DUAL;
688:
689: CURSOR c_app_info IS
690: SELECT APPLICATION_ID
1600: FROM HR_OPERATING_UNITS HOU
1601: WHERE HOU.organization_id = p_org_id;
1602:
1603:
1604: l_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
1605:
1606: l_org_name VARCHAR2(300);
1607: l_orcl_logo VARCHAR2(300);
1608: l_term_heading VARCHAR2(300);