191:
192: /* Inserts or updates a batch summary row into the PS_BATCH_SET */
193: /* table. This should happen for open or close batch operations. */
194: PROCEDURE insert_batch_status
195: (batch_id_in IN iby_batches_all.BatchID%TYPE,
196: merchant_id_in IN iby_batches_all.PayeeID%TYPE,
197: bep_id_in IN iby_batches_all.BEPID%TYPE,
198: /* vendor_suffix_in IN iby_batches_all.vendor_suffix%TYPE, */
199: /* close_status_in IN iby_batches_all.BatchCloseStatus%TYPE, */
192: /* Inserts or updates a batch summary row into the PS_BATCH_SET */
193: /* table. This should happen for open or close batch operations. */
194: PROCEDURE insert_batch_status
195: (batch_id_in IN iby_batches_all.BatchID%TYPE,
196: merchant_id_in IN iby_batches_all.PayeeID%TYPE,
197: bep_id_in IN iby_batches_all.BEPID%TYPE,
198: /* vendor_suffix_in IN iby_batches_all.vendor_suffix%TYPE, */
199: /* close_status_in IN iby_batches_all.BatchCloseStatus%TYPE, */
200: currency_in IN iby_batches_all.CurrencyNameCode%TYPE,
193: /* table. This should happen for open or close batch operations. */
194: PROCEDURE insert_batch_status
195: (batch_id_in IN iby_batches_all.BatchID%TYPE,
196: merchant_id_in IN iby_batches_all.PayeeID%TYPE,
197: bep_id_in IN iby_batches_all.BEPID%TYPE,
198: /* vendor_suffix_in IN iby_batches_all.vendor_suffix%TYPE, */
199: /* close_status_in IN iby_batches_all.BatchCloseStatus%TYPE, */
200: currency_in IN iby_batches_all.CurrencyNameCode%TYPE,
201: sale_price_in IN iby_batches_all.BatchSales%TYPE,
194: PROCEDURE insert_batch_status
195: (batch_id_in IN iby_batches_all.BatchID%TYPE,
196: merchant_id_in IN iby_batches_all.PayeeID%TYPE,
197: bep_id_in IN iby_batches_all.BEPID%TYPE,
198: /* vendor_suffix_in IN iby_batches_all.vendor_suffix%TYPE, */
199: /* close_status_in IN iby_batches_all.BatchCloseStatus%TYPE, */
200: currency_in IN iby_batches_all.CurrencyNameCode%TYPE,
201: sale_price_in IN iby_batches_all.BatchSales%TYPE,
202: credit_price_in IN iby_batches_all.BatchCredit%TYPE,
195: (batch_id_in IN iby_batches_all.BatchID%TYPE,
196: merchant_id_in IN iby_batches_all.PayeeID%TYPE,
197: bep_id_in IN iby_batches_all.BEPID%TYPE,
198: /* vendor_suffix_in IN iby_batches_all.vendor_suffix%TYPE, */
199: /* close_status_in IN iby_batches_all.BatchCloseStatus%TYPE, */
200: currency_in IN iby_batches_all.CurrencyNameCode%TYPE,
201: sale_price_in IN iby_batches_all.BatchSales%TYPE,
202: credit_price_in IN iby_batches_all.BatchCredit%TYPE,
203: trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
196: merchant_id_in IN iby_batches_all.PayeeID%TYPE,
197: bep_id_in IN iby_batches_all.BEPID%TYPE,
198: /* vendor_suffix_in IN iby_batches_all.vendor_suffix%TYPE, */
199: /* close_status_in IN iby_batches_all.BatchCloseStatus%TYPE, */
200: currency_in IN iby_batches_all.CurrencyNameCode%TYPE,
201: sale_price_in IN iby_batches_all.BatchSales%TYPE,
202: credit_price_in IN iby_batches_all.BatchCredit%TYPE,
203: trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
204: sale_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
197: bep_id_in IN iby_batches_all.BEPID%TYPE,
198: /* vendor_suffix_in IN iby_batches_all.vendor_suffix%TYPE, */
199: /* close_status_in IN iby_batches_all.BatchCloseStatus%TYPE, */
200: currency_in IN iby_batches_all.CurrencyNameCode%TYPE,
201: sale_price_in IN iby_batches_all.BatchSales%TYPE,
202: credit_price_in IN iby_batches_all.BatchCredit%TYPE,
203: trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
204: sale_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
205: credit_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
198: /* vendor_suffix_in IN iby_batches_all.vendor_suffix%TYPE, */
199: /* close_status_in IN iby_batches_all.BatchCloseStatus%TYPE, */
200: currency_in IN iby_batches_all.CurrencyNameCode%TYPE,
201: sale_price_in IN iby_batches_all.BatchSales%TYPE,
202: credit_price_in IN iby_batches_all.BatchCredit%TYPE,
203: trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
204: sale_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
205: credit_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
206: open_date_in IN iby_batches_all.BatchOpenDate%TYPE,
199: /* close_status_in IN iby_batches_all.BatchCloseStatus%TYPE, */
200: currency_in IN iby_batches_all.CurrencyNameCode%TYPE,
201: sale_price_in IN iby_batches_all.BatchSales%TYPE,
202: credit_price_in IN iby_batches_all.BatchCredit%TYPE,
203: trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
204: sale_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
205: credit_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
206: open_date_in IN iby_batches_all.BatchOpenDate%TYPE,
207: close_date_in IN iby_batches_all.BatchCloseDate%TYPE,
200: currency_in IN iby_batches_all.CurrencyNameCode%TYPE,
201: sale_price_in IN iby_batches_all.BatchSales%TYPE,
202: credit_price_in IN iby_batches_all.BatchCredit%TYPE,
203: trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
204: sale_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
205: credit_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
206: open_date_in IN iby_batches_all.BatchOpenDate%TYPE,
207: close_date_in IN iby_batches_all.BatchCloseDate%TYPE,
208: status_in IN iby_batches_all.BatchStatus%TYPE,
201: sale_price_in IN iby_batches_all.BatchSales%TYPE,
202: credit_price_in IN iby_batches_all.BatchCredit%TYPE,
203: trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
204: sale_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
205: credit_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
206: open_date_in IN iby_batches_all.BatchOpenDate%TYPE,
207: close_date_in IN iby_batches_all.BatchCloseDate%TYPE,
208: status_in IN iby_batches_all.BatchStatus%TYPE,
209: vendor_code_in IN iby_batches_all.BEPCode%TYPE,
202: credit_price_in IN iby_batches_all.BatchCredit%TYPE,
203: trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
204: sale_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
205: credit_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
206: open_date_in IN iby_batches_all.BatchOpenDate%TYPE,
207: close_date_in IN iby_batches_all.BatchCloseDate%TYPE,
208: status_in IN iby_batches_all.BatchStatus%TYPE,
209: vendor_code_in IN iby_batches_all.BEPCode%TYPE,
210: vendor_message_in IN iby_batches_all.BEPMessage%TYPE,
203: trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
204: sale_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
205: credit_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
206: open_date_in IN iby_batches_all.BatchOpenDate%TYPE,
207: close_date_in IN iby_batches_all.BatchCloseDate%TYPE,
208: status_in IN iby_batches_all.BatchStatus%TYPE,
209: vendor_code_in IN iby_batches_all.BEPCode%TYPE,
210: vendor_message_in IN iby_batches_all.BEPMessage%TYPE,
211: error_location_in IN iby_batches_all.ErrorLocation%TYPE,
204: sale_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
205: credit_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
206: open_date_in IN iby_batches_all.BatchOpenDate%TYPE,
207: close_date_in IN iby_batches_all.BatchCloseDate%TYPE,
208: status_in IN iby_batches_all.BatchStatus%TYPE,
209: vendor_code_in IN iby_batches_all.BEPCode%TYPE,
210: vendor_message_in IN iby_batches_all.BEPMessage%TYPE,
211: error_location_in IN iby_batches_all.ErrorLocation%TYPE,
212: org_id_in IN iby_batches_all.org_id%TYPE,
205: credit_trxn_count_in IN iby_batches_all.NumTrxns%TYPE,
206: open_date_in IN iby_batches_all.BatchOpenDate%TYPE,
207: close_date_in IN iby_batches_all.BatchCloseDate%TYPE,
208: status_in IN iby_batches_all.BatchStatus%TYPE,
209: vendor_code_in IN iby_batches_all.BEPCode%TYPE,
210: vendor_message_in IN iby_batches_all.BEPMessage%TYPE,
211: error_location_in IN iby_batches_all.ErrorLocation%TYPE,
212: org_id_in IN iby_batches_all.org_id%TYPE,
213: req_type_in IN iby_batches_all.reqtype%type);
206: open_date_in IN iby_batches_all.BatchOpenDate%TYPE,
207: close_date_in IN iby_batches_all.BatchCloseDate%TYPE,
208: status_in IN iby_batches_all.BatchStatus%TYPE,
209: vendor_code_in IN iby_batches_all.BEPCode%TYPE,
210: vendor_message_in IN iby_batches_all.BEPMessage%TYPE,
211: error_location_in IN iby_batches_all.ErrorLocation%TYPE,
212: org_id_in IN iby_batches_all.org_id%TYPE,
213: req_type_in IN iby_batches_all.reqtype%type);
214:
207: close_date_in IN iby_batches_all.BatchCloseDate%TYPE,
208: status_in IN iby_batches_all.BatchStatus%TYPE,
209: vendor_code_in IN iby_batches_all.BEPCode%TYPE,
210: vendor_message_in IN iby_batches_all.BEPMessage%TYPE,
211: error_location_in IN iby_batches_all.ErrorLocation%TYPE,
212: org_id_in IN iby_batches_all.org_id%TYPE,
213: req_type_in IN iby_batches_all.reqtype%type);
214:
215:
208: status_in IN iby_batches_all.BatchStatus%TYPE,
209: vendor_code_in IN iby_batches_all.BEPCode%TYPE,
210: vendor_message_in IN iby_batches_all.BEPMessage%TYPE,
211: error_location_in IN iby_batches_all.ErrorLocation%TYPE,
212: org_id_in IN iby_batches_all.org_id%TYPE,
213: req_type_in IN iby_batches_all.reqtype%type);
214:
215:
216: /* Inserts or updates the batch detail record upon the */
209: vendor_code_in IN iby_batches_all.BEPCode%TYPE,
210: vendor_message_in IN iby_batches_all.BEPMessage%TYPE,
211: error_location_in IN iby_batches_all.ErrorLocation%TYPE,
212: org_id_in IN iby_batches_all.org_id%TYPE,
213: req_type_in IN iby_batches_all.reqtype%type);
214:
215:
216: /* Inserts or updates the batch detail record upon the */
217: /* closebatch or querybatch operations. */