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.HR_FULL_SYNC_MESSAGES dependencies on HR_ALL_ORGANIZATION_UNITS

Line 876: p_bg_id hr_all_organization_units.business_group_id%type;

872: /*Procedure to extract the organization data for full synch process begins*/
873: procedure hr_organizaton_full_sync(errbuf OUT NOCOPY VARCHAR2
874: ,retcode OUT NOCOPY VARCHAR2)
875: is
876: p_bg_id hr_all_organization_units.business_group_id%type;
877: p_dept_id hr_all_organization_units.organization_id%type;
878: p_eff_date date;
879: p_loc_id hr_all_organization_units.location_id%type;
880: p_person_id per_org_manager_v.person_id%type;

Line 877: p_dept_id hr_all_organization_units.organization_id%type;

873: procedure hr_organizaton_full_sync(errbuf OUT NOCOPY VARCHAR2
874: ,retcode OUT NOCOPY VARCHAR2)
875: is
876: p_bg_id hr_all_organization_units.business_group_id%type;
877: p_dept_id hr_all_organization_units.organization_id%type;
878: p_eff_date date;
879: p_loc_id hr_all_organization_units.location_id%type;
880: p_person_id per_org_manager_v.person_id%type;
881: p_full_name per_org_manager_v.full_name%type;

Line 879: p_loc_id hr_all_organization_units.location_id%type;

875: is
876: p_bg_id hr_all_organization_units.business_group_id%type;
877: p_dept_id hr_all_organization_units.organization_id%type;
878: p_eff_date date;
879: p_loc_id hr_all_organization_units.location_id%type;
880: p_person_id per_org_manager_v.person_id%type;
881: p_full_name per_org_manager_v.full_name%type;
882: p_bg_name hr_all_organization_units.name%type;
883: p_eff_status varchar2(10);

Line 882: p_bg_name hr_all_organization_units.name%type;

878: p_eff_date date;
879: p_loc_id hr_all_organization_units.location_id%type;
880: p_person_id per_org_manager_v.person_id%type;
881: p_full_name per_org_manager_v.full_name%type;
882: p_bg_name hr_all_organization_units.name%type;
883: p_eff_status varchar2(10);
884: p_effective_date date default sysdate;
885:
886: cursor fet_org_fsync is

Line 897: from hr_all_organization_units org

893: org.name,
894: org.location_id,
895: mgr.person_id,
896: mgr.full_name
897: from hr_all_organization_units org
898: ,per_org_manager_v mgr,hr_organization_information hrorg
899: where org.business_group_id = mgr.business_group_id(+)
900: and org.organization_id = mgr.organization_id(+)
901: and hrorg.organization_id = org.organization_id