[Home] [Help]
102: *** ------------------------------------------------------------------------+
103: */
104:
105: /* Package - Functional comments.
106: This package is used to archive data in pay_action_information for TWO reports,
107: i. End of Year Reconciliation Detail Report (Bug 3899641)
108: ii. End of Year Reconciliation Summary Report (Bug 3891577)
109:
110: Parameter REP_MODE in legislative parameters is used to distinguish the type of Report.
1253: -- Name : Archive_code
1254: -- Type : Procedure
1255: -- Access: Public
1256: -- This procedure archives employee details for Assignment in
1257: -- pay_action_information.
1258: -- Identifies if Assignment is an FBT or Normal Employee and
1259: -- fetches appropriate Balance values using BBR.
1260: --------------------------------------------------------------------+
1261:
1544: OPEN c_get_payroll_name(l_employee_details.assignment_id,g_start_date,g_end_date);
1545: FETCH c_get_payroll_name INTO l_payroll_id, l_payroll_name;
1546: CLOSE c_get_payroll_name;
1547:
1548: insert into pay_action_information(
1549: action_information_id,
1550: action_context_id,
1551: action_context_type,
1552: effective_date,
1567: action_information12,
1568: action_information13,
1569: assignment_id)
1570: values(
1571: pay_action_information_s.nextval,
1572: g_arc_payroll_action_id,
1573: 'PA',
1574: p_effective_date,
1575: null,
2672: hr_utility.set_location('Element Name '||csr_ele_det.element_name,500);
2673: hr_utility.set_location('Classification Name '||csr_ele_det.classification_name,500);
2674: end if;
2675:
2676: insert into pay_action_information (
2677: action_information_id,
2678: action_context_id,
2679: action_context_type,
2680: effective_date,
2688: action_information5,
2689: action_information6,
2690: assignment_id)
2691: values (
2692: pay_action_information_s.nextval,
2693: p_assignment_action_id,
2694: 'AAP',
2695: p_effective_date,
2696: null,
2716: hr_utility.set_location('Element Name '||csr_alw_det.element_name,600);
2717: end if;
2718:
2719: /* Bug 8760756 - As hours and rate columns are removed from c_ps_alw_details cursor query ,
2720: the corresponding column values in pay_action_information table are made null */
2721:
2722: insert into pay_action_information (
2723: action_information_id,
2724: action_context_id,
2718:
2719: /* Bug 8760756 - As hours and rate columns are removed from c_ps_alw_details cursor query ,
2720: the corresponding column values in pay_action_information table are made null */
2721:
2722: insert into pay_action_information (
2723: action_information_id,
2724: action_context_id,
2725: action_context_type,
2726: effective_date,
2734: action_information5,
2735: action_information6,
2736: assignment_id)
2737: values (
2738: pay_action_information_s.nextval,
2739: p_assignment_action_id,
2740: 'AAP',
2741: p_effective_date,
2742: null,
2855: then
2856: for i in 1..counter
2857: loop
2858:
2859: insert into pay_action_information (
2860: action_information_id,
2861: action_context_id,
2862: action_context_type,
2863: effective_date,
2871: action_information5,
2872: action_information6,
2873: assignment_id)
2874: values (
2875: pay_action_information_s.nextval,
2876: p_assignment_action_id,
2877: 'AAP',
2878: p_effective_date,
2879: null,
3216: -- Name : Archive_balance_details
3217: -- Type : Procedure
3218: -- Access: Public
3219: -- Computes and Archives all the Balances in table
3220: -- pay_action_information with context,
3221: -- Normal Balances - AU_BALANCE_RECON_DETAILS_YTD
3222: -- Payment Summary Balances - AU_PS_BALANCE_RECON_DETAILS
3223: --------------------------------------------------------------------+
3224:
3372: l_YTD_FOREIGN_INCOME := g_result_table(22).balance_value;
3373: /* End 8587013 */
3374:
3375:
3376: insert into pay_action_information (
3377: action_information_id,
3378: action_context_id,
3379: action_context_type,
3380: effective_date,
3393: action_information9,
3394: action_information10
3395: )
3396: values (
3397: pay_action_information_s.nextval,
3398: p_assignment_action_id,
3399: 'AAP',
3400: p_effective_date,
3401: null,
3413: l_YTD_DIRECT_PAYMENTS,
3414: p_run_action_sequence);
3415:
3416: /*Bug 8587013 - The balances RESC and Exempt Foreign Employment Income are inserted into next available two columns
3417: of PAY_ACTION_INFORMATION table and the Other Income balance is removed from archival*/
3418:
3419: insert into pay_action_information (
3420: action_information_id,
3421: action_context_id,
3415:
3416: /*Bug 8587013 - The balances RESC and Exempt Foreign Employment Income are inserted into next available two columns
3417: of PAY_ACTION_INFORMATION table and the Other Income balance is removed from archival*/
3418:
3419: insert into pay_action_information (
3420: action_information_id,
3421: action_context_id,
3422: action_context_type,
3423: effective_date,
3438: action_information12,
3439: action_information13
3440: )
3441: values (
3442: pay_action_information_s.nextval,
3443: p_assignment_action_id,
3444: 'AAP',
3445: p_effective_date,
3446: null,
3462:
3463: ); /* 4015082 , 8587013 */
3464:
3465: /* Changes for 9147438 start */
3466: insert into pay_action_information (
3467: action_information_id,
3468: action_context_id,
3469: action_context_type,
3470: effective_date,
3485: action_information11,
3486: action_information12
3487: )
3488: values (
3489: pay_action_information_s.nextval,
3490: p_assignment_action_id,
3491: 'AAP',
3492: p_effective_date,
3493: null,