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_NL_ORG_INFO dependencies on HR_ORGANIZATION_UNITS

Line 27: FUNCTION check_org_in_region (p_org_id in hr_organization_units.organization_id%TYPE,

23: -- Function checks to see if organization region is same as the passed region
24: -- and returns Organization ID if it is found else returns NULL
25: -- It checks the Named Org Hierarchy to check if belongs to the same region from the Org Hierarchy
26: --
27: FUNCTION check_org_in_region (p_org_id in hr_organization_units.organization_id%TYPE,
28: p_region in varchar2) RETURN hr_organization_units.organization_id%TYPE;
29: --
30: --The following procedure checks if the Organization passed in exists in the Primary Hierarchy.
31: --

Line 28: p_region in varchar2) RETURN hr_organization_units.organization_id%TYPE;

24: -- and returns Organization ID if it is found else returns NULL
25: -- It checks the Named Org Hierarchy to check if belongs to the same region from the Org Hierarchy
26: --
27: FUNCTION check_org_in_region (p_org_id in hr_organization_units.organization_id%TYPE,
28: p_region in varchar2) RETURN hr_organization_units.organization_id%TYPE;
29: --
30: --The following procedure checks if the Organization passed in exists in the Primary Hierarchy.
31: --
32: PROCEDURE chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,

Line 32: PROCEDURE chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,

28: p_region in varchar2) RETURN hr_organization_units.organization_id%TYPE;
29: --
30: --The following procedure checks if the Organization passed in exists in the Primary Hierarchy.
31: --
32: PROCEDURE chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,
33: p_exists out nocopy varchar2);
34: --
35: --
36: -- Procedure returns the Region and Org. Number for the Named Org Hierarchy

Line 120: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;

116: FUNCTION Get_Parental_Leave_Wage_Perc(p_assignment_id NUMBER) RETURN NUMBER;
117: -- Function which returns the customer number for the given organization
118: -- If the value is not specified for the given organization it performs the tree walk.
119: FUNCTION Get_customer_number
120: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;
121: -- Function which returns Reporting Frequency for the given organization
122: -- If the value is not specified for the given organization it performs the tree walk.
123: FUNCTION Get_Reporting_Frequency
124: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;

Line 124: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;

120: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;
121: -- Function which returns Reporting Frequency for the given organization
122: -- If the value is not specified for the given organization it performs the tree walk.
123: FUNCTION Get_Reporting_Frequency
124: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;
125: -- Function which returns Public Sector Org for the given organization
126: -- If the value is not specified for the given organization it performs the tree walk.
127: FUNCTION Get_Public_Sector_Org
128: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;

Line 128: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;

124: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;
125: -- Function which returns Public Sector Org for the given organization
126: -- If the value is not specified for the given organization it performs the tree walk.
127: FUNCTION Get_Public_Sector_Org
128: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;
129: -- Function which returns company unit for the given organization
130: -- If the value is not specified for the given organization it performs the tree walk.
131: FUNCTION Get_company_unit
132: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;

Line 132: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;

128: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;
129: -- Function which returns company unit for the given organization
130: -- If the value is not specified for the given organization it performs the tree walk.
131: FUNCTION Get_company_unit
132: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;
133: -- Function which returns Full Sickness Wage Paid Indicator for the given organization
134: -- If the value is not specified for the given organization it performs the tree walk.
135: FUNCTION Get_Full_Sickness_Wage_Paid
136: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;

Line 136: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;

132: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;
133: -- Function which returns Full Sickness Wage Paid Indicator for the given organization
134: -- If the value is not specified for the given organization it performs the tree walk.
135: FUNCTION Get_Full_Sickness_Wage_Paid
136: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2;
137: -- Function which returns IZA Weekly Full Time Hours for the given organization
138: -- If the value is not specified for the given organization it performs the tree walk.
139: FUNCTION Get_IZA_Weekly_Full_Hours
140: (p_assignment_id in NUMBER ) RETURN Varchar2;