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.PAY_US_DB_PER_SETUP dependencies on PAY_US_DB_PER_SETUP

Line 1: PACKAGE BODY pay_us_db_per_setup AS

1: PACKAGE BODY pay_us_db_per_setup AS
2: /* $Header: pyusuelt.pkb 115.7 99/07/17 06:47:16 porting ship $ */
3: /*
4: ******************************************************************
5: * *

Line 23: Name : pay_us_db_per_setup (BODY)

19: * England. *
20: * *
21: ****************************************************************** */
22: /*
23: Name : pay_us_db_per_setup (BODY)
24: Description : This package defines the procedures required to
25: create all 'set up' entities in Personnel.
26: That is:
27: Business Groups,

Line 126: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',1);

122: hr_utility.set_message_token('PARAMETER_NAME','Business Group');
123: hr_utility.raise_error;
124: end if;
125: --
126: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',1);
127: --
128: SELECT hr_organization_units_s.nextval
129: INTO l_organization_id
130: FROM sys.dual ;

Line 138: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',2);

134: --
135: hr_organization.date_range(nvl(p_date_from,trunc(SYSDATE)),p_date_to);
136: --
137: --
138: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',2);
139: --
140: INSERT INTO HR_ALL_ORGANIZATION_UNITS
141: (organization_id
142: ,business_group_id

Line 175: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',3);

171: ,0
172: ,SYSDATE
173: FROM sys.dual ;
174: --
175: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',3);
176: --
177: OPEN get_languages;
178: --
179: LOOP

Line 208: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',4);

204: FROM sys.dual ;
205: --
206: END LOOP;
207: --
208: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',4);
209: --
210: return l_organization_id;
211: --
212: --

Line 257: hr_utility.set_location('pay_us_db_per_setup.create_business_group',1);

253: --
254: begin
255: --
256: --
257: hr_utility.set_location('pay_us_db_per_setup.create_business_group',1);
258: SELECT id_flex_num
259: INTO l_position_num
260: FROM fnd_id_flex_structures_vl
261: WHERE id_flex_code = 'POS'

Line 264: hr_utility.set_location('pay_us_db_per_setup.create_business_group',2);

260: FROM fnd_id_flex_structures_vl
261: WHERE id_flex_code = 'POS'
262: AND id_flex_structure_name = p_position_structure;
263: --
264: hr_utility.set_location('pay_us_db_per_setup.create_business_group',2);
265: SELECT id_flex_num
266: INTO l_grade_num
267: FROM fnd_id_flex_structures_vl
268: WHERE id_flex_code = 'GRD'

Line 271: hr_utility.set_location('pay_us_db_per_setup.create_business_group',3);

267: FROM fnd_id_flex_structures_vl
268: WHERE id_flex_code = 'GRD'
269: AND id_flex_structure_name = p_grade_structure;
270: --
271: hr_utility.set_location('pay_us_db_per_setup.create_business_group',3);
272: SELECT id_flex_num
273: INTO l_job_num
274: FROM fnd_id_flex_structures_vl
275: WHERE id_flex_code = 'JOB'

Line 278: hr_utility.set_location('pay_us_db_per_setup.create_business_group',4);

274: FROM fnd_id_flex_structures_vl
275: WHERE id_flex_code = 'JOB'
276: AND id_flex_structure_name = p_job_structure;
277: --
278: hr_utility.set_location('pay_us_db_per_setup.create_business_group',4);
279: SELECT id_flex_num
280: INTO l_people_group_num
281: FROM fnd_id_flex_structures_vl
282: WHERE id_flex_code = 'GRP'

Line 285: hr_utility.set_location('pay_us_db_per_setup.create_business_group',5);

281: FROM fnd_id_flex_structures_vl
282: WHERE id_flex_code = 'GRP'
283: AND id_flex_structure_name = p_people_group_structure;
284: --
285: hr_utility.set_location('pay_us_db_per_setup.create_business_group',5);
286: SELECT id_flex_num
287: INTO l_cost_allocation_num
288: FROM fnd_id_flex_structures_vl
289: WHERE id_flex_code = 'COST'

Line 292: hr_utility.set_location('pay_us_db_per_setup.create_business_group',6);

288: FROM fnd_id_flex_structures_vl
289: WHERE id_flex_code = 'COST'
290: AND id_flex_structure_name = p_cost_allocation_structure;
291: --
292: hr_utility.set_location('pay_us_db_per_setup.create_business_group',6);
293: l_business_group_id := insert_organization_unit('Y'
294: ,p_name
295: ,null
296: ,null

Line 306: hr_utility.set_location('pay_us_db_per_setup.create_business_group',7);

302: ,p_internal_address_line
303: ,null);
304: --
305: --
306: hr_utility.set_location('pay_us_db_per_setup.create_business_group',7);
307: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
308: l_business_group_id
309: ,'CLASS'
310: ,'HR_BG'

Line 332: hr_utility.set_location('pay_us_db_per_setup.create_business_group',8);

328: ,null
329: ,null);
330: --
331: --
332: hr_utility.set_location('pay_us_db_per_setup.create_business_group',8);
333: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
334: l_business_group_id
335: ,'CLASS'
336: ,'HR_ORG'

Line 358: hr_utility.set_location('pay_us_db_per_setup.create_business_group',9);

354: ,null
355: ,null);
356: --
357: --
358: hr_utility.set_location('pay_us_db_per_setup.create_business_group',9);
359: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
360: l_business_group_id
361: ,'Business Group Information'
362: ,p_short_name

Line 384: hr_utility.set_location('pay_us_db_per_setup.create_business_group',10);

380: ,null
381: ,null);
382: --
383: --
384: hr_utility.set_location('pay_us_db_per_setup.create_business_group',10);
385: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
386: l_business_group_id
387: ,'Work Day Information'
388: ,p_default_start_time

Line 412: hr_utility.set_location('pay_us_db_per_setup.create_business_group',11);

408: --
409: -- Reporting Categories and Reporting Statuses are for use in VETS-100
410: -- System Test
411: --
412: hr_utility.set_location('pay_us_db_per_setup.create_business_group',11);
413: --
414: if p_employment_category_1 is not null then
415: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
416: l_business_group_id

Line 441: hr_utility.set_location('pay_us_db_per_setup.create_business_group',12);

437: ,null);
438: end if;
439: --
440: --
441: hr_utility.set_location('pay_us_db_per_setup.create_business_group',12);
442: if p_employment_category_2 is not null then
443: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
444: l_business_group_id
445: ,'Reporting Categories'

Line 469: hr_utility.set_location('pay_us_db_per_setup.create_business_group',13);

465: ,null);
466: end if;
467: --
468: --
469: hr_utility.set_location('pay_us_db_per_setup.create_business_group',13);
470: if p_assignment_status_1 is not null then
471: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
472: l_business_group_id
473: ,'Reporting Statuses'

Line 497: hr_utility.set_location('pay_us_db_per_setup.create_business_group',14);

493: ,null);
494: end if;
495: --
496: --
497: hr_utility.set_location('pay_us_db_per_setup.create_business_group',14);
498: if p_assignment_status_2 is not null then
499: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
500: l_business_group_id
501: ,'Reporting Statuses'

Line 555: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);

551: begin
552: --
553: --
554: hr_utility.trace('Entered Create_Per_Organization ');
555: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);
556: --
557: SELECT business_group_id
558: INTO l_business_group_id
559: FROM per_business_groups

Line 668: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);

664: begin
665: --
666: --
667: hr_utility.trace('Entered Create_Est_Organization ');
668: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);
669: --
670: SELECT business_group_id
671: INTO l_business_group_id
672: FROM per_business_groups

Line 838: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',1);

834: l_business_group_id NUMBER;
835: --
836: begin
837: --
838: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',1);
839: --
840: SELECT business_group_id
841: INTO l_business_group_id
842: FROM hr_all_organization_units

Line 860: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',2);

856: ,p_org_type);
857: --
858: --
859: --
860: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',2);
861: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
862: l_legal_company_id
863: ,'CLASS'
864: ,'HR_ORG'

Line 887: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',3);

883: ,null);
884: --
885: --
886: --
887: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',3);
888: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
889: l_legal_company_id
890: ,'CLASS'
891: ,'HR_LEGAL'

Line 992: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',4);

988: end if;
989: --
990: -- Modified RMAMGAIN
991: -- Modified MSWANSON 'Nacha' to 'NACHA'.
992: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',4);
993: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
994: l_legal_company_id
995: ,'NACHA Rules'
996: ,P_NACHA_COMPANY_NAME

Line 1018: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',5);

1014: ,null
1015: ,null);
1016: --
1017: -- Inserted by RMAMGAIN
1018: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',5);
1019: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1020: l_legal_company_id
1021: ,'Multiple Worksite Reporting' -- context
1022: ,'Y' -- transmitter_flag

Line 1043: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',6);

1039: ,null
1040: ,null
1041: ,null);
1042: -- Inserted By RMAMGAIN
1043: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',6);
1044: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1045: l_legal_company_id
1046: ,'W2 Reporting Rules' -- context
1047: ,'Y' -- transmitter_flag

Line 1068: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',7);

1064: ,null
1065: ,null
1066: ,null);
1067: -- Inserted by RMAMGAIN
1068: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',7);
1069: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1070: l_legal_company_id
1071: ,'Employer Identification' -- context
1072: ,P_COMPANY_FEDERAL_IDENTIFIER

Line 1093: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',8);

1089: ,null
1090: ,null
1091: ,null);
1092: -- Inserted by AKELLY
1093: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',8);
1094: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1095: l_legal_company_id
1096: ,'Work Schedule' -- context
1097: ,P_WORK_SCHEDULE_TABLE

Line 1118: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',9);

1114: ,null
1115: ,null
1116: ,null);
1117: -- Inserted by AKELLY
1118: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',9);
1119: if P_SS_SELF_ADJUST_METHOD IS NULL
1120: and P_MED_SELF_ADJUST_METHOD IS NULL
1121: and P_FUTA_SELF_ADJUST_METHOD IS NULL
1122: and P_TYPE_OF_EMPLOYMENT IS NULL

Line 1153: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);

1149: ,null);
1150: end if;
1151: --
1152: -- Inserted by MSWANSON
1153: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);
1154: --
1155: -- Inserted by MSWANSON
1156: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);
1157: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

Line 1156: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);

1152: -- Inserted by MSWANSON
1153: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);
1154: --
1155: -- Inserted by MSWANSON
1156: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);
1157: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1158: l_legal_company_id
1159: ,'EEO-1 Filing' -- context
1160: ,P_EEO1_IDENTIFICATION_NUMBER

Line 1448: hr_utility.set_location('pay_us_db_per_setup.insert_job_definition',1);

1444: l_job_definition_id NUMBER;
1445: --
1446: begin
1447: --
1448: hr_utility.set_location('pay_us_db_per_setup.insert_job_definition',1);
1449: --
1450: SELECT per_job_definitions_s.nextval
1451: INTO l_job_definition_id
1452: FROM sys.dual;

Line 1454: hr_utility.set_location('pay_us_db_per_setup.insert_job_definition',2);

1450: SELECT per_job_definitions_s.nextval
1451: INTO l_job_definition_id
1452: FROM sys.dual;
1453: --
1454: hr_utility.set_location('pay_us_db_per_setup.insert_job_definition',2);
1455: --
1456: INSERT INTO per_job_definitions
1457: (JOB_DEFINITION_ID
1458: ,ID_FLEX_NUM

Line 1544: hr_utility.set_location('pay_us_db_per_setup.insert_job',1);

1540: l_job_id NUMBER;
1541: --
1542: begin
1543: --
1544: hr_utility.set_location('pay_us_db_per_setup.insert_job',1);
1545: --
1546: SELECT per_jobs_s.nextval
1547: INTO l_job_id
1548: FROM sys.dual;

Line 1550: hr_utility.set_location('pay_us_db_per_setup.insert_job',2);

1546: SELECT per_jobs_s.nextval
1547: INTO l_job_id
1548: FROM sys.dual;
1549: --
1550: hr_utility.set_location('pay_us_db_per_setup.insert_job',2);
1551: --
1552: unique_name(l_business_group_id,l_job_id, p_name);
1553: --
1554: hr_utility.set_location('pay_us_db_per_setup.insert_job',3);

Line 1554: hr_utility.set_location('pay_us_db_per_setup.insert_job',3);

1550: hr_utility.set_location('pay_us_db_per_setup.insert_job',2);
1551: --
1552: unique_name(l_business_group_id,l_job_id, p_name);
1553: --
1554: hr_utility.set_location('pay_us_db_per_setup.insert_job',3);
1555: --
1556: INSERT INTO per_jobs
1557: (JOB_ID
1558: ,BUSINESS_GROUP_ID

Line 1595: hr_utility.set_location('pay_us_db_per_setup.create_job',1);

1591: --
1592: begin -- FUNCTION create_job
1593: --
1594: --
1595: hr_utility.set_location('pay_us_db_per_setup.create_job',1);
1596: --
1597: SELECT business_group_id
1598: , job_structure
1599: INTO l_business_group_id

Line 1724: hr_utility.set_location('pay_us_db_per_setup.insert_pos_definition',1);

1720: l_pos_definition_id NUMBER;
1721: --
1722: begin
1723: --
1724: hr_utility.set_location('pay_us_db_per_setup.insert_pos_definition',1);
1725: --
1726: SELECT per_position_definitions_s.nextval
1727: INTO l_pos_definition_id
1728: FROM sys.dual;

Line 1730: hr_utility.set_location('pay_us_db_per_setup.insert_pos_definition',2);

1726: SELECT per_position_definitions_s.nextval
1727: INTO l_pos_definition_id
1728: FROM sys.dual;
1729: --
1730: hr_utility.set_location('pay_us_db_per_setup.insert_pos_definition',2);
1731: --
1732: INSERT INTO per_position_definitions
1733: (POSITION_DEFINITION_ID
1734: ,ID_FLEX_NUM

Line 1820: hr_utility.set_location('pay_us_db_per_setup.insert_position',1);

1816: l_position_id NUMBER;
1817: --
1818: begin
1819: --
1820: hr_utility.set_location('pay_us_db_per_setup.insert_position',1);
1821: --
1822: SELECT per_positions_s.nextval
1823: INTO l_position_id
1824: FROM sys.dual;

Line 1826: hr_utility.set_location('pay_us_db_per_setup.insert_position',2);

1822: SELECT per_positions_s.nextval
1823: INTO l_position_id
1824: FROM sys.dual;
1825: --
1826: hr_utility.set_location('pay_us_db_per_setup.insert_position',2);
1827: --
1828: unique_name(l_business_group_id, l_position_id, p_name);
1829: --
1830: hr_utility.set_location('pay_us_db_per_setup.insert_position',3);

Line 1830: hr_utility.set_location('pay_us_db_per_setup.insert_position',3);

1826: hr_utility.set_location('pay_us_db_per_setup.insert_position',2);
1827: --
1828: unique_name(l_business_group_id, l_position_id, p_name);
1829: --
1830: hr_utility.set_location('pay_us_db_per_setup.insert_position',3);
1831: --
1832: INSERT INTO per_positions
1833: (POSITION_ID
1834: ,BUSINESS_GROUP_ID

Line 1892: hr_utility.set_location('pay_us_db_per_setup.create_position',1);

1888: begin -- FUNCTION create_position
1889: --
1890: --
1891: --
1892: hr_utility.set_location('pay_us_db_per_setup.create_position',1);
1893: --
1894: SELECT business_group_id
1895: , position_structure
1896: INTO l_business_group_id

Line 1902: hr_utility.set_location('pay_us_db_per_setup.create_position',2);

1898: FROM per_business_groups
1899: WHERE name = p_business_group
1900: AND business_group_id + 0 <> 0;
1901: --
1902: hr_utility.set_location('pay_us_db_per_setup.create_position',2);
1903: --
1904: SELECT job_id
1905: INTO l_job_id
1906: FROM per_jobs

Line 1910: hr_utility.set_location('pay_us_db_per_setup.create_position',3);

1906: FROM per_jobs
1907: WHERE name = p_job
1908: AND business_group_id + 0 = l_business_group_id;
1909: --
1910: hr_utility.set_location('pay_us_db_per_setup.create_position',3);
1911: --
1912: SELECT organization_id
1913: INTO l_organization_id
1914: FROM per_organization_units

Line 1920: hr_utility.set_location('pay_us_db_per_setup.create_position',4);

1916: AND business_group_id + 0 = l_business_group_id;
1917: --
1918: begin
1919: --
1920: hr_utility.set_location('pay_us_db_per_setup.create_position',4);
1921: --
1922: SELECT location_id
1923: INTO l_location_id
1924: FROM hr_locations

Line 1927: hr_utility.set_location('pay_us_db_per_setup.create_position',5);

1923: INTO l_location_id
1924: FROM hr_locations
1925: WHERE location_code = p_location;
1926: --
1927: hr_utility.set_location('pay_us_db_per_setup.create_position',5);
1928: --
1929: SELECT position_id
1930: INTO l_relief_position_id
1931: FROM per_positions

Line 1934: hr_utility.set_location('pay_us_db_per_setup.create_position',6);

1930: INTO l_relief_position_id
1931: FROM per_positions
1932: WHERE name = p_relief_position;
1933: --
1934: hr_utility.set_location('pay_us_db_per_setup.create_position',6);
1935: --
1936: SELECT position_id
1937: INTO l_successor_position_id
1938: FROM per_positions

Line 2047: hr_utility.set_location('pay_us_db_per_setup.insert_grade_definition',1);

2043: l_grade_definition_id NUMBER;
2044: --
2045: begin
2046: --
2047: hr_utility.set_location('pay_us_db_per_setup.insert_grade_definition',1);
2048: --
2049: SELECT per_grade_definitions_s.nextval
2050: INTO l_grade_definition_id
2051: FROM sys.dual;

Line 2053: hr_utility.set_location('pay_us_db_per_setup.insert_grade_definition',2);

2049: SELECT per_grade_definitions_s.nextval
2050: INTO l_grade_definition_id
2051: FROM sys.dual;
2052: --
2053: hr_utility.set_location('pay_us_db_per_setup.insert_grade_definition',2);
2054: --
2055: INSERT INTO per_grade_definitions
2056: (GRADE_DEFINITION_ID
2057: ,ID_FLEX_NUM

Line 2143: hr_utility.set_location('pay_us_db_per_setup.insert_grade',1);

2139: l_grade_id NUMBER;
2140: --
2141: begin
2142: --
2143: hr_utility.set_location('pay_us_db_per_setup.insert_grade',1);
2144: --
2145: SELECT per_grades_s.nextval
2146: INTO l_grade_id
2147: FROM sys.dual;

Line 2149: hr_utility.set_location('pay_us_db_per_setup.insert_grade',2);

2145: SELECT per_grades_s.nextval
2146: INTO l_grade_id
2147: FROM sys.dual;
2148: --
2149: hr_utility.set_location('pay_us_db_per_setup.insert_grade',2);
2150: --
2151: unique_name(l_business_group_id, l_grade_id, p_name);
2152: --
2153: hr_utility.set_location('pay_us_db_per_setup.insert_grade',3);

Line 2153: hr_utility.set_location('pay_us_db_per_setup.insert_grade',3);

2149: hr_utility.set_location('pay_us_db_per_setup.insert_grade',2);
2150: --
2151: unique_name(l_business_group_id, l_grade_id, p_name);
2152: --
2153: hr_utility.set_location('pay_us_db_per_setup.insert_grade',3);
2154: --
2155: INSERT INTO per_grades
2156: (GRADE_ID
2157: ,BUSINESS_GROUP_ID

Line 2192: hr_utility.set_location('pay_us_db_per_setup.create_grade',1);

2188: --
2189: begin -- FUNCTION create_grade
2190: --
2191: --
2192: hr_utility.set_location('pay_us_db_per_setup.create_grade',1);
2193: --
2194: SELECT business_group_id
2195: , grade_structure
2196: INTO l_business_group_id

Line 2413: l_wc_carrier_id := pay_us_db_per_setup.insert_organization_unit

2409: INTO l_business_group_id
2410: FROM per_business_groups
2411: WHERE name = p_business_group;
2412: --
2413: l_wc_carrier_id := pay_us_db_per_setup.insert_organization_unit
2414: ('N'
2415: ,p_name
2416: ,l_business_group_id
2417: ,null

Line 2459: end pay_us_db_per_setup;

2455: --
2456: end create_wc_carrier;
2457: --
2458: --
2459: end pay_us_db_per_setup;