[Home] [Help]
69: PROCEDURE range_cursor (pactid in number,
70: sqlstr out nocopy varchar2) is
71:
72: --
73: leg_param pay_payroll_actions.legislative_parameters%type;
74:
75: l_business_group_id number;
76: l_consolidation_set_id number;
77: l_payroll_id number;
88:
89: begin
90: select legislative_parameters
91: into leg_param
92: from pay_payroll_actions ppa
93: where ppa.payroll_action_id = pactid;
94:
95: -- pay_process := pay_payact_pkg.get_parameter('P_P_TY',leg_param);
96:
113: l_person_id,
114: l_leg_start_date,
115: l_leg_end_date,
116: l_business_group_id
117: from pay_payroll_actions ppa
118: where ppa.payroll_action_id = pactid;
119:
120: IF l_consolidation_set_id is not null THEN
121:
168: -- for payroll and consolidation set
169:
170: sqlstr :=
171: 'select distinct asg.person_id
172: from pay_payroll_actions ppa,
173: pay_payroll_actions pa1,
174: pay_assignment_actions act,
175: per_assignments_f asg
176: where ppa.payroll_action_id = :payroll_action_id
169:
170: sqlstr :=
171: 'select distinct asg.person_id
172: from pay_payroll_actions ppa,
173: pay_payroll_actions pa1,
174: pay_assignment_actions act,
175: per_assignments_f asg
176: where ppa.payroll_action_id = :payroll_action_id
177: '||l_consolidation_set_text||'
214: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
215: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
216: ppa.start_date start_date,
217: ppa.effective_date effective_date
218: from pay_payroll_actions ppa
219: where ppa.payroll_action_id = pactid;
220:
221:
222: -- Bug 3372732 : All cursors defined below are changed
241: act.assignment_id,
242: act.tax_unit_id
243: from pay_assignment_actions act,
244: per_assignments_f paf,
245: pay_payroll_actions ppa, /* pre-payments and reversals
246: payroll action id */
247: pay_payrolls_f ppf -- Bug 3372732
248: where ppa.payroll_id = nvl(c_payroll_id,ppa.payroll_id)
249: and ppa.consolidation_set_id + 0 = nvl(c_consolidation_set_id,
297: act.assignment_id,
298: act.tax_unit_id
299: from pay_assignment_actions act,
300: per_assignments_f paf,
301: pay_payroll_actions ppa, /* pre-payments and reversals payroll action id */
302: pay_payrolls_f ppf -- Bug 3372732
303: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)
304: and ppa.consolidation_set_id +0 =
305: nvl(c_consolidation_set_id, ppa.consolidation_set_id)
352: act.assignment_id,
353: act.tax_unit_id
354: from pay_assignment_actions act,
355: per_assignments_f paf,
356: pay_payroll_actions ppa, /* pre-payments and reversals payroll action id */
357: pay_payrolls_f ppf -- Bug 3372732
358: where ppa.payroll_id =
359: nvl(c_payroll_id, ppa.payroll_id)
360: and ppa.consolidation_set_id +0 =
407: act.assignment_id,
408: act.tax_unit_id
409: from pay_assignment_actions act,
410: per_assignments_f paf,
411: pay_payroll_actions ppa, /* pre-payments and reversals */
412: /* payroll action id */
413: pay_payrolls_f ppf -- Bug 3372732
414: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)
415: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,
462: act.assignment_id,
463: act.tax_unit_id
464: from pay_assignment_actions act,
465: per_assignments_f paf,
466: pay_payroll_actions ppa, /* pre-payments and */
467: /* reversals payroll action id */
468: pay_payrolls_f ppf -- Bug 3372732
469: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)
470: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,
517: act.assignment_id,
518: act.tax_unit_id
519: from pay_assignment_actions act,
520: per_assignments_f paf,
521: pay_payroll_actions ppa, /* pre-payments and */
522: /* reversals payroll action id */
523: pay_payrolls_f ppf
524: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)
525: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,
571: act.assignment_id,
572: act.tax_unit_id
573: from pay_assignment_actions act,
574: per_assignments_f paf,
575: pay_payroll_actions ppa, /* pre-payments and */
576: /* reversals payroll action id */
577: pay_payrolls_f ppf -- Bug 3372732
578: where ppa.payroll_id =
579: nvl(c_payroll_id, ppa.payroll_id)
626: act.assignment_id,
627: act.tax_unit_id
628: from pay_assignment_actions act,
629: per_assignments_f paf,
630: pay_payroll_actions ppa, /* pre-payments and */
631: /* reversals payroll action id */
632: pay_payrolls_f ppf
633: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)
634: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id ,ppa.consolidation_set_id)
670: num number;
671: process_type varchar2(20);
672:
673: -- Bug 3372732
674: leg_param pay_payroll_actions.legislative_parameters%type;
675: ass_set_id number;
676: ass_flag varchar2(2);
677:
678: --
675: ass_set_id number;
676: ass_flag varchar2(2);
677:
678: --
679: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
680: l_location_id per_all_assignments_f.location_id%TYPE;
681: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
682: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
683: l_person_id per_all_assignments_f.person_id%TYPE;
677:
678: --
679: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
680: l_location_id per_all_assignments_f.location_id%TYPE;
681: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
682: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
683: l_person_id per_all_assignments_f.person_id%TYPE;
684: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
685: l_organization_id per_all_assignments_f.organization_id%TYPE;
682: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
683: l_person_id per_all_assignments_f.person_id%TYPE;
684: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
685: l_organization_id per_all_assignments_f.organization_id%TYPE;
686: l_start_date pay_payroll_actions.effective_date%TYPE;
687: l_effective_date pay_payroll_actions.effective_date%TYPE;
688:
689: -- algorithm is quite similar to the other process cases,
690: -- but we have to take into account assignments and
683: l_person_id per_all_assignments_f.person_id%TYPE;
684: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
685: l_organization_id per_all_assignments_f.organization_id%TYPE;
686: l_start_date pay_payroll_actions.effective_date%TYPE;
687: l_effective_date pay_payroll_actions.effective_date%TYPE;
688:
689: -- algorithm is quite similar to the other process cases,
690: -- but we have to take into account assignments and
691: -- personal payment methods.
693:
694: hr_utility.set_location('procpyr',1);
695:
696: select legislative_parameters into leg_param
697: from pay_payroll_actions
698: where payroll_action_id = pactid;
699:
700: -- Bug 3372732:Fetching the Input parameters that are passed to other cursors
701: open c_inputs(pactid);
1289: -- Cursor to get legislative parameters for Payroll Activity
1290: -- Bug 3037633
1291: cursor cur_leg_params(pactid varchar2) is
1292: select legislative_parameters
1293: from pay_payroll_actions
1294: where payroll_action_id = pactid;
1295:
1296: leg_params pay_payroll_actions.legislative_parameters%type;
1297: begin
1292: select legislative_parameters
1293: from pay_payroll_actions
1294: where payroll_action_id = pactid;
1295:
1296: leg_params pay_payroll_actions.legislative_parameters%type;
1297: begin
1298: sqlstr := 'select paa.rowid
1299: /* we need the row id of the assignment actions
1300: that are created by PYUGEN */
1303: hr_locations_all loc,
1304: per_all_people_f ppf,
1305: per_all_assignments_f paf,
1306: pay_assignment_actions paa, /* PYUGEN assignment action */
1307: pay_payroll_actions ppa, /* PYUGEN payroll action id */
1308: pay_assignment_actions paa1, /*For Sorting */
1309: pay_action_interlocks pai,
1310: pay_payroll_actions ppa1 /*For Sorting */
1311: where ppa.payroll_action_id = :payactid
1306: pay_assignment_actions paa, /* PYUGEN assignment action */
1307: pay_payroll_actions ppa, /* PYUGEN payroll action id */
1308: pay_assignment_actions paa1, /*For Sorting */
1309: pay_action_interlocks pai,
1310: pay_payroll_actions ppa1 /*For Sorting */
1311: where ppa.payroll_action_id = :payactid
1312: and paa.payroll_action_id = ppa.payroll_action_id
1313: and paf.assignment_id = paa.assignment_id
1314: and paf.effective_start_date =
1389: parameter_list varchar2) return varchar2
1390: is
1391: start_ptr number;
1392: end_ptr number;
1393: token_val pay_payroll_actions.legislative_parameters%type;
1394: par_value pay_payroll_actions.legislative_parameters%type;
1395: begin
1396: --
1397: token_val := name||'=';
1390: is
1391: start_ptr number;
1392: end_ptr number;
1393: token_val pay_payroll_actions.legislative_parameters%type;
1394: par_value pay_payroll_actions.legislative_parameters%type;
1395: begin
1396: --
1397: token_val := name||'=';
1398: --