[Home] [Help]
87: info has been archived. If not, pay level info data is archived for quickpay.
88: ====================================================================
89: */
90:
91: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type; -- Global to store last archive payroll action id
92:
93: g_package constant varchar2(60) := 'pay_au_payslip_archive.'; -- Global to store package name for tracing.
94:
95: --------------------------------------------------------------------
99: --
100: --------------------------------------------------------------------
101:
102: procedure range_code
103: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
104: ,p_sql out NOCOPY varchar2
105: ) is
106:
107: l_procedure varchar2(200) ;
129: --
130: --------------------------------------------------------------------
131:
132: procedure initialization_code
133: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
134: is
135: l_procedure varchar2(200) ;
136:
137: begin
165: --
166: --------------------------------------------------------------------
167:
168: procedure assignment_action_code
169: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
170: ,p_start_person in per_all_people_f.person_id%type
171: ,p_end_person in per_all_people_f.person_id%type
172: ,p_chunk in number
173: ) is
200: --------------------------------------------------------------------
201:
202: procedure archive_stat_elements
203: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type
204: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
205: ,p_assignment_id in pay_assignment_actions.assignment_id%type
206: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
207: ) is
208:
293: */
294:
295: procedure archive_balances
296: (p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
297: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
298: ,p_narrative in varchar2
299: ,p_ytd in number
300: ,p_tp in number --Bug 3891564
301: ) is
337: --------------------------------------------------------------------
338:
339: procedure archive_stat_balances
340: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type /*4363057*/
341: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
342: ,p_assignment_id in pay_assignment_actions.assignment_id%type
343: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
344: ,p_calculation_date in pay_payroll_actions.effective_date%type
345: ) is
340: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type /*4363057*/
341: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
342: ,p_assignment_id in pay_assignment_actions.assignment_id%type
343: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
344: ,p_calculation_date in pay_payroll_actions.effective_date%type
345: ) is
346: l_gross_this_pay number;
347: l_other_deductions_this_pay number;
348: l_tax_deductions_this_pay number;
533: ---------------------------------------------------------------------------
534:
535: procedure archive_accruals
536: (p_assignment_id in pay_assignment_actions.assignment_id%type
537: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
538: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
539: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
540: ,p_calculation_date in date
541: ) is
562: , pay_element_types_f et
563: , pay_element_links_f el
564: , pay_element_entries_f ee
565: , pay_assignment_actions aa
566: , pay_payroll_actions pa
567: where et.element_type_id = ap.accrual_plan_element_type_id -- select the accrual plan elements
568: and el.element_type_id = et.element_type_id -- select accrual plan element entries
569: and aa.assignment_id = ee.assignment_id -- select element entries for this assignment
570: and ee.element_link_id = el.element_link_id -- join element to element entries via element links
657: into pay_action_information */
658:
659: procedure archive_absences
660: (p_assignment_id in pay_assignment_actions.assignment_id%type
661: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
662: ,p_time_period_id in per_time_periods.time_period_id%type
663: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
664: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
665: ) is
1310: and exists (
1311: select ''
1312: from pay_run_types_f prt,
1313: pay_assignment_actions paa_run,
1314: pay_payroll_actions ppa_run
1315: where paa_run.assignment_action_id
1316: = ppp.source_action_id
1317: and paa_run.payroll_action_id
1318: = ppa_run.payroll_action_id
1471: (p_assignment_id in pay_assignment_actions.assignment_id%type
1472: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1473: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1474: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1475: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1476: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run
1477: ,p_run_date_earned in pay_payroll_actions.date_earned%type
1478: ,p_time_period_id in per_time_periods.time_period_id%type
1479: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1472: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1473: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1474: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1475: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1476: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run
1477: ,p_run_date_earned in pay_payroll_actions.date_earned%type
1478: ,p_time_period_id in per_time_periods.time_period_id%type
1479: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1480: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/
1473: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1474: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1475: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1476: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run
1477: ,p_run_date_earned in pay_payroll_actions.date_earned%type
1478: ,p_time_period_id in per_time_periods.time_period_id%type
1479: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1480: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/
1481: ) is
1481: ) is
1482:
1483: l_action_info_id pay_action_information.action_information_id%type;
1484: l_ovn pay_action_information.object_version_number%type;
1485: l_date_earned pay_payroll_actions.date_earned%type;
1486: l_procedure varchar2(80) ;
1487: l_abn number;
1488: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1489:
1499: --
1500: /*Bug2920725 Corrected base tables to support security model*/
1501: cursor csr_abn
1502: (p_assignment_id pay_assignment_actions.assignment_id%type
1503: ,p_effective_date pay_payroll_actions.effective_date%type
1504: ) is
1505: select org.org_information12 abn
1506: from per_assignments_f paaf
1507: , hr_soft_coding_keyflex flex
1527: /* Bug 5504354 - Added cursor to get pay_advice_date */
1528: /* Bug 6032985 - Added ptp.default_dd_date in place of pay_advice_date ,in case where
1529: ptp.default_dd_date is null use effective date of Pre Payment */
1530: cursor csr_pay_advice_date(p_run_assignment_action_id pay_assignment_actions.assignment_action_id%type ,
1531: p_run_date_earned pay_payroll_actions.date_earned%type,
1532: p_pre_effective_date pay_payroll_actions.effective_date%type)
1533: is
1534: select nvl(ptp.default_dd_date,p_pre_effective_date)
1535: from pay_payroll_actions ppa,
1528: /* Bug 6032985 - Added ptp.default_dd_date in place of pay_advice_date ,in case where
1529: ptp.default_dd_date is null use effective date of Pre Payment */
1530: cursor csr_pay_advice_date(p_run_assignment_action_id pay_assignment_actions.assignment_action_id%type ,
1531: p_run_date_earned pay_payroll_actions.date_earned%type,
1532: p_pre_effective_date pay_payroll_actions.effective_date%type)
1533: is
1534: select nvl(ptp.default_dd_date,p_pre_effective_date)
1535: from pay_payroll_actions ppa,
1536: per_time_periods ptp,
1531: p_run_date_earned pay_payroll_actions.date_earned%type,
1532: p_pre_effective_date pay_payroll_actions.effective_date%type)
1533: is
1534: select nvl(ptp.default_dd_date,p_pre_effective_date)
1535: from pay_payroll_actions ppa,
1536: per_time_periods ptp,
1537: pay_assignment_actions paa
1538: where p_run_date_earned between ptp.start_date and ptp.end_date
1539: and paa.assignment_action_id=p_run_assignment_action_id
1551:
1552: /* Bug 5504354 - Cursor c_grade_step added to get the grade step of an assignment */
1553:
1554: cursor c_grade_step(p_assignment_id pay_assignment_actions.assignment_id%type
1555: ,p_effective_date pay_payroll_actions.effective_date%type,
1556: p_business_group_id per_all_assignments_f.business_group_id%type
1557: ) is
1558: select count(*)
1559: from per_spinal_point_steps_f psp,
1813: --
1814: ----------------------------
1815:
1816: procedure insert_quickpay_pa_info
1817: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1818: ,p_effective_date in pay_action_information.effective_date%TYPE
1819: ) is
1820:
1821: cursor csr_get_payroll_id
1818: ,p_effective_date in pay_action_information.effective_date%TYPE
1819: ) is
1820:
1821: cursor csr_get_payroll_id
1822: (p_payroll_action_id pay_payroll_actions.payroll_id%TYPE)
1823: is
1824: select payroll_id
1825: from pay_payroll_actions paa
1826: where paa.payroll_action_id = p_payroll_action_id;
1821: cursor csr_get_payroll_id
1822: (p_payroll_action_id pay_payroll_actions.payroll_id%TYPE)
1823: is
1824: select payroll_id
1825: from pay_payroll_actions paa
1826: where paa.payroll_action_id = p_payroll_action_id;
1827:
1828: l_procedure varchar2(200);
1829:
1826: where paa.payroll_action_id = p_payroll_action_id;
1827:
1828: l_procedure varchar2(200);
1829:
1830: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1831:
1832: begin
1833: l_procedure := g_package||'archive_data_for_quickpay';
1834: hr_utility.set_location('Entering '||l_procedure,1);
1869: ----------------------------
1870:
1871: procedure archive_quickpay_pa_info
1872: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1873: ,p_effective_date in pay_payroll_actions.effective_date%type
1874: ) is
1875:
1876: cursor csr_get_payroll_action_id(
1877: p_aa_id pay_assignment_actions.assignment_action_id%TYPE)
1891: and pai.action_information14 = 'Employer Address'
1892: and pai.action_context_id = p_payroll_action_id
1893: and pai.effective_date = p_effective_date;
1894:
1895: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1896: l_is_employer_addr_archived number;
1897:
1898: l_procedure varchar2(200);
1899:
1936: --
1937: ----------------------------
1938: procedure archive_code
1939: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1940: ,p_effective_date in pay_payroll_actions.effective_date%type
1941: ) is
1942:
1943: cursor get_payslip_aa(p_master_aa_id number)
1944: is
1956: pay_assignment_actions paa_pre,
1957: pay_action_interlocks pai_pre,
1958: pay_assignment_actions paa_run,
1959: pay_action_interlocks pai_run,
1960: pay_payroll_actions ppa_pre,
1961: pay_payroll_actions ppa_run,
1962: per_time_periods ptp
1963: where paa_arch_mst.assignment_action_id = p_master_aa_id
1964: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
1957: pay_action_interlocks pai_pre,
1958: pay_assignment_actions paa_run,
1959: pay_action_interlocks pai_run,
1960: pay_payroll_actions ppa_pre,
1961: pay_payroll_actions ppa_run,
1962: per_time_periods ptp
1963: where paa_arch_mst.assignment_action_id = p_master_aa_id
1964: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
1965: and paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id