APPS.JA_ZZ_VALIDATE_INVOICE_GDF dependencies on RA_BATCH_SOURCES

Line 118: FROM ra_batch_sources src

114: , src.global_attribute2 init_trx_num
115: , src.global_attribute4 fin_trx_num
116: , src.global_attribute5 last_trx_date
117: , TO_NUMBER(src.global_attribute6) adv_days
118: FROM ra_batch_sources src
119: WHERE src.batch_source_id = x_batch_source_id;
120:
121: l_batch_source_id NUMBER;
122: l_trx_src_info c_trx_src_info%ROWTYPE;

Line 191: FROM ra_batch_sources src

187: l_ref_source_id NUMBER(15);
188:
189: CURSOR c_ref_src(x_batch_source_id NUMBER) IS
190: SELECT src.global_attribute1
191: FROM ra_batch_sources src
192: WHERE src.batch_source_id = x_batch_source_id;
193: BEGIN
194:
195: l_batch_source_id := p_batch_source_id;

Line 219: FROM ra_batch_sources src

215: l_inv_word VARCHAR2(2);
216:
217: CURSOR c_inv_word(x_batch_source_id NUMBER) IS
218: SELECT src.global_attribute3
219: FROM ra_batch_sources src
220: WHERE src.batch_source_id = x_batch_source_id;
221: BEGIN
222:
223: l_batch_source_id := p_batch_source_id;

Line 255: FROM ra_batch_sources src

251: SELECT decode(src.global_attribute1
252: , NULL
253: , x_batch_source_id
254: , src.global_attribute1)
255: FROM ra_batch_sources src
256: WHERE src.batch_source_id = x_batch_source_id;
257:
258: BEGIN
259:

Line 295: ra_batch_sources src

291: , 'FIN'
292: , src.global_attribute4
293: , NULL)
294: FROM
295: ra_batch_sources src
296: WHERE
297: src.batch_source_id = x_batch_source_id;
298: BEGIN
299:

Line 327: FROM ra_batch_sources src

323: l_last_trx_date DATE;
324:
325: CURSOR c_last_trx_date(x_gui_source_id NUMBER) IS
326: SELECT fnd_date.chardate_to_date(src.global_attribute5)
327: FROM ra_batch_sources src
328: WHERE src.batch_source_id = x_gui_source_id;
329:
330: BEGIN
331:

Line 356: FROM ra_batch_sources src

352: l_adv_days NUMBER;
353:
354: CURSOR c_adv_days(x_batch_source_id NUMBER) IS
355: SELECT src.global_attribute6
356: FROM ra_batch_sources src
357: WHERE src.batch_source_id = x_batch_source_id;
358:
359: BEGIN
360:

Line 765: FROM ra_batch_sources

761:
762: CURSOR c_last_issued_date(
763: x_batch_source_id NUMBER) IS
764: SELECT global_attribute5
765: FROM ra_batch_sources
766: WHERE batch_source_id = x_batch_source_id
767: FOR UPDATE OF global_attribute5 NOWAIT;
768:
769: l_gui_source_id NUMBER;

Line 784: UPDATE ra_batch_sources

780:
781: OPEN c_last_issued_date(l_gui_source_id);
782: FETCH c_last_issued_date INTO l_dummy;
783:
784: UPDATE ra_batch_sources
785: SET global_attribute5 = l_last_trx_date
786: WHERE CURRENT OF c_last_issued_date;
787:
788: CLOSE c_last_issued_date;