[Home] [Help]
82: NAME
83: get_next_pop_chunk - Get the Next Popultaion chunk by Sequence
84: DESCRIPTION
85: Locks and returns person range information from
86: pay_population_ranges. This is used to insert
87: a chunk of assignments at a time.
88: NOTES
89:
90: */
145: into stperson,
146: endperson,
147: chunk,
148: rand_chunk
149: from pay_population_ranges rge
150: where rge.payroll_action_id = pactid
151: and rge.range_status = 'U'
152: and rownum < 2;
153: found := TRUE;
169: norows := FALSE;
170: --
171: select null
172: into dummy
173: from pay_population_ranges rge
174: where rge.payroll_action_id = pactid
175: and rownum < 2;
176: --
177: exception
300: stperson,
301: endperson,
302: chunk,
303: rand_chunk
304: from pay_population_ranges rge
305: where rge.payroll_action_id = pactid
306: and rge.chunk_number = p_next_chunk
307: and rownum = 1;
308: --
415: norows := FALSE;
416: --
417: select null
418: into dummy
419: from pay_population_ranges rge
420: where rge.payroll_action_id = pactid
421: and rownum < 2;
422: --
423: exception
589: NAME
590: get_next_pop_chunk - Get the Next Popultaion chunk to process
591: DESCRIPTION
592: Locks and returns person range information from
593: pay_population_ranges. This is used to insert
594: a chunk of assignments at a time.
595: NOTES
596:
597: */
1001: NAME
1002: get_next_proc_chunk - Get the Next Process chunk to process
1003: DESCRIPTION
1004: Locks and returns person range information from
1005: pay_population_ranges. This is used to insert
1006: a chunk of assignments at a time.
1007: NOTES
1008: There is a COMMIT in this procedure to release
1009: the locks and update tables.
1075: NAME
1076: rangerow - return info from range row.
1077: DESCRIPTION
1078: Locks and returns person range information from
1079: pay_population_ranges. This is used to insert
1080: a chunk of assignments at a time.
1081:
1082: This is a cover for get_next_pop_chunk
1083: NOTES
1428: ppp.pre_payment_id
1429: from pay_payroll_actions pa1,
1430: pay_payroll_actions pa2,
1431: pay_action_classifications pcl,
1432: pay_population_ranges pop,
1433: per_periods_of_service pos,
1434: per_all_assignments_f as1,
1435: pay_assignment_actions act,
1436: per_all_assignments_f as2,
1576: act.assignment_id,
1577: act.tax_unit_id,
1578: ppp.pre_payment_id
1579: from pay_payroll_actions pa1,
1580: pay_population_ranges pop,
1581: per_periods_of_service pos,
1582: per_all_assignments_f as1,
1583: pay_assignment_actions act,
1584: pay_payroll_actions pa2,
1777: act.tax_unit_id
1778: from pay_payroll_actions pa1,
1779: pay_payroll_actions pa2,
1780: pay_action_classifications pcl,
1781: pay_population_ranges pop,
1782: per_periods_of_service pos,
1783: per_all_assignments_f as1,
1784: pay_assignment_actions act
1785: where pa1.payroll_action_id = pactid
1914: ppp.pre_payment_id
1915: from pay_payroll_actions pa1,
1916: pay_payroll_actions pa2,
1917: pay_action_classifications pcl,
1918: pay_population_ranges pop,
1919: hr_organization_units hou,
1920: pay_pre_payments ppp,
1921: pay_org_payment_methods_f opm,
1922: pay_contributing_payments pcp
2066: as1.payroll_id
2067: from pay_payroll_actions pa1,
2068: pay_payroll_actions pa2,
2069: pay_action_classifications pcl,
2070: pay_population_ranges pop,
2071: per_periods_of_service pos,
2072: per_all_assignments_f as1,
2073: pay_assignment_actions act,
2074: pay_pre_payments ppp,
2240: ppp.pre_payment_id,
2241: pa1.assignment_set_id,
2242: as1.payroll_id
2243: from pay_payroll_actions pa1,
2244: pay_population_ranges pop,
2245: per_periods_of_service pos,
2246: per_all_assignments_f as1,
2247: pay_assignment_actions act,
2248: pay_payroll_actions pa2,
2487: ppp.pre_payment_id
2488: from pay_payroll_actions pa1,
2489: pay_payroll_actions pa2,
2490: pay_action_classifications pcl,
2491: pay_population_ranges pop,
2492: per_periods_of_service pos,
2493: per_all_assignments_f as1,
2494: pay_assignment_actions act,
2495: per_all_assignments_f as2,
2659: act.assignment_id,
2660: act.tax_unit_id,
2661: ppp.pre_payment_id
2662: from pay_payroll_actions pa1,
2663: pay_population_ranges pop,
2664: per_periods_of_service pos,
2665: per_all_assignments_f as1,
2666: pay_assignment_actions act,
2667: pay_payroll_actions pa2,
2834: as1.primary_flag
2835: from pay_payroll_actions pa1,
2836: pay_payroll_actions pa2,
2837: pay_action_classifications pcl,
2838: pay_population_ranges pop,
2839: per_periods_of_service pos,
2840: per_all_assignments_f as1,
2841: pay_assignment_actions act,
2842: per_all_assignments_f as2
2976: as1.person_id,
2977: as1.effective_start_date,
2978: as1.primary_flag
2979: from pay_payroll_actions pa1,
2980: pay_population_ranges pop,
2981: per_periods_of_service pos,
2982: per_all_assignments_f as1,
2983: pay_assignment_actions act,
2984: pay_payroll_actions pa2,
3147: act.tax_unit_id
3148: from pay_payroll_actions pa1,
3149: pay_payroll_actions pa2,
3150: pay_action_classifications pcl,
3151: pay_population_ranges pop,
3152: per_periods_of_service pos,
3153: per_all_assignments_f as1,
3154: pay_assignment_actions act,
3155: per_all_assignments_f as2
3277: act.assignment_action_id,
3278: act.assignment_id,
3279: act.tax_unit_id
3280: from pay_payroll_actions pa1,
3281: pay_population_ranges pop,
3282: per_periods_of_service pos,
3283: per_all_assignments_f as1,
3284: pay_assignment_actions act,
3285: pay_payroll_actions pa2,
3422: act.payroll_action_id
3423: from pay_payroll_actions pa1,
3424: pay_payroll_actions pa2,
3425: pay_action_classifications pcl,
3426: pay_population_ranges pop,
3427: per_periods_of_service pos,
3428: per_all_assignments_f as1,
3429: pay_assignment_actions act,
3430: per_all_assignments_f as2
3696: act.assignment_id,
3697: act.tax_unit_id,
3698: act.payroll_action_id
3699: from pay_payroll_actions pa1,
3700: pay_population_ranges pop,
3701: per_periods_of_service pos,
3702: per_all_assignments_f as1,
3703: pay_assignment_actions act,
3704: pay_payroll_actions pa2,
3918: pay_all_payrolls_f pay,
3919: per_time_periods ptp,
3920: pay_payroll_actions pa2,
3921: pay_action_classifications pcl,
3922: pay_population_ranges pop,
3923: per_periods_of_service pos,
3924: per_all_assignments_f as1,
3925: pay_assignment_actions act,
3926: per_all_assignments_f as2
4101: chunk number
4102: ) is
4103: select asg.assignment_id
4104: from pay_payroll_actions pac,
4105: pay_population_ranges pop,
4106: pay_batch_headers bth,
4107: pay_batch_lines btl,
4108: per_all_assignments_f asg
4109: where pac.payroll_action_id = pactid
4221: pa2.action_type
4222: from pay_payroll_actions pa,
4223: pay_payroll_actions pa2,
4224: pay_action_classifications pcl,
4225: pay_population_ranges pop,
4226: per_periods_of_service pos,
4227: per_all_assignments_f as2,
4228: pay_assignment_actions ac2,
4229: per_all_assignments_f as1
4356: ac2.assignment_id,
4357: ac2.tax_unit_id,
4358: pa2.action_type
4359: from pay_payroll_actions pa,
4360: pay_population_ranges pop,
4361: per_periods_of_service pos,
4362: per_all_assignments_f as2,
4363: pay_assignment_actions ac2,
4364: pay_payroll_actions pa2,
4723: ppp.pre_payment_id
4724: from pay_payroll_actions pa1,
4725: pay_payroll_actions pa2,
4726: pay_action_classifications pcl,
4727: pay_population_ranges pop,
4728: per_periods_of_service pos,
4729: per_all_assignments_f as1,
4730: pay_assignment_actions act,
4731: per_all_assignments_f as2,
4895: act.assignment_id,
4896: act.tax_unit_id,
4897: ppp.pre_payment_id
4898: from pay_payroll_actions pa1,
4899: pay_population_ranges pop,
4900: per_periods_of_service pos,
4901: per_all_assignments_f as1,
4902: pay_assignment_actions act,
4903: pay_payroll_actions pa2,
5136: --
5137: -- 'lock' the range row grabbed by updating is status.
5138: -- check to see if want to use randomised chnks or sequential
5139: --
5140: update pay_population_ranges rge
5141: set rge.range_status = 'P'
5142: where rge.payroll_action_id = pactid
5143: and rge.chunk_number = chunk;
5144: --
5190: hr_utility.raise_error;
5191: end if;
5192: --
5193: -- we have processed the range, so delete the row.
5194: delete from pay_population_ranges rge
5195: where rge.payroll_action_id = pactid
5196: and rge.chunk_number = chunk;
5197: --
5198: commit;
5202:
5203: rollback;
5204: --
5205: -- set chunk to 'E'rrored
5206: update pay_population_ranges rge
5207: set rge.range_status = 'E'
5208: where rge.payroll_action_id = pactid
5209: and rge.chunk_number = chunk;
5210: