1 PACKAGE PSP_SUM_TRANS AUTHID CURRENT_USER as
2 /* $Header: PSPTRSTS.pls 120.2.12020000.3 2013/04/13 09:43:05 lkodaman ship $ */
3 g_run_id NUMBER(10);
4 -- Extending the length of this variable from 500 to 2000 as part of bug fix 1776606
5 g_error_api_path VARCHAR2(2000) := '';
6
7 PROCEDURE sum_and_transfer(errbuf OUT NOCOPY VARCHAR2,
8 retcode OUT NOCOPY VARCHAR2,
9 p_source_type IN VARCHAR2,
10 p_source_code IN VARCHAR2,
11 p_payroll_id IN NUMBER,
12 p_time_period_id IN NUMBER,
13 p_batch_name IN VARCHAR2,
14 p_business_group_id IN NUMBER,
15 p_set_of_books_id IN NUMBER);
16
17 PROCEDURE mark_batch_begin(p_source_type IN VARCHAR2,
18 p_source_code IN VARCHAR2,
19 p_payroll_id IN NUMBER,
20 p_time_period_id IN NUMBER,
21 p_batch_name IN VARCHAR2,
22 p_business_group_id IN NUMBER,
23 p_set_of_books_id IN NUMBER,
24 p_return_status OUT NOCOPY VARCHAR2);
25
26
27 PROCEDURE mark_batch_end(p_source_type IN VARCHAR2,
28 p_source_code IN VARCHAR2,
29 p_time_period_id IN NUMBER,
30 p_batch_name IN VARCHAR2,
31 p_business_group_id IN NUMBER,
32 p_set_of_books_id IN NUMBER,
33 p_return_status OUT NOCOPY VARCHAR2);
34
35
36 PROCEDURE create_gl_sum_lines(p_source_type IN VARCHAR2,
37 p_source_code IN VARCHAR2,
38 p_time_period_id IN NUMBER,
39 p_batch_name IN VARCHAR2,
40 p_business_group_id IN NUMBER,
41 p_set_of_books_id IN NUMBER,
42 p_return_status OUT NOCOPY VARCHAR2);
43
44
45 PROCEDURE insert_into_summary_lines(
46 P_SUMMARY_LINE_ID OUT NOCOPY NUMBER,
47 P_PERSON_ID IN NUMBER,
48 P_ASSIGNMENT_ID IN NUMBER,
49 P_TIME_PERIOD_ID IN NUMBER,
50 P_EFFECTIVE_DATE IN DATE,
51 P_ACCOUNTING_DATE IN DATE,
52 P_EXCHANGE_RATE_TYPE IN VARCHAR2,
53 P_SOURCE_TYPE IN VARCHAR2,
54 P_SOURCE_CODE IN VARCHAR2,
55 P_SET_OF_BOOKS_ID IN NUMBER,
56 P_GL_CODE_COMBINATION_ID IN NUMBER,
57 P_PROJECT_ID IN NUMBER,
58 P_EXPENDITURE_ORGANIZATION_ID IN NUMBER,
59 P_EXPENDITURE_TYPE IN VARCHAR2,
60 P_TASK_ID IN NUMBER,
61 P_AWARD_ID IN NUMBER,
62 P_SUMMARY_AMOUNT IN NUMBER,
63 P_DR_CR_FLAG IN VARCHAR2,
64 P_STATUS_CODE IN VARCHAR2,
65 P_INTERFACE_BATCH_NAME IN VARCHAR2,
66 P_PAYROLL_CONTROL_ID IN NUMBER,
67 p_business_group_id IN NUMBER,
68 p_attribute_category IN VARCHAR2, -- Introduced DFF columns for bug fix 2908859
69 p_attribute1 IN VARCHAR2,
70 p_attribute2 IN VARCHAR2,
71 p_attribute3 IN VARCHAR2,
72 p_attribute4 IN VARCHAR2,
73 p_attribute5 IN VARCHAR2,
74 p_attribute6 IN VARCHAR2,
75 p_attribute7 IN VARCHAR2,
76 p_attribute8 IN VARCHAR2,
77 p_attribute9 IN VARCHAR2,
78 p_attribute10 IN VARCHAR2,
79 P_RETURN_STATUS OUT NOCOPY VARCHAR2,
80 p_org_id IN NUMBER DEFAULT NULL -- R12 MOAC Uptake
81 );
82
83
84 PROCEDURE transfer_to_gl_interface(p_source_type IN VARCHAR2,
85 p_source_code IN VARCHAR2,
86 p_time_period_id IN NUMBER,
87 p_batch_name IN VARCHAR2,
88 p_business_group_id IN NUMBER,
89 p_set_of_books_id IN NUMBER,
90 p_return_status OUT NOCOPY VARCHAR2);
91
92
93 PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,
94 P_RETURN_STATUS OUT NOCOPY VARCHAR2);
95
96
97 PROCEDURE get_gl_je_categories(P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,
98 P_RETURN_STATUS OUT NOCOPY VARCHAR2);
99
100 PROCEDURE get_encum_type_id(P_ENCUMBRANCE_TYPE_ID OUT NOCOPY VARCHAR2,
101 P_RETURN_STATUS OUT NOCOPY VARCHAR2);
102
103
104 PROCEDURE gl_tie_back(p_payroll_control_id IN NUMBER,
105 p_source_type IN VARCHAR2,
106 p_period_end_date IN DATE,
107 p_group_id IN NUMBER,
108 p_business_group_id IN NUMBER,
109 p_set_of_books_id IN NUMBER,
110 p_mode IN VARCHAR2,
111 p_return_status OUT NOCOPY VARCHAR2);
112
113
114 PROCEDURE gl_balance_transaction(
115 P_SOURCE_TYPE IN VARCHAR2,
116 P_PAYROLL_CONTROL_ID IN NUMBER,
117 p_business_group_id IN NUMBER,
118 p_set_of_books_id IN NUMBER,
119 P_PRECISION IN NUMBER,
120 P_RETURN_STATUS OUT NOCOPY VARCHAR2);
121
122 PROCEDURE insert_into_gl_interface(
123 P_SET_OF_BOOKS_ID IN NUMBER,
124 P_ACCOUNTING_DATE IN DATE,
125 P_CURRENCY_CODE IN VARCHAR2,
126 P_USER_JE_CATEGORY_NAME IN VARCHAR2,
127 P_USER_JE_SOURCE_NAME IN VARCHAR2,
128 P_ENCUMBRANCE_TYPE_ID IN NUMBER,
129 P_CODE_COMBINATION_ID IN NUMBER,
130 P_ENTERED_DR IN NUMBER,
131 P_ENTERED_CR IN NUMBER,
132 P_GROUP_ID IN NUMBER,
133 P_REFERENCE1 IN VARCHAR2,
134 P_REFERENCE2 IN VARCHAR2,
135 P_REFERENCE4 IN VARCHAR2,
136 P_REFERENCE6 IN VARCHAR2,
137 P_REFERENCE10 IN VARCHAR2,
138 P_ATTRIBUTE1 IN VARCHAR2,
139 P_ATTRIBUTE2 IN VARCHAR2,
140 P_ATTRIBUTE3 IN VARCHAR2,
141 P_ATTRIBUTE4 IN VARCHAR2,
142 P_ATTRIBUTE5 IN VARCHAR2,
143 P_ATTRIBUTE6 IN VARCHAR2,
144 P_ATTRIBUTE7 IN VARCHAR2,
145 P_ATTRIBUTE8 IN VARCHAR2,
146 P_ATTRIBUTE9 IN VARCHAR2,
147 P_ATTRIBUTE10 IN VARCHAR2,
148 P_ATTRIBUTE11 IN VARCHAR2,
149 P_ATTRIBUTE12 IN VARCHAR2,
150 P_ATTRIBUTE13 IN VARCHAR2,
151 P_ATTRIBUTE14 IN VARCHAR2,
152 P_ATTRIBUTE15 IN VARCHAR2,
153 P_ATTRIBUTE16 IN VARCHAR2,
154 P_ATTRIBUTE17 IN VARCHAR2,
155 P_ATTRIBUTE18 IN VARCHAR2,
156 P_ATTRIBUTE19 IN VARCHAR2,
157 P_ATTRIBUTE20 IN VARCHAR2,
158 P_ATTRIBUTE21 IN VARCHAR2,
159 P_ATTRIBUTE22 IN VARCHAR2,
160 P_ATTRIBUTE23 IN VARCHAR2,
161 P_ATTRIBUTE24 IN VARCHAR2,
162 P_ATTRIBUTE25 IN VARCHAR2,
163 P_ATTRIBUTE26 IN VARCHAR2,
164 P_ATTRIBUTE27 IN VARCHAR2,
165 P_ATTRIBUTE28 IN VARCHAR2,
166 P_ATTRIBUTE29 IN VARCHAR2,
167 P_ATTRIBUTE30 IN VARCHAR2,
168 P_CURRENCY_CONVERSION_TYPE IN VARCHAR2,-- Introduced for Bug 2916848
169 P_CURRENCY_CONVERSION_DATE IN DATE,-- Introduced for Bug 2916848
170 P_RETURN_STATUS OUT NOCOPY VARCHAR2);
171
172
173 PROCEDURE create_gms_sum_lines(p_source_type IN VARCHAR2,
174 p_source_code IN VARCHAR2,
175 p_time_period_id IN NUMBER,
176 p_batch_name IN VARCHAR2,
177 p_business_group_id IN NUMBER,
178 p_set_of_books_id IN NUMBER,
179 p_return_status OUT NOCOPY VARCHAR2);
180
181 PROCEDURE transfer_to_gms_interface(p_source_type IN VARCHAR2,
182 p_source_code IN VARCHAR2,
183 p_time_period_id IN NUMBER,
184 p_batch_name IN VARCHAR2,
185 p_business_group_id IN NUMBER,
186 p_set_of_books_id IN NUMBER,
187 p_return_status OUT NOCOPY VARCHAR2);
188
189 PROCEDURE gms_tie_back(p_payroll_control_id IN NUMBER,
190 p_source_type IN VARCHAR2,
191 p_period_end_date IN DATE,
192 p_gms_batch_name IN VARCHAR2,
193 p_business_group_id IN NUMBER,
194 p_set_of_books_id IN NUMBER,
198
195 p_txn_source IN VARCHAR2,
196 p_mode IN VARCHAR2,
197 p_return_status OUT NOCOPY VARCHAR2);
199 PROCEDURE insert_into_pa_interface(
200 P_TRANSACTION_INTERFACE_ID IN NUMBER,
201 P_TRANSACTION_SOURCE IN VARCHAR2,
202 P_BATCH_NAME IN VARCHAR2,
203 P_EXPENDITURE_ENDING_DATE IN DATE,
204 P_EMPLOYEE_NUMBER IN VARCHAR2,
205 P_ORGANIZATION_NAME IN VARCHAR2,
206 P_EXPENDITURE_ITEM_DATE IN DATE,
207 P_PROJECT_NUMBER IN VARCHAR2,
208 -- P_TASK_NUMBER IN VARCHAR2, --Commented Bug for 16591849
209 P_TASK_ID IN NUMBER, --Added Bug for 16591849
210 P_EXPENDITURE_TYPE IN VARCHAR2,
211 P_QUANTITY IN NUMBER,
212 P_RAW_COST IN NUMBER,
213 P_EXPENDITURE_COMMENT IN VARCHAR2,
214 P_TRANSACTION_STATUS_CODE IN VARCHAR2,
215 P_ORIG_TRANSACTION_REFERENCE IN VARCHAR2,
216 P_ORG_ID IN NUMBER,
217 P_DENOM_CURRENCY_CODE IN VARCHAR2,
218 P_DENOM_RAW_COST IN NUMBER,
219 P_ATTRIBUTE1 IN VARCHAR2,
220 P_ATTRIBUTE2 IN VARCHAR2,
221 P_ATTRIBUTE3 IN VARCHAR2,
222 P_ATTRIBUTE4 IN VARCHAR2,
223 P_ATTRIBUTE5 IN VARCHAR2,
224 P_ATTRIBUTE6 IN VARCHAR2,
225 P_ATTRIBUTE7 IN VARCHAR2,
226 P_ATTRIBUTE8 IN VARCHAR2,
227 P_ATTRIBUTE9 IN VARCHAR2,
228 P_ATTRIBUTE10 IN VARCHAR2,
229 P_ACCT_RATE_TYPE IN VARCHAR2,-- Introduced for Bug 2916848
230 P_ACCT_RATE_DATE IN DATE,-- Introduced for Bug 2916848
231 P_PERSON_BUSINESS_GROUP_ID IN NUMBER,-- Introduced for Bug 2935850
232 P_RETURN_STATUS OUT NOCOPY VARCHAR2);
233
234 PROCEDURE SUPERCEDE_ER(p_run_id in integer,
235 errbuf in out nocopy varchar2,
236 retcode in out nocopy varchar2,
237 p_source_type in varchar2,
238 p_source_code in varchar2,
239 p_time_period_id in integer,
240 p_batch_name in varchar2,
241 p_return_status out nocopy varchar2);
242
243 END PSP_SUM_TRANS;