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_TRXN_SUMMARIES_ALL

Line 18: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,

14: -- only a single currency
15: --
16: PROCEDURE validate_open_batch
17: (
18: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
19: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
20: p_sec_key_on IN VARCHAR2,
21: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,
22: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE

Line 26: l_batch_currency iby_trxn_summaries_all.currencynamecode%TYPE;

22: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE
23: )
24: IS
25: l_sec_trxn_count NUMBER;
26: l_batch_currency iby_trxn_summaries_all.currencynamecode%TYPE;
27:
28: l_call_string VARCHAR2(1000);
29: l_call_params JTF_VARCHAR2_TABLE_200 := JTF_VARCHAR2_TABLE_200();
30: l_return_status VARCHAR2(10);

Line 37: FROM iby_batches_all ba, iby_trxn_summaries_all ts

33:
34: CURSOR c_currencycodes(ci_mbatch_id IN iby_batches_all.mbatchid%TYPE)
35: IS
36: SELECT ts.currencynamecode
37: FROM iby_batches_all ba, iby_trxn_summaries_all ts
38: WHERE (ba.mbatchid = ci_mbatch_id)
39: AND (ba.payeeid = ts.payeeid)
40: AND (ba.batchid = ts.batchid)
41: GROUP BY ts.currencynamecode;

Line 43: CURSOR c_valsets(ci_bep_id iby_trxn_summaries_all.bepid%TYPE)

39: AND (ba.payeeid = ts.payeeid)
40: AND (ba.batchid = ts.batchid)
41: GROUP BY ts.currencynamecode;
42:
43: CURSOR c_valsets(ci_bep_id iby_trxn_summaries_all.bepid%TYPE)
44: IS
45: SELECT validation_code_package, validation_code_entry_point
46: FROM iby_validation_sets_b vs, iby_fndcpt_sys_cc_pf_b pf,
47: iby_val_assignments va

Line 69: FROM iby_batches_all ba, iby_trxn_summaries_all ts

65: -- close to continue
66: --
67: SELECT COUNT(transactionid)
68: INTO l_sec_trxn_count
69: FROM iby_batches_all ba, iby_trxn_summaries_all ts
70: WHERE (ba.mbatchid = p_mbatch_id)
71: AND (ba.payeeid = ts.payeeid)
72: AND (ba.batchid = ts.batchid)
73: AND (NOT sub_key_id IS NULL);

Line 84: FROM iby_batches_all ba, iby_trxn_summaries_all ts

80: print_debuginfo('validate_ob', 'p_mbatch_id = ' || p_mbatch_id);
81:
82: SELECT COUNT(transactionid)
83: INTO x_trxn_count
84: FROM iby_batches_all ba, iby_trxn_summaries_all ts
85: WHERE (ba.mbatchid = p_mbatch_id)
86: AND (ba.payeeid = ts.payeeid)
87: AND (ba.batchid = ts.batchid);
88: --

Line 141: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,

137:
138: PROCEDURE prepare_instr_data
139: (p_commit IN VARCHAR2,
140: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
141: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
142: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
143: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
144: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
145: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,

Line 142: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,

138: PROCEDURE prepare_instr_data
139: (p_commit IN VARCHAR2,
140: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
141: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
142: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
143: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
144: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
145: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
146: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,

Line 143: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,

139: (p_commit IN VARCHAR2,
140: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
141: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
142: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
143: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
144: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
145: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
146: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
147: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,

Line 144: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,

140: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
141: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
142: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
143: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
144: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
145: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
146: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
147: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
148: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE

Line 145: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,

141: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
142: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
143: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
144: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
145: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
146: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
147: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
148: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
149: )

Line 146: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,

142: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
143: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
144: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
145: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
146: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
147: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
148: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
149: )
150: IS

Line 147: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,

143: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
144: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
145: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
146: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
147: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
148: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
149: )
150: IS
151: lx_instrnum iby_trxn_summaries_all.instrnumber%TYPE;

Line 148: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE

144: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
145: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
146: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
147: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
148: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
149: )
150: IS
151: lx_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
152: lx_unmask_digits iby_trxn_summaries_all.instrnumber%TYPE;

Line 151: lx_instrnum iby_trxn_summaries_all.instrnumber%TYPE;

147: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
148: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
149: )
150: IS
151: lx_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
152: lx_unmask_digits iby_trxn_summaries_all.instrnumber%TYPE;
153: lx_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
154: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
155:

Line 152: lx_unmask_digits iby_trxn_summaries_all.instrnumber%TYPE;

148: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
149: )
150: IS
151: lx_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
152: lx_unmask_digits iby_trxn_summaries_all.instrnumber%TYPE;
153: lx_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
154: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
155:
156: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

Line 231: p_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE,

227: -- USE: inserts transactional extensibility data
228: --
229: PROCEDURE insert_extensibility
230: (
231: p_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE,
232: p_commit IN VARCHAR2,
233: p_extend_names IN JTF_VARCHAR2_TABLE_100,
234: p_extend_vals IN JTF_VARCHAR2_TABLE_200
235: )

Line 261: /* Inserts a new row into the IBY_TRXN_SUMMARIES_ALL table. This method */

257: COMMIT;
258: END IF;
259: END insert_extensibility;
260:
261: /* Inserts a new row into the IBY_TRXN_SUMMARIES_ALL table. This method */
262: /* would be called every time a MIPP authorize operation is performed. */
263:
264: PROCEDURE insert_auth_txn
265: (

Line 266: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,

262: /* would be called every time a MIPP authorize operation is performed. */
263:
264: PROCEDURE insert_auth_txn
265: (
266: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
267: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
268: order_id_in IN iby_transactions_v.order_id%TYPE,
269: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
270: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

Line 267: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,

263:
264: PROCEDURE insert_auth_txn
265: (
266: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
267: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
268: order_id_in IN iby_transactions_v.order_id%TYPE,
269: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
270: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
271: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

Line 288: org_id_in IN iby_trxn_summaries_all.org_id%type,

284: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
285: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
286: error_location_in IN iby_transactions_v.error_location%TYPE,
287: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
288: org_id_in IN iby_trxn_summaries_all.org_id%type,
289: billeracct_in IN iby_tangible.acctno%type,
290: refinfo_in IN iby_tangible.refinfo%type,
291: memo_in IN iby_tangible.memo%type,
292: order_medium_in IN iby_tangible.order_medium%TYPE,

Line 294: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

290: refinfo_in IN iby_tangible.refinfo%type,
291: memo_in IN iby_tangible.memo%type,
292: order_medium_in IN iby_tangible.order_medium%TYPE,
293: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
294: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
295: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
296: payerid_in IN iby_trxn_summaries_all.payerid%type,
297: instrtype_in IN iby_trxn_summaries_all.instrType%type,
298: cvv2result_in IN iby_trxn_core.CVV2Result%type,

Line 295: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

291: memo_in IN iby_tangible.memo%type,
292: order_medium_in IN iby_tangible.order_medium%TYPE,
293: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
294: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
295: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
296: payerid_in IN iby_trxn_summaries_all.payerid%type,
297: instrtype_in IN iby_trxn_summaries_all.instrType%type,
298: cvv2result_in IN iby_trxn_core.CVV2Result%type,
299: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

Line 296: payerid_in IN iby_trxn_summaries_all.payerid%type,

292: order_medium_in IN iby_tangible.order_medium%TYPE,
293: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
294: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
295: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
296: payerid_in IN iby_trxn_summaries_all.payerid%type,
297: instrtype_in IN iby_trxn_summaries_all.instrType%type,
298: cvv2result_in IN iby_trxn_core.CVV2Result%type,
299: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
300: subkey_seed_in IN RAW,

Line 297: instrtype_in IN iby_trxn_summaries_all.instrType%type,

293: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
294: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
295: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
296: payerid_in IN iby_trxn_summaries_all.payerid%type,
297: instrtype_in IN iby_trxn_summaries_all.instrType%type,
298: cvv2result_in IN iby_trxn_core.CVV2Result%type,
299: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
300: subkey_seed_in IN RAW,
301: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

Line 301: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

297: instrtype_in IN iby_trxn_summaries_all.instrType%type,
298: cvv2result_in IN iby_trxn_core.CVV2Result%type,
299: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
300: subkey_seed_in IN RAW,
301: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
302: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
303: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
304: instr_sec_val_in IN VARCHAR2,
305: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,

Line 327: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,

323: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
324: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
325: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
326: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
327: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
328: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
329: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
330: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
331: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,

Line 328: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,

324: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
325: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
326: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
327: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
328: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
329: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
330: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
331: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
332: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,

Line 329: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

325: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
326: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
327: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
328: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
329: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
330: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
331: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
332: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
333: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,

Line 330: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,

326: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
327: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
328: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
329: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
330: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
331: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
332: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
333: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,
334: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE

Line 331: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,

327: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
328: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
329: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
330: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
331: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
332: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
333: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,
334: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE
335: )

Line 332: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,

328: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
329: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
330: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
331: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
332: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
333: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,
334: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE
335: )
336: IS

Line 333: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,

329: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
330: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
331: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
332: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
333: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,
334: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE
335: )
336: IS
337:

Line 341: l_tmid iby_trxn_summaries_all.mtangibleid%type;

337:
338: l_num_trxns NUMBER := 0;
339: l_trxn_mid NUMBER;
340: l_transaction_id NUMBER;
341: l_tmid iby_trxn_summaries_all.mtangibleid%type;
342: l_mpayeeid iby_payee.mpayeeid%type;
343:
344: l_return_status VARCHAR2(1);
345: l_msg_count NUMBER;

Line 350: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;

346: l_msg_data VARCHAR2(200);
347: l_checksum_valid BOOLEAN := FALSE; -- whether the card number is valid.
348:
349: l_cc_type VARCHAR2(80);
350: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
351: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
352: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
353: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
354: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;

Line 352: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;

348:
349: l_cc_type VARCHAR2(80);
350: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
351: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
352: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
353: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
354: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
355:
356: l_instrnum iby_trxn_summaries_all.instrnumber%type;

Line 353: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;

349: l_cc_type VARCHAR2(80);
350: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
351: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
352: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
353: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
354: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
355:
356: l_instrnum iby_trxn_summaries_all.instrnumber%type;
357: l_expirydate iby_trxn_core.instr_expirydate%type;

Line 354: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;

350: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
351: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
352: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
353: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
354: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
355:
356: l_instrnum iby_trxn_summaries_all.instrnumber%type;
357: l_expirydate iby_trxn_core.instr_expirydate%type;
358:

Line 356: l_instrnum iby_trxn_summaries_all.instrnumber%type;

352: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
353: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
354: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
355:
356: l_instrnum iby_trxn_summaries_all.instrnumber%type;
357: l_expirydate iby_trxn_core.instr_expirydate%type;
358:
359: l_pos_txn iby_trxn_core.pos_trxn_flag%TYPE;
360: l_payer_party_id iby_trxn_summaries_all.payer_party_id%type;

Line 360: l_payer_party_id iby_trxn_summaries_all.payer_party_id%type;

356: l_instrnum iby_trxn_summaries_all.instrnumber%type;
357: l_expirydate iby_trxn_core.instr_expirydate%type;
358:
359: l_pos_txn iby_trxn_core.pos_trxn_flag%TYPE;
360: l_payer_party_id iby_trxn_summaries_all.payer_party_id%type;
361:
362: l_voiceauth_flag iby_trxn_core.voiceauthflag%type;
363: l_sub_key_id iby_trxn_summaries_all.sub_key_id%TYPE;
364:

Line 363: l_sub_key_id iby_trxn_summaries_all.sub_key_id%TYPE;

359: l_pos_txn iby_trxn_core.pos_trxn_flag%TYPE;
360: l_payer_party_id iby_trxn_summaries_all.payer_party_id%type;
361:
362: l_voiceauth_flag iby_trxn_core.voiceauthflag%type;
363: l_sub_key_id iby_trxn_summaries_all.sub_key_id%TYPE;
364:
365: -- variables for CHNAME and EXPDATE encryption
366: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
367: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

Line 470: INSERT INTO iby_trxn_summaries_all

466: iby_bill_pkg.createBill(order_id_in,amount_in,currency_in,
467: billeracct_in,refinfo_in, memo_in,
468: order_medium_in, eft_auth_method_in, l_tmid);
469: --test_debug('subkeyid passed as: '|| sub_key_id_in);
470: INSERT INTO iby_trxn_summaries_all
471: (TrxnMID, TransactionID,TrxntypeID, ReqType, ReqDate,
472: Amount,CurrencyNameCode, UpdateDate,Status, PaymentMethodName,
473: TangibleID,MPayeeID, PayeeID,BEPID,bepKey,mtangibleid,
474: BEPCode,BEPMessage,Errorlocation,ecappid,org_id,

Line 561: FROM iby_trxn_summaries_all

557: --(l_num_trxns = 1)
558: -- One previous PENDING transaction, so update previous row
559: SELECT TrxnMID, TransactionID, Mtangibleid, instrnum_sec_segment_id, sub_key_id
560: INTO l_trxn_mid, transaction_id_out, l_tmid, l_old_segment_id, l_sub_key_id
561: FROM iby_trxn_summaries_all
562: WHERE (TangibleID = order_id_in)
563: AND (UPPER(ReqType) = UPPER(req_type_in))
564: AND (PayeeID = merchant_id_in)
565: AND (status IN (11,9));

Line 578: UPDATE iby_trxn_summaries_all

574: billeracct_in,refinfo_in,memo_in,
575: order_medium_in, eft_auth_method_in);
576:
577:
578: UPDATE iby_trxn_summaries_all
579: SET BEPID = vendor_id_in,
580: bepKey = vendor_key_in,
581: Amount = amount_in,
582: -- amount, bepid is updated as the request can come in

Line 681: ( ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,

677:
678: /* operation is performed. */
679:
680: PROCEDURE insert_other_txn
681: ( ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
682: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
683: order_id_in IN iby_transactions_v.order_id%TYPE,
684: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
685: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

Line 682: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,

678: /* operation is performed. */
679:
680: PROCEDURE insert_other_txn
681: ( ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
682: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
683: order_id_in IN iby_transactions_v.order_id%TYPE,
684: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
685: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
686: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

Line 699: org_id_in IN iby_trxn_summaries_all.org_id%type,

695: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
696: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
697: error_location_in IN iby_transactions_v.error_location%TYPE,
698: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
699: org_id_in IN iby_trxn_summaries_all.org_id%type,
700: billeracct_in IN iby_tangible.acctno%type,
701: refinfo_in IN iby_tangible.refinfo%type,
702: memo_in IN iby_tangible.memo%type,
703: order_medium_in IN iby_tangible.order_medium%TYPE,

Line 705: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

701: refinfo_in IN iby_tangible.refinfo%type,
702: memo_in IN iby_tangible.memo%type,
703: order_medium_in IN iby_tangible.order_medium%TYPE,
704: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
705: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
706: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
707: payerid_in IN iby_trxn_summaries_all.payerid%type,
708: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
709: subkey_seed_in IN RAW,

Line 706: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

702: memo_in IN iby_tangible.memo%type,
703: order_medium_in IN iby_tangible.order_medium%TYPE,
704: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
705: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
706: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
707: payerid_in IN iby_trxn_summaries_all.payerid%type,
708: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
709: subkey_seed_in IN RAW,
710: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

Line 707: payerid_in IN iby_trxn_summaries_all.payerid%type,

703: order_medium_in IN iby_tangible.order_medium%TYPE,
704: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
705: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
706: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
707: payerid_in IN iby_trxn_summaries_all.payerid%type,
708: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
709: subkey_seed_in IN RAW,
710: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
711: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,

Line 710: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

706: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
707: payerid_in IN iby_trxn_summaries_all.payerid%type,
708: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
709: subkey_seed_in IN RAW,
710: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
711: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
712: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
713: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
714: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,

Line 725: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,

721: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
722: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
723: extend_names_in IN JTF_VARCHAR2_TABLE_100,
724: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
725: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
726: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
727: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
728: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
729: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,

Line 726: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,

722: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
723: extend_names_in IN JTF_VARCHAR2_TABLE_100,
724: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
725: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
726: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
727: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
728: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
729: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
730: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,

Line 727: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

723: extend_names_in IN JTF_VARCHAR2_TABLE_100,
724: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
725: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
726: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
727: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
728: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
729: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
730: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,
731: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE

Line 728: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,

724: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
725: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
726: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
727: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
728: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
729: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
730: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,
731: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE
732: )

Line 729: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,

725: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
726: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
727: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
728: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
729: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
730: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,
731: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE
732: )
733: IS

Line 730: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,

726: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
727: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
728: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
729: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
730: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,
731: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE
732: )
733: IS
734:

Line 731: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE

727: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
728: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
729: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
730: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,
731: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE
732: )
733: IS
734:
735: l_num_trxns NUMBER := 0;

Line 738: l_tmid iby_trxn_summaries_all.mtangibleid%type;

734:
735: l_num_trxns NUMBER := 0;
736: l_trxn_mid NUMBER;
737: transaction_id NUMBER;
738: l_tmid iby_trxn_summaries_all.mtangibleid%type;
739: l_order_id iby_trxn_summaries_all.tangibleid%type;
740: l_mpayeeid iby_payee.mpayeeid%type;
741: l_org_id NUMBER;
742: l_target_trxn_type iby_trxn_summaries_all.trxntypeid%TYPE := -1;

Line 739: l_order_id iby_trxn_summaries_all.tangibleid%type;

735: l_num_trxns NUMBER := 0;
736: l_trxn_mid NUMBER;
737: transaction_id NUMBER;
738: l_tmid iby_trxn_summaries_all.mtangibleid%type;
739: l_order_id iby_trxn_summaries_all.tangibleid%type;
740: l_mpayeeid iby_payee.mpayeeid%type;
741: l_org_id NUMBER;
742: l_target_trxn_type iby_trxn_summaries_all.trxntypeid%TYPE := -1;
743: l_instrtype iby_trxn_summaries_all.instrtype%type;

Line 742: l_target_trxn_type iby_trxn_summaries_all.trxntypeid%TYPE := -1;

738: l_tmid iby_trxn_summaries_all.mtangibleid%type;
739: l_order_id iby_trxn_summaries_all.tangibleid%type;
740: l_mpayeeid iby_payee.mpayeeid%type;
741: l_org_id NUMBER;
742: l_target_trxn_type iby_trxn_summaries_all.trxntypeid%TYPE := -1;
743: l_instrtype iby_trxn_summaries_all.instrtype%type;
744: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
745:
746: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;

Line 743: l_instrtype iby_trxn_summaries_all.instrtype%type;

739: l_order_id iby_trxn_summaries_all.tangibleid%type;
740: l_mpayeeid iby_payee.mpayeeid%type;
741: l_org_id NUMBER;
742: l_target_trxn_type iby_trxn_summaries_all.trxntypeid%TYPE := -1;
743: l_instrtype iby_trxn_summaries_all.instrtype%type;
744: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
745:
746: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
747: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;

Line 744: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;

740: l_mpayeeid iby_payee.mpayeeid%type;
741: l_org_id NUMBER;
742: l_target_trxn_type iby_trxn_summaries_all.trxntypeid%TYPE := -1;
743: l_instrtype iby_trxn_summaries_all.instrtype%type;
744: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
745:
746: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
747: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
748: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;

Line 746: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;

742: l_target_trxn_type iby_trxn_summaries_all.trxntypeid%TYPE := -1;
743: l_instrtype iby_trxn_summaries_all.instrtype%type;
744: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
745:
746: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
747: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
748: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
749: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
750: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;

Line 748: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;

744: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
745:
746: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
747: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
748: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
749: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
750: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
751:
752: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;

Line 749: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;

745:
746: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
747: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
748: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
749: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
750: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
751:
752: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
753: l_expirydate iby_trxn_core.instr_expirydate%type;

Line 750: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;

746: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
747: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
748: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
749: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
750: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
751:
752: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
753: l_expirydate iby_trxn_core.instr_expirydate%type;
754:

Line 752: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;

748: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
749: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
750: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
751:
752: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
753: l_expirydate iby_trxn_core.instr_expirydate%type;
754:
755: l_cursor_empty BOOLEAN;
756: l_process_profile_code iby_trxn_summaries_all.process_profile_code%TYPE;

Line 756: l_process_profile_code iby_trxn_summaries_all.process_profile_code%TYPE;

752: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
753: l_expirydate iby_trxn_core.instr_expirydate%type;
754:
755: l_cursor_empty BOOLEAN;
756: l_process_profile_code iby_trxn_summaries_all.process_profile_code%TYPE;
757: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
758: l_pmt_chnl_code iby_trxn_summaries_all.payment_channel_code%TYPE;
759: l_module_name CONSTANT VARCHAR2(200) := 'IBY_TRANSACTIONCC_PKG.insert_other_txn';
760:

Line 757: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;

753: l_expirydate iby_trxn_core.instr_expirydate%type;
754:
755: l_cursor_empty BOOLEAN;
756: l_process_profile_code iby_trxn_summaries_all.process_profile_code%TYPE;
757: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
758: l_pmt_chnl_code iby_trxn_summaries_all.payment_channel_code%TYPE;
759: l_module_name CONSTANT VARCHAR2(200) := 'IBY_TRANSACTIONCC_PKG.insert_other_txn';
760:
761: CURSOR c_followon_info(ci_trxnid iby_trxn_summaries_all.transactionid%TYPE)

Line 758: l_pmt_chnl_code iby_trxn_summaries_all.payment_channel_code%TYPE;

754:
755: l_cursor_empty BOOLEAN;
756: l_process_profile_code iby_trxn_summaries_all.process_profile_code%TYPE;
757: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
758: l_pmt_chnl_code iby_trxn_summaries_all.payment_channel_code%TYPE;
759: l_module_name CONSTANT VARCHAR2(200) := 'IBY_TRANSACTIONCC_PKG.insert_other_txn';
760:
761: CURSOR c_followon_info(ci_trxnid iby_trxn_summaries_all.transactionid%TYPE)
762: IS

Line 761: CURSOR c_followon_info(ci_trxnid iby_trxn_summaries_all.transactionid%TYPE)

757: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
758: l_pmt_chnl_code iby_trxn_summaries_all.payment_channel_code%TYPE;
759: l_module_name CONSTANT VARCHAR2(200) := 'IBY_TRANSACTIONCC_PKG.insert_other_txn';
760:
761: CURSOR c_followon_info(ci_trxnid iby_trxn_summaries_all.transactionid%TYPE)
762: IS
763: SELECT mtangibleid, tangibleid, instrType, instrsubtype,
764: process_profile_code, payer_party_id, payment_channel_code
765: FROM iby_trxn_summaries_all

Line 765: FROM iby_trxn_summaries_all

761: CURSOR c_followon_info(ci_trxnid iby_trxn_summaries_all.transactionid%TYPE)
762: IS
763: SELECT mtangibleid, tangibleid, instrType, instrsubtype,
764: process_profile_code, payer_party_id, payment_channel_code
765: FROM iby_trxn_summaries_all
766: WHERE (transactionid = ci_trxnid)
767: --
768: -- only consider succeeded ones here
769: -- b/c different mtangibleid may get created in case of failed

Line 867: INSERT INTO iby_trxn_summaries_all

863: print_debuginfo(l_module_name, 'payment channel code passed='||payment_channel_code_in);
864: print_debuginfo(l_module_name, 'settledate='||settlement_date_in);
865: print_debuginfo(l_module_name, 'settlement_due_date='||settlement_due_date_in);
866:
867: INSERT INTO iby_trxn_summaries_all
868:
869: (TrxnMID, TransactionID,TrxntypeID, ReqType, ReqDate,
870: Amount,CurrencyNameCode, UpdateDate,Status, PaymentMethodName,
871: TangibleID,MPayeeID, PayeeID,BEPID,bepKey, MtangibleId,

Line 920: FROM iby_trxn_summaries_all

916: -- One previous transaction, so update previous row
917:
918: SELECT TrxnMID,Mtangibleid,transactionid, instrnum_sec_segment_id
919: INTO l_trxn_mid,l_tmid,transaction_id_in_out, l_old_segment_id
920: FROM iby_trxn_summaries_all
921: WHERE TangibleID = order_id_in
922: AND UPPER(ReqType) = UPPER(req_type_in)
923: AND PayeeID = merchant_id_in
924: AND Status IN (9,11);

Line 952: UPDATE iby_trxn_summaries_all

948:
949: END IF;
950:
951:
952: UPDATE iby_trxn_summaries_all
953: SET BEPID = vendor_id_in,
954: bepKey = vendor_key_in,
955: Amount = amount_in,
956: TrxntypeID = trxn_type_in,

Line 1053: UPDATE iby_trxn_summaries_all

1049: l_target_trxn_type := 11;
1050:
1051: END IF;
1052:
1053: UPDATE iby_trxn_summaries_all
1054: SET
1055: -- CHANGE: UPDATE STATUS FOR VOIDED GATEWAY TRXNS
1056: --
1057: -- currently only change the status for processor

Line 1079: (req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,

1075: /* Inserts a row into the iby_transaction table if auth, capture, */
1076: /* return, credit, and void timeout */
1077:
1078: PROCEDURE insert_timeout_txn
1079: (req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
1080: order_id_in IN iby_transactions_v.order_id%TYPE,
1081:
1082: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1083: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

Line 1085: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,

1081:
1082: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1083: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
1084: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
1085: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
1086: time_in IN iby_transactions_v.time%TYPE,
1087:
1088:
1089: status_in IN iby_transactions_v.status%TYPE,

Line 1090: org_id_in IN iby_trxn_summaries_all.org_id%type,

1086: time_in IN iby_transactions_v.time%TYPE,
1087:
1088:
1089: status_in IN iby_transactions_v.status%TYPE,
1090: org_id_in IN iby_trxn_summaries_all.org_id%type,
1091: amount_in IN iby_tangible.amount%type,
1092: currency_in IN iby_tangible.currencynamecode%type,
1093: billeracct_in IN iby_tangible.acctno%type,
1094: refinfo_in IN iby_tangible.refinfo%type,

Line 1098: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

1094: refinfo_in IN iby_tangible.refinfo%type,
1095: memo_in IN iby_tangible.memo%type,
1096: order_medium_in IN iby_tangible.order_medium%TYPE,
1097: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1098: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1099: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
1100: payerid_in IN iby_trxn_summaries_all.payerid%type,
1101: instrtype_in IN iby_trxn_summaries_all.instrType%type,
1102: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

Line 1099: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

1095: memo_in IN iby_tangible.memo%type,
1096: order_medium_in IN iby_tangible.order_medium%TYPE,
1097: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1098: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1099: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
1100: payerid_in IN iby_trxn_summaries_all.payerid%type,
1101: instrtype_in IN iby_trxn_summaries_all.instrType%type,
1102: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
1103: subkey_seed_in IN RAW,

Line 1100: payerid_in IN iby_trxn_summaries_all.payerid%type,

1096: order_medium_in IN iby_tangible.order_medium%TYPE,
1097: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1098: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1099: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
1100: payerid_in IN iby_trxn_summaries_all.payerid%type,
1101: instrtype_in IN iby_trxn_summaries_all.instrType%type,
1102: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
1103: subkey_seed_in IN RAW,
1104: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

Line 1101: instrtype_in IN iby_trxn_summaries_all.instrType%type,

1097: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1098: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1099: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
1100: payerid_in IN iby_trxn_summaries_all.payerid%type,
1101: instrtype_in IN iby_trxn_summaries_all.instrType%type,
1102: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
1103: subkey_seed_in IN RAW,
1104: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
1105: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,

Line 1104: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

1100: payerid_in IN iby_trxn_summaries_all.payerid%type,
1101: instrtype_in IN iby_trxn_summaries_all.instrType%type,
1102: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
1103: subkey_seed_in IN RAW,
1104: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
1105: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1106: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
1107: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
1108: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

Line 1105: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,

1101: instrtype_in IN iby_trxn_summaries_all.instrType%type,
1102: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
1103: subkey_seed_in IN RAW,
1104: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
1105: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1106: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
1107: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
1108: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
1109: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,

Line 1106: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,

1102: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
1103: subkey_seed_in IN RAW,
1104: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
1105: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1106: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
1107: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
1108: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
1109: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1110: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE

Line 1107: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

1103: subkey_seed_in IN RAW,
1104: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
1105: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1106: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
1107: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
1108: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
1109: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1110: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE
1111: )

Line 1108: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

1104: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
1105: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1106: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
1107: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
1108: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
1109: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1110: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE
1111: )
1112:

Line 1109: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,

1105: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1106: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
1107: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
1108: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
1109: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1110: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE
1111: )
1112:
1113: IS

Line 1110: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE

1106: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
1107: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
1108: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
1109: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1110: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE
1111: )
1112:
1113: IS
1114:

Line 1118: l_tmid iby_trxn_summaries_all.mtangibleid%type;

1114:
1115: l_num_trxns NUMBER := 0;
1116: l_trxn_mid NUMBER;
1117: transaction_id NUMBER;
1118: l_tmid iby_trxn_summaries_all.mtangibleid%type;
1119: l_order_id iby_trxn_summaries_all.tangibleid%type;
1120: l_mpayeeid iby_payee.mpayeeid%type;
1121: l_org_id NUMBER;
1122: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;

Line 1119: l_order_id iby_trxn_summaries_all.tangibleid%type;

1115: l_num_trxns NUMBER := 0;
1116: l_trxn_mid NUMBER;
1117: transaction_id NUMBER;
1118: l_tmid iby_trxn_summaries_all.mtangibleid%type;
1119: l_order_id iby_trxn_summaries_all.tangibleid%type;
1120: l_mpayeeid iby_payee.mpayeeid%type;
1121: l_org_id NUMBER;
1122: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
1123:

Line 1122: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;

1118: l_tmid iby_trxn_summaries_all.mtangibleid%type;
1119: l_order_id iby_trxn_summaries_all.tangibleid%type;
1120: l_mpayeeid iby_payee.mpayeeid%type;
1121: l_org_id NUMBER;
1122: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
1123:
1124: l_return_status VARCHAR2(1);
1125: l_msg_count NUMBER;
1126: l_msg_data VARCHAR2(200);

Line 1130: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;

1126: l_msg_data VARCHAR2(200);
1127: l_checksum_valid BOOLEAN := FALSE; -- To check whether the card number is valid.
1128: l_cc_type VARCHAR2(80);
1129:
1130: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
1131: l_subkey_id iby_payee_subkeys.payee_subkey_id%TYPE;
1132:
1133: BEGIN
1134:

Line 1169: FROM iby_trxn_summaries_all

1165: --tangible info should already exist, get them based on
1166: --transactionid
1167: SELECT DISTINCT mtangibleid, tangibleid
1168: INTO l_tmid, l_order_id
1169: FROM iby_trxn_summaries_all
1170: WHERE transactionid = transaction_id_out
1171: --
1172: -- 100 is equivalent to 0
1173: --

Line 1188: INSERT INTO iby_trxn_summaries_all

1184: /*
1185: prepare_instr_data(ecapp_id_in,merchant_id_in,master_key_in,
1186: instrnum_in,subkey_seed_in,FND_API.G_TRUE,l_instrnum,l_subkey_id);
1187: */
1188: INSERT INTO iby_trxn_summaries_all
1189: (TrxnMID, TransactionID, ReqType, ReqDate,
1190: UpdateDate,Status, Amount, CurrencyNameCode,
1191: TangibleID,MPayeeID, PayeeID,BEPID,bepKey, ECAppID,org_id,mtangibleid,
1192: payerinstrid, instrnumber, sub_key_id, payerid, instrType,

Line 1219: FROM iby_trxn_summaries_all

1215: -- One previous transaction, so update previous row
1216: SELECT TrxnMID, TransactionID, MtangibleId
1217: INTO l_trxn_mid, transaction_id_out, l_tmid
1218:
1219: FROM iby_trxn_summaries_all
1220: WHERE TangibleID = order_id_in
1221: AND UPPER(ReqType) = UPPER(req_type_in)
1222: AND PayeeID = merchant_id_in
1223: AND Status IN (9,11);

Line 1236: UPDATE iby_trxn_summaries_all

1232: order_medium_in, eft_auth_method_in);
1233:
1234: END IF;
1235:
1236: UPDATE iby_trxn_summaries_all
1237: SET UpdateDate = time_in,
1238: Status = status_in,
1239: BEPID = vendor_id_in,
1240: bepKey = vendor_key_in,

Line 1297: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

1293: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1294: error_location_in IN iby_batches_all.errorlocation%TYPE,
1295: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1296: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1297: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1298: req_type_in IN iby_batches_all.reqtype%TYPE,
1299: sec_key_present_in IN VARCHAR2,
1300: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type
1301: )

Line 1330: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown

1326: --
1327: -- need to lock trxn summaries table to ensure that
1328: -- trxns which have not been validated do not sneak into
1329: -- the batch; gap between call to validate_open_batch
1330: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
1331: -- to be vulnerable to race conditions even under moderate
1332: -- concurrency loads
1333: --
1334: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

Line 1334: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

1330: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
1331: -- to be vulnerable to race conditions even under moderate
1332: -- concurrency loads
1333: --
1334: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;
1335:
1336: SELECT iby_batches_s.NEXTVAL
1337: INTO l_mbatchid
1338: FROM dual;

Line 1362: UPDATE iby_trxn_summaries_all

1358: --
1359: -- associate all trxns in the current open batch
1360: -- with the bathc id of the batch close
1361: --
1362: UPDATE iby_trxn_summaries_all
1363: SET
1364: status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING,
1365: batchid = merch_batchid_in,
1366: mbatchid = l_mbatchid,

Line 1529: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

1525: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1526: error_location_in IN iby_batches_all.errorlocation%TYPE,
1527: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1528: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1529: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1530: req_type_in IN iby_batches_all.reqtype%TYPE,
1531: sec_key_present_in IN VARCHAR2,
1532: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
1533: instr_type_in IN iby_batches_all.instrument_type%TYPE,

Line 1535: f_pmt_channel_in IN iby_trxn_summaries_all.

1531: sec_key_present_in IN VARCHAR2,
1532: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
1533: instr_type_in IN iby_batches_all.instrument_type%TYPE,
1534: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
1535: f_pmt_channel_in IN iby_trxn_summaries_all.
1536: payment_channel_code%TYPE,
1537: f_curr_in IN iby_trxn_summaries_all.
1538: currencynamecode%TYPE,
1539: f_settle_date IN iby_trxn_summaries_all.

Line 1537: f_curr_in IN iby_trxn_summaries_all.

1533: instr_type_in IN iby_batches_all.instrument_type%TYPE,
1534: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
1535: f_pmt_channel_in IN iby_trxn_summaries_all.
1536: payment_channel_code%TYPE,
1537: f_curr_in IN iby_trxn_summaries_all.
1538: currencynamecode%TYPE,
1539: f_settle_date IN iby_trxn_summaries_all.
1540: settledate%TYPE,
1541: f_due_date IN iby_trxn_summaries_all.

Line 1539: f_settle_date IN iby_trxn_summaries_all.

1535: f_pmt_channel_in IN iby_trxn_summaries_all.
1536: payment_channel_code%TYPE,
1537: f_curr_in IN iby_trxn_summaries_all.
1538: currencynamecode%TYPE,
1539: f_settle_date IN iby_trxn_summaries_all.
1540: settledate%TYPE,
1541: f_due_date IN iby_trxn_summaries_all.
1542: settlement_due_date%TYPE,
1543: f_maturity_date IN iby_trxn_summaries_all.

Line 1541: f_due_date IN iby_trxn_summaries_all.

1537: f_curr_in IN iby_trxn_summaries_all.
1538: currencynamecode%TYPE,
1539: f_settle_date IN iby_trxn_summaries_all.
1540: settledate%TYPE,
1541: f_due_date IN iby_trxn_summaries_all.
1542: settlement_due_date%TYPE,
1543: f_maturity_date IN iby_trxn_summaries_all.
1544: br_maturity_date%TYPE,
1545: f_instr_type IN iby_trxn_summaries_all.

Line 1543: f_maturity_date IN iby_trxn_summaries_all.

1539: f_settle_date IN iby_trxn_summaries_all.
1540: settledate%TYPE,
1541: f_due_date IN iby_trxn_summaries_all.
1542: settlement_due_date%TYPE,
1543: f_maturity_date IN iby_trxn_summaries_all.
1544: br_maturity_date%TYPE,
1545: f_instr_type IN iby_trxn_summaries_all.
1546: instrtype%TYPE,
1547: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,

Line 1545: f_instr_type IN iby_trxn_summaries_all.

1541: f_due_date IN iby_trxn_summaries_all.
1542: settlement_due_date%TYPE,
1543: f_maturity_date IN iby_trxn_summaries_all.
1544: br_maturity_date%TYPE,
1545: f_instr_type IN iby_trxn_summaries_all.
1546: instrtype%TYPE,
1547: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
1548: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
1549: )

Line 1621: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown

1617: --
1618: -- need to lock trxn summaries table to ensure that
1619: -- trxns which have not been validated do not sneak into
1620: -- the batch; gap between call to validate_open_batch
1621: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
1622: -- to be vulnerable to race conditions even under moderate
1623: -- concurrency loads
1624: --
1625: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

Line 1625: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

1621: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
1622: -- to be vulnerable to race conditions even under moderate
1623: -- concurrency loads
1624: --
1625: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;
1626:
1627: --SELECT iby_batches_s.NEXTVAL
1628: -- INTO l_mbatchid
1629: --FROM dual;

Line 1776: IBY_TRXN_SUMMARIES_ALL

