[Home] [Help]
59: *** 18-Jun-08 avenkatk 115.46 7138494 Modified Allowance Cursor for peformance
60: *** ------------------------------------------------------------------------+
61: */
62: /* Package - Functional comments.
63: This package is used to archive data in pay_action_information for TWO reports,
64: i. End of Year Reconciliation Detail Report (Bug 3899641)
65: ii. End of Year Reconciliation Summary Report (Bug 3891577)
66:
67: Parameter REP_MODE in legislative parameters is used to distinguish the type of Report.
879: -- Name : Archive_code
880: -- Type : Procedure
881: -- Access: Public
882: -- This procedure archives employee details for Assignment in
883: -- pay_action_information.
884: -- Identifies if Assignment is an FBT or Normal Employee and
885: -- fetches appropriate Balance values using BBR.
886: --------------------------------------------------------------------+
887:
1145: OPEN c_get_payroll_name(l_employee_details.assignment_id,g_start_date,g_end_date);
1146: FETCH c_get_payroll_name INTO l_payroll_id, l_payroll_name;
1147: CLOSE c_get_payroll_name;
1148:
1149: insert into pay_action_information(
1150: action_information_id,
1151: action_context_id,
1152: action_context_type,
1153: effective_date,
1168: action_information12,
1169: action_information13,
1170: assignment_id)
1171: values(
1172: pay_action_information_s.nextval,
1173: g_arc_payroll_action_id,
1174: 'PA',
1175: p_effective_date,
1176: null,
1668: g_balance_type_tab(l_counter) := to_number(csr_ele_det.balance_type_id);
1669: l_prev_bal_type_id := csr_ele_det.balance_type_id;
1670: end if;
1671: end if;
1672: insert into pay_action_information (
1673: action_information_id,
1674: action_context_id,
1675: action_context_type,
1676: effective_date,
1684: action_information5,
1685: action_information6,
1686: assignment_id)
1687: values (
1688: pay_action_information_s.nextval,
1689: p_assignment_action_id,
1690: 'AAP',
1691: p_effective_date,
1692: null,
1789: then
1790: for i in 1..counter
1791: loop
1792:
1793: insert into pay_action_information (
1794: action_information_id,
1795: action_context_id,
1796: action_context_type,
1797: effective_date,
1805: action_information5,
1806: action_information6,
1807: assignment_id)
1808: values (
1809: pay_action_information_s.nextval,
1810: p_assignment_action_id,
1811: 'AAP',
1812: p_effective_date,
1813: null,
2051: -- Name : Archive_balance_details
2052: -- Type : Procedure
2053: -- Access: Public
2054: -- Computes and Archives all the Balances in table
2055: -- pay_action_information with context,
2056: -- Normal Balances - AU_BALANCE_RECON_DETAILS_YTD
2057: -- Payment Summary Balances - AU_PS_BALANCE_RECON_DETAILS
2058: --------------------------------------------------------------------+
2059:
2153: l_YTD_OTHER_INCOME := g_result_table(19).balance_value;
2154: l_YTD_UNION_FEES := g_result_table(20).balance_value;
2155: l_YTD_WORKPLACE_GIVING_DED := g_result_table(21).balance_value; /* 4085496 */
2156:
2157: insert into pay_action_information (
2158: action_information_id,
2159: action_context_id,
2160: action_context_type,
2161: effective_date,
2174: action_information9,
2175: action_information10
2176: )
2177: values (
2178: pay_action_information_s.nextval,
2179: p_assignment_action_id,
2180: 'AAP',
2181: p_effective_date,
2182: null,
2193: l_YTD_PRE_TAX_DEDUCTIONS,
2194: l_YTD_DIRECT_PAYMENTS,
2195: p_run_action_sequence);
2196:
2197: insert into pay_action_information (
2198: action_information_id,
2199: action_context_id,
2200: action_context_type,
2201: effective_date,
2215: action_information10,
2216: action_information11
2217: )
2218: values (
2219: pay_action_information_s.nextval,
2220: p_assignment_action_id,
2221: 'AAP',
2222: p_effective_date,
2223: null,