[Home] [Help]
185: stperson IN NUMBER,
186: endperson IN NUMBER,
187: chunk IN NUMBER) IS
188: --
189: l_actid pay_assignment_actions.assignment_action_id%TYPE;
190: --
191: l_proc VARCHAR2(60):= g_package||' action_creation ';
192: --
193: --This cursor fetches all master (or standard) prepayment assignment actions
196: SELECT pre_assact.assignment_action_id assignment_action_id
197: ,pre_assact.assignment_id assignment_id
198: ,pre_assact.tax_unit_id establishment_id
199: FROM per_all_assignments_f asg
200: ,pay_assignment_actions pre_assact
201: ,pay_payroll_actions pre_payact
202: WHERE asg.person_id between p_stperson and p_endperson
203: and asg.period_of_service_id is not null
204: and g_param_effective_date between asg.effective_start_date
240: LOOP
241: Fetch csr_assignments into rec_this;
242: EXIT WHEN csr_assignments%NOTFOUND;
243: -- create the action
244: SELECT pay_assignment_actions_s.nextval
245: INTO l_actid
246: FROM dual;
247: hr_nonrun_asact.insact(l_actid
248: ,rec_this.assignment_id
515: ,child_pre.assignment_id assignment_id
516: ,child_pre.tax_unit_id establishment_id
517: ,master_arc.chunk_number chunk_number
518: ,master_arc.payroll_action_id payroll_action_id
519: ,pay_assignment_actions_s.nextval new_ass_act_id
520: FROM pay_assignment_Actions master_arc
521: ,pay_action_interlocks lok
522: ,pay_assignment_Actions child_pre
523: WHERE master_arc.assignment_action_id = p_assactid
516: ,child_pre.tax_unit_id establishment_id
517: ,master_arc.chunk_number chunk_number
518: ,master_arc.payroll_action_id payroll_action_id
519: ,pay_assignment_actions_s.nextval new_ass_act_id
520: FROM pay_assignment_Actions master_arc
521: ,pay_action_interlocks lok
522: ,pay_assignment_Actions child_pre
523: WHERE master_arc.assignment_action_id = p_assactid
524: and lok.locking_Action_id = master_arc.assignment_action_id
518: ,master_arc.payroll_action_id payroll_action_id
519: ,pay_assignment_actions_s.nextval new_ass_act_id
520: FROM pay_assignment_Actions master_arc
521: ,pay_action_interlocks lok
522: ,pay_assignment_Actions child_pre
523: WHERE master_arc.assignment_action_id = p_assactid
524: and lok.locking_Action_id = master_arc.assignment_action_id
525: and lok.locked_action_id = child_pre.source_action_id;
526: --
554: ,p_effective_date => p_effective_date);
555: --
556: -- this child action is now complete
557: --
558: update pay_assignment_actions
559: set action_status = 'C'
560: where assignment_action_id = child.new_ass_act_id;
561: END LOOP;
562: --
581: procedure archive_code_sub(
582: p_assactid in number
583: ,p_effective_date in date) is
584: --
585: l_establishment_id pay_assignment_actions.tax_unit_id%TYPE;
586: l_person_id per_all_people_f.person_id%TYPE;
587: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
588: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
589: l_latest_assignment_action_id pay_assignment_actions.assignment_id%TYPE;
585: l_establishment_id pay_assignment_actions.tax_unit_id%TYPE;
586: l_person_id per_all_people_f.person_id%TYPE;
587: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
588: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
589: l_latest_assignment_action_id pay_assignment_actions.assignment_id%TYPE;
590: l_latest_date_paid date;
591: l_ee_asat_date date;
592: l_total_gross_pay number;
593: l_net_payments number;
985: comp_info.org_information3 urssaf_org_id,
986: comp_info.org_information2 naf_code,
987: substr(addr.address_line_1,1,150) address_line_1
988: from (select distinct tax_unit_id id
989: from pay_assignment_actions paa1
990: where paa1.payroll_action_id = p_payroll_action_id) tax_unit,
991: hr_organization_information est_info,
992: hr_all_organization_units comp,
993: hr_all_organization_units_tl comptl,
1017: est.location_id
1018: from hr_all_organization_units est
1019: , hr_organization_information est_info
1020: , hr_all_organization_units_tl esttl
1021: , pay_assignment_Actions paa
1022: where paa.payroll_action_id = p_payroll_action_id
1023: and est.organization_id = paa.tax_unit_id
1024: and est_info.organization_id(+) = est.organization_id
1025: and est_info.org_information_context(+) = 'FR_ESTAB_INFO'
1208: ,p_establishment_id out nocopy number
1209: ,p_assignment_id out nocopy number
1210: ,p_payroll_id out nocopy number) is
1211: --
1212: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1213: l_person_id per_all_people_f.person_id%TYPE;
1214: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1215: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
1216: --
1216: --
1217: l_proc VARCHAR2(40):= g_package||' get_instance_variables ';
1218: cursor csr_establishment(p_paa_id number) is
1219: select paa.tax_unit_id, paa.assignment_id, asg.person_id, asg.payroll_id
1220: from pay_assignment_actions paa
1221: ,per_assignments asg
1222: where paa.assignment_action_id = p_paa_id
1223: and paa.assignment_id = asg.assignment_id;
1224: BEGIN
1252: ,p_latest_process_type out nocopy varchar2
1253: ,p_latest_assignment_action_id out nocopy number) is
1254: --
1255: l_date_earned date;
1256: l_latest_action_sequence pay_assignment_actions.action_sequence%TYPE;
1257: l_latest_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1258: l_latest_process_type varchar2(30);
1259: l_dummy number;
1260: --
1253: ,p_latest_assignment_action_id out nocopy number) is
1254: --
1255: l_date_earned date;
1256: l_latest_action_sequence pay_assignment_actions.action_sequence%TYPE;
1257: l_latest_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1258: l_latest_process_type varchar2(30);
1259: l_dummy number;
1260: --
1261: l_proc VARCHAR2(40):= g_package||' get_latest_run_data ';
1265: SELECT run_payact.effective_date, run_assact.action_sequence,
1266: run_assact.assignment_action_id, proc_type.context_value
1267: FROM pay_action_interlocks arc_interlock
1268: , pay_action_interlocks pre_interlock
1269: , pay_assignment_actions run_assact
1270: , pay_payroll_actions run_payact
1271: , pay_action_contexts proc_type /*will exclude proration actions*/
1272: WHERE arc_interlock.locking_action_id = p_archive_action_id
1273: and pre_interlock.locking_action_id = arc_interlock.locked_action_id
1283: --
1284: CURSOR csr_locking_reversal (p_run_act_id number) is
1285: SELECT 1 /* if the run action is reversed exclude it */
1286: FROM pay_action_interlocks rev_interlock
1287: , pay_assignment_actions rev_assact
1288: , pay_payroll_actions rev_payact
1289: WHERE rev_interlock.locked_action_id = p_run_act_id
1290: AND rev_interlock.locking_action_id = rev_assact.assignment_action_id
1291: AND rev_assact.action_status = 'C'
1425: ,p_assignment_id number) is
1426: select m_ppa.overriding_dd_date
1427: from pay_action_interlocks a_lock
1428: ,pay_payroll_actions a_ppa
1429: ,pay_assignment_Actions a_asg
1430: ,pay_assignment_actions m_asg
1431: ,pay_assignment_actions p_asg
1432: ,pay_payroll_actions m_ppa
1433: ,pay_action_interlocks m_lock
1426: select m_ppa.overriding_dd_date
1427: from pay_action_interlocks a_lock
1428: ,pay_payroll_actions a_ppa
1429: ,pay_assignment_Actions a_asg
1430: ,pay_assignment_actions m_asg
1431: ,pay_assignment_actions p_asg
1432: ,pay_payroll_actions m_ppa
1433: ,pay_action_interlocks m_lock
1434: where a_lock.locking_Action_id = p_assignment_action_id
1427: from pay_action_interlocks a_lock
1428: ,pay_payroll_actions a_ppa
1429: ,pay_assignment_Actions a_asg
1430: ,pay_assignment_actions m_asg
1431: ,pay_assignment_actions p_asg
1432: ,pay_payroll_actions m_ppa
1433: ,pay_action_interlocks m_lock
1434: where a_lock.locking_Action_id = p_assignment_action_id
1435: and a_lock.locked_action_id = a_asg.assignment_Action_id
2106: ,this_arc_lock.locking_action_id,null
2107: ,all_arc_lock.locking_action_id)) num_previous
2108: from pay_action_interlocks this_arc_lock
2109: ,pay_action_interlocks all_arc_lock
2110: ,pay_assignment_actions arc_assact
2111: ,pay_payroll_actions arc_payact
2112: ,pay_pre_payments ppp
2113: ,pay_personal_payment_methods_f pppmf
2114: ,pay_org_payment_methods_f_tl opmtl
2225:
2226: cursor csr_message_details(p_archive_assignment_action_id number) is
2227: select substrb(run_payact.pay_advice_message, 1, 240) message
2228: from pay_payroll_actions pre_payact
2229: ,pay_assignment_actions pre_assact
2230: ,pay_payroll_actions run_payact
2231: ,pay_assignment_actions run_assact
2232: ,pay_action_interlocks arc_lock
2233: ,pay_action_interlocks pre_lock
2227: select substrb(run_payact.pay_advice_message, 1, 240) message
2228: from pay_payroll_actions pre_payact
2229: ,pay_assignment_actions pre_assact
2230: ,pay_payroll_actions run_payact
2231: ,pay_assignment_actions run_assact
2232: ,pay_action_interlocks arc_lock
2233: ,pay_action_interlocks pre_lock
2234: where
2235: arc_lock.locking_action_id = p_archive_assignment_action_id
2406: ,fnd_lookup_values user_rubric
2407: ,fnd_lookup_values seed_rubric
2408: ,fnd_lookup_values base_units
2409: ,pay_payroll_actions pre_payact
2410: ,pay_assignment_actions pre_assact
2411: ,pay_payroll_actions run_payact
2412: ,pay_assignment_actions run_assact
2413: ,pay_action_interlocks arc_lock
2414: ,pay_action_interlocks pre_lock
2408: ,fnd_lookup_values base_units
2409: ,pay_payroll_actions pre_payact
2410: ,pay_assignment_actions pre_assact
2411: ,pay_payroll_actions run_payact
2412: ,pay_assignment_actions run_assact
2413: ,pay_action_interlocks arc_lock
2414: ,pay_action_interlocks pre_lock
2415: ,pay_element_entries_f pee
2416: ,pay_run_results rr_ret
2478: decode(pee.creator_type,
2479: 'EE',pee.source_end_date,
2480: 'RR',rr_ret.end_date)
2481: ) result_rollup
2482: ,pay_assignment_actions paa
2483: ,pay_payroll_actions ppa
2484: ,per_time_periods ptp
2485: where paa.assignment_action_id (+) = result_rollup.retro_act_id
2486: and ppa.payroll_action_id (+) = paa.payroll_action_id
3026: ,fnd_lookup_values seed_rubric
3027: ,fnd_lookup_values base_units
3028: ,pay_action_interlocks arc_lock
3029: ,pay_action_interlocks pre_lock
3030: ,pay_assignment_actions run_assact
3031: ,pay_payroll_actions run_payact
3032: where pet.classification_id in (p_ee_classification, p_er_classification)
3033: and (pet.legislation_code = 'FR' or pet.legislation_code is null)
3034: and pet.element_type_id = prr.element_Type_id
3451: , pay_balance_types b
3452: , pay_run_balances rb
3453: , pay_defined_balances db
3454: , pay_payroll_actions pa
3455: , pay_assignment_actions aa
3456: , pay_defined_balances db2
3457: , pay_fr_contribution_usages fcu
3458: , pay_input_values_f piv
3459: , pay_element_types_f pet
3577: ,pay_run_results prr
3578: ,pay_element_types_f pet
3579: ,pay_input_values_f_tl piv
3580: ,pay_payroll_actions run_payact
3581: ,pay_assignment_actions run_assact
3582: ,pay_action_interlocks arc_lock
3583: ,pay_action_interlocks pre_lock
3584: ,pay_entry_process_details epd
3585: ,per_time_periods ptp_date
3583: ,pay_action_interlocks pre_lock
3584: ,pay_entry_process_details epd
3585: ,per_time_periods ptp_date
3586: ,pay_payroll_actions ppa_date
3587: ,pay_assignment_actions paa_date
3588: where epd.element_entry_id = prr.element_entry_id
3589: and epd.retro_component_id is not null
3590: and prrv.run_result_id = prr.run_result_id
3591: and prr.element_type_id = pet.element_type_id