APPS.IBY_BANKPAYMENT_UPDT_PUB dependencies on IBY_BATCHES_ALL

Line 198: -- iby_batches_all.payeeid

194: -- Parameters:
195: -- IN
196: -- 1) p_payerid VARCHAR2
197: -- The payerid for the iby batch
198: -- iby_batches_all.payeeid
199: --
200: -- 2) p_iby_batchid VARCHAR2
201: -- The iby merged batch (message) id
202: -- iby_batches_all.batchid

Line 202: -- iby_batches_all.batchid

198: -- iby_batches_all.payeeid
199: --
200: -- 2) p_iby_batchid VARCHAR2
201: -- The iby merged batch (message) id
202: -- iby_batches_all.batchid
203: --
204: -- 3)p_error_code VARCHAR2
205: -- The error code if any.
206: --

Line 222: IBY_BATCHES_ALL ibyb

218:
219: CURSOR l_ec_batch_csr (p_payerid IN VARCHAR2, p_iby_batchid IN VARCHAR2) IS
220: SELECT pb.batch_id
221: FROM IBY_PAY_BATCHES_ALL pb,
222: IBY_BATCHES_ALL ibyb
223: WHERE ibyb.batchid = p_iby_batchid
224: AND ibyb.payeeid = p_payerid;
225:
226: BEGIN

Line 258: UPDATE iby_batches_all

254:
255: END LOOP;
256:
257: -- update the iby merged batch
258: UPDATE iby_batches_all
259: SET
260: batchstatus = G_STATUS_QRY_BATCH_FAIL,
261: bepcode = p_error_code,
262: bepmessage = p_error_message,

Line 306: -- iby_batches_all.payeeid

302: -- Parameters:
303: -- IN
304: -- 1) p_payerid VARCHAR2
305: -- The payerid for the iby batch
306: -- iby_batches_all.payeeid
307: --
308: -- 2) p_iby_batchid VARCHAR2
309: -- The iby merged batch (message) id
310: -- iby_batches_all.batchid

Line 310: -- iby_batches_all.batchid

306: -- iby_batches_all.payeeid
307: --
308: -- 2) p_iby_batchid VARCHAR2
309: -- The iby merged batch (message) id
310: -- iby_batches_all.batchid
311: --
312: -- =======================================================================*/
313: PROCEDURE updateQueryStatus (
314: p_payerid IN VARCHAR2,

Line 338: IBY_BATCHES_ALL ibyb

334:
335: CURSOR l_ec_batch_csr (p_payerid IN VARCHAR2, p_iby_batchid IN VARCHAR2) IS
336: SELECT pb.batch_id, pb.batch_status
337: FROM IBY_PAY_BATCHES_ALL pb,
338: IBY_BATCHES_ALL ibyb
339: WHERE ibyb.batchid = p_iby_batchid
340: AND ibyb.payeeid = p_payerid
341: AND pb.batch_status not in (G_STATUS_SUCCESS, G_STATUS_QRY_BATCH_PARTIAL, G_STATUS_QRY_BATCH_FAIL);
342:

Line 346: IBY_BATCHES_ALL ibyb

342:
343: CURSOR l_finished_ecbatch_csr (p_payerid IN VARCHAR2, p_iby_batchid IN VARCHAR2) IS
344: SELECT pb.batch_id
345: FROM IBY_PAY_BATCHES_ALL pb,
346: IBY_BATCHES_ALL ibyb
347: WHERE ibyb.batchid = p_iby_batchid
348: AND ibyb.payeeid = p_payerid
349: AND pb.batch_status in (G_STATUS_SUCCESS, G_STATUS_QRY_BATCH_PARTIAL, G_STATUS_QRY_BATCH_FAIL);
350:

Line 355: IBY_BATCHES_ALL ibyb

351: -- count of all EC batches in an iby merged batch
352: CURSOR l_ecbatch_cnt_csr (p_payerid IN VARCHAR2, p_iby_batchid IN VARCHAR2) IS
353: SELECT count(pb.batch_id)
354: FROM IBY_PAY_BATCHES_ALL pb,
355: IBY_BATCHES_ALL ibyb
356: WHERE ibyb.batchid = p_iby_batchid
357: AND ibyb.payeeid = p_payerid;
358:
359: -- count of all unsuccessful EC batches in an iby merged batch

Line 363: IBY_BATCHES_ALL ibyb

359: -- count of all unsuccessful EC batches in an iby merged batch
360: CURSOR l_failed_ecbatch_cnt_csr (p_payerid IN VARCHAR2, p_iby_batchid IN VARCHAR2) IS
361: SELECT count(pb.batch_id)
362: FROM IBY_PAY_BATCHES_ALL pb,
363: IBY_BATCHES_ALL ibyb
364: WHERE ibyb.batchid = p_iby_batchid
365: AND ibyb.payeeid = p_payerid
366: AND pb.batch_status in (G_STATUS_QRY_BATCH_PARTIAL, G_STATUS_QRY_BATCH_FAIL);
367:

Line 485: UPDATE iby_batches_all

481: l_batch_status := G_STATUS_QRY_BATCH_FAIL;
482: END IF;
483:
484: -- update the iby merged batch
485: UPDATE iby_batches_all
486: SET
487: batchstatus = l_batch_status,
488: bepcode = null,
489: bepmessage = null,

Line 512: UPDATE iby_batches_all

508: l_batch_status := G_STATUS_QRY_BATCH_PENDING;
509: END IF;
510:
511: -- update the iby merged batch
512: UPDATE iby_batches_all
513: SET
514: batchstatus = l_batch_status,
515: bepcode = null,
516: bepmessage = null,