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

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

147: The following procedure checks if the Organization passed in exists in the Prima
148: ry Hierarchy. Called in HREMEA.pll to validate the Organization Name on the Assi
149: gnment form
150: --------------------------------------------------------------------------------*/
151: PROCEDURE chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,
152: p_exists out nocopy varchar2) IS
153: l_organization_id hr_organization_units.organization_id%TYPE;
154: l_level number;
155: BEGIN

Line 153: l_organization_id hr_organization_units.organization_id%TYPE;

149: gnment form
150: --------------------------------------------------------------------------------*/
151: PROCEDURE chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,
152: p_exists out nocopy varchar2) IS
153: l_organization_id hr_organization_units.organization_id%TYPE;
154: l_level number;
155: BEGIN
156: p_exists := org_exists_in_hierarchy(p_org_id);
157: END chk_for_org_in_hierarchy;

Line 159: PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,

155: BEGIN
156: p_exists := org_exists_in_hierarchy(p_org_id);
157: END chk_for_org_in_hierarchy;
158:
159: PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
160: p_employer_name out nocopy varchar2,
161: p_business_group_id hr_organization_units.organization_id%TYPE) IS
162: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
163: p_bus_group_id hr_organization_units.organization_id%TYPE) is

Line 161: p_business_group_id hr_organization_units.organization_id%TYPE) IS

157: END chk_for_org_in_hierarchy;
158:
159: PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
160: p_employer_name out nocopy varchar2,
161: p_business_group_id hr_organization_units.organization_id%TYPE) IS
162: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
163: p_bus_group_id hr_organization_units.organization_id%TYPE) is
164: select hou.name
165: from hr_organization_units hou,

Line 162: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,

158:
159: PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
160: p_employer_name out nocopy varchar2,
161: p_business_group_id hr_organization_units.organization_id%TYPE) IS
162: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
163: p_bus_group_id hr_organization_units.organization_id%TYPE) is
164: select hou.name
165: from hr_organization_units hou,
166: hr_organization_information hoi1,

Line 163: p_bus_group_id hr_organization_units.organization_id%TYPE) is

159: PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
160: p_employer_name out nocopy varchar2,
161: p_business_group_id hr_organization_units.organization_id%TYPE) IS
162: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
163: p_bus_group_id hr_organization_units.organization_id%TYPE) is
164: select hou.name
165: from hr_organization_units hou,
166: hr_organization_information hoi1,
167: hr_organization_information hoi2

Line 165: from hr_organization_units hou,

161: p_business_group_id hr_organization_units.organization_id%TYPE) IS
162: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
163: p_bus_group_id hr_organization_units.organization_id%TYPE) is
164: select hou.name
165: from hr_organization_units hou,
166: hr_organization_information hoi1,
167: hr_organization_information hoi2
168: where (hou.business_group_id= p_bus_group_id
169: OR (hou.business_group_id=hou.organization_id and

Line 203: PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,

199: END LOOP;
200:
201: end get_employer_name;
202:
203: PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
204: p_employer_name out nocopy varchar2,
205: p_business_group_id hr_organization_units.organization_id%TYPE,
206: p_structure_version_id number) IS
207: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,

Line 205: p_business_group_id hr_organization_units.organization_id%TYPE,

201: end get_employer_name;
202:
203: PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
204: p_employer_name out nocopy varchar2,
205: p_business_group_id hr_organization_units.organization_id%TYPE,
206: p_structure_version_id number) IS
207: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
208: p_bus_group_id hr_organization_units.organization_id%TYPE) is
209: select hou.name

Line 207: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,

203: PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
204: p_employer_name out nocopy varchar2,
205: p_business_group_id hr_organization_units.organization_id%TYPE,
206: p_structure_version_id number) IS
207: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
208: p_bus_group_id hr_organization_units.organization_id%TYPE) is
209: select hou.name
210: from hr_organization_units hou,
211: hr_organization_information hoi1,

Line 208: p_bus_group_id hr_organization_units.organization_id%TYPE) is

204: p_employer_name out nocopy varchar2,
205: p_business_group_id hr_organization_units.organization_id%TYPE,
206: p_structure_version_id number) IS
207: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
208: p_bus_group_id hr_organization_units.organization_id%TYPE) is
209: select hou.name
210: from hr_organization_units hou,
211: hr_organization_information hoi1,
212: hr_organization_information hoi2

Line 210: from hr_organization_units hou,

206: p_structure_version_id number) IS
207: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
208: p_bus_group_id hr_organization_units.organization_id%TYPE) is
209: select hou.name
210: from hr_organization_units hou,
211: hr_organization_information hoi1,
212: hr_organization_information hoi2
213: where (hou.business_group_id= p_bus_group_id
214: OR (hou.business_group_id=hou.organization_id and

Line 246: FUNCTION get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,

242:
243: end get_employer_name;
244:
245:
246: FUNCTION get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
247: p_business_group_id hr_organization_units.organization_id%TYPE,
248: p_structure_version_id number default null) RETURN VARCHAR2 IS
249: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
250: p_bus_group_id hr_organization_units.organization_id%TYPE) is

Line 247: p_business_group_id hr_organization_units.organization_id%TYPE,

243: end get_employer_name;
244:
245:
246: FUNCTION get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
247: p_business_group_id hr_organization_units.organization_id%TYPE,
248: p_structure_version_id number default null) RETURN VARCHAR2 IS
249: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
250: p_bus_group_id hr_organization_units.organization_id%TYPE) is
251: select hou.name

Line 249: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,

245:
246: FUNCTION get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
247: p_business_group_id hr_organization_units.organization_id%TYPE,
248: p_structure_version_id number default null) RETURN VARCHAR2 IS
249: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
250: p_bus_group_id hr_organization_units.organization_id%TYPE) is
251: select hou.name
252: from hr_organization_units hou,
253: hr_organization_information hoi1,

Line 250: p_bus_group_id hr_organization_units.organization_id%TYPE) is

246: FUNCTION get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
247: p_business_group_id hr_organization_units.organization_id%TYPE,
248: p_structure_version_id number default null) RETURN VARCHAR2 IS
249: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
250: p_bus_group_id hr_organization_units.organization_id%TYPE) is
251: select hou.name
252: from hr_organization_units hou,
253: hr_organization_information hoi1,
254: hr_organization_information hoi2

Line 252: from hr_organization_units hou,

248: p_structure_version_id number default null) RETURN VARCHAR2 IS
249: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
250: p_bus_group_id hr_organization_units.organization_id%TYPE) is
251: select hou.name
252: from hr_organization_units hou,
253: hr_organization_information hoi1,
254: hr_organization_information hoi2
255: where (hou.business_group_id= p_bus_group_id
256: OR (hou.business_group_id=hou.organization_id and