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