[Home] [Help]
PACKAGE: APPS.PAY_AU_REC_DET_ARCHIVE
Source
1 package pay_au_rec_det_archive as
2 /* $Header: pyaurecd.pkh 120.6 2008/03/18 13:27:04 avenkatk noship $*/
3 /*
4
5 *** ------------------------------------------------------------------------+
6 *** Program: pay_au_rec_det_archive (Package Specification)
7 ***
8 *** Change History
9 ***
10 *** Date Changed By Version Bug No Description of Change
11 *** --------- ---------- ------- ------ --------------------------------+
12 *** 25 DEC 03 avenkatk 1.0 3064269 Initial version
13 *** 16 APR 04 punmehta 1.1 3538810 Modified for GSCC standards
14 *** 04 JUN 04 abhkumar 1.2 3662449 Added function check_termination to check termination status.
15 *** 25-JAN-05 abhkumar 1.3 4142159 Added "delete_actions" to parameters
16 *** 16-OCT-06 priupadh 1.4 5603254 Added Function get_element_payment_hours
17 *** 27-OCT-06 hnainani 1.7 Backing out changes made due to bug 5599310
18 *** 3-MAR-07i hnainani 1.8 5599310 Added function get_element_payment_rate
19 *** 26-FEB-08 vdabgar 1.9 6839263 Added a variable for parameters.
20 *** 18-MAR-08 avenkatk 1.10 6839263 Backed out changes for parameters
21 *** ------------------------------------------------------------------------+
22 */
23
24 TYPE parameters IS RECORD (payroll_id number,
25 org_id number,
26 business_group_id number,
27 start_date date,
28 end_date date,
29 pact_id number,
30 legal_employer number,
31 assignment_id number,
32 sort_order_1 varchar2(50),
33 sort_order_2 varchar2(50),
34 sort_order_3 varchar2(50),
35 sort_order_4 varchar2(50),
36 period_end_date date,
37 ytd_totals varchar2(1),
38 zero_records varchar2(1),
39 negative_records varchar2(1),
40 employee_type varchar2(1),
41 delete_actions varchar2(1)); /*Bug# 4142159*/
42
43 g_parameters parameters;
44
45
46
47 g_def_bal_c pay_balance_pkg.t_balance_value_tab; -- To Populate the Defined Balance IDs
48
49
50 procedure range_code
51 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
52 ,p_sql out NOCOPY varchar2
53 );
54
55 procedure initialization_code
56 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
57
58 procedure assignment_action_code
59 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
60 ,p_start_person in per_all_people_f.person_id%type
61 ,p_end_person in per_all_people_f.person_id%type
62 ,p_chunk in number
63 );
64
65 procedure archive_code
66 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
67 ,p_effective_date in pay_payroll_actions.effective_date%type
68 );
69
70 procedure spawn_archive_reports
71 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
72
73 /*Bug#3662449*/
74 function check_termination
75 (p_sys_status per_assignment_status_types.per_system_status%TYPE,
76 p_emp_type varchar2)
77 return varchar2;
78
79 /*Bug#5603254 */
80 function get_element_payment_hours
81 (
82 p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
83 p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
84 p_run_result_id IN pay_run_results.run_result_ID%TYPE,
85 p_effective_date IN pay_payroll_actions.effective_date%TYPE
86 )
87 return number;
88
89 /* Bug 5599310 */
90
91 function get_element_payment_rate
92 (
93 p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
94 p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
95 p_run_result_id IN pay_run_results.run_result_ID%TYPE,
96 p_effective_date IN pay_payroll_actions.effective_date%TYPE
97 )
98 return number;
99
100 end pay_au_rec_det_archive;