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_TRANSACTIONCC_PKG dependencies on IBY_BATCHES_ALL

Line 86: * The IBY_BATCHES_ALL table will be updated with

82: /*
83: * Record to store attributes of a batch that
84: * are influenced by transaction grouping rules.
85: *
86: * The IBY_BATCHES_ALL table will be updated with
87: * these attributes after transaction grouping.
88: */
89: TYPE batchAttrRecType IS RECORD (
90: mbatch_id

Line 91: IBY_BATCHES_ALL.mbatchid%TYPE,

87: * these attributes after transaction grouping.
88: */
89: TYPE batchAttrRecType IS RECORD (
90: mbatch_id
91: IBY_BATCHES_ALL.mbatchid%TYPE,
92: batch_id
93: IBY_BATCHES_ALL.batchid%TYPE,
94: profile_code
95: IBY_BATCHES_ALL.process_profile_code%TYPE,

Line 93: IBY_BATCHES_ALL.batchid%TYPE,

89: TYPE batchAttrRecType IS RECORD (
90: mbatch_id
91: IBY_BATCHES_ALL.mbatchid%TYPE,
92: batch_id
93: IBY_BATCHES_ALL.batchid%TYPE,
94: profile_code
95: IBY_BATCHES_ALL.process_profile_code%TYPE,
96: bep_key
97: IBY_BATCHES_ALL.bepkey%TYPE,

Line 95: IBY_BATCHES_ALL.process_profile_code%TYPE,

91: IBY_BATCHES_ALL.mbatchid%TYPE,
92: batch_id
93: IBY_BATCHES_ALL.batchid%TYPE,
94: profile_code
95: IBY_BATCHES_ALL.process_profile_code%TYPE,
96: bep_key
97: IBY_BATCHES_ALL.bepkey%TYPE,
98: org_id
99: IBY_BATCHES_ALL.org_id%TYPE,

Line 97: IBY_BATCHES_ALL.bepkey%TYPE,

93: IBY_BATCHES_ALL.batchid%TYPE,
94: profile_code
95: IBY_BATCHES_ALL.process_profile_code%TYPE,
96: bep_key
97: IBY_BATCHES_ALL.bepkey%TYPE,
98: org_id
99: IBY_BATCHES_ALL.org_id%TYPE,
100: org_type
101: IBY_BATCHES_ALL.org_type%TYPE,

Line 99: IBY_BATCHES_ALL.org_id%TYPE,

95: IBY_BATCHES_ALL.process_profile_code%TYPE,
96: bep_key
97: IBY_BATCHES_ALL.bepkey%TYPE,
98: org_id
99: IBY_BATCHES_ALL.org_id%TYPE,
100: org_type
101: IBY_BATCHES_ALL.org_type%TYPE,
102: le_id
103: IBY_BATCHES_ALL.legal_entity_id%TYPE,

Line 101: IBY_BATCHES_ALL.org_type%TYPE,

97: IBY_BATCHES_ALL.bepkey%TYPE,
98: org_id
99: IBY_BATCHES_ALL.org_id%TYPE,
100: org_type
101: IBY_BATCHES_ALL.org_type%TYPE,
102: le_id
103: IBY_BATCHES_ALL.legal_entity_id%TYPE,
104: int_bank_acct_id
105: IBY_BATCHES_ALL.payeeinstrid%TYPE,

Line 103: IBY_BATCHES_ALL.legal_entity_id%TYPE,

99: IBY_BATCHES_ALL.org_id%TYPE,
100: org_type
101: IBY_BATCHES_ALL.org_type%TYPE,
102: le_id
103: IBY_BATCHES_ALL.legal_entity_id%TYPE,
104: int_bank_acct_id
105: IBY_BATCHES_ALL.payeeinstrid%TYPE,
106: curr_code
107: IBY_BATCHES_ALL.currencynamecode%TYPE,

Line 105: IBY_BATCHES_ALL.payeeinstrid%TYPE,

101: IBY_BATCHES_ALL.org_type%TYPE,
102: le_id
103: IBY_BATCHES_ALL.legal_entity_id%TYPE,
104: int_bank_acct_id
105: IBY_BATCHES_ALL.payeeinstrid%TYPE,
106: curr_code
107: IBY_BATCHES_ALL.currencynamecode%TYPE,
108: settle_date
109: IBY_BATCHES_ALL.settledate%TYPE

Line 107: IBY_BATCHES_ALL.currencynamecode%TYPE,

103: IBY_BATCHES_ALL.legal_entity_id%TYPE,
104: int_bank_acct_id
105: IBY_BATCHES_ALL.payeeinstrid%TYPE,
106: curr_code
107: IBY_BATCHES_ALL.currencynamecode%TYPE,
108: settle_date
109: IBY_BATCHES_ALL.settledate%TYPE
110: );
111:

Line 109: IBY_BATCHES_ALL.settledate%TYPE

105: IBY_BATCHES_ALL.payeeinstrid%TYPE,
106: curr_code
107: IBY_BATCHES_ALL.currencynamecode%TYPE,
108: settle_date
109: IBY_BATCHES_ALL.settledate%TYPE
110: );
111:
112: /*
113: * Table of grouping based batch attributes.

Line 141: * Maps to IBY_BATCHES_ALL.MBATCHID.

137:
138: /*
139: * Table of mbatch ids.
140: *
141: * Maps to IBY_BATCHES_ALL.MBATCHID.
142: */
143: TYPE mBatchIdsTab IS TABLE OF IBY_BATCHES_ALL.mbatchid%TYPE
144: INDEX BY BINARY_INTEGER;
145:

Line 143: TYPE mBatchIdsTab IS TABLE OF IBY_BATCHES_ALL.mbatchid%TYPE

139: * Table of mbatch ids.
140: *
141: * Maps to IBY_BATCHES_ALL.MBATCHID.
142: */
143: TYPE mBatchIdsTab IS TABLE OF IBY_BATCHES_ALL.mbatchid%TYPE
144: INDEX BY BINARY_INTEGER;
145:
146:
147: PROCEDURE validate_open_batch

Line 150: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,

146:
147: PROCEDURE validate_open_batch
148: (
149: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
150: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
151: p_sec_key_on IN VARCHAR2,
152: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,
153: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE
154: );

Line 152: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,

148: (
149: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
150: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
151: p_sec_key_on IN VARCHAR2,
152: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,
153: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE
154: );
155:
156: PROCEDURE prepare_instr_data

Line 153: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE

149: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
150: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
151: p_sec_key_on IN VARCHAR2,
152: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,
153: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE
154: );
155:
156: PROCEDURE prepare_instr_data
157: (p_commit IN VARCHAR2,

Line 368: * Inserts a row about batch status into iby_batches_all. This will

364:
365:
366:
367: /*
368: * Inserts a row about batch status into iby_batches_all. This will
369: * be called for link error, timeout error or other batch status with
370: * gateway payment systems. For processor payment systems, this will
371: * create a new batch and associate all trxns in the current, unnamed
372: * open batch with it.

Line 375: (merch_batchid_in IN iby_batches_all.batchid%TYPE,

371: * create a new batch and associate all trxns in the current, unnamed
372: * open batch with it.
373: */
374: PROCEDURE insert_batch_status
375: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
376: merchant_id_in IN iby_batches_all.payeeid%TYPE,
377: vendor_id_in IN iby_batches_all.bepid%TYPE,
378: vendor_key_in IN iby_batches_all.bepkey%TYPE,
379: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 376: merchant_id_in IN iby_batches_all.payeeid%TYPE,

372: * open batch with it.
373: */
374: PROCEDURE insert_batch_status
375: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
376: merchant_id_in IN iby_batches_all.payeeid%TYPE,
377: vendor_id_in IN iby_batches_all.bepid%TYPE,
378: vendor_key_in IN iby_batches_all.bepkey%TYPE,
379: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
380: status_in IN iby_batches_all.batchstatus%TYPE,

Line 377: vendor_id_in IN iby_batches_all.bepid%TYPE,

373: */
374: PROCEDURE insert_batch_status
375: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
376: merchant_id_in IN iby_batches_all.payeeid%TYPE,
377: vendor_id_in IN iby_batches_all.bepid%TYPE,
378: vendor_key_in IN iby_batches_all.bepkey%TYPE,
379: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
380: status_in IN iby_batches_all.batchstatus%TYPE,
381: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,

Line 378: vendor_key_in IN iby_batches_all.bepkey%TYPE,

374: PROCEDURE insert_batch_status
375: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
376: merchant_id_in IN iby_batches_all.payeeid%TYPE,
377: vendor_id_in IN iby_batches_all.bepid%TYPE,
378: vendor_key_in IN iby_batches_all.bepkey%TYPE,
379: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
380: status_in IN iby_batches_all.batchstatus%TYPE,
381: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
382: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,

Line 379: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

375: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
376: merchant_id_in IN iby_batches_all.payeeid%TYPE,
377: vendor_id_in IN iby_batches_all.bepid%TYPE,
378: vendor_key_in IN iby_batches_all.bepkey%TYPE,
379: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
380: status_in IN iby_batches_all.batchstatus%TYPE,
381: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
382: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
383: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,

Line 380: status_in IN iby_batches_all.batchstatus%TYPE,

376: merchant_id_in IN iby_batches_all.payeeid%TYPE,
377: vendor_id_in IN iby_batches_all.bepid%TYPE,
378: vendor_key_in IN iby_batches_all.bepkey%TYPE,
379: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
380: status_in IN iby_batches_all.batchstatus%TYPE,
381: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
382: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
383: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
384: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,

Line 381: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,

377: vendor_id_in IN iby_batches_all.bepid%TYPE,
378: vendor_key_in IN iby_batches_all.bepkey%TYPE,
379: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
380: status_in IN iby_batches_all.batchstatus%TYPE,
381: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
382: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
383: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
384: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
385: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,

Line 382: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,

378: vendor_key_in IN iby_batches_all.bepkey%TYPE,
379: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
380: status_in IN iby_batches_all.batchstatus%TYPE,
381: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
382: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
383: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
384: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
385: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
386: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,

Line 383: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,

379: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
380: status_in IN iby_batches_all.batchstatus%TYPE,
381: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
382: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
383: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
384: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
385: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
386: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
387: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,

Line 384: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,

380: status_in IN iby_batches_all.batchstatus%TYPE,
381: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
382: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
383: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
384: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
385: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
386: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
387: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
388: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,

Line 385: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,

381: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
382: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
383: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
384: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
385: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
386: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
387: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
388: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
389: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,

Line 386: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,

382: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
383: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
384: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
385: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
386: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
387: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
388: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
389: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
390: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,

Line 387: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,

383: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
384: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
385: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
386: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
387: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
388: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
389: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
390: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
391: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,

Line 388: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,

384: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
385: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
386: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
387: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
388: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
389: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
390: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
391: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
392: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,

Line 389: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,

385: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
386: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
387: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
388: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
389: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
390: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
391: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
392: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
393: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,

Line 390: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,

386: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
387: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
388: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
389: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
390: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
391: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
392: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
393: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
394: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,

Line 391: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,

387: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
388: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
389: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
390: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
391: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
392: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
393: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
394: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
395: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

Line 392: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,

388: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
389: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
390: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
391: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
392: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
393: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
394: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
395: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
396: req_type_in IN iby_batches_all.reqtype%type,

Line 393: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,

389: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
390: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
391: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
392: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
393: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
394: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
395: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
396: req_type_in IN iby_batches_all.reqtype%type,
397: sec_key_present_in IN VARCHAR2,

Line 394: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,

390: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
391: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
392: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
393: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
394: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
395: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
396: req_type_in IN iby_batches_all.reqtype%type,
397: sec_key_present_in IN VARCHAR2,
398: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type

Line 396: req_type_in IN iby_batches_all.reqtype%type,

392: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
393: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
394: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
395: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
396: req_type_in IN iby_batches_all.reqtype%type,
397: sec_key_present_in IN VARCHAR2,
398: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type
399: );
400:

Line 398: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type

394: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
395: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
396: req_type_in IN iby_batches_all.reqtype%type,
397: sec_key_present_in IN VARCHAR2,
398: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type
399: );
400:
401: /*
402: * Performs batch close operation by grouping pending transactions.

Line 408: (merch_batchid_in IN iby_batches_all.batchid%TYPE,

404: * batch close call depending upon how many batches are
405: * generated by applying grouping rules.
406: */
407: PROCEDURE insert_batch_status_new
408: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
409: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
410: merchant_id_in IN iby_batches_all.payeeid%TYPE,
411: vendor_id_in IN iby_batches_all.bepid%TYPE,
412: vendor_key_in IN iby_batches_all.bepkey%TYPE,

Line 409: profile_code_in IN iby_batches_all.process_profile_code%TYPE,

405: * generated by applying grouping rules.
406: */
407: PROCEDURE insert_batch_status_new
408: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
409: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
410: merchant_id_in IN iby_batches_all.payeeid%TYPE,
411: vendor_id_in IN iby_batches_all.bepid%TYPE,
412: vendor_key_in IN iby_batches_all.bepkey%TYPE,
413: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 410: merchant_id_in IN iby_batches_all.payeeid%TYPE,

406: */
407: PROCEDURE insert_batch_status_new
408: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
409: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
410: merchant_id_in IN iby_batches_all.payeeid%TYPE,
411: vendor_id_in IN iby_batches_all.bepid%TYPE,
412: vendor_key_in IN iby_batches_all.bepkey%TYPE,
413: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
414: status_in IN iby_batches_all.batchstatus%TYPE,

Line 411: vendor_id_in IN iby_batches_all.bepid%TYPE,

407: PROCEDURE insert_batch_status_new
408: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
409: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
410: merchant_id_in IN iby_batches_all.payeeid%TYPE,
411: vendor_id_in IN iby_batches_all.bepid%TYPE,
412: vendor_key_in IN iby_batches_all.bepkey%TYPE,
413: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
414: status_in IN iby_batches_all.batchstatus%TYPE,
415: time_in IN iby_batches_all.batchclosedate%TYPE,

Line 412: vendor_key_in IN iby_batches_all.bepkey%TYPE,

408: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
409: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
410: merchant_id_in IN iby_batches_all.payeeid%TYPE,
411: vendor_id_in IN iby_batches_all.bepid%TYPE,
412: vendor_key_in IN iby_batches_all.bepkey%TYPE,
413: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
414: status_in IN iby_batches_all.batchstatus%TYPE,
415: time_in IN iby_batches_all.batchclosedate%TYPE,
416: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

Line 413: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

409: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
410: merchant_id_in IN iby_batches_all.payeeid%TYPE,
411: vendor_id_in IN iby_batches_all.bepid%TYPE,
412: vendor_key_in IN iby_batches_all.bepkey%TYPE,
413: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
414: status_in IN iby_batches_all.batchstatus%TYPE,
415: time_in IN iby_batches_all.batchclosedate%TYPE,
416: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
417: currency_in IN iby_batches_all.currencynamecode%TYPE,

Line 414: status_in IN iby_batches_all.batchstatus%TYPE,

410: merchant_id_in IN iby_batches_all.payeeid%TYPE,
411: vendor_id_in IN iby_batches_all.bepid%TYPE,
412: vendor_key_in IN iby_batches_all.bepkey%TYPE,
413: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
414: status_in IN iby_batches_all.batchstatus%TYPE,
415: time_in IN iby_batches_all.batchclosedate%TYPE,
416: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
417: currency_in IN iby_batches_all.currencynamecode%TYPE,
418: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

Line 415: time_in IN iby_batches_all.batchclosedate%TYPE,

411: vendor_id_in IN iby_batches_all.bepid%TYPE,
412: vendor_key_in IN iby_batches_all.bepkey%TYPE,
413: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
414: status_in IN iby_batches_all.batchstatus%TYPE,
415: time_in IN iby_batches_all.batchclosedate%TYPE,
416: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
417: currency_in IN iby_batches_all.currencynamecode%TYPE,
418: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
419: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

Line 416: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

412: vendor_key_in IN iby_batches_all.bepkey%TYPE,
413: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
414: status_in IN iby_batches_all.batchstatus%TYPE,
415: time_in IN iby_batches_all.batchclosedate%TYPE,
416: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
417: currency_in IN iby_batches_all.currencynamecode%TYPE,
418: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
419: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
420: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

Line 417: currency_in IN iby_batches_all.currencynamecode%TYPE,

413: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
414: status_in IN iby_batches_all.batchstatus%TYPE,
415: time_in IN iby_batches_all.batchclosedate%TYPE,
416: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
417: currency_in IN iby_batches_all.currencynamecode%TYPE,
418: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
419: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
420: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
421: saleamount_in IN iby_batches_all.BatchSales%TYPE,

Line 418: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

414: status_in IN iby_batches_all.batchstatus%TYPE,
415: time_in IN iby_batches_all.batchclosedate%TYPE,
416: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
417: currency_in IN iby_batches_all.currencynamecode%TYPE,
418: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
419: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
420: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
421: saleamount_in IN iby_batches_all.BatchSales%TYPE,
422: cramount_in IN iby_batches_all.BatchCredit%TYPE,

Line 419: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

415: time_in IN iby_batches_all.batchclosedate%TYPE,
416: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
417: currency_in IN iby_batches_all.currencynamecode%TYPE,
418: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
419: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
420: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
421: saleamount_in IN iby_batches_all.BatchSales%TYPE,
422: cramount_in IN iby_batches_all.BatchCredit%TYPE,
423: gwid_in IN iby_batches_all.GWBatchID%TYPE,

Line 420: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

416: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
417: currency_in IN iby_batches_all.currencynamecode%TYPE,
418: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
419: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
420: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
421: saleamount_in IN iby_batches_all.BatchSales%TYPE,
422: cramount_in IN iby_batches_all.BatchCredit%TYPE,
423: gwid_in IN iby_batches_all.GWBatchID%TYPE,
424: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

Line 421: saleamount_in IN iby_batches_all.BatchSales%TYPE,

417: currency_in IN iby_batches_all.currencynamecode%TYPE,
418: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
419: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
420: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
421: saleamount_in IN iby_batches_all.BatchSales%TYPE,
422: cramount_in IN iby_batches_all.BatchCredit%TYPE,
423: gwid_in IN iby_batches_all.GWBatchID%TYPE,
424: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
425: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

Line 422: cramount_in IN iby_batches_all.BatchCredit%TYPE,

418: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
419: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
420: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
421: saleamount_in IN iby_batches_all.BatchSales%TYPE,
422: cramount_in IN iby_batches_all.BatchCredit%TYPE,
423: gwid_in IN iby_batches_all.GWBatchID%TYPE,
424: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
425: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
426: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 423: gwid_in IN iby_batches_all.GWBatchID%TYPE,

419: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
420: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
421: saleamount_in IN iby_batches_all.BatchSales%TYPE,
422: cramount_in IN iby_batches_all.BatchCredit%TYPE,
423: gwid_in IN iby_batches_all.GWBatchID%TYPE,
424: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
425: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
426: error_location_in IN iby_batches_all.errorlocation%TYPE,
427: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

Line 424: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

420: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
421: saleamount_in IN iby_batches_all.BatchSales%TYPE,
422: cramount_in IN iby_batches_all.BatchCredit%TYPE,
423: gwid_in IN iby_batches_all.GWBatchID%TYPE,
424: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
425: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
426: error_location_in IN iby_batches_all.errorlocation%TYPE,
427: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
428: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

Line 425: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

421: saleamount_in IN iby_batches_all.BatchSales%TYPE,
422: cramount_in IN iby_batches_all.BatchCredit%TYPE,
423: gwid_in IN iby_batches_all.GWBatchID%TYPE,
424: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
425: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
426: error_location_in IN iby_batches_all.errorlocation%TYPE,
427: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
428: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
429: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 426: error_location_in IN iby_batches_all.errorlocation%TYPE,

422: cramount_in IN iby_batches_all.BatchCredit%TYPE,
423: gwid_in IN iby_batches_all.GWBatchID%TYPE,
424: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
425: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
426: error_location_in IN iby_batches_all.errorlocation%TYPE,
427: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
428: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
429: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
430: req_type_in IN iby_batches_all.reqtype%TYPE,

Line 427: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

423: gwid_in IN iby_batches_all.GWBatchID%TYPE,
424: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
425: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
426: error_location_in IN iby_batches_all.errorlocation%TYPE,
427: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
428: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
429: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
430: req_type_in IN iby_batches_all.reqtype%TYPE,
431: sec_key_present_in IN VARCHAR2,

Line 428: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

424: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
425: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
426: error_location_in IN iby_batches_all.errorlocation%TYPE,
427: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
428: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
429: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
430: req_type_in IN iby_batches_all.reqtype%TYPE,
431: sec_key_present_in IN VARCHAR2,
432: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

Line 430: req_type_in IN iby_batches_all.reqtype%TYPE,

426: error_location_in IN iby_batches_all.errorlocation%TYPE,
427: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
428: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
429: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
430: req_type_in IN iby_batches_all.reqtype%TYPE,
431: sec_key_present_in IN VARCHAR2,
432: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
433: instr_type_in IN iby_batches_all.instrument_type%TYPE,
434: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

Line 432: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

428: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
429: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
430: req_type_in IN iby_batches_all.reqtype%TYPE,
431: sec_key_present_in IN VARCHAR2,
432: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
433: instr_type_in IN iby_batches_all.instrument_type%TYPE,
434: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
435: f_pmt_channel_in IN iby_trxn_summaries_all.
436: payment_channel_code%TYPE,

Line 433: instr_type_in IN iby_batches_all.instrument_type%TYPE,

429: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
430: req_type_in IN iby_batches_all.reqtype%TYPE,
431: sec_key_present_in IN VARCHAR2,
432: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
433: instr_type_in IN iby_batches_all.instrument_type%TYPE,
434: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
435: f_pmt_channel_in IN iby_trxn_summaries_all.
436: payment_channel_code%TYPE,
437: f_curr_in IN iby_trxn_summaries_all.

Line 434: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

430: req_type_in IN iby_batches_all.reqtype%TYPE,
431: sec_key_present_in IN VARCHAR2,
432: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
433: instr_type_in IN iby_batches_all.instrument_type%TYPE,
434: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
435: f_pmt_channel_in IN iby_trxn_summaries_all.
436: payment_channel_code%TYPE,
437: f_curr_in IN iby_trxn_summaries_all.
438: currencynamecode%TYPE,

Line 455: (merch_batchid_in IN iby_batches_all.batchid%TYPE,

451: /* Overloaded form of the above API. This one takes an
452: Array of user profiles instead of a single one.
453: */
454: PROCEDURE insert_batch_status_new
455: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
456: profile_code_array IN JTF_VARCHAR2_TABLE_100,
457: merchant_id_in IN iby_batches_all.payeeid%TYPE,
458: vendor_id_in IN iby_batches_all.bepid%TYPE,
459: vendor_key_in IN iby_batches_all.bepkey%TYPE,

Line 457: merchant_id_in IN iby_batches_all.payeeid%TYPE,

453: */
454: PROCEDURE insert_batch_status_new
455: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
456: profile_code_array IN JTF_VARCHAR2_TABLE_100,
457: merchant_id_in IN iby_batches_all.payeeid%TYPE,
458: vendor_id_in IN iby_batches_all.bepid%TYPE,
459: vendor_key_in IN iby_batches_all.bepkey%TYPE,
460: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
461: status_in IN iby_batches_all.batchstatus%TYPE,

Line 458: vendor_id_in IN iby_batches_all.bepid%TYPE,

454: PROCEDURE insert_batch_status_new
455: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
456: profile_code_array IN JTF_VARCHAR2_TABLE_100,
457: merchant_id_in IN iby_batches_all.payeeid%TYPE,
458: vendor_id_in IN iby_batches_all.bepid%TYPE,
459: vendor_key_in IN iby_batches_all.bepkey%TYPE,
460: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
461: status_in IN iby_batches_all.batchstatus%TYPE,
462: time_in IN iby_batches_all.batchclosedate%TYPE,

Line 459: vendor_key_in IN iby_batches_all.bepkey%TYPE,

455: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
456: profile_code_array IN JTF_VARCHAR2_TABLE_100,
457: merchant_id_in IN iby_batches_all.payeeid%TYPE,
458: vendor_id_in IN iby_batches_all.bepid%TYPE,
459: vendor_key_in IN iby_batches_all.bepkey%TYPE,
460: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
461: status_in IN iby_batches_all.batchstatus%TYPE,
462: time_in IN iby_batches_all.batchclosedate%TYPE,
463: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

Line 460: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

456: profile_code_array IN JTF_VARCHAR2_TABLE_100,
457: merchant_id_in IN iby_batches_all.payeeid%TYPE,
458: vendor_id_in IN iby_batches_all.bepid%TYPE,
459: vendor_key_in IN iby_batches_all.bepkey%TYPE,
460: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
461: status_in IN iby_batches_all.batchstatus%TYPE,
462: time_in IN iby_batches_all.batchclosedate%TYPE,
463: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
464: currency_in IN iby_batches_all.currencynamecode%TYPE,

Line 461: status_in IN iby_batches_all.batchstatus%TYPE,

457: merchant_id_in IN iby_batches_all.payeeid%TYPE,
458: vendor_id_in IN iby_batches_all.bepid%TYPE,
459: vendor_key_in IN iby_batches_all.bepkey%TYPE,
460: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
461: status_in IN iby_batches_all.batchstatus%TYPE,
462: time_in IN iby_batches_all.batchclosedate%TYPE,
463: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
464: currency_in IN iby_batches_all.currencynamecode%TYPE,
465: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

Line 462: time_in IN iby_batches_all.batchclosedate%TYPE,

458: vendor_id_in IN iby_batches_all.bepid%TYPE,
459: vendor_key_in IN iby_batches_all.bepkey%TYPE,
460: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
461: status_in IN iby_batches_all.batchstatus%TYPE,
462: time_in IN iby_batches_all.batchclosedate%TYPE,
463: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
464: currency_in IN iby_batches_all.currencynamecode%TYPE,
465: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
466: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

Line 463: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

459: vendor_key_in IN iby_batches_all.bepkey%TYPE,
460: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
461: status_in IN iby_batches_all.batchstatus%TYPE,
462: time_in IN iby_batches_all.batchclosedate%TYPE,
463: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
464: currency_in IN iby_batches_all.currencynamecode%TYPE,
465: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
466: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
467: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

Line 464: currency_in IN iby_batches_all.currencynamecode%TYPE,

460: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
461: status_in IN iby_batches_all.batchstatus%TYPE,
462: time_in IN iby_batches_all.batchclosedate%TYPE,
463: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
464: currency_in IN iby_batches_all.currencynamecode%TYPE,
465: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
466: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
467: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
468: saleamount_in IN iby_batches_all.BatchSales%TYPE,

Line 465: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

461: status_in IN iby_batches_all.batchstatus%TYPE,
462: time_in IN iby_batches_all.batchclosedate%TYPE,
463: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
464: currency_in IN iby_batches_all.currencynamecode%TYPE,
465: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
466: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
467: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
468: saleamount_in IN iby_batches_all.BatchSales%TYPE,
469: cramount_in IN iby_batches_all.BatchCredit%TYPE,

Line 466: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

462: time_in IN iby_batches_all.batchclosedate%TYPE,
463: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
464: currency_in IN iby_batches_all.currencynamecode%TYPE,
465: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
466: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
467: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
468: saleamount_in IN iby_batches_all.BatchSales%TYPE,
469: cramount_in IN iby_batches_all.BatchCredit%TYPE,
470: gwid_in IN iby_batches_all.GWBatchID%TYPE,

Line 467: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

463: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
464: currency_in IN iby_batches_all.currencynamecode%TYPE,
465: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
466: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
467: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
468: saleamount_in IN iby_batches_all.BatchSales%TYPE,
469: cramount_in IN iby_batches_all.BatchCredit%TYPE,
470: gwid_in IN iby_batches_all.GWBatchID%TYPE,
471: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

Line 468: saleamount_in IN iby_batches_all.BatchSales%TYPE,

464: currency_in IN iby_batches_all.currencynamecode%TYPE,
465: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
466: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
467: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
468: saleamount_in IN iby_batches_all.BatchSales%TYPE,
469: cramount_in IN iby_batches_all.BatchCredit%TYPE,
470: gwid_in IN iby_batches_all.GWBatchID%TYPE,
471: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
472: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

Line 469: cramount_in IN iby_batches_all.BatchCredit%TYPE,

465: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
466: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
467: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
468: saleamount_in IN iby_batches_all.BatchSales%TYPE,
469: cramount_in IN iby_batches_all.BatchCredit%TYPE,
470: gwid_in IN iby_batches_all.GWBatchID%TYPE,
471: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
472: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
473: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 470: gwid_in IN iby_batches_all.GWBatchID%TYPE,

466: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
467: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
468: saleamount_in IN iby_batches_all.BatchSales%TYPE,
469: cramount_in IN iby_batches_all.BatchCredit%TYPE,
470: gwid_in IN iby_batches_all.GWBatchID%TYPE,
471: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
472: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
473: error_location_in IN iby_batches_all.errorlocation%TYPE,
474: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

Line 471: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

467: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
468: saleamount_in IN iby_batches_all.BatchSales%TYPE,
469: cramount_in IN iby_batches_all.BatchCredit%TYPE,
470: gwid_in IN iby_batches_all.GWBatchID%TYPE,
471: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
472: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
473: error_location_in IN iby_batches_all.errorlocation%TYPE,
474: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
475: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

Line 472: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

468: saleamount_in IN iby_batches_all.BatchSales%TYPE,
469: cramount_in IN iby_batches_all.BatchCredit%TYPE,
470: gwid_in IN iby_batches_all.GWBatchID%TYPE,
471: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
472: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
473: error_location_in IN iby_batches_all.errorlocation%TYPE,
474: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
475: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
476: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 473: error_location_in IN iby_batches_all.errorlocation%TYPE,

469: cramount_in IN iby_batches_all.BatchCredit%TYPE,
470: gwid_in IN iby_batches_all.GWBatchID%TYPE,
471: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
472: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
473: error_location_in IN iby_batches_all.errorlocation%TYPE,
474: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
475: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
476: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
477: req_type_in IN iby_batches_all.reqtype%TYPE,

Line 474: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

470: gwid_in IN iby_batches_all.GWBatchID%TYPE,
471: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
472: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
473: error_location_in IN iby_batches_all.errorlocation%TYPE,
474: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
475: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
476: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
477: req_type_in IN iby_batches_all.reqtype%TYPE,
478: sec_key_present_in IN VARCHAR2,

Line 475: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

471: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
472: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
473: error_location_in IN iby_batches_all.errorlocation%TYPE,
474: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
475: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
476: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
477: req_type_in IN iby_batches_all.reqtype%TYPE,
478: sec_key_present_in IN VARCHAR2,
479: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

Line 477: req_type_in IN iby_batches_all.reqtype%TYPE,

473: error_location_in IN iby_batches_all.errorlocation%TYPE,
474: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
475: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
476: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
477: req_type_in IN iby_batches_all.reqtype%TYPE,
478: sec_key_present_in IN VARCHAR2,
479: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
480: instr_type_in IN iby_batches_all.instrument_type%TYPE,
481: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

Line 479: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

475: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
476: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
477: req_type_in IN iby_batches_all.reqtype%TYPE,
478: sec_key_present_in IN VARCHAR2,
479: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
480: instr_type_in IN iby_batches_all.instrument_type%TYPE,
481: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
482: f_pmt_channel_in IN iby_trxn_summaries_all.
483: payment_channel_code%TYPE,

Line 480: instr_type_in IN iby_batches_all.instrument_type%TYPE,

476: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
477: req_type_in IN iby_batches_all.reqtype%TYPE,
478: sec_key_present_in IN VARCHAR2,
479: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
480: instr_type_in IN iby_batches_all.instrument_type%TYPE,
481: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
482: f_pmt_channel_in IN iby_trxn_summaries_all.
483: payment_channel_code%TYPE,
484: f_curr_in IN iby_trxn_summaries_all.

Line 481: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

477: req_type_in IN iby_batches_all.reqtype%TYPE,
478: sec_key_present_in IN VARCHAR2,
479: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
480: instr_type_in IN iby_batches_all.instrument_type%TYPE,
481: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
482: f_pmt_channel_in IN iby_trxn_summaries_all.
483: payment_channel_code%TYPE,
484: f_curr_in IN iby_trxn_summaries_all.
485: currencynamecode%TYPE,

Line 561: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,

557: /*
558: ** Procedure: getMBatchId
559: ** Purpose: retrieve mBatchid from iby_Batch table based on Batchid
560: */
561: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
562: i_Payeeid in iby_Batches_all.Payeeid%type,
563: o_mBatchid out nocopy iby_Batches_all.mBatchid%type);
564:
565: /*

Line 562: i_Payeeid in iby_Batches_all.Payeeid%type,

558: ** Procedure: getMBatchId
559: ** Purpose: retrieve mBatchid from iby_Batch table based on Batchid
560: */
561: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
562: i_Payeeid in iby_Batches_all.Payeeid%type,
563: o_mBatchid out nocopy iby_Batches_all.mBatchid%type);
564:
565: /*
566: ** Function: getTID

Line 563: o_mBatchid out nocopy iby_Batches_all.mBatchid%type);

559: ** Purpose: retrieve mBatchid from iby_Batch table based on Batchid
560: */
561: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
562: i_Payeeid in iby_Batches_all.Payeeid%type,
563: o_mBatchid out nocopy iby_Batches_all.mBatchid%type);
564:
565: /*
566: ** Function: getTID
567: ** Purpose: get the next trxnid availabe, make sure there is only one TID

Line 686: ecapp_id_in IN iby_batches_all.ecappid%TYPE,

682: );
683:
684: PROCEDURE Update_Batch
685: (
686: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
687: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
688: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
689: batch_status_in IN iby_batches_all.batchstatus%TYPE,
690: batch_total_in IN iby_batches_all.batchtotal%TYPE,

Line 689: batch_status_in IN iby_batches_all.batchstatus%TYPE,

685: (
686: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
687: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
688: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
689: batch_status_in IN iby_batches_all.batchstatus%TYPE,
690: batch_total_in IN iby_batches_all.batchtotal%TYPE,
691: sale_amount_in IN iby_batches_all.batchsales%TYPE,
692: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
693: bep_code_in IN iby_batches_all.bepcode%TYPE,

Line 690: batch_total_in IN iby_batches_all.batchtotal%TYPE,

686: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
687: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
688: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
689: batch_status_in IN iby_batches_all.batchstatus%TYPE,
690: batch_total_in IN iby_batches_all.batchtotal%TYPE,
691: sale_amount_in IN iby_batches_all.batchsales%TYPE,
692: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
693: bep_code_in IN iby_batches_all.bepcode%TYPE,
694: bep_message_in IN iby_batches_all.bepmessage%TYPE,

Line 691: sale_amount_in IN iby_batches_all.batchsales%TYPE,

687: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
688: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
689: batch_status_in IN iby_batches_all.batchstatus%TYPE,
690: batch_total_in IN iby_batches_all.batchtotal%TYPE,
691: sale_amount_in IN iby_batches_all.batchsales%TYPE,
692: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
693: bep_code_in IN iby_batches_all.bepcode%TYPE,
694: bep_message_in IN iby_batches_all.bepmessage%TYPE,
695: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 692: credit_amount_in IN iby_batches_all.batchcredit%TYPE,

688: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
689: batch_status_in IN iby_batches_all.batchstatus%TYPE,
690: batch_total_in IN iby_batches_all.batchtotal%TYPE,
691: sale_amount_in IN iby_batches_all.batchsales%TYPE,
692: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
693: bep_code_in IN iby_batches_all.bepcode%TYPE,
694: bep_message_in IN iby_batches_all.bepmessage%TYPE,
695: error_location_in IN iby_batches_all.errorlocation%TYPE,
696: ack_type_in IN VARCHAR2,

Line 693: bep_code_in IN iby_batches_all.bepcode%TYPE,

689: batch_status_in IN iby_batches_all.batchstatus%TYPE,
690: batch_total_in IN iby_batches_all.batchtotal%TYPE,
691: sale_amount_in IN iby_batches_all.batchsales%TYPE,
692: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
693: bep_code_in IN iby_batches_all.bepcode%TYPE,
694: bep_message_in IN iby_batches_all.bepmessage%TYPE,
695: error_location_in IN iby_batches_all.errorlocation%TYPE,
696: ack_type_in IN VARCHAR2,
697: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,

Line 694: bep_message_in IN iby_batches_all.bepmessage%TYPE,

690: batch_total_in IN iby_batches_all.batchtotal%TYPE,
691: sale_amount_in IN iby_batches_all.batchsales%TYPE,
692: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
693: bep_code_in IN iby_batches_all.bepcode%TYPE,
694: bep_message_in IN iby_batches_all.bepmessage%TYPE,
695: error_location_in IN iby_batches_all.errorlocation%TYPE,
696: ack_type_in IN VARCHAR2,
697: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
698: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,

Line 695: error_location_in IN iby_batches_all.errorlocation%TYPE,

691: sale_amount_in IN iby_batches_all.batchsales%TYPE,
692: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
693: bep_code_in IN iby_batches_all.bepcode%TYPE,
694: bep_message_in IN iby_batches_all.bepmessage%TYPE,
695: error_location_in IN iby_batches_all.errorlocation%TYPE,
696: ack_type_in IN VARCHAR2,
697: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
698: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
699: trxn_status_in IN JTF_VARCHAR2_TABLE_100,

Line 804: orgid_in IN iby_batches_all.org_id%TYPE,

800: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,
801: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
802: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
803: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
804: orgid_in IN iby_batches_all.org_id%TYPE,
805: seckey_present_in IN VARCHAR2,
806: trxncount_out OUT NOCOPY NUMBER,
807: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE
808: );

Line 807: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE

803: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
804: orgid_in IN iby_batches_all.org_id%TYPE,
805: seckey_present_in IN VARCHAR2,
806: trxncount_out OUT NOCOPY NUMBER,
807: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE
808: );
809:
810: /*--------------------------------------------------------------------
811: | NAME:

Line 835: req_type IN IBY_BATCHES_ALL.

831: p_profile_code IN IBY_FNDCPT_USER_CC_PF_B.
832: user_cc_profile_code%TYPE,
833: instr_type IN IBY_TRXN_SUMMARIES_ALL.
834: instrtype%TYPE,
835: req_type IN IBY_BATCHES_ALL.
836: reqtype%TYPE,
837: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
838: payment_channel_code%TYPE,
839: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

Line 881: req_type IN IBY_BATCHES_ALL.

877: PROCEDURE performTransactionGrouping(
878: profile_code_array IN JTF_VARCHAR2_TABLE_100,
879: instr_type IN IBY_TRXN_SUMMARIES_ALL.
880: instrtype%TYPE,
881: req_type IN IBY_BATCHES_ALL.
882: reqtype%TYPE,
883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
884: payment_channel_code%TYPE,
885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

Line 928: x_currentBatchId IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE,

924: PROCEDURE insertTrxnIntoBatch(
925: x_batchRec IN OUT NOCOPY batchAttrRecType,
926: x_batchTab IN OUT NOCOPY batchAttrTabType,
927: p_newBatchFlag IN BOOLEAN,
928: x_currentBatchId IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE,
929: x_trxnsInBatchTab IN OUT NOCOPY trxnsInBatchTabType,
930: x_trxnsInBatchRec IN OUT NOCOPY trxnsInBatchRecType,
931: x_trxnsInBatchCount IN OUT NOCOPY NUMBER
932: );

Line 955: x_batchID IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE

951: | NOTES:
952: |
953: *---------------------------------------------------------------------*/
954: PROCEDURE getNextBatchId(
955: x_batchID IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE
956: );
957:
958: /*--------------------------------------------------------------------
959: | NAME:

Line 1004: mbatchid_in IN iby_batches_all.mbatchid%TYPE

1000: | NOTES:
1001: |
1002: *---------------------------------------------------------------------*/
1003: PROCEDURE Update_Payer_Notif_Batch(
1004: mbatchid_in IN iby_batches_all.mbatchid%TYPE
1005: );
1006:
1007: END iby_transactioncc_pkg;
1008: