1 PACKAGE PAY_DK_ARCHIVE AS
2 /* $Header: pydkparc.pkh 120.0.12000000.1 2007/01/17 18:29:12 appldev noship $ */
3
4
5 --------------------- FUNCTION GET_PARAMETER ------------------------------------------
6
7 FUNCTION GET_PARAMETER(p_parameter_string IN VARCHAR2
8 ,p_token IN VARCHAR2
9 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2;
10
11
12 --------------------- PROCEDURE GET_ALL_PARAMETERS ------------------------------------
13
14 PROCEDURE GET_ALL_PARAMETERS(p_payroll_action_id IN NUMBER
15 ,p_business_group_id OUT NOCOPY NUMBER
16 ,p_start_date OUT NOCOPY VARCHAR2
17 ,p_end_date OUT NOCOPY VARCHAR2
18 ,p_effective_date OUT NOCOPY DATE
19 ,p_payroll_id OUT NOCOPY VARCHAR2
20 ,p_consolidation_set OUT NOCOPY VARCHAR2);
21
22 --------------------- PROCEDURE RANGE_CODE --------------------------------------------
23
24 PROCEDURE RANGE_CODE (p_payroll_action_id IN NUMBER
25 ,p_sql OUT NOCOPY VARCHAR2) ;
26
27 --------------------- PROCEDURE ASSIGNMENT_ACTION_CODE --------------------------------
28
29 PROCEDURE ASSIGNMENT_ACTION_CODE (p_payroll_action_id IN NUMBER
30 ,p_start_person IN NUMBER
31 ,p_end_person IN NUMBER
32 ,p_chunk IN NUMBER);
33
34 --------------------- PROCEDURE INITIALIZATION_CODE ----------------------------------
35
36 PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER);
37
38 --------------------- PROCEDURE SETUP_ELEMENT_DEFINITIONS ----------------------------
39
40 PROCEDURE SETUP_ELEMENT_DEFINITIONS( p_classification_name IN VARCHAR2
41 ,p_element_name IN VARCHAR2
42 ,p_element_type_id IN NUMBER
43 ,p_input_value_id IN NUMBER
44 ,p_element_type IN VARCHAR2
45 ,p_uom IN VARCHAR2
46 ,p_archive_flag IN VARCHAR2);
47
48 --------------------- PROCEDURE SETUP_BALANCE_DEFINITIONS -----------------------------
49
50 PROCEDURE SETUP_BALANCE_DEFINITIONS(p_balance_name IN VARCHAR2
51 ,p_defined_balance_id IN NUMBER
52 ,p_balance_type_id IN NUMBER);
53
54 --------------------- FUNCTION GET_COUNTRY_NAME ---------------------------------------
55
56 FUNCTION GET_COUNTRY_NAME(p_territory_code VARCHAR2) RETURN VARCHAR2;
57
58 --------------------- PROCEDURE ARCHIVE_EMPLOYEE_DETAILS -----------------------------
59
60 PROCEDURE ARCHIVE_EMPLOYEE_DETAILS (p_archive_assact_id IN NUMBER
61 ,p_assignment_id IN NUMBER
62 ,p_assignment_action_id IN NUMBER
63 ,p_payroll_action_id IN NUMBER
64 ,p_time_period_id IN NUMBER
65 ,p_date_earned IN DATE
66 ,p_pay_date_earned IN DATE
67 ,p_effective_date IN DATE);
68
69 ---------------------- PROCEDURE ARCHIVE_ELEMENT_INFO ---------------------------------
70
71 PROCEDURE ARCHIVE_ELEMENT_INFO( p_payroll_action_id IN NUMBER
72 ,p_effective_date IN DATE
73 ,p_date_earned IN DATE
74 ,p_pre_payact_id IN NUMBER);
75
76 ----------------------- FUNCTION GET_DEFINED_BALANCE_ID -------------------------------
77
78 FUNCTION GET_DEFINED_BALANCE_ID(p_user_name IN VARCHAR2) RETURN NUMBER;
79
80 ----------------------- PROCEDURE ARCHIVE_PAYMENT_INFO -------------------------------
81
82 PROCEDURE ARCHIVE_PAYMENT_INFO(p_archive_assact_id IN NUMBER,
83 p_prepay_assact_id IN NUMBER,
84 p_assignment_id IN NUMBER,
85 p_date_earned IN DATE,
86 p_effective_date IN DATE);
87
88 ------------------------ PROCEDURE ARCHIVE_ADD_ELEMENT ------------------------------
89
90 PROCEDURE ARCHIVE_ADD_ELEMENT(p_archive_assact_id IN NUMBER,
91 p_assignment_action_id IN NUMBER,
92 p_assignment_id IN NUMBER,
93 p_payroll_action_id IN NUMBER,
94 p_date_earned IN DATE,
95 p_effective_date IN DATE,
96 p_pre_payact_id IN NUMBER,
97 p_archive_flag IN VARCHAR2);
98
99 -------------------------- PROCEDURE ARCHIVE_OTH_BALANCE -----------------------------
100
101 PROCEDURE ARCHIVE_OTH_BALANCE(p_archive_assact_id IN NUMBER,
102 p_assignment_action_id IN NUMBER,
103 p_assignment_id IN NUMBER,
104 p_payroll_action_id IN NUMBER,
105 p_record_count IN NUMBER,
106 p_pre_payact_id IN NUMBER,
107 p_effective_date IN DATE,
108 p_date_earned IN DATE,
109 p_archive_flag IN VARCHAR2);
110
111
112 ----------------------------- PROCEDURE ARCHIVE_CODE --------------------------------
113
114 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
115 ,p_effective_date IN DATE);
116
117
118 ------------------------------ PROCEDURE ARCHIVE_ADDL_EMP_DETAILS ------------------
119
120 PROCEDURE ARCHIVE_ADDL_EMP_DETAILS(p_archive_assact_id IN NUMBER
121 ,p_assignment_id IN NUMBER
122 ,p_assignment_action_id IN NUMBER
123 ,p_effective_date IN DATE
124 ,p_date_earned IN DATE
125 ,p_payroll_action_id IN NUMBER ) ;
126
127
128 ------------------------------ PROCEDURE ARCHIVE_MAIN_ELEMENTS ------------------------
129
130 PROCEDURE ARCHIVE_MAIN_ELEMENTS
131 (p_archive_assact_id IN NUMBER,
132 p_assignment_action_id IN NUMBER,
133 p_assignment_id IN NUMBER,
134 p_date_earned IN DATE,
135 p_effective_date IN DATE ) ;
136
137
138 ------------------------------ End of package ---------------------------------------------
139
140 END PAY_DK_ARCHIVE ;