APPS.JA_TW_SH_GUI_UTILS dependencies on RA_BATCH_SOURCES

Line 123: FROM ra_batch_sources src

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:

Line 207: FROM ra_batch_sources src

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

Line 240: FROM ra_batch_sources src

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

Line 282: FROM ra_batch_sources src

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

Line 326: ra_batch_sources src

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);

Line 364: FROM ra_batch_sources src

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

Line 398: FROM ra_batch_sources src

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

Line 761: FROM ra_batch_sources src

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;

Line 782: UPDATE ra_batch_sources

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;