1772: * here for documentation purposes.
1773: */
1774: /*------------------------------------------
1775: UPDATE
1776: IBY_TRXN_SUMMARIES_ALL
1777: SET
1778: status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING,
1779: batchid = merch_batchid_in
1780: || '_' || i,

Line 1814: IBY_TRXN_SUMMARIES_ALL

1810: print_debuginfo(l_module_name, 'Going to update '
1811: || 'transaction ' || l_trxns_in_batch_tab(i).trxn_id);
1812:
1813: UPDATE
1814: IBY_TRXN_SUMMARIES_ALL
1815: SET
1816: status = iby_transactioncc_pkg.
1817: C_STATUS_BATCH_PENDING,
1818: batchid = l_trxns_in_batch_tab(i).

Line 2140: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

2136: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2137: error_location_in IN iby_batches_all.errorlocation%TYPE,
2138: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2139: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2140: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2141: req_type_in IN iby_batches_all.reqtype%TYPE,
2142: sec_key_present_in IN VARCHAR2,
2143: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
2144: instr_type_in IN iby_batches_all.instrument_type%TYPE,

Line 2146: f_pmt_channel_in IN iby_trxn_summaries_all.

2142: sec_key_present_in IN VARCHAR2,
2143: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
2144: instr_type_in IN iby_batches_all.instrument_type%TYPE,
2145: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
2146: f_pmt_channel_in IN iby_trxn_summaries_all.
2147: payment_channel_code%TYPE,
2148: f_curr_in IN iby_trxn_summaries_all.
2149: currencynamecode%TYPE,
2150: f_settle_date IN iby_trxn_summaries_all.

Line 2148: f_curr_in IN iby_trxn_summaries_all.

2144: instr_type_in IN iby_batches_all.instrument_type%TYPE,
2145: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
2146: f_pmt_channel_in IN iby_trxn_summaries_all.
2147: payment_channel_code%TYPE,
2148: f_curr_in IN iby_trxn_summaries_all.
2149: currencynamecode%TYPE,
2150: f_settle_date IN iby_trxn_summaries_all.
2151: settledate%TYPE,
2152: f_due_date IN iby_trxn_summaries_all.

Line 2150: f_settle_date IN iby_trxn_summaries_all.

2146: f_pmt_channel_in IN iby_trxn_summaries_all.
2147: payment_channel_code%TYPE,
2148: f_curr_in IN iby_trxn_summaries_all.
2149: currencynamecode%TYPE,
2150: f_settle_date IN iby_trxn_summaries_all.
2151: settledate%TYPE,
2152: f_due_date IN iby_trxn_summaries_all.
2153: settlement_due_date%TYPE,
2154: f_maturity_date IN iby_trxn_summaries_all.

Line 2152: f_due_date IN iby_trxn_summaries_all.

2148: f_curr_in IN iby_trxn_summaries_all.
2149: currencynamecode%TYPE,
2150: f_settle_date IN iby_trxn_summaries_all.
2151: settledate%TYPE,
2152: f_due_date IN iby_trxn_summaries_all.
2153: settlement_due_date%TYPE,
2154: f_maturity_date IN iby_trxn_summaries_all.
2155: br_maturity_date%TYPE,
2156: f_instr_type IN iby_trxn_summaries_all.

Line 2154: f_maturity_date IN iby_trxn_summaries_all.

2150: f_settle_date IN iby_trxn_summaries_all.
2151: settledate%TYPE,
2152: f_due_date IN iby_trxn_summaries_all.
2153: settlement_due_date%TYPE,
2154: f_maturity_date IN iby_trxn_summaries_all.
2155: br_maturity_date%TYPE,
2156: f_instr_type IN iby_trxn_summaries_all.
2157: instrtype%TYPE,
2158: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,

Line 2156: f_instr_type IN iby_trxn_summaries_all.

2152: f_due_date IN iby_trxn_summaries_all.
2153: settlement_due_date%TYPE,
2154: f_maturity_date IN iby_trxn_summaries_all.
2155: br_maturity_date%TYPE,
2156: f_instr_type IN iby_trxn_summaries_all.
2157: instrtype%TYPE,
2158: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
2159: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
2160: )

Line 2261: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown

2257: --
2258: -- need to lock trxn summaries table to ensure that
2259: -- trxns which have not been validated do not sneak into
2260: -- the batch; gap between call to validate_open_batch
2261: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
2262: -- to be vulnerable to race conditions even under moderate
2263: -- concurrency loads
2264: --
2265: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

Line 2265: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

2261: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
2262: -- to be vulnerable to race conditions even under moderate
2263: -- concurrency loads
2264: --
2265: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;
2266:
2267: --SELECT iby_batches_s.NEXTVAL
2268: -- INTO l_mbatchid
2269: --FROM dual;

Line 2417: IBY_TRXN_SUMMARIES_ALL

2413: * here for documentation purposes.
2414: */
2415: /*------------------------------------------
2416: UPDATE
2417: IBY_TRXN_SUMMARIES_ALL
2418: SET
2419: status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING,
2420: batchid = merch_batchid_in
2421: || '_' || i,

Line 2455: IBY_TRXN_SUMMARIES_ALL

2451: print_debuginfo(l_module_name, 'Going to update '
2452: || 'transaction ' || l_trxns_in_batch_tab(i).trxn_id);
2453:
2454: UPDATE
2455: IBY_TRXN_SUMMARIES_ALL
2456: SET
2457: status = iby_transactioncc_pkg.
2458: C_STATUS_BATCH_PENDING,
2459: batchid = l_trxns_in_batch_tab(i).

Line 2764: instr_type IN IBY_TRXN_SUMMARIES_ALL.

2760: *---------------------------------------------------------------------*/
2761: PROCEDURE performTransactionGrouping(
2762: p_profile_code IN IBY_FNDCPT_USER_CC_PF_B.
2763: user_cc_profile_code%TYPE,
2764: instr_type IN IBY_TRXN_SUMMARIES_ALL.
2765: instrtype%TYPE,
2766: req_type IN IBY_BATCHES_ALL.
2767: reqtype%TYPE,
2768: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.

Line 2768: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.

2764: instr_type IN IBY_TRXN_SUMMARIES_ALL.
2765: instrtype%TYPE,
2766: req_type IN IBY_BATCHES_ALL.
2767: reqtype%TYPE,
2768: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
2769: payment_channel_code%TYPE,
2770: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
2771: currencynamecode%TYPE,
2772: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.

Line 2770: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

2766: req_type IN IBY_BATCHES_ALL.
2767: reqtype%TYPE,
2768: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
2769: payment_channel_code%TYPE,
2770: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
2771: currencynamecode%TYPE,
2772: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
2773: settledate%TYPE,
2774: f_due_date IN IBY_TRXN_SUMMARIES_ALL.

Line 2772: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.

2768: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
2769: payment_channel_code%TYPE,
2770: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
2771: currencynamecode%TYPE,
2772: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
2773: settledate%TYPE,
2774: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
2775: settlement_due_date%TYPE,
2776: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.

Line 2774: f_due_date IN IBY_TRXN_SUMMARIES_ALL.

2770: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
2771: currencynamecode%TYPE,
2772: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
2773: settledate%TYPE,
2774: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
2775: settlement_due_date%TYPE,
2776: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
2777: br_maturity_date%TYPE,
2778: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.

Line 2776: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.

2772: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
2773: settledate%TYPE,
2774: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
2775: settlement_due_date%TYPE,
2776: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
2777: br_maturity_date%TYPE,
2778: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
2779: instrtype%TYPE,
2780: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

Line 2778: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.

2774: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
2775: settlement_due_date%TYPE,
2776: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
2777: br_maturity_date%TYPE,
2778: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
2779: instrtype%TYPE,
2780: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
2781: batchAttrTabType,
2782: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

Line 2846: * used to update the rows in IBY_TRXN_SUMMARIES_ALL table with

2842: *
2843: * A separate data structure is needed to keep track of the transactions
2844: * that are part of a batch. This information is tracked in the
2845: * trxnsInBatchTabType table. The rows in trxnsInBatchTabType are
2846: * used to update the rows in IBY_TRXN_SUMMARIES_ALL table with
2847: * batch ids.
2848: *
2849: * l_batchTab l_trxnsInBatchTab
2850: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)

Line 2850: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)

2846: * used to update the rows in IBY_TRXN_SUMMARIES_ALL table with
2847: * batch ids.
2848: *
2849: * l_batchTab l_trxnsInBatchTab
2850: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)
2851: * /-------------------------------------\ /------------\
2852: * |MBatch |Profile|..|Curr |Org |..| |MBatch |Trx |
2853: * |Id |Code |..|Code |Id |..| |Id |Id |
2854: * | | |..| | |..| | | |

Line 2883: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;

2879: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
2880: l_bankaccount CONSTANT VARCHAR2(100) :='BANKACCOUNT';
2881:
2882: /* previous transaction attributes */
2883: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
2884: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2885: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2886: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2887: prev_org_id iby_trxn_summaries_all.org_id%TYPE;

Line 2884: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;

2880: l_bankaccount CONSTANT VARCHAR2(100) :='BANKACCOUNT';
2881:
2882: /* previous transaction attributes */
2883: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
2884: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2885: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2886: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2887: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
2888: prev_org_type iby_trxn_summaries_all.org_type%TYPE;

Line 2885: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;

2881:
2882: /* previous transaction attributes */
2883: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
2884: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2885: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2886: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2887: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
2888: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
2889: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;

Line 2886: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;

2882: /* previous transaction attributes */
2883: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
2884: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2885: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2886: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2887: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
2888: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
2889: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
2890: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;

Line 2887: prev_org_id iby_trxn_summaries_all.org_id%TYPE;

2883: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
2884: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2885: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2886: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2887: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
2888: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
2889: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
2890: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2891: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;

Line 2888: prev_org_type iby_trxn_summaries_all.org_type%TYPE;

2884: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2885: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2886: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2887: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
2888: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
2889: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
2890: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2891: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
2892: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;

Line 2889: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;

2885: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2886: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2887: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
2888: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
2889: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
2890: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2891: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
2892: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
2893:

Line 2890: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;

2886: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2887: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
2888: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
2889: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
2890: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2891: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
2892: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
2893:
2894: /* current transaction attributes */

Line 2891: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;

2887: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
2888: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
2889: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
2890: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2891: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
2892: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
2893:
2894: /* current transaction attributes */
2895: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;

Line 2892: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;

2888: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
2889: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
2890: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2891: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
2892: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
2893:
2894: /* current transaction attributes */
2895: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
2896: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;

Line 2895: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;

2891: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
2892: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
2893:
2894: /* current transaction attributes */
2895: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
2896: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2897: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2898: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2899: curr_org_id iby_trxn_summaries_all.org_id%TYPE;

Line 2896: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;

2892: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
2893:
2894: /* current transaction attributes */
2895: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
2896: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2897: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2898: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2899: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
2900: curr_org_type iby_trxn_summaries_all.org_type%TYPE;

Line 2897: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;

2893:
2894: /* current transaction attributes */
2895: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
2896: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2897: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2898: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2899: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
2900: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
2901: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;

Line 2898: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;

2894: /* current transaction attributes */
2895: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
2896: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2897: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2898: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2899: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
2900: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
2901: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
2902: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;

Line 2899: curr_org_id iby_trxn_summaries_all.org_id%TYPE;

2895: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
2896: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2897: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2898: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2899: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
2900: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
2901: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
2902: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2903: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;

Line 2900: curr_org_type iby_trxn_summaries_all.org_type%TYPE;

2896: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
2897: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2898: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2899: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
2900: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
2901: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
2902: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2903: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;
2904: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;

Line 2901: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;

2897: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
2898: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2899: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
2900: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
2901: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
2902: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2903: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;
2904: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
2905: l_user_pf_table_name VARCHAR2(100);

Line 2902: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;

2898: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
2899: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
2900: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
2901: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
2902: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2903: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;
2904: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
2905: l_user_pf_table_name VARCHAR2(100);
2906: l_sys_pf_table_name VARCHAR2(100);

Line 2903: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;

2899: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
2900: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
2901: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
2902: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2903: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;
2904: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
2905: l_user_pf_table_name VARCHAR2(100);
2906: l_sys_pf_table_name VARCHAR2(100);
2907: l_user_pf_column_name VARCHAR2(100);

Line 2904: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;

2900: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
2901: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
2902: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
2903: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;
2904: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
2905: l_user_pf_table_name VARCHAR2(100);
2906: l_sys_pf_table_name VARCHAR2(100);
2907: l_user_pf_column_name VARCHAR2(100);
2908: l_sys_pf_column_name VARCHAR2(100);

Line 2958: IBY_TRXN_SUMMARIES_ALL txn,

2954: sys_prof.limit_by_exch_rate_type,
2955: sys_prof.limit_by_total_amt,
2956: sys_prof.limit_by_settlement_num
2957: FROM
2958: IBY_TRXN_SUMMARIES_ALL txn,
2959: IBY_FNDCPT_USER_CC_PF_B user_prof,
2960: IBY_FNDCPT_SYS_CC_PF_B sys_prof
2961: WHERE
2962: user_prof.user_cc_profile_code = p_profile_code AND

Line 3288: || 'IBY_TRXN_SUMMARIES_ALL txn, '

3284: || 'sys_prof.limit_by_exch_rate_type, '
3285: || 'sys_prof.limit_by_total_amt, '
3286: || 'sys_prof.limit_by_settlement_num '
3287: || 'FROM '
3288: || 'IBY_TRXN_SUMMARIES_ALL txn, '
3289: || l_user_pf_table_name || ' user_prof, '
3290: || l_sys_pf_table_name || ' sys_prof '
3291: || 'WHERE '
3292: || 'user_prof.'||l_user_pf_column_name||' = :profile_code AND '

Line 3879: instr_type IN IBY_TRXN_SUMMARIES_ALL.

