[Home] [Help]
PACKAGE: APPS.PAY_AU_REC_DET_PAYSUM_MODE
Source
1 package pay_au_rec_det_paysum_mode AUTHID CURRENT_USER as
2 /* $Header: pyaureps.pkh 120.10.12020000.1 2012/06/28 16:48:59 appldev ship $*/
3 /*
4 *** ------------------------------------------------------------------------+
5 *** Program: PAY_AU_REC_DET_PAYSUM_MODE (Package Specification)
6 *** This package is used for horizontal archive implementation of Report
7 *** "Payroll Reconciliation Detail Report - Payment Summary Mode."
8 *** Change History
9 ***
10 *** Date Changed By Version Bug No Description of Change
11 *** --------- ---------- ------- ------ --------------------------------+
12 *** 22 DEC 04 avenkatk 1.0 3899641 Initial Version
13 *** 30 DEC 04 avenkatk 1.1 3899641 Changed Package Name
14 *** 07 FEB 05 abhkumar 1.2 4142159 Added delete_actions to parameters.
15 *** 24 FEB 05 avenkatk 1.3 4201894 Introduced Variable g_adjusted_lump_sum_e_pay
16 *** for storing the Retro Payment < $400
17 *** 04 JUL 05 avenkatk 1.4 3891577 Introduced procedures for Summary Report - Payment Summary Mode
18 *** 29 OCT 06 hnainani 1.5 5603254 Added Function get_element_payment_hours
19 *** 29 OCT 06 hnainani 1.6 5603524 Removed function get_element_payment_hours.. used function defined in pay_au_Rec_Det_archive
20 *** 26 FEB 08 vdabgar 1.7 6839263 Added a new variable for parameters type.
21 *** 18 MAR 08 avenkatk 1.9 6839263 Backed out changes for Output type in parameters field
22 *** 27 JAN 09 skshin 1.10 7571001 Removed summary_rep_populate_allowance procedure and p_allowance_exist in archive_element_details
23 *** 19 NOV 09 skshin 1.12 8711855 Reverted the change back to 115.10
24 *** 15 Dec 09 pmatamsr 1.13 9190980 Added a new global variable g_adj_lump_sum_pre_tax for storing Retro GT12 Pre Tax < $400
25 *** ------------------------------------------------------------------------+
26 */
27 TYPE parameters IS RECORD (
28 business_group_id number,
29 legal_employer number,
30 payroll_id varchar2(240),
31 assignment_id varchar2(240),
32 employee_type varchar2(1),
33 fin_year_start_date date,
34 fin_year_end_date date,
35 fbt_year_start_date date,
36 fbt_year_end_date date,
37 lst_year_term varchar2(1),
38 delete_actions varchar2(1), /*Bug 4142159*/
39 report_mode varchar2(1)); /* Bug 3891577 */
40
41 g_parameters parameters;
42
43 /* To Store the Defined Balance ID for Fringe Benefits */
44 g_fbt_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
45
46 /* For BBR */
47 g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
48 g_context_table pay_balance_pkg.t_context_tab;
49 g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
50
51 g_fbt_balance_value number;
52 g_allowance_balance_value number;
53 g_adjusted_lump_sum_e_pay number; /*Bug 4201894 */
54 g_adj_lump_sum_pre_tax number; /*Bug 9190980 */
55
56 /* To Store Allowance Balance_type_ID's */
57 TYPE
58 g_bal_type_tab IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
59
60
61
62 procedure range_code
63 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
64 ,p_sql out NOCOPY varchar2
65 );
66
67 procedure initialization_code
68 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
69
70 procedure assignment_action_code
71 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
72 ,p_start_person in per_all_people_f.person_id%type
73 ,p_end_person in per_all_people_f.person_id%type
74 ,p_chunk in number
75 );
76
77 procedure archive_code
78 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
79 ,p_effective_date in pay_payroll_actions.effective_date%type
80 );
81
82 procedure spawn_archive_reports
83 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
84
85 procedure get_fbt_balance(p_assignment_id in pay_assignment_actions.assignment_id%type
86 ,p_start_date in date
87 ,p_end_date in date
88 ,p_action_sequence out nocopy number);
89
90 procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
91 ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
92 ,p_effective_date in date
93 ,p_pre01jul1983_ratio in number
94 ,p_post30jun1983_ratio in number);
95
96 /*bug8711855 - p_assignment_action_id and p_registered_employer parameter are added to call
97 pay_au_payment_summary.get_retro_lumpsumE_value function */
98 procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type);
99
100 procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
101 ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
102
103 procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
104 ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
105 ,p_effective_date in date
106 ,p_pre01jul1983_ratio in number
107 ,p_post30jun1983_ratio in number
108 ,p_run_action_sequence in pay_assignment_actions.action_sequence%type);
109
110
111 /* Bug 3891577 - Procedure to spawn report for Summary Report */
112 procedure spawn_summary_reports
113 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
114
115
116 end pay_au_rec_det_paysum_mode;