eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_PSPRCPGD_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 269: x_org_name hr_all_organization_units_tl.name%TYPE; x_org_id varchar2(15);

265:
266: END;
267:
268: function CF_org_reportFormula return VARCHAR2 is
269: x_org_name hr_all_organization_units_tl.name%TYPE; x_org_id varchar2(15);
270: begin
271: fnd_profile.get('PSP_ORG_REPORT', x_org_id);
272: if x_org_id is not null then
273: select name into x_org_name from hr_organization_units where organization_id = TO_NUMBER(x_org_id);

Line 319: l_org_name hr_all_organization_units_tl.name%TYPE; l_poeta VARCHAR2(360); l_gl_flex_values VARCHAR2(2000);

315: v_retcode NUMBER;
316: l_project_name VARCHAR2(30);
317: l_award_number VARCHAR2(15);
318: l_task_number VARCHAR2(300); -- Bug : 16391366 (27/03/2013)
319: l_org_name hr_all_organization_units_tl.name%TYPE; l_poeta VARCHAR2(360); l_gl_flex_values VARCHAR2(2000);
320:
321: CURSOR c_project_name
322: IS
323: SELECT ppa.name