[Home] [Help]
PACKAGE: APPS.PAY_IN_PF_ARCHIVE
Source
1 PACKAGE pay_in_pf_archive AUTHID CURRENT_USER AS
2 /* $Header: pyinmpfa.pkh 120.0.12010000.1 2008/07/27 22:53:41 appldev ship $ */
3
4 --------------------------------------------------------------------------
5 -- --
6 -- Name : RANGE_CODE --
7 -- Type : PROCEDURE --
8 -- Access : Public --
9 -- Description : This procedure returns a sql string to select a --
10 -- range of assignments eligible for archival. --
11 -- --
12 -- Parameters : --
13 -- IN : p_payroll_action_id NUMBER --
14 -- OUT : p_sql VARCHAR2 --
15 -- --
16
17 --------------------------------------------------------------------------
18 --
19
20 PROCEDURE range_code
21 (
22 p_payroll_action_id IN NUMBER
23 ,p_sql OUT NOCOPY VARCHAR2
24 );
25 --
26
27 --------------------------------------------------------------------------
28 -- --
29 -- Name : INITIALIZATION_CODE --
30 -- Type : PROCEDURE --
31 -- Access : Public --
32 -- Description : This procedure is used to set global contexts. --
33 -- --
34 -- Parameters : --
35 -- IN : p_payroll_action_id NUMBER --
36 -- OUT : N/A --
37 -- --
38 --------------------------------------------------------------------------
39 --
40 PROCEDURE initialization_code
41 (
42 p_payroll_action_id IN NUMBER
43 );
44 --
45
46 --------------------------------------------------------------------------
47 -- --
48 -- Name : ASSIGNMENT_ACTION_CODE --
49 -- Type : PROCEDURE --
50 -- Access : Public --
51 -- Description : This procedure further restricts the assignment_id's--
52 -- returned by range_code. --
53 -- It filters the assignments selected by range_code --
54 -- procedure. --
55 -- --
56 -- Parameters : --
57 -- IN : p_payroll_action_id NUMBER --
58 -- p_start_person NUMBER --
59 -- p_end_person NUMBER --
60 -- p_chunk NUMBER --
61 -- OUT : N/A --
62 -- --
63 --------------------------------------------------------------------------
64 --
65
66 PROCEDURE assignment_action_code
67 (
68 p_payroll_action_id IN NUMBER
69 ,p_start_person IN NUMBER
70 ,p_end_person IN NUMBER
71 ,p_chunk IN NUMBER
72 );
73 --
74
75 --------------------------------------------------------------------------
76 -- --
77 -- Name : ARCHIVE_CODE --
78 -- Type : PROCEDURE --
79 -- Access : Public --
80 -- Description : Procedure to call the internal procedures to --
81 -- actually archive the data. The procedures --
82 -- called are --
83 -- archive_pf_balances --
84 -- archive_pf_emp_dtls --
85 -- archive_pf_org_dtls --
86 -- archive_pf_challan_dtls --
87 -- archive_pf_7Q_dtls --
88 -- archive_pf_misc_dtls --
89 -- --
90 -- Parameters : --
91 -- IN : p_assignment_action_id NUMBER --
92 -- p_effective_date DATE --
93 -- --
94 -- OUT : N/A --
95 --------------------------------------------------------------------------
96 --
97
98 PROCEDURE archive_code
99 (
100 p_assignment_action_id IN NUMBER
101 ,p_effective_date IN DATE
102 );
103 --
104
105
106
107
108 END pay_in_pf_archive;