119: , src.global_attribute2 init_trx_num
120: , src.global_attribute4 fin_trx_num
121: , src.global_attribute5 last_trx_date
122: , TO_NUMBER(src.global_attribute6) adv_days
123: FROM ra_batch_sources src
124: WHERE src.batch_source_id = x_batch_source_id
125: -- Bug 4673732 : R12 MOAC change
126: AND decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);
127:
203:
204: CURSOR c_ref_src(x_batch_source_id NUMBER,
205: x_org_id NUMBER) IS
206: SELECT src.global_attribute1
207: FROM ra_batch_sources src
208: WHERE src.batch_source_id = x_batch_source_id
209: -- Bug 4673732 : R12 MOAC change
210: AND decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);
211: BEGIN
236:
237: CURSOR c_inv_word(x_batch_source_id NUMBER,
238: x_org_id NUMBER) IS
239: SELECT src.global_attribute3
240: FROM ra_batch_sources src
241: WHERE src.batch_source_id = x_batch_source_id
242: -- Bug 4673732 : R12 MOAC change
243: AND decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);
244: BEGIN
278: SELECT decode(src.global_attribute1
279: , NULL
280: , x_batch_source_id
281: , src.global_attribute1)
282: FROM ra_batch_sources src
283: WHERE src.batch_source_id = x_batch_source_id
284: -- Bug 4673732 : R12 MOAC change
285: AND decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);
286: BEGIN
322: , 'FIN'
323: , src.global_attribute4
324: , NULL)
325: FROM
326: ra_batch_sources src
327: WHERE
328: src.batch_source_id = x_batch_source_id
329: -- Bug 4673732 : R12 MOAC change
330: AND decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);
360:
361: CURSOR c_last_trx_date(x_gui_source_id NUMBER,
362: x_org_id NUMBER) IS
363: SELECT fnd_date.chardate_to_date(src.global_attribute5)
364: FROM ra_batch_sources src
365: WHERE src.batch_source_id = x_gui_source_id
366: -- Bug 4673732 : R12 MOAC change
367: AND decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);
368: BEGIN
394:
395: CURSOR c_adv_days(x_batch_source_id NUMBER,
396: x_org_id NUMBER) IS
397: SELECT src.global_attribute6
398: FROM ra_batch_sources src
399: WHERE src.batch_source_id = x_batch_source_id
400: -- Bug 4673732 : R12 MOAC change
401: AND decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);
402: BEGIN
757: CURSOR c_last_issued_date(
758: x_batch_source_id NUMBER,
759: x_org_id NUMBER) IS
760: SELECT global_attribute5
761: FROM ra_batch_sources src
762: WHERE batch_source_id = x_batch_source_id
763: -- Bug 4673732 : R12 MOAC change
764: AND decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1)
765: FOR UPDATE OF global_attribute5 NOWAIT;
778: OPEN c_last_issued_date(l_gui_source_id,
779: p_org_id);
780: FETCH c_last_issued_date INTO l_dummy;
781:
782: UPDATE ra_batch_sources
783: SET global_attribute5 = l_last_trx_date
784: WHERE CURRENT OF c_last_issued_date;
785:
786: CLOSE c_last_issued_date;