[Home] [Help]
PACKAGE BODY: APPS.JAI_RCV_RRSL_TRIGGER_PKG
Source
1 PACKAGE BODY JAI_RCV_RRSL_TRIGGER_PKG AS
2 /* $Header: jai_rcv_rrsl_t.plb 120.0 2005/09/01 12:37:22 rallamse noship $ */
3
4 /* REM +======================================================================+
5 REM NAME ARIU_T1
6 REM
7 REM DESCRIPTION Called from trigger JAI_RCV_RRSL_ARIUD_T1
8 REM
9 REM NOTES Refers to old trigger JAI_RCV_RRSL_ARIU_T1
10 REM
11 REM +======================================================================+
12 */
13 PROCEDURE ARIU_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
14 BEGIN
15 pv_return_code := jai_constants.successful ;
16 --added the below by Sanjikum for Bug#4035297
17
18 --IF jai_cmn_utils_pkg.check_jai_exists(p_calling_object => 'JA_IN_SUB_LEDGER_TRG',
19 -- p_set_of_books_id => pr_new.set_of_books_id) = FALSE THEN
20 -- RETURN;
21 -- END IF;
22
23
24
25 /*------------------------------------------------------------------------------------------
26 FILENAME: ja_in_sub_ledger_trg.sql
27
28 CHANGE HISTORY:
29 S.No Date Author and Details
30 1 29-Nov-2004 Sanjikum for 4035297. Version 115.1
31 Commented the WHEN condition and added the call to jai_cmn_utils_pkg.check_jai_exists
32
33 Dependency Due to this Bug:-
34 The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
35
36 2. 08-Jun-2005 This Object is Modified to refer to New DB Entry names in place of Old
37 DB as required for CASE COMPLAINCE. Version 116.1
38
39 3 . 13-Jun-2005 File Version: 116.2
40 Ramananda for bug#4428980. Removal of SQL LITERALs is done
41
42 Future Dependencies For the release Of this Object:-
43 (Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/
44 A datamodel change )
45 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
46 Current Version Current Bug Dependent Files Version Author Date Remarks
47 Of File On Bug/Patchset Dependent On
48
49 ja_in_sub_ledger_trg.sql
50 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
51 115.1 4035297 IN60105D2+4033992 ja_in_util_pkg_s.sql 115.0 Sanjikum 29-Nov-2004 Call to this function.
52 ja_in_util_pkg_s.sql 115.0 Sanjikum
53
54 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
55
56
57 IF pv_action = jai_constants.INSERTING THEN --1
58 INSERT INTO JAI_RCV_SUBLED_ENTRIES(SUBLED_ENTRY_ID,LAST_UPDATE_DATE,
59 LAST_UPDATED_BY,
60 CREATION_DATE,
61 CREATED_BY,
62 LAST_UPDATE_LOGIN,
63 RCV_TRANSACTION_ID,
64 CURRENCY_CODE,
65 ACTUAL_FLAG,
66 JE_SOURCE_NAME,
67 JE_CATEGORY_NAME,
68 SET_OF_BOOKS_ID,
69 ACCOUNTING_DATE,
70 CODE_COMBINATION_ID,
71 ACCOUNTED_DR,
72 ACCOUNTED_CR,
73 ENCUMBRANCE_TYPE_ID,
74 ENTERED_DR,
75 ENTERED_CR,
76 BUDGET_VERSION_ID,
77 CURRENCY_CONVERSION_DATE,
78 USER_CURRENCY_CONVERSION_TYPE,
79 CURRENCY_CONVERSION_RATE,
80 TRANSACTION_DATE,
81 PERIOD_NAME,
82 CHART_OF_ACCOUNTS_ID,
83 FUNCTIONAL_CURRENCY_CODE,
84 DATE_CREATED_IN_GL,
85 JE_BATCH_NAME,
86 JE_BATCH_DESCRIPTION,
87 JE_HEADER_NAME,
88 JE_LINE_DESCRIPTION,
89 REVERSE_JOURNAL_FLAG,
90 REVERSAL_PERIOD_NAME,
91 ATTRIBUTE_CATEGORY,
92 ATTRIBUTE1,
93 ATTRIBUTE2,
94 ATTRIBUTE3,
95 ATTRIBUTE4,
96 ATTRIBUTE5,
97 ATTRIBUTE6,
98 ATTRIBUTE7,
99 ATTRIBUTE8,
100 ATTRIBUTE9,
101 ATTRIBUTE10,
102 ATTRIBUTE11,
103 ATTRIBUTE12,
104 ATTRIBUTE13,
105 ATTRIBUTE14,
106 ATTRIBUTE15,
107 REQUEST_ID,
108 PROGRAM_APPLICATION_ID,
109 PROGRAM_ID,
110 PROGRAM_UPDATE_DATE,
111 --SUBLEDGER_DOC_SEQUENCE_ID,
112 --SUBLEDGER_DOC_SEQUENCE_VALUE,
113 USSGL_TRANSACTION_CODE,
114 REFERENCE1,
115 REFERENCE2,
116 REFERENCE3,
117 REFERENCE4,
118 REFERENCE5,
119 REFERENCE6,
120 REFERENCE7,
121 REFERENCE8,
122 REFERENCE9,
123 REFERENCE10,
124 SOURCE_DOC_QUANTITY,
125 FROM_TYPE
126 )
127 VALUES( JAI_RCV_SUBLED_ENTRIES_S.nextval,
128 pr_new.LAST_UPDATE_DATE,
129 pr_new.LAST_UPDATED_BY,
130 pr_new.CREATION_DATE,
131 pr_new.CREATED_BY,
132 pr_new.LAST_UPDATE_LOGIN,
133 pr_new.RCV_TRANSACTION_ID,
134 pr_new.CURRENCY_CODE,
135 pr_new.ACTUAL_FLAG,
136 pr_new.JE_SOURCE_NAME,
137 pr_new.JE_CATEGORY_NAME,
138 pr_new.SET_OF_BOOKS_ID,
139 pr_new.ACCOUNTING_DATE,
140 pr_new.CODE_COMBINATION_ID,
141 pr_new.ACCOUNTED_DR,
142 pr_new.ACCOUNTED_CR,
143 pr_new.ENCUMBRANCE_TYPE_ID,
144 pr_new.ENTERED_DR,
145 pr_new.ENTERED_CR,
146 pr_new.BUDGET_VERSION_ID,
147 pr_new.CURRENCY_CONVERSION_DATE,
148 pr_new.USER_CURRENCY_CONVERSION_TYPE,
149 pr_new.CURRENCY_CONVERSION_RATE,
150 pr_new.TRANSACTION_DATE,
151 pr_new.PERIOD_NAME,
152 pr_new.CHART_OF_ACCOUNTS_ID,
153 pr_new.FUNCTIONAL_CURRENCY_CODE,
154 pr_new.DATE_CREATED_IN_GL,
155 pr_new.JE_BATCH_NAME,
156 pr_new.JE_BATCH_DESCRIPTION,
157 pr_new.JE_HEADER_NAME,
158 pr_new.JE_LINE_DESCRIPTION,
159 pr_new.REVERSE_JOURNAL_FLAG,
160 pr_new.REVERSAL_PERIOD_NAME,
161 pr_new.ATTRIBUTE_CATEGORY,
162 pr_new.ATTRIBUTE1,
163 pr_new.ATTRIBUTE2,
164 pr_new.ATTRIBUTE3,
165 pr_new.ATTRIBUTE4,
166 pr_new.ATTRIBUTE5,
167 pr_new.ATTRIBUTE6,
168 pr_new.ATTRIBUTE7,
169 pr_new.ATTRIBUTE8,
170 pr_new.ATTRIBUTE9,
171 pr_new.ATTRIBUTE10,
172 pr_new.ATTRIBUTE11,
173 pr_new.ATTRIBUTE12,
174 pr_new.ATTRIBUTE13,
175 pr_new.ATTRIBUTE14,
176 pr_new.ATTRIBUTE15,
177 pr_new.REQUEST_ID,
178 pr_new.PROGRAM_APPLICATION_ID,
179 pr_new.PROGRAM_ID,
180 pr_new.PROGRAM_UPDATE_DATE,
181 --pr_new.SUBLEDGER_DOC_SEQUENCE_ID,
182 --pr_new.SUBLEDGER_DOC_SEQUENCE_VALUE,
183 pr_new.USSGL_TRANSACTION_CODE,
184 pr_new.REFERENCE1,
185 pr_new.REFERENCE2,
186 pr_new.REFERENCE3,
187 pr_new.REFERENCE4,
188 pr_new.REFERENCE5,
189 pr_new.REFERENCE6,
190 pr_new.REFERENCE7,
191 pr_new.REFERENCE8,
192 pr_new.REFERENCE9,
193 pr_new.REFERENCE10,
194 pr_new.SOURCE_DOC_QUANTITY,
195 'A'
196 );
197 ELSIF pv_action = jai_constants.UPDATING THEN
198
199 UPDATE JAI_RCV_SUBLED_ENTRIES
200 SET LAST_UPDATE_DATE = pr_new.LAST_UPDATE_DATE,
201 LAST_UPDATED_BY = pr_new.LAST_UPDATED_BY,
202 CREATION_DATE = pr_new.CREATION_DATE,
203 CREATED_BY = pr_new.CREATED_BY,
204 LAST_UPDATE_LOGIN = pr_new.LAST_UPDATE_LOGIN,
205 RCV_TRANSACTION_ID = pr_new.RCV_TRANSACTION_ID,
206 CURRENCY_CODE = pr_new.CURRENCY_CODE,
207 ACTUAL_FLAG = pr_new.ACTUAL_FLAG,
208 JE_SOURCE_NAME = pr_new.JE_SOURCE_NAME,
209 JE_CATEGORY_NAME = pr_new.JE_CATEGORY_NAME,
210 SET_OF_BOOKS_ID = pr_new.SET_OF_BOOKS_ID,
211 ACCOUNTING_DATE = pr_new.ACCOUNTING_DATE,
212 CODE_COMBINATION_ID = pr_new.CODE_COMBINATION_ID,
213 ACCOUNTED_DR = pr_new.ACCOUNTED_DR,
214 ACCOUNTED_CR = pr_new.ACCOUNTED_CR,
215 ENCUMBRANCE_TYPE_ID = pr_new.ENCUMBRANCE_TYPE_ID,
216 ENTERED_DR = pr_new.ENTERED_DR,
217 ENTERED_CR = pr_new.ENTERED_CR,
218 BUDGET_VERSION_ID = pr_new.BUDGET_VERSION_ID,
219 CURRENCY_CONVERSION_DATE = pr_new.CURRENCY_CONVERSION_DATE,
220 USER_CURRENCY_CONVERSION_TYPE = pr_new.USER_CURRENCY_CONVERSION_TYPE,
221 CURRENCY_CONVERSION_RATE = pr_new.CURRENCY_CONVERSION_RATE,
222 TRANSACTION_DATE = pr_new.TRANSACTION_DATE,
223 PERIOD_NAME = pr_new.PERIOD_NAME,
224 CHART_OF_ACCOUNTS_ID = pr_new.CHART_OF_ACCOUNTS_ID,
225 FUNCTIONAL_CURRENCY_CODE = pr_new.FUNCTIONAL_CURRENCY_CODE,
226 DATE_CREATED_IN_GL = pr_new.DATE_CREATED_IN_GL,
227 JE_BATCH_NAME = pr_new.JE_BATCH_NAME,
228 JE_BATCH_DESCRIPTION = pr_new.JE_BATCH_DESCRIPTION,
229 JE_HEADER_NAME = pr_new.JE_HEADER_NAME,
230 JE_LINE_DESCRIPTION = pr_new.JE_LINE_DESCRIPTION,
231 REVERSE_JOURNAL_FLAG = pr_new.REVERSE_JOURNAL_FLAG,
232 REVERSAL_PERIOD_NAME = pr_new.REVERSAL_PERIOD_NAME,
233 ATTRIBUTE_CATEGORY = pr_new.ATTRIBUTE_CATEGORY,
234 ATTRIBUTE1 = pr_new.ATTRIBUTE1,
235 ATTRIBUTE2 = pr_new.ATTRIBUTE2,
236 ATTRIBUTE3 = pr_new.ATTRIBUTE3,
237 ATTRIBUTE4 = pr_new.ATTRIBUTE4,
238 ATTRIBUTE5 = pr_new.ATTRIBUTE5,
239 ATTRIBUTE6 = pr_new.ATTRIBUTE6,
240 ATTRIBUTE7 = pr_new.ATTRIBUTE7,
241 ATTRIBUTE8 = pr_new.ATTRIBUTE8,
242 ATTRIBUTE9 = pr_new.ATTRIBUTE9,
243 ATTRIBUTE10 = pr_new.ATTRIBUTE10,
244 ATTRIBUTE11 = pr_new.ATTRIBUTE11,
245 ATTRIBUTE12 = pr_new.ATTRIBUTE12,
246 ATTRIBUTE13 = pr_new.ATTRIBUTE13,
247 ATTRIBUTE14 = pr_new.ATTRIBUTE14,
248 ATTRIBUTE15 = pr_new.ATTRIBUTE15,
249 REQUEST_ID = pr_new.REQUEST_ID,
250 PROGRAM_APPLICATION_ID = pr_new.PROGRAM_APPLICATION_ID,
251 PROGRAM_ID = pr_new.PROGRAM_ID,
252 PROGRAM_UPDATE_DATE = pr_new.PROGRAM_UPDATE_DATE,
253 --SUBLEDGER_DOC_SEQUENCE_ID = pr_new.SUBLEDGER_DOC_SEQUENCE_ID,
254 --SUBLEDGER_DOC_SEQUENCE_VALUE = pr_new.SUBLEDGER_DOC_SEQUENCE_VALUE,
255 USSGL_TRANSACTION_CODE = pr_new.USSGL_TRANSACTION_CODE,
256 REFERENCE1 = pr_new.REFERENCE1,
257 REFERENCE2 = pr_new.REFERENCE2,
258 REFERENCE3 = pr_new.REFERENCE3,
259 REFERENCE4 = pr_new.REFERENCE4,
260 REFERENCE5 = pr_new.REFERENCE5,
261 REFERENCE6 = pr_new.REFERENCE6,
262 REFERENCE7 = pr_new.REFERENCE7,
263 REFERENCE8 = pr_new.REFERENCE8,
264 REFERENCE9 = pr_new.REFERENCE9,
265 REFERENCE10 = pr_new.REFERENCE10,
266 SOURCE_DOC_QUANTITY = pr_new.SOURCE_DOC_QUANTITY
267 WHERE from_type = 'A'
268 AND rcv_transaction_id = pr_old.rcv_transaction_id
269 AND ((entered_dr IS NULL AND entered_cr = pr_old.entered_cr) OR
270 (entered_cr IS NULL AND entered_dr = pr_old.entered_dr));
271
272
273 END IF; --1
274 END ARIU_T1 ;
275
276 END JAI_RCV_RRSL_TRIGGER_PKG ;