DBA Data[Home] [Help]

APPS.PAY_US_DB_PER_SETUP dependencies on PAY_US_INS_ORG_INFO_PKG

Line 67: pay_us_ins_org_info_pkg

63: ****
64: 40.0 31-MAY-94 MGILMORE Renamed.
65: 40.1 03-JUL-94 AROUSSEL Tidyied up for 10G install
66: 40.2 05-OCT-94 RFINE Changed calls from us_ins_org_info to
67: pay_us_ins_org_info_pkg
68: 40.3 24-NOV-94 RFINE Suppressed index on business_group_id
69: 40.4 01-MAR-95 MSWANSON Add/Change for EEO and VETS100 system
70: test data creation:
71: - create_est_organization,

Line 307: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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'
311: ,'Y'

Line 333: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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'
337: ,'Y'

Line 359: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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
363: ,p_method_of_generation_emp_num

Line 385: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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
389: ,p_default_end_time

Line 415: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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
417: ,'Reporting Categories'
418: ,p_employment_category_1
419: ,null

Line 443: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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'
446: ,p_employment_category_2
447: ,null

Line 471: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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'
474: ,p_assignment_status_1
475: ,null

Line 499: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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'
502: ,p_assignment_status_2
503: ,null

Line 577: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(l_organization_id

573: hr_utility.trace('Called insert_information_unit from CPO');
574: --
575: --
576: --
577: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(l_organization_id
578: ,'CLASS'
579: ,'HR_ORG'
580: ,'Y'
581: ,null

Line 605: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(l_organization_id

601: --
602: --
603: hr_utility.trace('p_default_start_time '||p_default_start_time);
604:
605: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(l_organization_id
606: ,'Work Day Information'
607: ,p_default_start_time
608: ,p_default_end_time
609: ,p_working_hours

Line 689: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

685: ,p_type);
686: hr_utility.trace('Called insert_information_unit from CEO');
687: --
688: -- Add new classification : HR_ESTAB
689: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
690: l_organization_id
691: ,'CLASS'
692: ,'HR_ESTAB'
693: ,'Y'

Line 714: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information

710: ,null
711: ,null);
712: --
713: --
714: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information
715: (l_organization_id
716: ,'CLASS'
717: ,'HR_ORG'
718: ,'Y'

Line 739: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information

735: ,null
736: ,null);
737: hr_utility.trace('Called insert_org_information once from CEO');
738: --
739: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information
740: (l_organization_id
741: ,'Establishment EEO-1 Filing'
742: ,'Y'
743: ,p_eeo1_unit_number

Line 763: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information

759: ,null
760: ,null
761: ,null);
762: if p_vets100_unit_number is not null then
763: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information
764: (l_organization_id
765: ,'Establishment VETS-100 Filing'
766: ,p_vets100_unit_number
767: ,p_vets100_reporting_name

Line 861: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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'
865: ,'Y'

Line 888: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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'
892: ,'Y'

Line 917: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

913: if P_NAME = 'Swanson I.T.' then
914: --
915: -- Add new classification : HR_ESTAB this org is a GRE/EST combo
916: --
917: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
918: l_legal_company_id
919: ,'CLASS'
920: ,'HR_ESTAB'
921: ,'Y'

Line 941: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

937: ,null
938: ,null
939: ,null);
940: --
941: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
942: l_legal_company_id
943: ,'Establishment EEO-1 Filing' -- context
944: ,null -- used to be Establishment flag
945: ,P_EEO1_UNIT_NUMBER

Line 965: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

961: ,null
962: ,null
963: ,null);
964: -- Enter row for VETS-100
965: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
966: l_legal_company_id
967: ,'Establishment VETS-100 Filing' -- context
968: ,P_VETS100_UNIT_NUMBER
969: ,null

Line 993: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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
997: ,'220'

Line 1019: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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
1023: ,'Contact Person1' -- position

Line 1044: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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
1048: ,'SEQUENT' -- computer

Line 1069: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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
1073: ,P_COMPANY_FEDERAL_IDENTIFIER

Line 1094: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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
1098: ,P_WORK_SCHEDULE_TABLE

Line 1127: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

1123: and P_TAX_GROUP IS NULL
1124: and P_SUPPLEMENTAL_CALC_METHOD IS NULL then
1125: null;
1126: else
1127: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1128: l_legal_company_id
1129: ,'Federal Tax Rules' -- context
1130: ,P_SS_SELF_ADJUST_METHOD
1131: ,P_MED_SELF_ADJUST_METHOD

Line 1157: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

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
1161: ,P_DUN_AND_BRADSTREET_NUMBER

Line 1183: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

1179: ,null);
1180: --
1181: -- Add data for VETS-100
1182: --
1183: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1184: l_legal_company_id
1185: ,'VETS-100 Filing' -- context
1186: ,P_VETS100_COMPANY_NUMBER
1187: ,null

Line 1337: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

1333: IS
1334: l_org_information_id NUMBER;
1335: --
1336: begin
1337: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1338: p_legal_company_id
1339: ,'State Tax Rules' -- context
1340: ,p_state_code
1341: ,p_sui_company_state_id

Line 2428: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information

2424: ,p_type);
2425: hr_utility.trace('Called insert_information_unit from create_wc_carrier');
2426: --
2427: --
2428: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information
2429: (l_wc_carrier_id
2430: ,'CLASS'
2431: ,'US_WC_CARRIER'
2432: ,'Y'