eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_BANKPAYMENT_UPDT_PUB dependencies on IBY_PAY_BATCHES_ALL

Line 7: -- Purpose: This procedure will update the iby_pay_batches_all table

3:
4: /* ========================================================================
5: -- Procedure Name: updateBatchStatus
6: --
7: -- Purpose: This procedure will update the iby_pay_batches_all table
8: -- with the new batch status value.
9: -- The possible batch status values considered at present
10: -- includes -
11: -- 1) 18 - Submitted to Processor

Line 36: p_batch_id IN iby_pay_batches_all.batch_id%TYPE,

32: -- =======================================================================*/
33:
34: PROCEDURE updateBatchStatus(
35:
36: p_batch_id IN iby_pay_batches_all.batch_id%TYPE,
37: p_new_status IN iby_pay_batches_all.batch_status%TYPE,
38: p_error_code IN iby_pay_batches_all.bep_code%TYPE,
39: p_error_message IN iby_pay_batches_all.bep_message%TYPE
40: );

Line 37: p_new_status IN iby_pay_batches_all.batch_status%TYPE,

33:
34: PROCEDURE updateBatchStatus(
35:
36: p_batch_id IN iby_pay_batches_all.batch_id%TYPE,
37: p_new_status IN iby_pay_batches_all.batch_status%TYPE,
38: p_error_code IN iby_pay_batches_all.bep_code%TYPE,
39: p_error_message IN iby_pay_batches_all.bep_message%TYPE
40: );
41:

Line 38: p_error_code IN iby_pay_batches_all.bep_code%TYPE,

34: PROCEDURE updateBatchStatus(
35:
36: p_batch_id IN iby_pay_batches_all.batch_id%TYPE,
37: p_new_status IN iby_pay_batches_all.batch_status%TYPE,
38: p_error_code IN iby_pay_batches_all.bep_code%TYPE,
39: p_error_message IN iby_pay_batches_all.bep_message%TYPE
40: );
41:
42: /* ========================================================================

Line 39: p_error_message IN iby_pay_batches_all.bep_message%TYPE

35:
36: p_batch_id IN iby_pay_batches_all.batch_id%TYPE,
37: p_new_status IN iby_pay_batches_all.batch_status%TYPE,
38: p_error_code IN iby_pay_batches_all.bep_code%TYPE,
39: p_error_message IN iby_pay_batches_all.bep_message%TYPE
40: );
41:
42: /* ========================================================================
43: -- Procedure Name: updateECBatches

Line 51: payerid_in IN iby_pay_batches_all.payer_id%TYPE,

47: -- =======================================================================*/
48:
49: PROCEDURE updateECBatches
50: (
51: payerid_in IN iby_pay_batches_all.payer_id%TYPE,
52: bepid_in IN iby_pay_batches_all.bepid%TYPE,
53: bepkey_in IN iby_pay_batches_all.bepkey%TYPE,
54: oldstatus_in IN iby_pay_batches_all.batch_status%TYPE,
55: newstatus_in IN iby_pay_batches_all.batch_status%TYPE,

Line 52: bepid_in IN iby_pay_batches_all.bepid%TYPE,

48:
49: PROCEDURE updateECBatches
50: (
51: payerid_in IN iby_pay_batches_all.payer_id%TYPE,
52: bepid_in IN iby_pay_batches_all.bepid%TYPE,
53: bepkey_in IN iby_pay_batches_all.bepkey%TYPE,
54: oldstatus_in IN iby_pay_batches_all.batch_status%TYPE,
55: newstatus_in IN iby_pay_batches_all.batch_status%TYPE,
56: oldbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE,

Line 53: bepkey_in IN iby_pay_batches_all.bepkey%TYPE,

49: PROCEDURE updateECBatches
50: (
51: payerid_in IN iby_pay_batches_all.payer_id%TYPE,
52: bepid_in IN iby_pay_batches_all.bepid%TYPE,
53: bepkey_in IN iby_pay_batches_all.bepkey%TYPE,
54: oldstatus_in IN iby_pay_batches_all.batch_status%TYPE,
55: newstatus_in IN iby_pay_batches_all.batch_status%TYPE,
56: oldbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE,
57: newbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE

Line 54: oldstatus_in IN iby_pay_batches_all.batch_status%TYPE,

50: (
51: payerid_in IN iby_pay_batches_all.payer_id%TYPE,
52: bepid_in IN iby_pay_batches_all.bepid%TYPE,
53: bepkey_in IN iby_pay_batches_all.bepkey%TYPE,
54: oldstatus_in IN iby_pay_batches_all.batch_status%TYPE,
55: newstatus_in IN iby_pay_batches_all.batch_status%TYPE,
56: oldbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE,
57: newbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE
58: );

Line 55: newstatus_in IN iby_pay_batches_all.batch_status%TYPE,

51: payerid_in IN iby_pay_batches_all.payer_id%TYPE,
52: bepid_in IN iby_pay_batches_all.bepid%TYPE,
53: bepkey_in IN iby_pay_batches_all.bepkey%TYPE,
54: oldstatus_in IN iby_pay_batches_all.batch_status%TYPE,
55: newstatus_in IN iby_pay_batches_all.batch_status%TYPE,
56: oldbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE,
57: newbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE
58: );
59:

Line 56: oldbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE,

52: bepid_in IN iby_pay_batches_all.bepid%TYPE,
53: bepkey_in IN iby_pay_batches_all.bepkey%TYPE,
54: oldstatus_in IN iby_pay_batches_all.batch_status%TYPE,
55: newstatus_in IN iby_pay_batches_all.batch_status%TYPE,
56: oldbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE,
57: newbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE
58: );
59:
60:

Line 57: newbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE

53: bepkey_in IN iby_pay_batches_all.bepkey%TYPE,
54: oldstatus_in IN iby_pay_batches_all.batch_status%TYPE,
55: newstatus_in IN iby_pay_batches_all.batch_status%TYPE,
56: oldbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE,
57: newbatchid_in IN iby_pay_batches_all.iby_batch_id%TYPE
58: );
59:
60:
61: /* ========================================================================