3875: |
3876: *---------------------------------------------------------------------*/
3877: PROCEDURE performTransactionGrouping(
3878: profile_code_array IN JTF_VARCHAR2_TABLE_100,
3879: instr_type IN IBY_TRXN_SUMMARIES_ALL.
3880: instrtype%TYPE,
3881: req_type IN IBY_BATCHES_ALL.
3882: reqtype%TYPE,
3883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.

Line 3883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.

3879: instr_type IN IBY_TRXN_SUMMARIES_ALL.
3880: instrtype%TYPE,
3881: req_type IN IBY_BATCHES_ALL.
3882: reqtype%TYPE,
3883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
3884: payment_channel_code%TYPE,
3885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
3886: currencynamecode%TYPE,
3887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.

Line 3885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

3881: req_type IN IBY_BATCHES_ALL.
3882: reqtype%TYPE,
3883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
3884: payment_channel_code%TYPE,
3885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
3886: currencynamecode%TYPE,
3887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
3888: settledate%TYPE,
3889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.

Line 3887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.

3883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
3884: payment_channel_code%TYPE,
3885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
3886: currencynamecode%TYPE,
3887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
3888: settledate%TYPE,
3889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
3890: settlement_due_date%TYPE,
3891: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.

Line 3889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.

3885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
3886: currencynamecode%TYPE,
3887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
3888: settledate%TYPE,
3889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
3890: settlement_due_date%TYPE,
3891: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
3892: br_maturity_date%TYPE,
3893: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.

Line 3891: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.

3887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
3888: settledate%TYPE,
3889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
3890: settlement_due_date%TYPE,
3891: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
3892: br_maturity_date%TYPE,
3893: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
3894: instrtype%TYPE,
3895: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

Line 3893: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.

3889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
3890: settlement_due_date%TYPE,
3891: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
3892: br_maturity_date%TYPE,
3893: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
3894: instrtype%TYPE,
3895: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
3896: batchAttrTabType,
3897: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

Line 3961: * used to update the rows in IBY_TRXN_SUMMARIES_ALL table with

3957: *
3958: * A separate data structure is needed to keep track of the transactions
3959: * that are part of a batch. This information is tracked in the
3960: * trxnsInBatchTabType table. The rows in trxnsInBatchTabType are
3961: * used to update the rows in IBY_TRXN_SUMMARIES_ALL table with
3962: * batch ids.
3963: *
3964: * l_batchTab l_trxnsInBatchTab
3965: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)

Line 3965: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)

3961: * used to update the rows in IBY_TRXN_SUMMARIES_ALL table with
3962: * batch ids.
3963: *
3964: * l_batchTab l_trxnsInBatchTab
3965: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)
3966: * /-------------------------------------\ /------------\
3967: * |MBatch |Profile|..|Curr |Org |..| |MBatch |Trx |
3968: * |Id |Code |..|Code |Id |..| |Id |Id |
3969: * | | |..| | |..| | | |

Line 3998: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;

3994: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
3995: l_bankaccount CONSTANT VARCHAR2(100) :='BANKACCOUNT';
3996:
3997: /* previous transaction attributes */
3998: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
3999: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4000: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4001: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4002: prev_org_id iby_trxn_summaries_all.org_id%TYPE;

Line 3999: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;

3995: l_bankaccount CONSTANT VARCHAR2(100) :='BANKACCOUNT';
3996:
3997: /* previous transaction attributes */
3998: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
3999: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4000: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4001: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4002: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
4003: prev_org_type iby_trxn_summaries_all.org_type%TYPE;

Line 4000: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;

3996:
3997: /* previous transaction attributes */
3998: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
3999: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4000: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4001: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4002: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
4003: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
4004: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;

Line 4001: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;

3997: /* previous transaction attributes */
3998: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
3999: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4000: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4001: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4002: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
4003: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
4004: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
4005: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;

Line 4002: prev_org_id iby_trxn_summaries_all.org_id%TYPE;

3998: prev_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
3999: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4000: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4001: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4002: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
4003: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
4004: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
4005: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4006: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;

Line 4003: prev_org_type iby_trxn_summaries_all.org_type%TYPE;

3999: prev_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4000: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4001: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4002: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
4003: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
4004: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
4005: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4006: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
4007: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;

Line 4004: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;

4000: prev_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4001: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4002: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
4003: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
4004: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
4005: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4006: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
4007: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
4008:

Line 4005: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;

4001: prev_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4002: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
4003: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
4004: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
4005: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4006: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
4007: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
4008:
4009: /* current transaction attributes */

Line 4006: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;

4002: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
4003: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
4004: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
4005: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4006: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
4007: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
4008:
4009: /* current transaction attributes */
4010: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;

Line 4007: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;

4003: prev_org_type iby_trxn_summaries_all.org_type%TYPE;
4004: prev_settle_date iby_trxn_summaries_all.settledate%TYPE;
4005: prev_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4006: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
4007: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
4008:
4009: /* current transaction attributes */
4010: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
4011: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;

Line 4010: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;

4006: prev_bep_key iby_trxn_summaries_all.bepkey%TYPE;
4007: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
4008:
4009: /* current transaction attributes */
4010: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
4011: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4012: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4013: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4014: curr_org_id iby_trxn_summaries_all.org_id%TYPE;

Line 4011: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;

4007: prev_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
4008:
4009: /* current transaction attributes */
4010: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
4011: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4012: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4013: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4014: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
4015: curr_org_type iby_trxn_summaries_all.org_type%TYPE;

Line 4012: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;

4008:
4009: /* current transaction attributes */
4010: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
4011: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4012: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4013: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4014: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
4015: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
4016: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;

Line 4013: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;

4009: /* current transaction attributes */
4010: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
4011: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4012: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4013: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4014: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
4015: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
4016: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
4017: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;

Line 4014: curr_org_id iby_trxn_summaries_all.org_id%TYPE;

4010: curr_trxn_id iby_trxn_summaries_all.transactionid%TYPE;
4011: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4012: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4013: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4014: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
4015: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
4016: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
4017: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4018: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;

Line 4015: curr_org_type iby_trxn_summaries_all.org_type%TYPE;

4011: curr_trxn_currency iby_trxn_summaries_all.currencynamecode%TYPE;
4012: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4013: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4014: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
4015: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
4016: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
4017: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4018: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;
4019: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;

Line 4016: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;

4012: curr_trxn_amount iby_trxn_summaries_all.amount%TYPE;
4013: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4014: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
4015: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
4016: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
4017: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4018: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;
4019: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
4020: l_user_pf_table_name VARCHAR2(100);

Line 4017: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;

4013: curr_int_bank_acct_id iby_trxn_summaries_all.payeeinstrid%TYPE;
4014: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
4015: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
4016: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
4017: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4018: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;
4019: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
4020: l_user_pf_table_name VARCHAR2(100);
4021: l_sys_pf_table_name VARCHAR2(100);

Line 4018: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;

4014: curr_org_id iby_trxn_summaries_all.org_id%TYPE;
4015: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
4016: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
4017: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4018: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;
4019: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
4020: l_user_pf_table_name VARCHAR2(100);
4021: l_sys_pf_table_name VARCHAR2(100);
4022: l_user_pf_column_name VARCHAR2(100);

Line 4019: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;

4015: curr_org_type iby_trxn_summaries_all.org_type%TYPE;
4016: curr_settle_date iby_trxn_summaries_all.settledate%TYPE;
4017: curr_le_id iby_trxn_summaries_all.legal_entity_id%TYPE;
4018: curr_bep_key iby_trxn_summaries_all.bepkey%TYPE;
4019: curr_profile_cd iby_trxn_summaries_all.process_profile_code%TYPE;
4020: l_user_pf_table_name VARCHAR2(100);
4021: l_sys_pf_table_name VARCHAR2(100);
4022: l_user_pf_column_name VARCHAR2(100);
4023: l_sys_pf_column_name VARCHAR2(100);

Line 4076: IBY_TRXN_SUMMARIES_ALL txn,

4072: sys_prof.limit_by_exch_rate_type,
4073: sys_prof.limit_by_total_amt,
4074: sys_prof.limit_by_settlement_num
4075: FROM
4076: IBY_TRXN_SUMMARIES_ALL txn,
4077: IBY_FNDCPT_USER_CC_PF_B user_prof,
4078: IBY_FNDCPT_SYS_CC_PF_B sys_prof
4079: WHERE
4080: user_prof.user_cc_profile_code IN (strProfiles) AND

Line 4417: || 'IBY_TRXN_SUMMARIES_ALL txn, '

4413: || 'sys_prof.limit_by_exch_rate_type, '
4414: || 'sys_prof.limit_by_total_amt, '
4415: || 'sys_prof.limit_by_settlement_num '
4416: || 'FROM '
4417: || 'IBY_TRXN_SUMMARIES_ALL txn, '
4418: || l_user_pf_table_name || ' user_prof, '
4419: || l_sys_pf_table_name || ' sys_prof '
4420: || 'WHERE '
4421: || 'user_prof.'||l_user_pf_column_name||' IN ('||strProfCodes||') AND '

Line 5361: UPDATE iby_trxn_summaries_all

5357: open c_getNumTrxns(trxn_type_in);
5358:
5359: FETCH c_getNumTrxns INTO l_numrows;
5360: /* IF (l_numrows > 0 AND l_needupdate) THEN
5361: UPDATE iby_trxn_summaries_all
5362: SET trxntypeid = trxn_type_in
5363: WHERE tangibleid = order_id_in
5364: AND payeeid = merchant_id_in
5365: AND bepid = vendor_id_in

Line 5380: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,

5376:
5377: /* Inserts the transaction record for the closebatch operation */
5378:
5379: PROCEDURE insert_batch_txn
5380: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
5381:
5382: order_id_in IN iby_transactions_v.order_id%TYPE,
5383: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5384: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,

Line 5395: org_id_in IN iby_trxn_summaries_all.org_id%type,

5391: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5392: error_location_in IN iby_transactions_v.error_location%TYPE,
5393:
5394: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
5395: org_id_in IN iby_trxn_summaries_all.org_id%type,
5396: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE)
5397:
5398: IS
5399:

Line 5396: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE)

5392: error_location_in IN iby_transactions_v.error_location%TYPE,
5393:
5394: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
5395: org_id_in IN iby_trxn_summaries_all.org_id%type,
5396: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE)
5397:
5398: IS
5399:
5400: num_rows NUMBER;

Line 5409: l_reqtype iby_trxn_summaries_all.reqtype%type;

5405: l_mbatchid iby_batches_all.mbatchid%type;
5406: l_mtangibleid iby_tangible.mtangibleid%type;
5407:
5408: l_prev_trxn_count number;
5409: l_reqtype iby_trxn_summaries_all.reqtype%type;
5410: l_instrtype iby_trxn_summaries_all.instrtype%type;
5411: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
5412: BEGIN
5413:

Line 5410: l_instrtype iby_trxn_summaries_all.instrtype%type;

5406: l_mtangibleid iby_tangible.mtangibleid%type;
5407:
5408: l_prev_trxn_count number;
5409: l_reqtype iby_trxn_summaries_all.reqtype%type;
5410: l_instrtype iby_trxn_summaries_all.instrtype%type;
5411: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
5412: BEGIN
5413:
5414: -- Update the existing row for this order id with merchant batch id

Line 5411: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;

5407:
5408: l_prev_trxn_count number;
5409: l_reqtype iby_trxn_summaries_all.reqtype%type;
5410: l_instrtype iby_trxn_summaries_all.instrtype%type;
5411: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
5412: BEGIN
5413:
5414: -- Update the existing row for this order id with merchant batch id
5415: -- Only the transaction types auth,authcapture,return,capture,markcapture

Line 5424: UPDATE iby_trxn_summaries_all

5420: IF (trxn_type_in = 8 OR trxn_type_in = 9) THEN
5421: l_reqtype := 'ORAPMTCAPTURE';
5422: --dbms_output.put_line('position 1');
5423: getMBatchId(merch_batchid_in, merchant_id_in, l_mbatchid);
5424: UPDATE iby_trxn_summaries_all
5425: SET BatchID = merch_batchid_in,
5426: MBatchID = l_mbatchid,
5427: last_update_date=sysdate,
5428: updatedate = sysdate,

Line 5445: UPDATE iby_trxn_summaries_all

5441: l_reqtype := 'ORAPMTRETURN';
5442: --dbms_output.put_line('position 2');
5443: getMBatchId(merch_batchid_in, merchant_id_in, l_mbatchid);
5444:
5445: UPDATE iby_trxn_summaries_all
5446:
5447: SET BatchID = merch_batchid_in,
5448: MBatchID = l_mbatchid,
5449: last_update_date=sysdate,

Line 5473: FROM iby_trxn_summaries_all

5469: -- Now insert a new row for this transaction in the batch
5470: -- Get the transaction id first
5471: SELECT count(*)
5472: INTO l_prev_trxn_count
5473: FROM iby_trxn_summaries_all
5474: WHERE tangibleid = order_id_in AND
5475: payeeid = merchant_id_in;
5476:
5477: IF (l_prev_trxn_count = 0) THEN

Line 5486: FROM iby_trxn_summaries_all

5482: l_mtangibleid := -1;
5483: ELSE
5484: SELECT DISTINCT transactionid, mtangibleid, instrtype, instrsubtype
5485: INTO transaction_id_out, l_mtangibleid, l_instrtype, l_instrsubtype
5486: FROM iby_trxn_summaries_all
5487: WHERE tangibleid = order_id_in AND
5488: payeeid = merchant_id_in
5489: AND status = 0;
5490: END IF;

Line 5518: INSERT INTO iby_trxn_summaries_all

5514: -- (not through iPayment)
5515: -- 3) during testing, requests submitted to Cybercash regular
5516: -- and Cybercash SSL are considered different, but during close
5517: -- batch, they are mixed.
5518: INSERT INTO iby_trxn_summaries_all
5519: (TrxnMID, TransactionID,TangibleID,MPayeeID, PayeeID,BEPID, bepKey,
5520: ECAppID,org_id, Status, UpdateDate,TrxnTypeID, MBatchID, BatchID,
5521: BEPCode,BEPMessage,Errorlocation,
5522: ReqType, ReqDate, mtangibleid,

Line 5540: FROM iby_trxn_summaries_all

5536:
5537: -- retrieve existing tid out
5538: SELECT distinct(transactionid)
5539: INTO transaction_id_out
5540: FROM iby_trxn_summaries_all
5541: WHERE tangibleid = order_id_in
5542: AND payeeid = merchant_id_in
5543: AND bepid = vendor_id_in
5544: AND trxntypeid = trxn_type_in

Line 5556: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,

5552:
5553: /* Inserts transaction record for transaction query operation */
5554:
5555: PROCEDURE insert_query_txn
5556: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
5557: order_id_in IN iby_transactions_v.order_id%TYPE,
5558: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5559: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5560: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

Line 5576: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

5572: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
5573: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
5574: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
5575: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
5576: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
5577: ecappid_in IN iby_ecapp.ecappid%type,
5578: req_type_in IN iby_trxn_summaries_all.reqtype%type)
5579: IS
5580:

Line 5578: req_type_in IN iby_trxn_summaries_all.reqtype%type)

5574: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
5575: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
5576: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
5577: ecappid_in IN iby_ecapp.ecappid%type,
5578: req_type_in IN iby_trxn_summaries_all.reqtype%type)
5579: IS
5580:
5581: num_rows NUMBER;
5582: l_trxn_mid NUMBER;

Line 5584: l_mtangibleid iby_trxn_summaries_all.mtangibleid%type;

5580:
5581: num_rows NUMBER;
5582: l_trxn_mid NUMBER;
5583: l_mpayeeid iby_payee.mpayeeid%type;
5584: l_mtangibleid iby_trxn_summaries_all.mtangibleid%type;
5585: l_cnt number;
5586: l_instrtype iby_trxn_summaries_all.instrtype%type;
5587: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
5588: l_trxnref iby_trxn_summaries_all.trxnref%type;

Line 5586: l_instrtype iby_trxn_summaries_all.instrtype%type;

5582: l_trxn_mid NUMBER;
5583: l_mpayeeid iby_payee.mpayeeid%type;
5584: l_mtangibleid iby_trxn_summaries_all.mtangibleid%type;
5585: l_cnt number;
5586: l_instrtype iby_trxn_summaries_all.instrtype%type;
5587: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
5588: l_trxnref iby_trxn_summaries_all.trxnref%type;
5589:
5590: CURSOR c_trxnmid(

Line 5587: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;

5583: l_mpayeeid iby_payee.mpayeeid%type;
5584: l_mtangibleid iby_trxn_summaries_all.mtangibleid%type;
5585: l_cnt number;
5586: l_instrtype iby_trxn_summaries_all.instrtype%type;
5587: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
5588: l_trxnref iby_trxn_summaries_all.trxnref%type;
5589:
5590: CURSOR c_trxnmid(
5591: ci_trxnid iby_trxn_summaries_all.TransactionID%TYPE,

Line 5588: l_trxnref iby_trxn_summaries_all.trxnref%type;

5584: l_mtangibleid iby_trxn_summaries_all.mtangibleid%type;
5585: l_cnt number;
5586: l_instrtype iby_trxn_summaries_all.instrtype%type;
5587: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
5588: l_trxnref iby_trxn_summaries_all.trxnref%type;
5589:
5590: CURSOR c_trxnmid(
5591: ci_trxnid iby_trxn_summaries_all.TransactionID%TYPE,
5592: ci_merchid iby_trxn_summaries_all.PayeeId%TYPE,

Line 5591: ci_trxnid iby_trxn_summaries_all.TransactionID%TYPE,

5587: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
5588: l_trxnref iby_trxn_summaries_all.trxnref%type;
5589:
5590: CURSOR c_trxnmid(
5591: ci_trxnid iby_trxn_summaries_all.TransactionID%TYPE,
5592: ci_merchid iby_trxn_summaries_all.PayeeId%TYPE,
5593: --ci_trxntype iby_trxn_summaries_all.TrxnTypeId%TYPE,
5594: ci_reqtype iby_trxn_summaries_all.ReqType%TYPE,
5595: ci_status iby_trxn_summaries_all.Status%TYPE

Line 5592: ci_merchid iby_trxn_summaries_all.PayeeId%TYPE,

5588: l_trxnref iby_trxn_summaries_all.trxnref%type;
5589:
5590: CURSOR c_trxnmid(
5591: ci_trxnid iby_trxn_summaries_all.TransactionID%TYPE,
5592: ci_merchid iby_trxn_summaries_all.PayeeId%TYPE,
5593: --ci_trxntype iby_trxn_summaries_all.TrxnTypeId%TYPE,
5594: ci_reqtype iby_trxn_summaries_all.ReqType%TYPE,
5595: ci_status iby_trxn_summaries_all.Status%TYPE
5596: )

Line 5593: --ci_trxntype iby_trxn_summaries_all.TrxnTypeId%TYPE,

5589:
5590: CURSOR c_trxnmid(
5591: ci_trxnid iby_trxn_summaries_all.TransactionID%TYPE,
5592: ci_merchid iby_trxn_summaries_all.PayeeId%TYPE,
5593: --ci_trxntype iby_trxn_summaries_all.TrxnTypeId%TYPE,
5594: ci_reqtype iby_trxn_summaries_all.ReqType%TYPE,
5595: ci_status iby_trxn_summaries_all.Status%TYPE
5596: )
5597: IS

Line 5594: ci_reqtype iby_trxn_summaries_all.ReqType%TYPE,

5590: CURSOR c_trxnmid(
5591: ci_trxnid iby_trxn_summaries_all.TransactionID%TYPE,
5592: ci_merchid iby_trxn_summaries_all.PayeeId%TYPE,
5593: --ci_trxntype iby_trxn_summaries_all.TrxnTypeId%TYPE,
5594: ci_reqtype iby_trxn_summaries_all.ReqType%TYPE,
5595: ci_status iby_trxn_summaries_all.Status%TYPE
5596: )
5597: IS
5598: SELECT trxnmid

Line 5595: ci_status iby_trxn_summaries_all.Status%TYPE

5591: ci_trxnid iby_trxn_summaries_all.TransactionID%TYPE,
5592: ci_merchid iby_trxn_summaries_all.PayeeId%TYPE,
5593: --ci_trxntype iby_trxn_summaries_all.TrxnTypeId%TYPE,
5594: ci_reqtype iby_trxn_summaries_all.ReqType%TYPE,
5595: ci_status iby_trxn_summaries_all.Status%TYPE
5596: )
5597: IS
5598: SELECT trxnmid
5599: FROM iby_trxn_summaries_all

Line 5599: FROM iby_trxn_summaries_all

5595: ci_status iby_trxn_summaries_all.Status%TYPE
5596: )
5597: IS
5598: SELECT trxnmid
5599: FROM iby_trxn_summaries_all
5600: WHERE (status = ci_status)
5601: AND (payeeid = ci_merchid)
5602: AND (transactionid = ci_trxnid)
5603: AND (reqtype = ci_reqtype);

Line 5612: FROM iby_trxn_summaries_all

5608: ci_merchid iby_transactions_v.merchant_id%TYPE
5609: )
5610: IS
5611: SELECT mtangibleid, instrtype, instrsubtype, trxnref
5612: FROM iby_trxn_summaries_all
5613: WHERE (tangibleid = ci_orderid)
5614: AND (payeeid = ci_merchid)
5615: AND (mtangibleid <> -1)
5616: ORDER BY reqdate DESC;

Line 5641: UPDATE iby_trxn_summaries_all

5637: -- exists ; update it instead of adding a new
5638: -- row
5639: CLOSE c_trxnmid;
5640:
5641: UPDATE iby_trxn_summaries_all
5642: SET ReqDate = NVL(time_in,reqdate),
5643: --Amount = amount_in,
5644: --CurrencyNameCode = currency_in,
5645: UpdateDate = NVL(time_in,updatedate),

Line 5714: select count(*) into l_cnt from iby_trxn_summaries_all

5710: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
5711:
5712:
5713: -- try to get mtangibleid
5714: select count(*) into l_cnt from iby_trxn_summaries_all
5715: where tangibleid = order_id_in and
5716: payeeid = merchant_id_in and
5717: mtangibleid <> -1;
5718:

Line 5735: INSERT INTO iby_trxn_summaries_all

5731: -- because it is missing the payee info
5732: l_mtangibleid := -1;
5733: end if;
5734:
5735: INSERT INTO iby_trxn_summaries_all
5736: (ECAppID, TrxnMID, TransactionID,TrxntypeID, ReqDate, ReqType,
5737: Amount,CurrencyNameCode, UpdateDate,Status,
5738: TangibleID,MPayeeID, PayeeID,BEPID, bepKey, MTangibleID,
5739: BEPCode,BEPMessage,Errorlocation, org_id,

Line 5773: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,

5769:
5770: /* updates the statuses of trxns saved in a batch */
5771: PROCEDURE updateBatchedTrxns
5772: (
5773: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5774: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
5775: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
5776: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
5777: newstatus_in IN iby_trxn_summaries_all.status%TYPE,

Line 5774: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,

5770: /* updates the statuses of trxns saved in a batch */
5771: PROCEDURE updateBatchedTrxns
5772: (
5773: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5774: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
5775: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
5776: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
5777: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
5778: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,

Line 5775: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,

5771: PROCEDURE updateBatchedTrxns
5772: (
5773: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5774: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
5775: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
5776: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
5777: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
5778: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5779: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE

Line 5776: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,

5772: (
5773: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5774: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
5775: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
5776: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
5777: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
5778: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5779: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE
5780: )

Line 5777: newstatus_in IN iby_trxn_summaries_all.status%TYPE,

5773: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5774: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
5775: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
5776: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
5777: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
5778: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5779: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE
5780: )
5781: IS

Line 5778: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,

5774: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
5775: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
5776: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
5777: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
5778: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5779: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE
5780: )
5781: IS
5782: l_mbatchid iby_trxn_summaries_all.mbatchid%TYPE;

Line 5779: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE

5775: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
5776: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
5777: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
5778: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5779: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE
5780: )
5781: IS
5782: l_mbatchid iby_trxn_summaries_all.mbatchid%TYPE;
5783: BEGIN

Line 5782: l_mbatchid iby_trxn_summaries_all.mbatchid%TYPE;

5778: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5779: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE
5780: )
5781: IS
5782: l_mbatchid iby_trxn_summaries_all.mbatchid%TYPE;
5783: BEGIN
5784:
5785: BEGIN
5786: getMBatchId(oldbatchid_in, payeeid_in, l_mbatchid);

Line 5796: UPDATE iby_trxn_summaries_all

5792: EXCEPTION WHEN others THEN
5793: l_mbatchid := NULL;
5794: END;
5795:
5796: UPDATE iby_trxn_summaries_all
5797: SET
5798: status = newstatus_in,
5799: batchid = newbatchid_in,
5800: mbatchid = l_mbatchid,

Line 5820: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,

5816:
5817: /* Regular version of this method. */
5818: PROCEDURE updateBatchQueryTrxn
5819: (
5820: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5821: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5822: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5823: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5824: status_in IN iby_trxn_summaries_all.status%TYPE,

Line 5821: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,

5817: /* Regular version of this method. */
5818: PROCEDURE updateBatchQueryTrxn
5819: (
5820: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5821: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5822: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5823: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5824: status_in IN iby_trxn_summaries_all.status%TYPE,
5825: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,

Line 5822: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

5818: PROCEDURE updateBatchQueryTrxn
5819: (
5820: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5821: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5822: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5823: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5824: status_in IN iby_trxn_summaries_all.status%TYPE,
5825: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5826: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,

Line 5823: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,

5819: (
5820: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5821: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5822: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5823: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5824: status_in IN iby_trxn_summaries_all.status%TYPE,
5825: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5826: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5827: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,

Line 5824: status_in IN iby_trxn_summaries_all.status%TYPE,

5820: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5821: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5822: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5823: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5824: status_in IN iby_trxn_summaries_all.status%TYPE,
5825: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5826: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5827: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
5828: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE

Line 5825: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,

5821: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5822: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5823: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5824: status_in IN iby_trxn_summaries_all.status%TYPE,
5825: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5826: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5827: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
5828: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
5829: )

Line 5826: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,

5822: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5823: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5824: status_in IN iby_trxn_summaries_all.status%TYPE,
5825: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5826: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5827: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
5828: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
5829: )
5830: IS

Line 5827: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,

5823: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5824: status_in IN iby_trxn_summaries_all.status%TYPE,
5825: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5826: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5827: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
5828: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
5829: )
5830: IS
5831: BEGIN

Line 5828: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE

5824: status_in IN iby_trxn_summaries_all.status%TYPE,
5825: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5826: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5827: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
5828: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
5829: )
5830: IS
5831: BEGIN
5832:

Line 5834: iby_trxn_summaries_all

5830: IS
5831: BEGIN
5832:
5833: UPDATE
5834: iby_trxn_summaries_all
5835:
5836: SET
5837: status=status_in,
5838: --

Line 5880: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,

5876:
5877: /* auth version of the method. */
5878: PROCEDURE updateBatchQueryTrxn
5879: (
5880: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5881: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5882: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5883: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5884: status_in IN iby_trxn_summaries_all.status%TYPE,

Line 5881: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,

5877: /* auth version of the method. */
5878: PROCEDURE updateBatchQueryTrxn
5879: (
5880: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5881: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5882: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5883: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5884: status_in IN iby_trxn_summaries_all.status%TYPE,
5885: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,

Line 5882: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

5878: PROCEDURE updateBatchQueryTrxn
5879: (
5880: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5881: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5882: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5883: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5884: status_in IN iby_trxn_summaries_all.status%TYPE,
5885: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5886: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,

Line 5883: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,

5879: (
5880: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5881: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5882: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5883: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5884: status_in IN iby_trxn_summaries_all.status%TYPE,
5885: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5886: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5887: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,

Line 5884: status_in IN iby_trxn_summaries_all.status%TYPE,

5880: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5881: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5882: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5883: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5884: status_in IN iby_trxn_summaries_all.status%TYPE,
5885: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5886: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5887: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
5888: authcode_in IN iby_trxn_core.authcode%TYPE,

Line 5885: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,

5881: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
5882: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5883: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5884: status_in IN iby_trxn_summaries_all.status%TYPE,
5885: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5886: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5887: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
5888: authcode_in IN iby_trxn_core.authcode%TYPE,
5889: avscode_in IN iby_trxn_core.avscode%TYPE,

Line 5886: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,

5882: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
5883: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5884: status_in IN iby_trxn_summaries_all.status%TYPE,
5885: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5886: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5887: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
5888: authcode_in IN iby_trxn_core.authcode%TYPE,
5889: avscode_in IN iby_trxn_core.avscode%TYPE,
5890: cvv2result_in IN iby_trxn_core.cvv2result%TYPE,

Line 5887: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,

5883: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5884: status_in IN iby_trxn_summaries_all.status%TYPE,
5885: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5886: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5887: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
5888: authcode_in IN iby_trxn_core.authcode%TYPE,
5889: avscode_in IN iby_trxn_core.avscode%TYPE,
5890: cvv2result_in IN iby_trxn_core.cvv2result%TYPE,
5891: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE

Line 5891: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE

5887: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
5888: authcode_in IN iby_trxn_core.authcode%TYPE,
5889: avscode_in IN iby_trxn_core.avscode%TYPE,
5890: cvv2result_in IN iby_trxn_core.cvv2result%TYPE,
5891: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
5892: )
5893: IS
5894: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;
5895: BEGIN

Line 5894: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;

5890: cvv2result_in IN iby_trxn_core.cvv2result%TYPE,
5891: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
5892: )
5893: IS
5894: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;
5895: BEGIN
5896:
5897: updateBatchQueryTrxn(payeeid_in,orderid_in,trxn_type_in,batchid_in,status_in,bep_code_in,bep_msg_in,error_loc_in,trxnid_out);
5898:

Line 5904: iby_trxn_summaries_all

5900: trxnmid
5901: INTO
5902: l_trxnmid
5903: FROM
5904: iby_trxn_summaries_all
5905: WHERE
5906:
5907: --
5908: -- Where clause modified to support

Line 5942: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,

5938:
5939: PROCEDURE Update_Batch
5940: (
5941: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
5942: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5943: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5944: batch_status_in IN iby_batches_all.batchstatus%TYPE,
5945: batch_total_in IN iby_batches_all.batchtotal%TYPE,
5946: sale_amount_in IN iby_batches_all.batchsales%TYPE,

Line 5943: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,

5939: PROCEDURE Update_Batch
5940: (
5941: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
5942: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5943: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5944: batch_status_in IN iby_batches_all.batchstatus%TYPE,
5945: batch_total_in IN iby_batches_all.batchtotal%TYPE,
5946: sale_amount_in IN iby_batches_all.batchsales%TYPE,
5947: credit_amount_in IN iby_batches_all.batchcredit%TYPE,

Line 5964: l_tmid iby_trxn_summaries_all.trxnmid%TYPE;

5960: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
5961: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
5962: )
5963: IS
5964: l_tmid iby_trxn_summaries_all.trxnmid%TYPE;
5965: l_tid iby_trxn_summaries_all.transactionid%TYPE;
5966: l_count NUMBER := 0;
5967:
5968: CURSOR c_tmid

Line 5965: l_tid iby_trxn_summaries_all.transactionid%TYPE;

5961: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
5962: )
5963: IS
5964: l_tmid iby_trxn_summaries_all.trxnmid%TYPE;
5965: l_tid iby_trxn_summaries_all.transactionid%TYPE;
5966: l_count NUMBER := 0;
5967:
5968: CURSOR c_tmid
5969: (ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,

Line 5969: (ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,

5965: l_tid iby_trxn_summaries_all.transactionid%TYPE;
5966: l_count NUMBER := 0;
5967:
5968: CURSOR c_tmid
5969: (ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
5970: ci_orderid iby_trxn_summaries_all.tangibleid%TYPE,
5971: ci_reqtype iby_trxn_summaries_all.reqtype%TYPE,
5972: ci_mbatchid iby_trxn_summaries_all.mbatchid%TYPE
5973: )

Line 5970: ci_orderid iby_trxn_summaries_all.tangibleid%TYPE,

5966: l_count NUMBER := 0;
5967:
5968: CURSOR c_tmid
5969: (ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
5970: ci_orderid iby_trxn_summaries_all.tangibleid%TYPE,
5971: ci_reqtype iby_trxn_summaries_all.reqtype%TYPE,
5972: ci_mbatchid iby_trxn_summaries_all.mbatchid%TYPE
5973: )
5974: IS

Line 5971: ci_reqtype iby_trxn_summaries_all.reqtype%TYPE,

5967:
5968: CURSOR c_tmid
5969: (ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
5970: ci_orderid iby_trxn_summaries_all.tangibleid%TYPE,
5971: ci_reqtype iby_trxn_summaries_all.reqtype%TYPE,
5972: ci_mbatchid iby_trxn_summaries_all.mbatchid%TYPE
5973: )
5974: IS
5975: SELECT trxnmid, transactionid

Line 5972: ci_mbatchid iby_trxn_summaries_all.mbatchid%TYPE

5968: CURSOR c_tmid
5969: (ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
5970: ci_orderid iby_trxn_summaries_all.tangibleid%TYPE,
5971: ci_reqtype iby_trxn_summaries_all.reqtype%TYPE,
5972: ci_mbatchid iby_trxn_summaries_all.mbatchid%TYPE
5973: )
5974: IS
5975: SELECT trxnmid, transactionid
5976: FROM iby_trxn_summaries_all

Line 5976: FROM iby_trxn_summaries_all

5972: ci_mbatchid iby_trxn_summaries_all.mbatchid%TYPE
5973: )
5974: IS
5975: SELECT trxnmid, transactionid
5976: FROM iby_trxn_summaries_all
5977: WHERE (payeeid = ci_payeeid)
5978: AND (tangibleid = ci_orderid)
5979: -- ack cannot distinguish between credits and returns
5980: AND (DECODE(reqtype, 'ORAPMTRETURN','ORAPMTCREDIT', reqtype) =

Line 5990: FROM iby_trxn_summaries_all ibs,

5986: (ci_tracenumber iby_trxn_core.tracenumber%TYPE)
5987:
5988: IS
5989: SELECT ibc.trxnmid, ibs.transactionid
5990: FROM iby_trxn_summaries_all ibs,
5991: iby_trxn_core ibc
5992: WHERE ibs.trxnmid=ibc.trxnmid
5993: AND ibc.tracenumber=ci_tracenumber;
5994:

Line 6043: UPDATE iby_trxn_summaries_all

6039: --trxnid_out.extend(1);
6040: l_count := l_count +1;
6041:
6042: IF (l_tmid IS NOT NULL) THEN
6043: UPDATE iby_trxn_summaries_all
6044: SET status = TO_NUMBER(trxn_status_in(i)),
6045: bepcode = trxn_bep_code_in(i),
6046: bepmessage = trxn_bep_msg_in(i),
6047: errorlocation = TO_NUMBER(trxn_error_loc_in(i)),

Line 6084: UPDATE iby_trxn_summaries_all

6080: -- for some acknowledgements missing transactions are
6081: -- implicitly assumed to have succeeded or failed
6082: --
6083: IF ((ack_type_in = 'P') OR (ack_type_in = 'N')) THEN
6084: UPDATE iby_trxn_summaries_all
6085: SET
6086: status = DECODE(ack_type_in,
6087: 'P',C_STATUS_BEP_FAIL,
6088: 'N',C_STATUS_SUCCESS,

Line 6141: Function getOrgId(i_tid in iby_trxn_summaries_all.transactionid%type)

6137: for QueryTrxn where there will be no orgid inserted
6138: try to see if there is already some valid org id stored,
6139: if so, use the non-null one first
6140: */
6141: Function getOrgId(i_tid in iby_trxn_summaries_all.transactionid%type)
6142: return number
6143: IS
6144: l_org_id NUMBER := NULL;
6145: l_count NUMBER;

Line 6148: iby_trxn_summaries_all.transactionid%type)

6144: l_org_id NUMBER := NULL;
6145: l_count NUMBER;
6146:
6147: cursor c_getNonNullOrgId(ci_tid
6148: iby_trxn_summaries_all.transactionid%type)
6149:
6150: is
6151: SELECT DISTINCT org_id
6152: FROM iby_trxn_summaries_all

Line 6152: FROM iby_trxn_summaries_all

6148: iby_trxn_summaries_all.transactionid%type)
6149:
6150: is
6151: SELECT DISTINCT org_id
6152: FROM iby_trxn_summaries_all
6153: WHERE transactionid = i_tid
6154: AND status <> -99 AND status <> 14 -- ignore cancelled trxns
6155: AND org_id IS NOT NULL;
6156:

Line 6178: i_reqtype in iby_trxn_summaries_all.reqtype%type)

6174: */
6175:
6176: Function getNumPendingTrxns(i_payeeid in iby_payee.payeeid%type,
6177: i_tangibleid in iby_tangible.tangibleid%type,
6178: i_reqtype in iby_trxn_summaries_all.reqtype%type)
6179: return number
6180:
6181: IS
6182:

Line 6189: FROM iby_trxn_summaries_all

6185: BEGIN
6186:
6187: SELECT count(*)
6188: INTO l_num_trxns
6189: FROM iby_trxn_summaries_all
6190: WHERE TangibleID = i_tangibleid
6191: AND UPPER(ReqType) = UPPER(i_reqtype)
6192: AND PayeeID = i_payeeid
6193: AND (status IN (11,9));

Line 6216: FROM iby_trxn_summaries_all

6212: cursor c_tid(ci_payeeid in iby_payee.payeeid%type,
6213: ci_tangibleid in iby_tangible.tangibleid%type)
6214: is
6215: SELECT distinct transactionid
6216: FROM iby_trxn_summaries_all
6217: WHERE tangibleid = ci_tangibleid
6218: AND payeeid = ci_payeeid;
6219:
6220: BEGIN

Line 6252: FROM iby_trxn_summaries_all

6248: cursor c_tid(ci_payeeid in iby_payee.payeeid%type,
6249: ci_tangibleid in iby_tangible.tangibleid%type)
6250: is
6251: SELECT distinct transactionid
6252: FROM iby_trxn_summaries_all
6253: WHERE tangibleid = ci_tangibleid
6254: AND payeeid = ci_payeeid;
6255:
6256: BEGIN

Line 6286: (p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,

6282:
6283: END getTIDUniqueCheck;
6284:
6285: FUNCTION unencrypt_instr_num
6286: (p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
6287: p_payee_key IN iby_security_pkg.des3_key_type,
6288: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%TYPE,
6289: p_sys_key IN RAW,
6290: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,

Line 6297: RETURN iby_trxn_summaries_all.instrnumber%TYPE

6293: p_card_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
6294: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
6295: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE
6296: )
6297: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6298: IS
6299: l_subkey_cleartxt iby_security_pkg.des3_key_type;
6300: l_subkey_raw RAW(24);
6301: l_number iby_trxn_summaries_all.instrnumber%TYPE;

Line 6301: l_number iby_trxn_summaries_all.instrnumber%TYPE;

6297: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6298: IS
6299: l_subkey_cleartxt iby_security_pkg.des3_key_type;
6300: l_subkey_raw RAW(24);
6301: l_number iby_trxn_summaries_all.instrnumber%TYPE;
6302: l_number_len NUMBER;
6303: BEGIN
6304:
6305: -- handle 2 cases: not encrypted, PCI-encrypted

Line 6345: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

6341: END IF;
6342: END unencrypt_instr_num;
6343:
6344: PROCEDURE unencrypt_instr_num
6345: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
6346: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
6347: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE
6348: )
6349: IS

Line 6347: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE

6343:
6344: PROCEDURE unencrypt_instr_num
6345: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
6346: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
6347: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE
6348: )
6349: IS
6350: l_subkey_cipher iby_payee_subkeys.subkey_cipher_text%TYPE;
6351: l_cipher_instrnum iby_trxn_summaries_all.instrnumber%TYPE;

Line 6351: l_cipher_instrnum iby_trxn_summaries_all.instrnumber%TYPE;

6347: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE
6348: )
6349: IS
6350: l_subkey_cipher iby_payee_subkeys.subkey_cipher_text%TYPE;
6351: l_cipher_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
6352: l_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
6353: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
6354: l_sys_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
6355: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;

Line 6352: l_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;

6348: )
6349: IS
6350: l_subkey_cipher iby_payee_subkeys.subkey_cipher_text%TYPE;
6351: l_cipher_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
6352: l_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
6353: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
6354: l_sys_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
6355: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
6356: l_card_length iby_cc_issuer_ranges.card_number_length%TYPE;

