DBA Data[Home] [Help]

APPS.HR_PPVOL dependencies on HR_PPVOL

Line 1: package body hr_ppvol as

1: package body hr_ppvol as
2: /* $Header: pyvpymnt.pkb 120.0 2006/03/06 04:29:38 pgongada noship $ */
3: --
4: /*
5: -- Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved

Line 76: hr_utility.set_location('HR_PPVOL.ins_opm',1);

72: end if;
73: --
74: -- Get the ID of the new method
75: --
76: hr_utility.set_location('HR_PPVOL.ins_opm',1);
77: --
78: select pay_org_payment_methods_s.nextval
79: into method_id
80: from dual;

Line 84: hr_utility.set_location('HR_PPVOL.ins_opm',2);

80: from dual;
81: --
82: -- Now do the insert
83: --
84: hr_utility.set_location('HR_PPVOL.ins_opm',2);
85: --
86: insert into pay_org_payment_methods_f
87: (ORG_PAYMENT_METHOD_ID,
88: EFFECTIVE_START_DATE,

Line 574: hr_utility.set_location('HR_PPVOL.ins_payroll',1);

570:
571: payroll_id number(16);
572: begin
573: --
574: hr_utility.set_location('HR_PPVOL.ins_payroll',1);
575: --
576: select pay_payrolls_s.nextval
577: into payroll_id
578: from dual;

Line 580: hr_utility.set_location('HR_PPVOL.ins_payroll',2);

576: select pay_payrolls_s.nextval
577: into payroll_id
578: from dual;
579: --
580: hr_utility.set_location('HR_PPVOL.ins_payroll',2);
581: --
582: insert into pay_payrolls_f
583: (PAYROLL_ID,
584: EFFECTIVE_START_DATE,

Line 815: cash_opm1 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),

811: where payment_type_name = 'Cash';
812: --
813: -- Now insert the methods
814: --
815: cash_opm1 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),
816: to_date('31-12-4712','DD_MM-YYYY'),
817: business_group,
818: account1,
819: 'NVS',

Line 823: cash_opm2 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),

819: 'NVS',
820: cash_type,
821: name_prefix || 'Cash OPM 1');
822: --
823: cash_opm2 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),
824: to_date('31-12-4712','DD_MM-YYYY'),
825: business_group,
826: account2,
827: 'NVS',

Line 840: check_opm1 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),

836: where payment_type_name = 'Check';
837: --
838: -- Now insert the methods
839: --
840: check_opm1 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),
841: to_date('31-12-4712','DD_MM-YYYY'),
842: business_group,
843: account1,
844: 'NVS',

Line 848: check_opm2 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),

844: 'NVS',
845: check_type,
846: name_prefix || 'Check OPM 1');
847: --
848: check_opm2 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),
849: to_date('31-12-4712','DD_MM-YYYY'),
850: business_group,
851: account2,
852: 'NVS',

Line 865: nacs_opm1 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),

861: where payment_type_name = 'NACS';
862: --
863: -- Now insert the methods
864: --
865: nacs_opm1 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),
866: to_date('31-12-4712','DD_MM-YYYY'),
867: business_group,
868: account1,
869: 'NVS',

Line 873: nacs_opm2 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),

869: 'NVS',
870: nacs_type,
871: name_prefix || 'NACS OPM 1');
872: --
873: nacs_opm2 := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),
874: to_date('31-12-4712','DD_MM-YYYY'),
875: business_group,
876: account2,
877: 'NVS',

Line 890: cheque_opm := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),

886: where payment_type_name = 'Cheque';
887: --
888: -- Now insert the methods
889: --
890: cheque_opm := hr_ppvol.ins_opm(to_date('01-01-1990','DD-MM-YYYY'),
891: to_date('31-12-4712','DD_MM-YYYY'),
892: business_group,
893: account1,
894: 'GBP',

Line 904: payroll1 := hr_ppvol.ins_payroll(

900: cset := pay_db_pay_setup.create_consolidation_set(
901: p_consolidation_set_name => name_prefix || 'Payments set',
902: p_business_group_name => input_bg_name);
903: --
904: payroll1 := hr_ppvol.ins_payroll(
905: payroll_name=>name_prefix || 'Paym Test Payroll',
906: number_of_years=>5,
907: period_type=>'Calendar Month',
908: first_period_end_date=>to_date('31-01-1990',

Line 918: payroll2 := hr_ppvol.ins_payroll(

914: effective_end_date=>to_date('31-12-4712',
915: 'DD-MM-YYYY'),
916: business_group=>business_group);
917: --
918: payroll2 := hr_ppvol.ins_payroll(
919: payroll_name=>name_prefix || 'Paym Dummy Payroll',
920: number_of_years=>5,
921: period_type=>'Calendar Month',
922: first_period_end_date=>to_date('31-01-1990',

Line 1226: payroll_action := hr_ppvol.ins_ppa(action_type=>'P',

1222: -- Now populate a payroll action and two chunks (three assignments each) of
1223: -- assignment actions for the payments process to run off. Chunk 1 will
1224: -- have asg1-3, while chunk2 will have asg 4-6.
1225: --
1226: payroll_action := hr_ppvol.ins_ppa(action_type=>'P',
1227: business_group=>business_group,
1228: consolidation_set=>cset,
1229: payroll=>payroll1,
1230: pop_status=>'C',

Line 1238: action1 := hr_ppvol.ins_paa(assignment=>assignment1,

1234: parameters=>null);
1235: --
1236: -- Insert the first chunk
1237: --
1238: action1 := hr_ppvol.ins_paa(assignment=>assignment1,
1239: payroll_action=>payroll_action,
1240: chunk=>1);
1241: --
1242: action2 := hr_ppvol.ins_paa(assignment=>assignment2,

Line 1242: action2 := hr_ppvol.ins_paa(assignment=>assignment2,

1238: action1 := hr_ppvol.ins_paa(assignment=>assignment1,
1239: payroll_action=>payroll_action,
1240: chunk=>1);
1241: --
1242: action2 := hr_ppvol.ins_paa(assignment=>assignment2,
1243: payroll_action=>payroll_action,
1244: chunk=>1);
1245: --
1246: action3 := hr_ppvol.ins_paa(assignment=>assignment3,

Line 1246: action3 := hr_ppvol.ins_paa(assignment=>assignment3,

1242: action2 := hr_ppvol.ins_paa(assignment=>assignment2,
1243: payroll_action=>payroll_action,
1244: chunk=>1);
1245: --
1246: action3 := hr_ppvol.ins_paa(assignment=>assignment3,
1247: payroll_action=>payroll_action,
1248: chunk=>1);
1249: --
1250: -- Insert the second chunk

Line 1252: action4 := hr_ppvol.ins_paa(assignment=>assignment4,

1248: chunk=>1);
1249: --
1250: -- Insert the second chunk
1251: --
1252: action4 := hr_ppvol.ins_paa(assignment=>assignment4,
1253: payroll_action=>payroll_action,
1254: chunk=>2);
1255: --
1256: action5 := hr_ppvol.ins_paa(assignment=>assignment5,

Line 1256: action5 := hr_ppvol.ins_paa(assignment=>assignment5,

1252: action4 := hr_ppvol.ins_paa(assignment=>assignment4,
1253: payroll_action=>payroll_action,
1254: chunk=>2);
1255: --
1256: action5 := hr_ppvol.ins_paa(assignment=>assignment5,
1257: payroll_action=>payroll_action,
1258: chunk=>2);
1259: --
1260: action6 := hr_ppvol.ins_paa(assignment=>assignment6,

Line 1260: action6 := hr_ppvol.ins_paa(assignment=>assignment6,

1256: action5 := hr_ppvol.ins_paa(assignment=>assignment5,
1257: payroll_action=>payroll_action,
1258: chunk=>2);
1259: --
1260: action6 := hr_ppvol.ins_paa(assignment=>assignment6,
1261: payroll_action=>payroll_action,
1262: chunk=>2);
1263: --
1264: -- End loading of standars pre-payments test data

Line 1268: end hr_ppvol;

1264: -- End loading of standars pre-payments test data
1265: --
1266: end;
1267: --
1268: end hr_ppvol;