[Home] [Help]
PACKAGE: APPS.PAY_AU_REC_DET_PAYSUM_MODE
Source
1 package pay_au_rec_det_paysum_mode as
2 /* $Header: pyaureps.pkh 120.5.12010000.1 2008/07/27 22:06:47 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 *** ------------------------------------------------------------------------+
23 */
24 TYPE parameters IS RECORD (
25 business_group_id number,
26 legal_employer number,
27 payroll_id varchar2(240),
28 assignment_id varchar2(240),
29 employee_type varchar2(1),
30 fin_year_start_date date,
31 fin_year_end_date date,
32 fbt_year_start_date date,
33 fbt_year_end_date date,
34 lst_year_term varchar2(1),
35 delete_actions varchar2(1), /*Bug 4142159*/
36 report_mode varchar2(1)); /* Bug 3891577 */
37
38 g_parameters parameters;
39
40 /* To Store the Defined Balance ID for Fringe Benefits */
41 g_fbt_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
42
43 /* For BBR */
44 g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
45 g_context_table pay_balance_pkg.t_context_tab;
46 g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
47
48 g_fbt_balance_value number;
49 g_allowance_balance_value number;
50 g_adjusted_lump_sum_e_pay number; /*Bug 4201894 */
51
52 /* To Store Allowance Balance_type_ID's */
53 TYPE
54 g_bal_type_tab IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
55
56
57
58 procedure range_code
59 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
60 ,p_sql out NOCOPY varchar2
61 );
62
63 procedure initialization_code
64 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
65
66 procedure assignment_action_code
67 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
68 ,p_start_person in per_all_people_f.person_id%type
69 ,p_end_person in per_all_people_f.person_id%type
70 ,p_chunk in number
71 );
72
73 procedure archive_code
74 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
75 ,p_effective_date in pay_payroll_actions.effective_date%type
76 );
77
78 procedure spawn_archive_reports
79 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
80
81 procedure get_fbt_balance(p_assignment_id in pay_assignment_actions.assignment_id%type
82 ,p_start_date in date
83 ,p_end_date in date
84 ,p_action_sequence out nocopy number);
85
86 procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
87 ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
88 ,p_effective_date in date
89 ,p_pre01jul1983_ratio in number
90 ,p_post30jun1983_ratio in number
91 ,p_allowance_exists out nocopy number);
92
93 procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type);
94
95 procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
96 ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
97
98 procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
99 ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
100 ,p_effective_date in date
101 ,p_pre01jul1983_ratio in number
102 ,p_post30jun1983_ratio in number
103 ,p_run_action_sequence in pay_assignment_actions.action_sequence%type);
104
105 /* Bug 3891577 - Procedure to populate Allowance Balances for Summary Report */
106 procedure summary_rep_populate_allowance(p_assignment_id in per_all_assignments_f.assignment_id%type
107 ,p_allowance_exists out nocopy number);
108
109
110 /* Bug 3891577 - Procedure to spawn report for Summary Report */
111 procedure spawn_summary_reports
112 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
113
114
115 end pay_au_rec_det_paysum_mode;