Line 6359: CURSOR c_instr_num(ci_trxnmid iby_trxn_summaries_all.trxnmid%TYPE)

6355: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
6356: l_card_length iby_cc_issuer_ranges.card_number_length%TYPE;
6357: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
6358:
6359: CURSOR c_instr_num(ci_trxnmid iby_trxn_summaries_all.trxnmid%TYPE)
6360: IS
6361: SELECT NULL, tx.instrnumber,
6362: tx.instrnum_sec_segment_id, k.subkey_cipher_text,
6363: seg.segment_cipher_text, r.card_number_prefix,

Line 6365: FROM iby_trxn_summaries_all tx,

6361: SELECT NULL, tx.instrnumber,
6362: tx.instrnum_sec_segment_id, k.subkey_cipher_text,
6363: seg.segment_cipher_text, r.card_number_prefix,
6364: NVL(r.card_number_length,tx.instrnum_length), i.digit_check_flag
6365: FROM iby_trxn_summaries_all tx,
6366: iby_security_segments seg, iby_sys_security_subkeys k,
6367: iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
6368: WHERE (tx.trxnmid = ci_trxnmid)
6369: AND (tx.instrnum_sec_segment_id = seg.sec_segment_id(+))

Line 6398: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

6394:
6395:
6396: FUNCTION unencrypt_instr_num
6397: (
6398: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
6399: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
6400: )
6401: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6402: IS

Line 6401: RETURN iby_trxn_summaries_all.instrnumber%TYPE

6397: (
6398: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
6399: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
6400: )
6401: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6402: IS
6403: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
6404: BEGIN
6405: unencrypt_instr_num(trxnmid_in,master_key_in,l_instrnum);

Line 6403: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;

6399: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
6400: )
6401: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6402: IS
6403: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
6404: BEGIN
6405: unencrypt_instr_num(trxnmid_in,master_key_in,l_instrnum);
6406: RETURN l_instrnum;
6407: END unencrypt_instr_num;

Line 6411: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

6407: END unencrypt_instr_num;
6408:
6409: FUNCTION unencrypt_instr_num_ui_wrp
6410: (
6411: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
6412: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
6413: )
6414: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6415: IS

Line 6414: RETURN iby_trxn_summaries_all.instrnumber%TYPE

6410: (
6411: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
6412: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
6413: )
6414: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6415: IS
6416: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
6417: BEGIN
6418: l_instrnum := unencrypt_instr_num(trxnmid_in,master_key_in);

Line 6416: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;

6412: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
6413: )
6414: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6415: IS
6416: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
6417: BEGIN
6418: l_instrnum := unencrypt_instr_num(trxnmid_in,master_key_in);
6419: RETURN l_instrnum;
6420:

Line 6457: FROM iby_trxn_summaries_all tx

6453: SELECT /*+ rowid(tx) */
6454: tx.trxnmid,
6455: iby_utility_pvt.decode64(instrnumber) ccnum,
6456: tx.instrtype
6457: FROM iby_trxn_summaries_all tx
6458: WHERE
6459: (NOT instrnumber IS NULL)
6460: AND (DECODE(instrtype, 'PINLESSDEBITCARD','CREDITCARD',
6461: 'PURCHASECARD','CREDITCARD',

Line 6474: -- corresponding records in iby_trxn_summaries_all are encrypted.

6470: -- The below cursor will fetch all un-encrypted rows from
6471: -- IBY_TRXN_CORE table. Though we could probably have merged this
6472: -- cursor with the earlier one, we maintain a separate one since
6473: -- there could be records in this table that are un-encrypted but the
6474: -- corresponding records in iby_trxn_summaries_all are encrypted.
6475: CURSOR c_trxn_core
6476: IS
6477: SELECT
6478: tx.trxnmid tmid,

Line 6481: FROM iby_trxn_summaries_all tx,

6477: SELECT
6478: tx.trxnmid tmid,
6479: core.instr_expirydate expdate,
6480: core.instr_owner_name chname
6481: FROM iby_trxn_summaries_all tx,
6482: iby_trxn_core core
6483: WHERE
6484: (DECODE(tx.instrtype, 'PINLESSDEBITCARD','CREDITCARD',
6485: 'PURCHASECARD','CREDITCARD',

Line 6526: UPDATE iby_trxn_summaries_all

6522: l_trxnmid_tbl(l_index) := txn_rec.trxnmid;
6523:
6524: IF (l_index=1000) THEN
6525: FORALL i IN l_trxnmid_tbl.first..l_trxnmid_tbl.last
6526: UPDATE iby_trxn_summaries_all
6527: SET
6528: instrnumber = l_maskedcc_tbl(i),
6529: instrnum_hash = l_cchash_tbl(i),
6530: cc_issuer_range_id = l_rangeid_tbl(i),

Line 6552: UPDATE iby_trxn_summaries_all

6548: END LOOP;
6549:
6550: IF (l_trxnmid_tbl.COUNT>0) THEN
6551: FORALL i IN l_trxnmid_tbl.first..l_trxnmid_tbl.last
6552: UPDATE iby_trxn_summaries_all
6553: SET
6554: instrnumber = l_maskedcc_tbl(i),
6555: instrnum_hash = l_cchash_tbl(i),
6556: cc_issuer_range_id = l_rangeid_tbl(i),

Line 6637: FROM iby_trxn_summaries_all tx,

6633: seg.segment_cipher_text, r.card_number_prefix,
6634: NVL(r.card_number_length,tx.instrnum_length),
6635: i.digit_check_flag) ccnum,
6636: instrnum_sec_segment_id
6637: FROM iby_trxn_summaries_all tx,
6638: iby_security_segments seg, iby_sys_security_subkeys k,
6639: iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
6640: WHERE
6641: /*

Line 6689: UPDATE iby_trxn_summaries_all

6685: l_segmentid_tbl(l_index) := txn_rec.instrnum_sec_segment_id;
6686:
6687: IF (l_index=1000) THEN
6688: FORALL i IN l_trxnmid_tbl.first..l_trxnmid_tbl.last
6689: UPDATE iby_trxn_summaries_all
6690: SET
6691: instrnumber = l_instrnum_tbl(i),
6692: instrnum_sec_segment_id = NULL
6693: WHERE trxnmid=l_trxnmid_tbl(i);

Line 6712: UPDATE iby_trxn_summaries_all

6708: END LOOP;
6709:
6710: IF (l_trxnmid_tbl.COUNT>0) THEN
6711: FORALL i IN l_trxnmid_tbl.first..l_trxnmid_tbl.last
6712: UPDATE iby_trxn_summaries_all
6713: SET
6714: instrnumber = l_instrnum_tbl(i),
6715: instrnum_sec_segment_id = NULL
6716: WHERE trxnmid=l_trxnmid_tbl(i);

Line 6769: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,

6765: END Decrypt_CC_Data;
6766:
6767: PROCEDURE check_batch_size
6768: (
6769: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,
6770: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
6771: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
6772: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
6773: orgid_in IN iby_batches_all.org_id%TYPE,

Line 6770: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,

6766:
6767: PROCEDURE check_batch_size
6768: (
6769: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,
6770: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
6771: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
6772: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
6773: orgid_in IN iby_batches_all.org_id%TYPE,
6774: seckey_present_in IN VARCHAR2,

Line 6771: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,

6767: PROCEDURE check_batch_size
6768: (
6769: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,
6770: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
6771: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
6772: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
6773: orgid_in IN iby_batches_all.org_id%TYPE,
6774: seckey_present_in IN VARCHAR2,
6775: trxncount_out OUT NOCOPY NUMBER,

Line 6772: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,

6768: (
6769: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,
6770: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
6771: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
6772: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
6773: orgid_in IN iby_batches_all.org_id%TYPE,
6774: seckey_present_in IN VARCHAR2,
6775: trxncount_out OUT NOCOPY NUMBER,
6776: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE

Line 6785: ci_ecappid iby_trxn_summaries_all.ecappid%TYPE,

6781: l_mbatch_id iby_batches_all.mbatchid%TYPE;
6782:
6783: CURSOR c_trxn_count
6784: (
6785: ci_ecappid iby_trxn_summaries_all.ecappid%TYPE,
6786: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
6787: ci_bepid iby_trxn_summaries_all.bepid%TYPE,
6788: ci_bepkey iby_trxn_summaries_all.bepkey%TYPE
6789: ) IS

Line 6786: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,

6782:
6783: CURSOR c_trxn_count
6784: (
6785: ci_ecappid iby_trxn_summaries_all.ecappid%TYPE,
6786: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
6787: ci_bepid iby_trxn_summaries_all.bepid%TYPE,
6788: ci_bepkey iby_trxn_summaries_all.bepkey%TYPE
6789: ) IS
6790: SELECT count(transactionid)

Line 6787: ci_bepid iby_trxn_summaries_all.bepid%TYPE,

6783: CURSOR c_trxn_count
6784: (
6785: ci_ecappid iby_trxn_summaries_all.ecappid%TYPE,
6786: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
6787: ci_bepid iby_trxn_summaries_all.bepid%TYPE,
6788: ci_bepkey iby_trxn_summaries_all.bepkey%TYPE
6789: ) IS
6790: SELECT count(transactionid)
6791: FROM iby_trxn_summaries_all

Line 6788: ci_bepkey iby_trxn_summaries_all.bepkey%TYPE

6784: (
6785: ci_ecappid iby_trxn_summaries_all.ecappid%TYPE,
6786: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
6787: ci_bepid iby_trxn_summaries_all.bepid%TYPE,
6788: ci_bepkey iby_trxn_summaries_all.bepkey%TYPE
6789: ) IS
6790: SELECT count(transactionid)
6791: FROM iby_trxn_summaries_all
6792: WHERE (ci_bepid=bepid)

Line 6791: FROM iby_trxn_summaries_all

6787: ci_bepid iby_trxn_summaries_all.bepid%TYPE,
6788: ci_bepkey iby_trxn_summaries_all.bepkey%TYPE
6789: ) IS
6790: SELECT count(transactionid)
6791: FROM iby_trxn_summaries_all
6792: WHERE (ci_bepid=bepid)
6793: AND (ci_payeeid=payeeid)
6794: AND (ci_bepkey=bepkey)
6795: --

Line 6808: CURSOR c_max_bsize(ci_bepid iby_trxn_summaries_all.bepid%TYPE) IS

6804: AND (instrtype IN (iby_creditcard_pkg.C_INSTRTYPE_CCARD,
6805: iby_creditcard_pkg.C_INSTRTYPE_PCARD)
6806: OR instrtype IS NULL);
6807:
6808: CURSOR c_max_bsize(ci_bepid iby_trxn_summaries_all.bepid%TYPE) IS
6809: SELECT NVL(max_batch_size,-1)
6810: FROM iby_bepinfo
6811: WHERE (ci_bepid=bepid);
6812:

Line 6852: LOCK TABLE iby_batches_all, iby_trxn_summaries_all

6848: -- threads; lock both tables (even though iby_batches_all
6849: -- is sufficient) so as to ensure no deadlock can happen
6850: -- later
6851: --
6852: LOCK TABLE iby_batches_all, iby_trxn_summaries_all
6853: IN EXCLUSIVE MODE;
6854:
6855: -- check batch size once more to ensure another thread has
6856: -- not closed it between the last check and possession of

Line 7021: UPDATE iby_trxn_summaries_all

7017: WHERE (mbatchid = mbatchid_in);
7018:
7019: -- the update will update only settlement trxn.
7020: -- authcapture, capture and markcapture
7021: UPDATE iby_trxn_summaries_all
7022: SET payer_notification_required = l_payer_notif_flag,
7023: last_update_date=sysdate,
7024: last_updated_by = fnd_global.user_id,
7025: object_version_number = object_version_number + 1