1 PACKAGE PSP_ENC_LIQ_TRAN AUTHID CURRENT_USER AS
2 /* $Header: PSPENLQS.pls 120.2.12000000.1 2007/01/18 12:09:40 appldev noship $ */
3 g_run_id NUMBER(10);
4 g_error_api_path VARCHAR2(500) := '';
5
6 --PROCEDURE enc_liq_trans( errbuf OUT NOCOPY VARCHAR2,
7 -- retcode OUT NOCOPY VARCHAR2,
8 PROCEDURE enc_liq_trans( p_payroll_action_id IN NUMBER,
9 -- p_payroll_id IN NUMBER,
10 -- p_action_type IN VARCHAR2,
11 p_business_group_id IN NUMBER,
12 p_set_of_books_id IN NUMBER,
13 p_return_status OUT NOCOPY VARCHAR2
14 );
15
16 PROCEDURE enc_batch_begin(p_payroll_action_id IN NUMBER,
17 -- p_payroll_id IN NUMBER,
18 -- p_action_type IN VARCHAR2,
19 p_return_status OUT NOCOPY VARCHAR2
20 );
21
22 PROCEDURE enc_batch_end( p_payroll_action_id IN NUMBER,
23 -- p_payroll_id IN NUMBER,
24 -- p_action_type IN VARCHAR2,
25 -- p_mode in varchar2, ---Bug 2039196: three new params
26 p_business_group_id in number,
27 p_set_of_books_id in number,
28 p_return_status OUT NOCOPY VARCHAR2
29 );
30
31 PROCEDURE create_gl_enc_liq_lines(p_payroll_id IN NUMBER,
32 p_action_type IN VARCHAR2,
33 p_return_status OUT NOCOPY VARCHAR2
34 );
35 /***** Commented for bug fix 4625734
36 PROCEDURE insert_into_enc_sum_lines(
37 p_enc_summary_line_id OUT NOCOPY NUMBER,
38 p_business_group_id IN NUMBER,
39 p_enc_control_id IN NUMBER,
40 p_time_period_id IN NUMBER,
41 p_person_id IN NUMBER,
42 p_assignment_id IN NUMBER,
43 p_effective_date IN DATE,
44 p_set_of_books_id IN NUMBER,
45 p_gl_code_combination_id IN NUMBER,
46 p_project_id IN NUMBER,
47 p_expenditure_organization_id IN NUMBER,
48 p_expenditure_type IN VARCHAR2,
49 p_task_id IN NUMBER,
50 p_award_id IN NUMBER,
51 p_summary_amount IN NUMBER,
52 p_dr_cr_flag IN VARCHAR2,
53 p_status_code IN VARCHAR2,
54 p_payroll_id IN NUMBER,
55 p_gl_period_id IN NUMBER,
56 p_gl_project_flag IN VARCHAR2,
57 p_suspense_org_account_id IN NUMBER,
58 p_superceded_line_id IN NUMBER,
59 p_gms_posting_override_date IN DATE,
60 p_gl_posting_override_date IN DATE,
61 p_attribute_category IN VARCHAR2, -- Introduced DFF columns for bug fix 2908859
62 p_attribute1 IN VARCHAR2,
63 p_attribute2 IN VARCHAR2,
64 p_attribute3 IN VARCHAR2,
65 p_attribute4 IN VARCHAR2,
66 p_attribute5 IN VARCHAR2,
67 p_attribute6 IN VARCHAR2,
68 p_attribute7 IN VARCHAR2,
69 p_attribute8 IN VARCHAR2,
70 p_attribute9 IN VARCHAR2,
71 p_attribute10 IN VARCHAR2,
72 p_expenditure_item_id IN NUMBER, -- Introduced for bug fix 4068182
73 p_return_status OUT NOCOPY VARCHAR2
74 );
75 End of comment for bug fix 4625734 *****/
76
77 PROCEDURE tr_to_gl_int( p_payroll_action_id IN NUMBER,
78 -- p_payroll_id IN NUMBER,
79 -- p_action_type IN VARCHAR2, -- Added for Restart Update Enh.
80 p_return_status OUT NOCOPY VARCHAR2
81 );
82
83
84 PROCEDURE gl_je_source(
85 p_user_je_source_name OUT NOCOPY VARCHAR2,
86 p_return_status OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE gl_je_cat(
90 p_user_je_category_name OUT NOCOPY VARCHAR2,
91 p_return_status OUT NOCOPY VARCHAR2
92 );
93
94 PROCEDURE enc_type(
95 p_encumbrance_type_id OUT NOCOPY VARCHAR2,
96 p_return_status OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE gl_enc_tie_back(
100 p_enc_control_id IN NUMBER,
101 p_period_end_date IN DATE,
102 p_group_id IN NUMBER,
103 p_business_group_id IN NUMBER,
104 p_set_of_books_id IN NUMBER,
105 p_mode in varchar2, ---Bug 2039196
106 p_action_type IN VARCHAR2, -- Added for Restart Update Enh.
107 p_return_status OUT NOCOPY VARCHAR2
108 );
109 /***** Commented for bug fix 4625734
110 PROCEDURE insert_into_gl_int (
111 p_set_of_books_id IN NUMBER,
112 p_accounting_date IN DATE,
113 p_currency_code IN VARCHAR2,
114 p_user_je_category_name IN VARCHAR2,
115 p_user_je_source_name IN VARCHAR2,
116 p_encumbrance_type_id IN NUMBER,
117 p_code_combination_id IN NUMBER,
118 p_entered_dr IN NUMBER,
119 p_entered_cr IN NUMBER,
120 p_group_id IN NUMBER,
121 p_reference1 IN VARCHAR2,
122 p_reference2 IN VARCHAR2,
123 p_reference4 IN VARCHAR2,
124 p_reference6 IN VARCHAR2,
125 p_reference10 IN VARCHAR2,
126 p_attribute1 IN VARCHAR2,
127 p_attribute2 IN VARCHAR2,
128 p_attribute3 IN VARCHAR2,
129 p_attribute4 IN VARCHAR2,
130 p_attribute5 IN VARCHAR2,
131 p_attribute6 IN VARCHAR2,
132 p_attribute7 IN VARCHAR2,
133 p_attribute8 IN VARCHAR2,
134 p_attribute9 IN VARCHAR2,
135 p_attribute10 IN VARCHAR2,
136 p_attribute11 IN VARCHAR2,
137 p_attribute12 IN VARCHAR2,
138 p_attribute13 IN VARCHAR2,
139 p_attribute14 IN VARCHAR2,
140 p_attribute15 IN VARCHAR2,
141 p_attribute16 IN VARCHAR2,
142 p_attribute17 IN VARCHAR2,
143 p_attribute18 IN VARCHAR2,
144 p_attribute19 IN VARCHAR2,
145 p_attribute20 IN VARCHAR2,
146 p_attribute21 IN VARCHAR2,
147 p_attribute22 IN VARCHAR2,
148 p_attribute23 IN VARCHAR2,
149 p_attribute24 IN VARCHAR2,
150 p_attribute25 IN VARCHAR2,
151 p_attribute26 IN VARCHAR2,
152 p_attribute27 IN VARCHAR2,
153 p_attribute28 IN VARCHAR2,
154 p_attribute29 IN VARCHAR2,
155 p_attribute30 IN VARCHAR2,
156 p_return_status OUT NOCOPY VARCHAR2
157 );
158 End of comment for bug fix 4625734 *****/
159
160 PROCEDURE create_gms_enc_liq_lines(p_payroll_id IN NUMBER,
161 p_action_type IN VARCHAR2,
162 p_return_status OUT NOCOPY VARCHAR2
163 );
164
165 PROCEDURE tr_to_gms_int( p_payroll_action_id IN NUMBER,
166 -- p_payroll_id IN NUMBER,
167 -- p_action_type IN VARCHAR2, -- Added for Restart Update Enh.
168 p_return_status OUT NOCOPY VARCHAR2
169 );
170
171 PROCEDURE gms_enc_tie_back(
172 p_enc_control_id IN NUMBER,
173 p_period_end_date IN DATE,
174 p_gms_batch_name IN VARCHAR2,
175 p_business_group_id IN NUMBER,
176 p_set_of_books_id IN NUMBER,
177 p_mode in varchar2, ---Bug 2039196
178 p_action_type IN VARCHAR2, -- Added for Restart Update Enh.
179 p_return_status OUT NOCOPY VARCHAR2
180 );
181
182 /* Commented the below procedure as part of "zero work days" enhancement */
183
184 /* PROCEDURE get_effective_date(p_person_id in number,
185 p_effective_date in out NOCOPY date
186 ); */
187
188 /**** Commented for bug fix 4625734
189 PROCEDURE insert_into_pa_int(
190 p_txn_interface_id IN NUMBER,
191 p_transaction_source IN VARCHAR2,
192 p_batch_name IN VARCHAR2,
193 p_expenditure_ending_date IN DATE,
194 p_employee_number IN VARCHAR2,
195 p_organization_name IN VARCHAR2,
196 p_expenditure_item_date IN DATE,
197 p_project_number IN VARCHAR2,
198 p_task_number IN VARCHAR2,
199 p_expenditure_type IN VARCHAR2,
200 p_quantity IN NUMBER,
201 p_raw_cost IN NUMBER,
202 p_expenditure_comment IN VARCHAR2,
203 p_transaction_status_code IN VARCHAR2,
204 p_orig_transaction_reference IN VARCHAR2,
205 p_org_id IN NUMBER,
206 p_denom_currency_code IN VARCHAR2,
207 p_denom_raw_cost IN NUMBER,
208 p_attribute1 IN VARCHAR2,
209 p_attribute2 IN VARCHAR2,
210 p_attribute3 IN VARCHAR2,
211 p_attribute6 IN VARCHAR2,
212 p_attribute7 IN VARCHAR2,
213 p_attribute8 IN VARCHAR2,
214 p_attribute9 IN VARCHAR2,
215 p_attribute10 IN VARCHAR2,
216 p_person_business_group_id IN NUMBER,
217 p_return_status OUT NOCOPY VARCHAR2
218 );
219 End of comment for bug fix 4625734 *****/
220
221 /*
222 PROCEDURE insert_into_psp_stout(
223 P_MSG IN VARCHAR2);
224 */
225
226 -- Introduced move_qkupd_rec_to_hist for Quick Update Enc. enh. 2143723
227 /* Commented for Restart Update/Quick Update Encumbrance Lines Enh.
228 PROCEDURE move_qkupd_rec_to_hist
229 (p_payroll_id IN NUMBER,
230 p_action_type IN VARCHAR2,
231 p_business_group_id IN NUMBER,
232 p_set_of_books_id IN NUMBER,
233 p_return_status OUT NOCOPY VARCHAR2);
234 */
235 /***** Commented for Create and Update multi thread enh.
236 --- introduced for 3413373
237 PROCEDURE LIQUIDATE_EMP_TERM(errbuf OUT NOCOPY VARCHAR2,
238 retcode OUT NOCOPY VARCHAR2,
239 p_business_group_id in number,
240 p_set_of_books_id in number,
241 p_person_id in number,
242 p_actual_term_date in date);
243 End of comment for Create and Update multi thread enh. *****/
244
245
246 END psp_enc_liq_tran;