[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,
2246: ppp.pre_payment_id,
2247: pa1.assignment_set_id,
2248: as1.payroll_id
2249: from pay_payroll_actions pa1,
2250: pay_population_ranges pop,
2251: per_periods_of_service pos,
2252: per_all_assignments_f as1,
2253: pay_assignment_actions act,
2254: pay_payroll_actions pa2,
2493: ppp.pre_payment_id
2494: from pay_payroll_actions pa1,
2495: pay_payroll_actions pa2,
2496: pay_action_classifications pcl,
2497: pay_population_ranges pop,
2498: per_periods_of_service pos,
2499: per_all_assignments_f as1,
2500: pay_assignment_actions act,
2501: per_all_assignments_f as2,
2665: act.assignment_id,
2666: act.tax_unit_id,
2667: ppp.pre_payment_id
2668: from pay_payroll_actions pa1,
2669: pay_population_ranges pop,
2670: per_periods_of_service pos,
2671: per_all_assignments_f as1,
2672: pay_assignment_actions act,
2673: pay_payroll_actions pa2,
2840: as1.primary_flag
2841: from pay_payroll_actions pa1,
2842: pay_payroll_actions pa2,
2843: pay_action_classifications pcl,
2844: pay_population_ranges pop,
2845: per_periods_of_service pos,
2846: per_all_assignments_f as1,
2847: pay_assignment_actions act,
2848: per_all_assignments_f as2
2982: as1.person_id,
2983: as1.effective_start_date,
2984: as1.primary_flag
2985: from pay_payroll_actions pa1,
2986: pay_population_ranges pop,
2987: per_periods_of_service pos,
2988: per_all_assignments_f as1,
2989: pay_assignment_actions act,
2990: pay_payroll_actions pa2,
3154: act.tax_unit_id
3155: from pay_payroll_actions pa1,
3156: pay_payroll_actions pa2,
3157: pay_action_classifications pcl,
3158: pay_population_ranges pop,
3159: per_periods_of_service pos,
3160: per_all_assignments_f as1,
3161: pay_assignment_actions act,
3162: per_all_assignments_f as2
3285: act.assignment_action_id,
3286: act.assignment_id,
3287: act.tax_unit_id
3288: from pay_payroll_actions pa1,
3289: pay_population_ranges pop,
3290: per_periods_of_service pos,
3291: per_all_assignments_f as1,
3292: pay_assignment_actions act,
3293: pay_payroll_actions pa2,
3430: act.payroll_action_id
3431: from pay_payroll_actions pa1,
3432: pay_payroll_actions pa2,
3433: pay_action_classifications pcl,
3434: pay_population_ranges pop,
3435: per_periods_of_service pos,
3436: per_all_assignments_f as1,
3437: pay_assignment_actions act,
3438: per_all_assignments_f as2
3704: act.assignment_id,
3705: act.tax_unit_id,
3706: act.payroll_action_id
3707: from pay_payroll_actions pa1,
3708: pay_population_ranges pop,
3709: per_periods_of_service pos,
3710: per_all_assignments_f as1,
3711: pay_assignment_actions act,
3712: pay_payroll_actions pa2,
3926: pay_all_payrolls_f pay,
3927: per_time_periods ptp,
3928: pay_payroll_actions pa2,
3929: pay_action_classifications pcl,
3930: pay_population_ranges pop,
3931: per_periods_of_service pos,
3932: per_all_assignments_f as1,
3933: pay_assignment_actions act,
3934: per_all_assignments_f as2
4109: chunk number
4110: ) is
4111: select asg.assignment_id
4112: from pay_payroll_actions pac,
4113: pay_population_ranges pop,
4114: pay_batch_headers bth,
4115: pay_batch_lines btl,
4116: per_all_assignments_f asg
4117: where pac.payroll_action_id = pactid
4230: pa2.action_type
4231: from pay_payroll_actions pa,
4232: pay_payroll_actions pa2,
4233: pay_action_classifications pcl,
4234: pay_population_ranges pop,
4235: per_periods_of_service pos,
4236: per_all_assignments_f as2,
4237: pay_assignment_actions ac2,
4238: per_all_assignments_f as1
4366: ac2.assignment_id,
4367: ac2.tax_unit_id,
4368: pa2.action_type
4369: from pay_payroll_actions pa,
4370: pay_population_ranges pop,
4371: per_periods_of_service pos,
4372: per_all_assignments_f as2,
4373: pay_assignment_actions ac2,
4374: pay_payroll_actions pa2,
4738: ppp.pre_payment_id
4739: from pay_payroll_actions pa1,
4740: pay_payroll_actions pa2,
4741: pay_action_classifications pcl,
4742: pay_population_ranges pop,
4743: per_periods_of_service pos,
4744: per_all_assignments_f as1,
4745: pay_assignment_actions act,
4746: per_all_assignments_f as2,
4910: act.assignment_id,
4911: act.tax_unit_id,
4912: ppp.pre_payment_id
4913: from pay_payroll_actions pa1,
4914: pay_population_ranges pop,
4915: per_periods_of_service pos,
4916: per_all_assignments_f as1,
4917: pay_assignment_actions act,
4918: pay_payroll_actions pa2,
5151: --
5152: -- 'lock' the range row grabbed by updating is status.
5153: -- check to see if want to use randomised chnks or sequential
5154: --
5155: update pay_population_ranges rge
5156: set rge.range_status = 'P'
5157: where rge.payroll_action_id = pactid
5158: and rge.chunk_number = chunk;
5159: --
5205: hr_utility.raise_error;
5206: end if;
5207: --
5208: -- we have processed the range, so delete the row.
5209: delete from pay_population_ranges rge
5210: where rge.payroll_action_id = pactid
5211: and rge.chunk_number = chunk;
5212: --
5213: commit;
5217:
5218: rollback;
5219: --
5220: -- set chunk to 'E'rrored
5221: update pay_population_ranges rge
5222: set rge.range_status = 'E'
5223: where rge.payroll_action_id = pactid
5224: and rge.chunk_number = chunk;
5225: