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: trxn_count
111: IBY_BATCHES_ALL.numtrxns%TYPE

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: trxn_count
111: IBY_BATCHES_ALL.numtrxns%TYPE
112: );
113:

Line 111: IBY_BATCHES_ALL.numtrxns%TYPE

107: IBY_BATCHES_ALL.currencynamecode%TYPE,
108: settle_date
109: IBY_BATCHES_ALL.settledate%TYPE,
110: trxn_count
111: IBY_BATCHES_ALL.numtrxns%TYPE
112: );
113:
114: /*
115: * Table of grouping based batch attributes.

Line 143: * Maps to IBY_BATCHES_ALL.MBATCHID.

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

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

141: * Table of mbatch ids.
142: *
143: * Maps to IBY_BATCHES_ALL.MBATCHID.
144: */
145: TYPE mBatchIdsTab IS TABLE OF IBY_BATCHES_ALL.mbatchid%TYPE
146: INDEX BY BINARY_INTEGER;
147:
148: -- Changes for bug# 8889709
149: TYPE t_mbatchid IS TABLE OF

Line 150: IBY_BATCHES_ALL.mbatchid%TYPE

146: INDEX BY BINARY_INTEGER;
147:
148: -- Changes for bug# 8889709
149: TYPE t_mbatchid IS TABLE OF
150: IBY_BATCHES_ALL.mbatchid%TYPE
151: INDEX BY BINARY_INTEGER;
152:
153: TYPE t_batchid IS TABLE OF
154: IBY_BATCHES_ALL.batchid%TYPE

Line 154: IBY_BATCHES_ALL.batchid%TYPE

150: IBY_BATCHES_ALL.mbatchid%TYPE
151: INDEX BY BINARY_INTEGER;
152:
153: TYPE t_batchid IS TABLE OF
154: IBY_BATCHES_ALL.batchid%TYPE
155: INDEX BY BINARY_INTEGER;
156:
157: TYPE t_profcode IS TABLE OF
158: IBY_BATCHES_ALL.process_profile_code%TYPE

Line 158: IBY_BATCHES_ALL.process_profile_code%TYPE

154: IBY_BATCHES_ALL.batchid%TYPE
155: INDEX BY BINARY_INTEGER;
156:
157: TYPE t_profcode IS TABLE OF
158: IBY_BATCHES_ALL.process_profile_code%TYPE
159: INDEX BY BINARY_INTEGER;
160:
161: TYPE t_bepkey IS TABLE OF
162: IBY_BATCHES_ALL.bepkey%TYPE

Line 162: IBY_BATCHES_ALL.bepkey%TYPE

158: IBY_BATCHES_ALL.process_profile_code%TYPE
159: INDEX BY BINARY_INTEGER;
160:
161: TYPE t_bepkey IS TABLE OF
162: IBY_BATCHES_ALL.bepkey%TYPE
163: INDEX BY BINARY_INTEGER;
164:
165: TYPE t_org_id IS TABLE OF
166: IBY_BATCHES_ALL.org_id%TYPE

Line 166: IBY_BATCHES_ALL.org_id%TYPE

162: IBY_BATCHES_ALL.bepkey%TYPE
163: INDEX BY BINARY_INTEGER;
164:
165: TYPE t_org_id IS TABLE OF
166: IBY_BATCHES_ALL.org_id%TYPE
167: INDEX BY BINARY_INTEGER;
168:
169: TYPE t_org_type IS TABLE OF
170: IBY_BATCHES_ALL.org_type%TYPE

Line 170: IBY_BATCHES_ALL.org_type%TYPE

166: IBY_BATCHES_ALL.org_id%TYPE
167: INDEX BY BINARY_INTEGER;
168:
169: TYPE t_org_type IS TABLE OF
170: IBY_BATCHES_ALL.org_type%TYPE
171: INDEX BY BINARY_INTEGER;
172:
173: TYPE t_legal_entity_id IS TABLE OF
174: IBY_BATCHES_ALL.legal_entity_id%TYPE

Line 174: IBY_BATCHES_ALL.legal_entity_id%TYPE

170: IBY_BATCHES_ALL.org_type%TYPE
171: INDEX BY BINARY_INTEGER;
172:
173: TYPE t_legal_entity_id IS TABLE OF
174: IBY_BATCHES_ALL.legal_entity_id%TYPE
175: INDEX BY BINARY_INTEGER;
176:
177: TYPE t_payeeinstrid IS TABLE OF
178: IBY_BATCHES_ALL.payeeinstrid%TYPE

Line 178: IBY_BATCHES_ALL.payeeinstrid%TYPE

174: IBY_BATCHES_ALL.legal_entity_id%TYPE
175: INDEX BY BINARY_INTEGER;
176:
177: TYPE t_payeeinstrid IS TABLE OF
178: IBY_BATCHES_ALL.payeeinstrid%TYPE
179: INDEX BY BINARY_INTEGER;
180:
181: TYPE t_currencynamecode IS TABLE OF
182: IBY_BATCHES_ALL.currencynamecode%TYPE

Line 182: IBY_BATCHES_ALL.currencynamecode%TYPE

178: IBY_BATCHES_ALL.payeeinstrid%TYPE
179: INDEX BY BINARY_INTEGER;
180:
181: TYPE t_currencynamecode IS TABLE OF
182: IBY_BATCHES_ALL.currencynamecode%TYPE
183: INDEX BY BINARY_INTEGER;
184:
185: TYPE t_settledate IS TABLE OF
186: IBY_BATCHES_ALL.settledate%TYPE

Line 186: IBY_BATCHES_ALL.settledate%TYPE

182: IBY_BATCHES_ALL.currencynamecode%TYPE
183: INDEX BY BINARY_INTEGER;
184:
185: TYPE t_settledate IS TABLE OF
186: IBY_BATCHES_ALL.settledate%TYPE
187: INDEX BY BINARY_INTEGER;
188:
189: TYPE batch_tab_type IS RECORD
190: (

Line 228: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,

224:
225: PROCEDURE validate_open_batch
226: (
227: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
228: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
229: p_sec_key_on IN VARCHAR2,
230: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,
231: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE
232: );

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

226: (
227: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
228: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
229: p_sec_key_on IN VARCHAR2,
230: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,
231: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE
232: );
233:
234: PROCEDURE prepare_instr_data

Line 231: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE

227: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
228: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
229: p_sec_key_on IN VARCHAR2,
230: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,
231: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE
232: );
233:
234: PROCEDURE prepare_instr_data
235: (p_commit IN VARCHAR2,

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

468:
469:
470:
471: /*
472: * Inserts a row about batch status into iby_batches_all. This will
473: * be called for link error, timeout error or other batch status with
474: * gateway payment systems. For processor payment systems, this will
475: * create a new batch and associate all trxns in the current, unnamed
476: * open batch with it.

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

475: * create a new batch and associate all trxns in the current, unnamed
476: * open batch with it.
477: */
478: PROCEDURE insert_batch_status
479: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
480: merchant_id_in IN iby_batches_all.payeeid%TYPE,
481: vendor_id_in IN iby_batches_all.bepid%TYPE,
482: vendor_key_in IN iby_batches_all.bepkey%TYPE,
483: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 480: merchant_id_in IN iby_batches_all.payeeid%TYPE,

476: * open batch with it.
477: */
478: PROCEDURE insert_batch_status
479: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
480: merchant_id_in IN iby_batches_all.payeeid%TYPE,
481: vendor_id_in IN iby_batches_all.bepid%TYPE,
482: vendor_key_in IN iby_batches_all.bepkey%TYPE,
483: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
484: status_in IN iby_batches_all.batchstatus%TYPE,

Line 481: vendor_id_in IN iby_batches_all.bepid%TYPE,

477: */
478: PROCEDURE insert_batch_status
479: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
480: merchant_id_in IN iby_batches_all.payeeid%TYPE,
481: vendor_id_in IN iby_batches_all.bepid%TYPE,
482: vendor_key_in IN iby_batches_all.bepkey%TYPE,
483: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
484: status_in IN iby_batches_all.batchstatus%TYPE,
485: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,

Line 482: vendor_key_in IN iby_batches_all.bepkey%TYPE,

478: PROCEDURE insert_batch_status
479: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
480: merchant_id_in IN iby_batches_all.payeeid%TYPE,
481: vendor_id_in IN iby_batches_all.bepid%TYPE,
482: vendor_key_in IN iby_batches_all.bepkey%TYPE,
483: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
484: status_in IN iby_batches_all.batchstatus%TYPE,
485: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
486: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,

Line 483: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

479: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
480: merchant_id_in IN iby_batches_all.payeeid%TYPE,
481: vendor_id_in IN iby_batches_all.bepid%TYPE,
482: vendor_key_in IN iby_batches_all.bepkey%TYPE,
483: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
484: status_in IN iby_batches_all.batchstatus%TYPE,
485: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
486: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
487: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,

Line 484: status_in IN iby_batches_all.batchstatus%TYPE,

480: merchant_id_in IN iby_batches_all.payeeid%TYPE,
481: vendor_id_in IN iby_batches_all.bepid%TYPE,
482: vendor_key_in IN iby_batches_all.bepkey%TYPE,
483: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
484: status_in IN iby_batches_all.batchstatus%TYPE,
485: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
486: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
487: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
488: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,

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

481: vendor_id_in IN iby_batches_all.bepid%TYPE,
482: vendor_key_in IN iby_batches_all.bepkey%TYPE,
483: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
484: status_in IN iby_batches_all.batchstatus%TYPE,
485: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
486: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
487: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
488: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
489: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,

Line 486: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,

482: vendor_key_in IN iby_batches_all.bepkey%TYPE,
483: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
484: status_in IN iby_batches_all.batchstatus%TYPE,
485: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
486: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
487: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
488: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
489: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
490: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,

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

483: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
484: status_in IN iby_batches_all.batchstatus%TYPE,
485: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
486: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
487: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
488: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
489: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
490: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
491: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,

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

484: status_in IN iby_batches_all.batchstatus%TYPE,
485: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
486: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
487: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
488: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
489: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
490: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
491: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
492: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,

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

485: time_in IN iby_batches_all.batchclosedate%TYPE DEFAULT SYSDATE,
486: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
487: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
488: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
489: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
490: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
491: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
492: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
493: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,

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

486: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE,
487: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
488: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
489: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
490: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
491: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
492: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
493: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
494: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,

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

487: currency_in IN iby_batches_all.currencynamecode%TYPE DEFAULT NULL,
488: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
489: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
490: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
491: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
492: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
493: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
494: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
495: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,

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

488: numtrxns_in IN iby_batches_all.NumTrxns%TYPE DEFAULT NULL,
489: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
490: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
491: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
492: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
493: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
494: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
495: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
496: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,

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

489: batchstate_in IN iby_batches_all.BatchStateid%TYPE DEFAULT NULL,
490: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
491: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
492: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
493: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
494: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
495: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
496: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
497: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,

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

490: batchtotal_in IN iby_batches_all.BatchTotal%TYPE DEFAULT NULL,
491: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
492: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
493: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
494: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
495: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
496: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
497: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
498: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,

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

491: saleamount_in IN iby_batches_all.BatchSales%TYPE DEFAULT NULL,
492: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
493: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
494: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
495: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
496: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
497: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
498: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
499: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

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

492: cramount_in IN iby_batches_all.BatchCredit%TYPE DEFAULT NULL,
493: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
494: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
495: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
496: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
497: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
498: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
499: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
500: req_type_in IN iby_batches_all.reqtype%type,

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

493: gwid_in IN iby_batches_all.GWBatchID%TYPE DEFAULT NULL,
494: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
495: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
496: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
497: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
498: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
499: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
500: req_type_in IN iby_batches_all.reqtype%type,
501: sec_key_present_in IN VARCHAR2,

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

494: vendor_code_in IN iby_batches_all.bepcode%TYPE DEFAULT NULL,
495: vendor_message_in IN iby_batches_all.bepmessage%TYPE DEFAULT NULL,
496: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
497: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
498: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
499: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
500: req_type_in IN iby_batches_all.reqtype%type,
501: sec_key_present_in IN VARCHAR2,
502: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type

Line 500: req_type_in IN iby_batches_all.reqtype%type,

496: error_location_in IN iby_batches_all.errorlocation%TYPE DEFAULT NULL,
497: terminal_id_in IN iby_batches_all.TerminalId%TYPE DEFAULT NULL,
498: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
499: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
500: req_type_in IN iby_batches_all.reqtype%type,
501: sec_key_present_in IN VARCHAR2,
502: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type
503: );
504:

Line 502: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type

498: acquirer_id_in IN iby_batches_all.Acquirer%TYPE DEFAULT NULL,
499: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
500: req_type_in IN iby_batches_all.reqtype%type,
501: sec_key_present_in IN VARCHAR2,
502: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type
503: );
504:
505: /*
506: * Performs batch close operation by grouping pending transactions.

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

508: * batch close call depending upon how many batches are
509: * generated by applying grouping rules.
510: */
511: PROCEDURE insert_batch_status_new
512: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
513: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
514: merchant_id_in IN iby_batches_all.payeeid%TYPE,
515: vendor_id_in IN iby_batches_all.bepid%TYPE,
516: vendor_key_in IN iby_batches_all.bepkey%TYPE,

Line 513: profile_code_in IN iby_batches_all.process_profile_code%TYPE,

509: * generated by applying grouping rules.
510: */
511: PROCEDURE insert_batch_status_new
512: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
513: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
514: merchant_id_in IN iby_batches_all.payeeid%TYPE,
515: vendor_id_in IN iby_batches_all.bepid%TYPE,
516: vendor_key_in IN iby_batches_all.bepkey%TYPE,
517: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 514: merchant_id_in IN iby_batches_all.payeeid%TYPE,

510: */
511: PROCEDURE insert_batch_status_new
512: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
513: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
514: merchant_id_in IN iby_batches_all.payeeid%TYPE,
515: vendor_id_in IN iby_batches_all.bepid%TYPE,
516: vendor_key_in IN iby_batches_all.bepkey%TYPE,
517: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
518: status_in IN iby_batches_all.batchstatus%TYPE,

Line 515: vendor_id_in IN iby_batches_all.bepid%TYPE,

511: PROCEDURE insert_batch_status_new
512: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
513: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
514: merchant_id_in IN iby_batches_all.payeeid%TYPE,
515: vendor_id_in IN iby_batches_all.bepid%TYPE,
516: vendor_key_in IN iby_batches_all.bepkey%TYPE,
517: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
518: status_in IN iby_batches_all.batchstatus%TYPE,
519: time_in IN iby_batches_all.batchclosedate%TYPE,

Line 516: vendor_key_in IN iby_batches_all.bepkey%TYPE,

512: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
513: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
514: merchant_id_in IN iby_batches_all.payeeid%TYPE,
515: vendor_id_in IN iby_batches_all.bepid%TYPE,
516: vendor_key_in IN iby_batches_all.bepkey%TYPE,
517: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
518: status_in IN iby_batches_all.batchstatus%TYPE,
519: time_in IN iby_batches_all.batchclosedate%TYPE,
520: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

Line 517: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

513: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
514: merchant_id_in IN iby_batches_all.payeeid%TYPE,
515: vendor_id_in IN iby_batches_all.bepid%TYPE,
516: vendor_key_in IN iby_batches_all.bepkey%TYPE,
517: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
518: status_in IN iby_batches_all.batchstatus%TYPE,
519: time_in IN iby_batches_all.batchclosedate%TYPE,
520: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
521: currency_in IN iby_batches_all.currencynamecode%TYPE,

Line 518: status_in IN iby_batches_all.batchstatus%TYPE,

514: merchant_id_in IN iby_batches_all.payeeid%TYPE,
515: vendor_id_in IN iby_batches_all.bepid%TYPE,
516: vendor_key_in IN iby_batches_all.bepkey%TYPE,
517: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
518: status_in IN iby_batches_all.batchstatus%TYPE,
519: time_in IN iby_batches_all.batchclosedate%TYPE,
520: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
521: currency_in IN iby_batches_all.currencynamecode%TYPE,
522: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

Line 519: time_in IN iby_batches_all.batchclosedate%TYPE,

515: vendor_id_in IN iby_batches_all.bepid%TYPE,
516: vendor_key_in IN iby_batches_all.bepkey%TYPE,
517: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
518: status_in IN iby_batches_all.batchstatus%TYPE,
519: time_in IN iby_batches_all.batchclosedate%TYPE,
520: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
521: currency_in IN iby_batches_all.currencynamecode%TYPE,
522: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
523: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

Line 520: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

516: vendor_key_in IN iby_batches_all.bepkey%TYPE,
517: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
518: status_in IN iby_batches_all.batchstatus%TYPE,
519: time_in IN iby_batches_all.batchclosedate%TYPE,
520: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
521: currency_in IN iby_batches_all.currencynamecode%TYPE,
522: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
523: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
524: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

Line 521: currency_in IN iby_batches_all.currencynamecode%TYPE,

517: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
518: status_in IN iby_batches_all.batchstatus%TYPE,
519: time_in IN iby_batches_all.batchclosedate%TYPE,
520: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
521: currency_in IN iby_batches_all.currencynamecode%TYPE,
522: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
523: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
524: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
525: saleamount_in IN iby_batches_all.BatchSales%TYPE,

Line 522: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

518: status_in IN iby_batches_all.batchstatus%TYPE,
519: time_in IN iby_batches_all.batchclosedate%TYPE,
520: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
521: currency_in IN iby_batches_all.currencynamecode%TYPE,
522: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
523: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
524: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
525: saleamount_in IN iby_batches_all.BatchSales%TYPE,
526: cramount_in IN iby_batches_all.BatchCredit%TYPE,

Line 523: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

519: time_in IN iby_batches_all.batchclosedate%TYPE,
520: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
521: currency_in IN iby_batches_all.currencynamecode%TYPE,
522: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
523: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
524: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
525: saleamount_in IN iby_batches_all.BatchSales%TYPE,
526: cramount_in IN iby_batches_all.BatchCredit%TYPE,
527: gwid_in IN iby_batches_all.GWBatchID%TYPE,

Line 524: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

520: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
521: currency_in IN iby_batches_all.currencynamecode%TYPE,
522: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
523: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
524: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
525: saleamount_in IN iby_batches_all.BatchSales%TYPE,
526: cramount_in IN iby_batches_all.BatchCredit%TYPE,
527: gwid_in IN iby_batches_all.GWBatchID%TYPE,
528: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

Line 525: saleamount_in IN iby_batches_all.BatchSales%TYPE,

521: currency_in IN iby_batches_all.currencynamecode%TYPE,
522: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
523: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
524: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
525: saleamount_in IN iby_batches_all.BatchSales%TYPE,
526: cramount_in IN iby_batches_all.BatchCredit%TYPE,
527: gwid_in IN iby_batches_all.GWBatchID%TYPE,
528: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
529: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

Line 526: cramount_in IN iby_batches_all.BatchCredit%TYPE,

522: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
523: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
524: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
525: saleamount_in IN iby_batches_all.BatchSales%TYPE,
526: cramount_in IN iby_batches_all.BatchCredit%TYPE,
527: gwid_in IN iby_batches_all.GWBatchID%TYPE,
528: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
529: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
530: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 527: gwid_in IN iby_batches_all.GWBatchID%TYPE,

523: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
524: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
525: saleamount_in IN iby_batches_all.BatchSales%TYPE,
526: cramount_in IN iby_batches_all.BatchCredit%TYPE,
527: gwid_in IN iby_batches_all.GWBatchID%TYPE,
528: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
529: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
530: error_location_in IN iby_batches_all.errorlocation%TYPE,
531: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

Line 528: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

524: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
525: saleamount_in IN iby_batches_all.BatchSales%TYPE,
526: cramount_in IN iby_batches_all.BatchCredit%TYPE,
527: gwid_in IN iby_batches_all.GWBatchID%TYPE,
528: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
529: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
530: error_location_in IN iby_batches_all.errorlocation%TYPE,
531: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
532: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

Line 529: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

525: saleamount_in IN iby_batches_all.BatchSales%TYPE,
526: cramount_in IN iby_batches_all.BatchCredit%TYPE,
527: gwid_in IN iby_batches_all.GWBatchID%TYPE,
528: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
529: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
530: error_location_in IN iby_batches_all.errorlocation%TYPE,
531: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
532: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
533: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 530: error_location_in IN iby_batches_all.errorlocation%TYPE,

526: cramount_in IN iby_batches_all.BatchCredit%TYPE,
527: gwid_in IN iby_batches_all.GWBatchID%TYPE,
528: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
529: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
530: error_location_in IN iby_batches_all.errorlocation%TYPE,
531: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
532: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
533: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
534: req_type_in IN iby_batches_all.reqtype%TYPE,

Line 531: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

527: gwid_in IN iby_batches_all.GWBatchID%TYPE,
528: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
529: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
530: error_location_in IN iby_batches_all.errorlocation%TYPE,
531: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
532: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
533: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
534: req_type_in IN iby_batches_all.reqtype%TYPE,
535: sec_key_present_in IN VARCHAR2,

Line 532: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

528: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
529: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
530: error_location_in IN iby_batches_all.errorlocation%TYPE,
531: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
532: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
533: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
534: req_type_in IN iby_batches_all.reqtype%TYPE,
535: sec_key_present_in IN VARCHAR2,
536: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

Line 534: req_type_in IN iby_batches_all.reqtype%TYPE,

530: error_location_in IN iby_batches_all.errorlocation%TYPE,
531: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
532: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
533: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
534: req_type_in IN iby_batches_all.reqtype%TYPE,
535: sec_key_present_in IN VARCHAR2,
536: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
537: instr_type_in IN iby_batches_all.instrument_type%TYPE,
538: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

Line 536: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

532: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
533: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
534: req_type_in IN iby_batches_all.reqtype%TYPE,
535: sec_key_present_in IN VARCHAR2,
536: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
537: instr_type_in IN iby_batches_all.instrument_type%TYPE,
538: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
539: f_pmt_channel_in IN iby_trxn_summaries_all.
540: payment_channel_code%TYPE,

Line 537: instr_type_in IN iby_batches_all.instrument_type%TYPE,

533: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
534: req_type_in IN iby_batches_all.reqtype%TYPE,
535: sec_key_present_in IN VARCHAR2,
536: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
537: instr_type_in IN iby_batches_all.instrument_type%TYPE,
538: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
539: f_pmt_channel_in IN iby_trxn_summaries_all.
540: payment_channel_code%TYPE,
541: f_curr_in IN iby_trxn_summaries_all.

Line 538: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

534: req_type_in IN iby_batches_all.reqtype%TYPE,
535: sec_key_present_in IN VARCHAR2,
536: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
537: instr_type_in IN iby_batches_all.instrument_type%TYPE,
538: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
539: f_pmt_channel_in IN iby_trxn_summaries_all.
540: payment_channel_code%TYPE,
541: f_curr_in IN iby_trxn_summaries_all.
542: currencynamecode%TYPE,

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

555: /* Overloaded form of the above API. This one takes an
556: Array of user profiles instead of a single one.
557: */
558: PROCEDURE insert_batch_status_new
559: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
560: profile_code_array IN JTF_VARCHAR2_TABLE_100,
561: merchant_id_in IN iby_batches_all.payeeid%TYPE,
562: vendor_id_in IN iby_batches_all.bepid%TYPE,
563: vendor_key_in IN iby_batches_all.bepkey%TYPE,

Line 561: merchant_id_in IN iby_batches_all.payeeid%TYPE,

557: */
558: PROCEDURE insert_batch_status_new
559: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
560: profile_code_array IN JTF_VARCHAR2_TABLE_100,
561: merchant_id_in IN iby_batches_all.payeeid%TYPE,
562: vendor_id_in IN iby_batches_all.bepid%TYPE,
563: vendor_key_in IN iby_batches_all.bepkey%TYPE,
564: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
565: status_in IN iby_batches_all.batchstatus%TYPE,

Line 562: vendor_id_in IN iby_batches_all.bepid%TYPE,

558: PROCEDURE insert_batch_status_new
559: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
560: profile_code_array IN JTF_VARCHAR2_TABLE_100,
561: merchant_id_in IN iby_batches_all.payeeid%TYPE,
562: vendor_id_in IN iby_batches_all.bepid%TYPE,
563: vendor_key_in IN iby_batches_all.bepkey%TYPE,
564: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
565: status_in IN iby_batches_all.batchstatus%TYPE,
566: time_in IN iby_batches_all.batchclosedate%TYPE,

Line 563: vendor_key_in IN iby_batches_all.bepkey%TYPE,

559: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
560: profile_code_array IN JTF_VARCHAR2_TABLE_100,
561: merchant_id_in IN iby_batches_all.payeeid%TYPE,
562: vendor_id_in IN iby_batches_all.bepid%TYPE,
563: vendor_key_in IN iby_batches_all.bepkey%TYPE,
564: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
565: status_in IN iby_batches_all.batchstatus%TYPE,
566: time_in IN iby_batches_all.batchclosedate%TYPE,
567: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

Line 564: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

560: profile_code_array IN JTF_VARCHAR2_TABLE_100,
561: merchant_id_in IN iby_batches_all.payeeid%TYPE,
562: vendor_id_in IN iby_batches_all.bepid%TYPE,
563: vendor_key_in IN iby_batches_all.bepkey%TYPE,
564: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
565: status_in IN iby_batches_all.batchstatus%TYPE,
566: time_in IN iby_batches_all.batchclosedate%TYPE,
567: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
568: currency_in IN iby_batches_all.currencynamecode%TYPE,

Line 565: status_in IN iby_batches_all.batchstatus%TYPE,

561: merchant_id_in IN iby_batches_all.payeeid%TYPE,
562: vendor_id_in IN iby_batches_all.bepid%TYPE,
563: vendor_key_in IN iby_batches_all.bepkey%TYPE,
564: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
565: status_in IN iby_batches_all.batchstatus%TYPE,
566: time_in IN iby_batches_all.batchclosedate%TYPE,
567: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
568: currency_in IN iby_batches_all.currencynamecode%TYPE,
569: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

Line 566: time_in IN iby_batches_all.batchclosedate%TYPE,

562: vendor_id_in IN iby_batches_all.bepid%TYPE,
563: vendor_key_in IN iby_batches_all.bepkey%TYPE,
564: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
565: status_in IN iby_batches_all.batchstatus%TYPE,
566: time_in IN iby_batches_all.batchclosedate%TYPE,
567: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
568: currency_in IN iby_batches_all.currencynamecode%TYPE,
569: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
570: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

Line 567: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

563: vendor_key_in IN iby_batches_all.bepkey%TYPE,
564: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
565: status_in IN iby_batches_all.batchstatus%TYPE,
566: time_in IN iby_batches_all.batchclosedate%TYPE,
567: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
568: currency_in IN iby_batches_all.currencynamecode%TYPE,
569: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
570: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
571: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

Line 568: currency_in IN iby_batches_all.currencynamecode%TYPE,

564: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
565: status_in IN iby_batches_all.batchstatus%TYPE,
566: time_in IN iby_batches_all.batchclosedate%TYPE,
567: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
568: currency_in IN iby_batches_all.currencynamecode%TYPE,
569: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
570: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
571: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
572: saleamount_in IN iby_batches_all.BatchSales%TYPE,

Line 569: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

565: status_in IN iby_batches_all.batchstatus%TYPE,
566: time_in IN iby_batches_all.batchclosedate%TYPE,
567: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
568: currency_in IN iby_batches_all.currencynamecode%TYPE,
569: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
570: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
571: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
572: saleamount_in IN iby_batches_all.BatchSales%TYPE,
573: cramount_in IN iby_batches_all.BatchCredit%TYPE,

Line 570: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

566: time_in IN iby_batches_all.batchclosedate%TYPE,
567: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
568: currency_in IN iby_batches_all.currencynamecode%TYPE,
569: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
570: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
571: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
572: saleamount_in IN iby_batches_all.BatchSales%TYPE,
573: cramount_in IN iby_batches_all.BatchCredit%TYPE,
574: gwid_in IN iby_batches_all.GWBatchID%TYPE,

Line 571: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

567: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
568: currency_in IN iby_batches_all.currencynamecode%TYPE,
569: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
570: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
571: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
572: saleamount_in IN iby_batches_all.BatchSales%TYPE,
573: cramount_in IN iby_batches_all.BatchCredit%TYPE,
574: gwid_in IN iby_batches_all.GWBatchID%TYPE,
575: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

Line 572: saleamount_in IN iby_batches_all.BatchSales%TYPE,

568: currency_in IN iby_batches_all.currencynamecode%TYPE,
569: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
570: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
571: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
572: saleamount_in IN iby_batches_all.BatchSales%TYPE,
573: cramount_in IN iby_batches_all.BatchCredit%TYPE,
574: gwid_in IN iby_batches_all.GWBatchID%TYPE,
575: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
576: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

Line 573: cramount_in IN iby_batches_all.BatchCredit%TYPE,

569: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
570: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
571: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
572: saleamount_in IN iby_batches_all.BatchSales%TYPE,
573: cramount_in IN iby_batches_all.BatchCredit%TYPE,
574: gwid_in IN iby_batches_all.GWBatchID%TYPE,
575: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
576: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
577: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 574: gwid_in IN iby_batches_all.GWBatchID%TYPE,

570: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
571: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
572: saleamount_in IN iby_batches_all.BatchSales%TYPE,
573: cramount_in IN iby_batches_all.BatchCredit%TYPE,
574: gwid_in IN iby_batches_all.GWBatchID%TYPE,
575: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
576: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
577: error_location_in IN iby_batches_all.errorlocation%TYPE,
578: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

Line 575: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

571: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
572: saleamount_in IN iby_batches_all.BatchSales%TYPE,
573: cramount_in IN iby_batches_all.BatchCredit%TYPE,
574: gwid_in IN iby_batches_all.GWBatchID%TYPE,
575: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
576: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
577: error_location_in IN iby_batches_all.errorlocation%TYPE,
578: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
579: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

Line 576: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

572: saleamount_in IN iby_batches_all.BatchSales%TYPE,
573: cramount_in IN iby_batches_all.BatchCredit%TYPE,
574: gwid_in IN iby_batches_all.GWBatchID%TYPE,
575: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
576: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
577: error_location_in IN iby_batches_all.errorlocation%TYPE,
578: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
579: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
580: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 577: error_location_in IN iby_batches_all.errorlocation%TYPE,

573: cramount_in IN iby_batches_all.BatchCredit%TYPE,
574: gwid_in IN iby_batches_all.GWBatchID%TYPE,
575: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
576: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
577: error_location_in IN iby_batches_all.errorlocation%TYPE,
578: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
579: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
580: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
581: req_type_in IN iby_batches_all.reqtype%TYPE,

Line 578: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

574: gwid_in IN iby_batches_all.GWBatchID%TYPE,
575: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
576: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
577: error_location_in IN iby_batches_all.errorlocation%TYPE,
578: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
579: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
580: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
581: req_type_in IN iby_batches_all.reqtype%TYPE,
582: sec_key_present_in IN VARCHAR2,

Line 579: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

575: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
576: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
577: error_location_in IN iby_batches_all.errorlocation%TYPE,
578: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
579: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
580: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
581: req_type_in IN iby_batches_all.reqtype%TYPE,
582: sec_key_present_in IN VARCHAR2,
583: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

Line 581: req_type_in IN iby_batches_all.reqtype%TYPE,

577: error_location_in IN iby_batches_all.errorlocation%TYPE,
578: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
579: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
580: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
581: req_type_in IN iby_batches_all.reqtype%TYPE,
582: sec_key_present_in IN VARCHAR2,
583: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
584: instr_type_in IN iby_batches_all.instrument_type%TYPE,
585: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

Line 583: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

579: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
580: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
581: req_type_in IN iby_batches_all.reqtype%TYPE,
582: sec_key_present_in IN VARCHAR2,
583: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
584: instr_type_in IN iby_batches_all.instrument_type%TYPE,
585: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
586: f_pmt_channel_in IN iby_trxn_summaries_all.
587: payment_channel_code%TYPE,

Line 584: instr_type_in IN iby_batches_all.instrument_type%TYPE,

580: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
581: req_type_in IN iby_batches_all.reqtype%TYPE,
582: sec_key_present_in IN VARCHAR2,
583: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
584: instr_type_in IN iby_batches_all.instrument_type%TYPE,
585: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
586: f_pmt_channel_in IN iby_trxn_summaries_all.
587: payment_channel_code%TYPE,
588: f_curr_in IN iby_trxn_summaries_all.

Line 585: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

581: req_type_in IN iby_batches_all.reqtype%TYPE,
582: sec_key_present_in IN VARCHAR2,
583: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
584: instr_type_in IN iby_batches_all.instrument_type%TYPE,
585: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
586: f_pmt_channel_in IN iby_trxn_summaries_all.
587: payment_channel_code%TYPE,
588: f_curr_in IN iby_trxn_summaries_all.
589: currencynamecode%TYPE,

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

661: /*
662: ** Procedure: getMBatchId
663: ** Purpose: retrieve mBatchid from iby_Batch table based on Batchid
664: */
665: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
666: i_Payeeid in iby_Batches_all.Payeeid%type,
667: o_mBatchid out nocopy iby_Batches_all.mBatchid%type);
668:
669: /*

Line 666: i_Payeeid in iby_Batches_all.Payeeid%type,

662: ** Procedure: getMBatchId
663: ** Purpose: retrieve mBatchid from iby_Batch table based on Batchid
664: */
665: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
666: i_Payeeid in iby_Batches_all.Payeeid%type,
667: o_mBatchid out nocopy iby_Batches_all.mBatchid%type);
668:
669: /*
670: ** Function: getTID

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

663: ** Purpose: retrieve mBatchid from iby_Batch table based on Batchid
664: */
665: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
666: i_Payeeid in iby_Batches_all.Payeeid%type,
667: o_mBatchid out nocopy iby_Batches_all.mBatchid%type);
668:
669: /*
670: ** Function: getTID
671: ** Purpose: get the next trxnid availabe, make sure there is only one TID

Line 790: ecapp_id_in IN iby_batches_all.ecappid%TYPE,

786: );
787:
788: PROCEDURE Update_Batch
789: (
790: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
791: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
792: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
793: batch_status_in IN iby_batches_all.batchstatus%TYPE,
794: batch_total_in IN iby_batches_all.batchtotal%TYPE,

Line 793: batch_status_in IN iby_batches_all.batchstatus%TYPE,

789: (
790: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
791: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
792: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
793: batch_status_in IN iby_batches_all.batchstatus%TYPE,
794: batch_total_in IN iby_batches_all.batchtotal%TYPE,
795: sale_amount_in IN iby_batches_all.batchsales%TYPE,
796: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
797: bep_code_in IN iby_batches_all.bepcode%TYPE,

Line 794: batch_total_in IN iby_batches_all.batchtotal%TYPE,

790: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
791: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
792: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
793: batch_status_in IN iby_batches_all.batchstatus%TYPE,
794: batch_total_in IN iby_batches_all.batchtotal%TYPE,
795: sale_amount_in IN iby_batches_all.batchsales%TYPE,
796: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
797: bep_code_in IN iby_batches_all.bepcode%TYPE,
798: bep_message_in IN iby_batches_all.bepmessage%TYPE,

Line 795: sale_amount_in IN iby_batches_all.batchsales%TYPE,

791: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
792: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
793: batch_status_in IN iby_batches_all.batchstatus%TYPE,
794: batch_total_in IN iby_batches_all.batchtotal%TYPE,
795: sale_amount_in IN iby_batches_all.batchsales%TYPE,
796: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
797: bep_code_in IN iby_batches_all.bepcode%TYPE,
798: bep_message_in IN iby_batches_all.bepmessage%TYPE,
799: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 796: credit_amount_in IN iby_batches_all.batchcredit%TYPE,

792: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
793: batch_status_in IN iby_batches_all.batchstatus%TYPE,
794: batch_total_in IN iby_batches_all.batchtotal%TYPE,
795: sale_amount_in IN iby_batches_all.batchsales%TYPE,
796: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
797: bep_code_in IN iby_batches_all.bepcode%TYPE,
798: bep_message_in IN iby_batches_all.bepmessage%TYPE,
799: error_location_in IN iby_batches_all.errorlocation%TYPE,
800: ack_type_in IN VARCHAR2,

Line 797: bep_code_in IN iby_batches_all.bepcode%TYPE,

793: batch_status_in IN iby_batches_all.batchstatus%TYPE,
794: batch_total_in IN iby_batches_all.batchtotal%TYPE,
795: sale_amount_in IN iby_batches_all.batchsales%TYPE,
796: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
797: bep_code_in IN iby_batches_all.bepcode%TYPE,
798: bep_message_in IN iby_batches_all.bepmessage%TYPE,
799: error_location_in IN iby_batches_all.errorlocation%TYPE,
800: ack_type_in IN VARCHAR2,
801: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,

Line 798: bep_message_in IN iby_batches_all.bepmessage%TYPE,

794: batch_total_in IN iby_batches_all.batchtotal%TYPE,
795: sale_amount_in IN iby_batches_all.batchsales%TYPE,
796: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
797: bep_code_in IN iby_batches_all.bepcode%TYPE,
798: bep_message_in IN iby_batches_all.bepmessage%TYPE,
799: error_location_in IN iby_batches_all.errorlocation%TYPE,
800: ack_type_in IN VARCHAR2,
801: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
802: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,

Line 799: error_location_in IN iby_batches_all.errorlocation%TYPE,

795: sale_amount_in IN iby_batches_all.batchsales%TYPE,
796: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
797: bep_code_in IN iby_batches_all.bepcode%TYPE,
798: bep_message_in IN iby_batches_all.bepmessage%TYPE,
799: error_location_in IN iby_batches_all.errorlocation%TYPE,
800: ack_type_in IN VARCHAR2,
801: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
802: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
803: trxn_status_in IN JTF_VARCHAR2_TABLE_100,

Line 908: orgid_in IN iby_batches_all.org_id%TYPE,

904: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,
905: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
906: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
907: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
908: orgid_in IN iby_batches_all.org_id%TYPE,
909: seckey_present_in IN VARCHAR2,
910: trxncount_out OUT NOCOPY NUMBER,
911: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE
912: );

Line 911: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE

907: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
908: orgid_in IN iby_batches_all.org_id%TYPE,
909: seckey_present_in IN VARCHAR2,
910: trxncount_out OUT NOCOPY NUMBER,
911: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE
912: );
913:
914: /*--------------------------------------------------------------------
915: | NAME:

Line 939: req_type IN IBY_BATCHES_ALL.

935: p_profile_code IN IBY_FNDCPT_USER_CC_PF_B.
936: user_cc_profile_code%TYPE,
937: instr_type IN IBY_TRXN_SUMMARIES_ALL.
938: instrtype%TYPE,
939: req_type IN IBY_BATCHES_ALL.
940: reqtype%TYPE,
941: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
942: payment_channel_code%TYPE,
943: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

Line 985: req_type IN IBY_BATCHES_ALL.

981: PROCEDURE performTransactionGrouping(
982: profile_code_array IN JTF_VARCHAR2_TABLE_100,
983: instr_type IN IBY_TRXN_SUMMARIES_ALL.
984: instrtype%TYPE,
985: req_type IN IBY_BATCHES_ALL.
986: reqtype%TYPE,
987: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
988: payment_channel_code%TYPE,
989: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

Line 999: merch_batchid_in IN iby_batches_all.batchid%TYPE,

995: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
996: br_maturity_date%TYPE,
997: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
998: instrtype%TYPE,
999: merch_batchid_in IN iby_batches_all.batchid%TYPE,
1000:
1001: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
1002: batchAttrTabType,
1003: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

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

1030: PROCEDURE insertTrxnIntoBatch(
1031: x_batchRec IN OUT NOCOPY batchAttrRecType,
1032: x_batchTab IN OUT NOCOPY batchAttrTabType,
1033: p_newBatchFlag IN BOOLEAN,
1034: x_currentBatchId IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE,
1035: x_trxnsInBatchTab IN OUT NOCOPY trxnsInBatchTabType,
1036: x_trxnsInBatchRec IN OUT NOCOPY trxnsInBatchRecType,
1037: x_trxnsInBatchCount IN OUT NOCOPY NUMBER
1038: );

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

1057: | NOTES:
1058: |
1059: *---------------------------------------------------------------------*/
1060: PROCEDURE getNextBatchId(
1061: x_batchID IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE
1062: );
1063:
1064: /*--------------------------------------------------------------------
1065: | NAME:

Line 1110: mbatchid_in IN iby_batches_all.mbatchid%TYPE

1106: | NOTES:
1107: |
1108: *---------------------------------------------------------------------*/
1109: PROCEDURE Update_Payer_Notif_Batch(
1110: mbatchid_in IN iby_batches_all.mbatchid%TYPE
1111: );
1112:
1113: /*--------------------------------------------------------------------
1114: | NAME: