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.

[Home] [Help]

APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 37: IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,

33: * used as criteria for grouping.
34: */
35: TYPE trxnGroupCriteriaType IS RECORD (
36: trxn_id
37: IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
38: process_profile_code
39: IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
40: bep_key
41: IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,

Line 39: IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,

35: TYPE trxnGroupCriteriaType IS RECORD (
36: trxn_id
37: IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
38: process_profile_code
39: IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
40: bep_key
41: IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
42: org_id
43: IBY_TRXN_SUMMARIES_ALL.org_id%TYPE,

Line 41: IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,

37: IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
38: process_profile_code
39: IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
40: bep_key
41: IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
42: org_id
43: IBY_TRXN_SUMMARIES_ALL.org_id%TYPE,
44: org_type
45: IBY_TRXN_SUMMARIES_ALL.org_type%TYPE,

Line 43: IBY_TRXN_SUMMARIES_ALL.org_id%TYPE,

39: IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
40: bep_key
41: IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
42: org_id
43: IBY_TRXN_SUMMARIES_ALL.org_id%TYPE,
44: org_type
45: IBY_TRXN_SUMMARIES_ALL.org_type%TYPE,
46: curr_code
47: IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,

Line 45: IBY_TRXN_SUMMARIES_ALL.org_type%TYPE,

41: IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
42: org_id
43: IBY_TRXN_SUMMARIES_ALL.org_id%TYPE,
44: org_type
45: IBY_TRXN_SUMMARIES_ALL.org_type%TYPE,
46: curr_code
47: IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
48: amount
49: IBY_TRXN_SUMMARIES_ALL.amount%TYPE,

Line 47: IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,

43: IBY_TRXN_SUMMARIES_ALL.org_id%TYPE,
44: org_type
45: IBY_TRXN_SUMMARIES_ALL.org_type%TYPE,
46: curr_code
47: IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
48: amount
49: IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
50: legal_entity_id
51: IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,

Line 49: IBY_TRXN_SUMMARIES_ALL.amount%TYPE,

45: IBY_TRXN_SUMMARIES_ALL.org_type%TYPE,
46: curr_code
47: IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
48: amount
49: IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
50: legal_entity_id
51: IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
52: int_bank_acct_id
53: IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,

Line 51: IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,

47: IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
48: amount
49: IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
50: legal_entity_id
51: IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
52: int_bank_acct_id
53: IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
54: settle_date
55: IBY_TRXN_SUMMARIES_ALL.settledate%TYPE,

Line 53: IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,

49: IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
50: legal_entity_id
51: IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
52: int_bank_acct_id
53: IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
54: settle_date
55: IBY_TRXN_SUMMARIES_ALL.settledate%TYPE,
56: group_by_org
57: IBY_FNDCPT_SYS_CC_PF_B.group_by_org%TYPE,

Line 55: IBY_TRXN_SUMMARIES_ALL.settledate%TYPE,

51: IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
52: int_bank_acct_id
53: IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
54: settle_date
55: IBY_TRXN_SUMMARIES_ALL.settledate%TYPE,
56: group_by_org
57: IBY_FNDCPT_SYS_CC_PF_B.group_by_org%TYPE,
58: group_by_le
59: IBY_FNDCPT_SYS_CC_PF_B.group_by_legal_entity%TYPE,

Line 125: IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,

121: * a batch and transaction.
122: */
123: TYPE trxnsInBatchRecType IS RECORD (
124: trxn_id
125: IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
126: mbatch_id
127: IBY_TRXN_SUMMARIES_ALL.mbatchid%TYPE,
128: batch_id
129: IBY_TRXN_SUMMARIES_ALL.batchid%TYPE

Line 127: IBY_TRXN_SUMMARIES_ALL.mbatchid%TYPE,

123: TYPE trxnsInBatchRecType IS RECORD (
124: trxn_id
125: IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
126: mbatch_id
127: IBY_TRXN_SUMMARIES_ALL.mbatchid%TYPE,
128: batch_id
129: IBY_TRXN_SUMMARIES_ALL.batchid%TYPE
130: );
131:

Line 129: IBY_TRXN_SUMMARIES_ALL.batchid%TYPE

125: IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
126: mbatch_id
127: IBY_TRXN_SUMMARIES_ALL.mbatchid%TYPE,
128: batch_id
129: IBY_TRXN_SUMMARIES_ALL.batchid%TYPE
130: );
131:
132: /*
133: * Table of trxn-batch relationships.

Line 149: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,

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

Line 159: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,

155:
156: PROCEDURE prepare_instr_data
157: (p_commit IN VARCHAR2,
158: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
159: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
160: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
161: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
162: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
163: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,

Line 160: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,

156: PROCEDURE prepare_instr_data
157: (p_commit IN VARCHAR2,
158: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
159: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
160: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
161: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
162: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
163: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
164: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,

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

157: (p_commit IN VARCHAR2,
158: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
159: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
160: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
161: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
162: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
163: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
164: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
165: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,

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

158: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
159: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
160: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
161: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
162: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
163: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
164: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
165: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
166: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE

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

159: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
160: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
161: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
162: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
163: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
164: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
165: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
166: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
167: );

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

160: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
161: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
162: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
163: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
164: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
165: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
166: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
167: );
168:

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

161: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
162: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
163: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
164: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
165: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
166: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
167: );
168:
169: PROCEDURE insert_extensibility

Line 166: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE

162: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
163: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
164: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
165: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
166: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
167: );
168:
169: PROCEDURE insert_extensibility
170: (

Line 171: p_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE,

167: );
168:
169: PROCEDURE insert_extensibility
170: (
171: p_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE,
172: p_commit IN VARCHAR2,
173: p_extend_names IN JTF_VARCHAR2_TABLE_100,
174: p_extend_vals IN JTF_VARCHAR2_TABLE_200
175: );

Line 182: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,

178: /* would be called every time a MIPP authorize operation is performed. */
179:
180: PROCEDURE insert_auth_txn
181: (
182: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
183: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
184: order_id_in IN iby_transactions_v.order_id%TYPE,
185: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
186: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

Line 183: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,

179:
180: PROCEDURE insert_auth_txn
181: (
182: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
183: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
184: order_id_in IN iby_transactions_v.order_id%TYPE,
185: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
186: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
187: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

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

200: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
201: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
202: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
203: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
204: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
205: billeracct_in IN iby_tangible.acctno%type,
206: refinfo_in IN iby_tangible.refinfo%type,
207: memo_in IN iby_tangible.memo%type,
208: order_medium_in IN iby_tangible.order_medium%TYPE,

Line 210: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

206: refinfo_in IN iby_tangible.refinfo%type,
207: memo_in IN iby_tangible.memo%type,
208: order_medium_in IN iby_tangible.order_medium%TYPE,
209: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
210: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
211: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
212: payerid_in IN iby_trxn_summaries_all.payerid%type,
213: instrtype_in IN iby_trxn_summaries_all.instrType%type,
214: cvv2result_in IN iby_trxn_core.CVV2Result%type,

Line 211: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

207: memo_in IN iby_tangible.memo%type,
208: order_medium_in IN iby_tangible.order_medium%TYPE,
209: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
210: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
211: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
212: payerid_in IN iby_trxn_summaries_all.payerid%type,
213: instrtype_in IN iby_trxn_summaries_all.instrType%type,
214: cvv2result_in IN iby_trxn_core.CVV2Result%type,
215: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

Line 212: payerid_in IN iby_trxn_summaries_all.payerid%type,

208: order_medium_in IN iby_tangible.order_medium%TYPE,
209: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
210: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
211: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
212: payerid_in IN iby_trxn_summaries_all.payerid%type,
213: instrtype_in IN iby_trxn_summaries_all.instrType%type,
214: cvv2result_in IN iby_trxn_core.CVV2Result%type,
215: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
216: subkey_seed_in IN RAW,

Line 213: instrtype_in IN iby_trxn_summaries_all.instrType%type,

209: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
210: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
211: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
212: payerid_in IN iby_trxn_summaries_all.payerid%type,
213: instrtype_in IN iby_trxn_summaries_all.instrType%type,
214: cvv2result_in IN iby_trxn_core.CVV2Result%type,
215: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
216: subkey_seed_in IN RAW,
217: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

Line 217: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

213: instrtype_in IN iby_trxn_summaries_all.instrType%type,
214: cvv2result_in IN iby_trxn_core.CVV2Result%type,
215: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
216: subkey_seed_in IN RAW,
217: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
218: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
219: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
220: instr_sec_val_in IN VARCHAR2,
221: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,

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

239: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
240: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
241: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
242: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
243: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
244: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
245: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
246: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
247: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,

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

240: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
241: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
242: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
243: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
244: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
245: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
246: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
247: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
248: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,

Line 245: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

241: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
242: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
243: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
244: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
245: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
246: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
247: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
248: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
249: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,

Line 246: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,

242: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
243: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
244: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
245: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
246: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
247: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
248: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
249: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,
250: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE

Line 247: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,

243: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
244: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
245: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
246: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
247: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
248: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
249: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,
250: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE
251: );

Line 248: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,

244: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
245: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
246: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
247: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
248: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
249: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,
250: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE
251: );
252:

Line 249: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,

245: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
246: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
247: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
248: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
249: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,
250: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE
251: );
252:
253:

Line 261: ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,

257:
258:
259: PROCEDURE insert_other_txn
260: (
261: ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
262: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
263: order_id_in IN iby_transactions_v.order_id%TYPE,
264: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
265: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

Line 262: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,

258:
259: PROCEDURE insert_other_txn
260: (
261: ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
262: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
263: order_id_in IN iby_transactions_v.order_id%TYPE,
264: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
265: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
266: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

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

275: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
276: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
277: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
278: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
279: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
280: billeracct_in IN iby_tangible.acctno%type,
281: refinfo_in IN iby_tangible.refinfo%type,
282: memo_in IN iby_tangible.memo%type,
283: order_medium_in IN iby_tangible.order_medium%TYPE,

Line 285: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

281: refinfo_in IN iby_tangible.refinfo%type,
282: memo_in IN iby_tangible.memo%type,
283: order_medium_in IN iby_tangible.order_medium%TYPE,
284: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
285: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
286: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
287: payerid_in IN iby_trxn_summaries_all.payerid%type,
288: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
289: subkey_seed_in IN RAW,

Line 286: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

282: memo_in IN iby_tangible.memo%type,
283: order_medium_in IN iby_tangible.order_medium%TYPE,
284: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
285: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
286: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
287: payerid_in IN iby_trxn_summaries_all.payerid%type,
288: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
289: subkey_seed_in IN RAW,
290: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

Line 287: payerid_in IN iby_trxn_summaries_all.payerid%type,

283: order_medium_in IN iby_tangible.order_medium%TYPE,
284: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
285: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
286: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
287: payerid_in IN iby_trxn_summaries_all.payerid%type,
288: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
289: subkey_seed_in IN RAW,
290: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
291: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,

Line 290: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

286: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
287: payerid_in IN iby_trxn_summaries_all.payerid%type,
288: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
289: subkey_seed_in IN RAW,
290: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
291: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
292: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
293: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
294: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,

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

301: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
302: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
303: extend_names_in IN JTF_VARCHAR2_TABLE_100,
304: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
305: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
306: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
307: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
308: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
309: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,

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

302: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
303: extend_names_in IN JTF_VARCHAR2_TABLE_100,
304: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
305: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
306: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
307: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
308: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
309: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
310: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,

Line 307: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

303: extend_names_in IN JTF_VARCHAR2_TABLE_100,
304: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
305: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
306: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
307: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
308: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
309: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
310: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,
311: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE

Line 308: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,

304: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
305: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
306: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
307: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
308: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
309: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
310: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,
311: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE
312: );

Line 309: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,

305: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
306: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
307: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
308: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
309: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
310: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,
311: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE
312: );
313:

Line 310: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,

306: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
307: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
308: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
309: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
310: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,
311: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE
312: );
313:
314:

Line 311: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE

307: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
308: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
309: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
310: settlement_date_in IN iby_trxn_summaries_all.settledate%TYPE,
311: settlement_due_date_in IN iby_trxn_summaries_all.settlement_due_date%TYPE
312: );
313:
314:
315: /* Inserts a row into the iby_transaction table if auth, capture, */

Line 320: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,

316: /* return, credit, and void timeout */
317:
318: PROCEDURE insert_timeout_txn
319: (
320: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
321: order_id_in IN iby_transactions_v.order_id%TYPE,
322: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
323: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
324: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

Line 325: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,

321: order_id_in IN iby_transactions_v.order_id%TYPE,
322: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
323: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
324: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
325: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
326: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
327: status_in IN iby_transactions_v.status%TYPE,
328: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
329: amount_in IN iby_tangible.amount%type,

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

324: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
325: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
326: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
327: status_in IN iby_transactions_v.status%TYPE,
328: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
329: amount_in IN iby_tangible.amount%type,
330: currency_in IN iby_tangible.currencynamecode%type,
331: billeracct_in IN iby_tangible.acctno%type,
332: refinfo_in IN iby_tangible.refinfo%type,

Line 336: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

332: refinfo_in IN iby_tangible.refinfo%type,
333: memo_in IN iby_tangible.memo%type,
334: order_medium_in IN iby_tangible.order_medium%TYPE,
335: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
336: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
337: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
338: payerid_in IN iby_trxn_summaries_all.payerid%type,
339: instrtype_in IN iby_trxn_summaries_all.instrType%type,
340: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

Line 337: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

333: memo_in IN iby_tangible.memo%type,
334: order_medium_in IN iby_tangible.order_medium%TYPE,
335: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
336: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
337: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
338: payerid_in IN iby_trxn_summaries_all.payerid%type,
339: instrtype_in IN iby_trxn_summaries_all.instrType%type,
340: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
341: subkey_seed_in IN RAW,

Line 338: payerid_in IN iby_trxn_summaries_all.payerid%type,

334: order_medium_in IN iby_tangible.order_medium%TYPE,
335: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
336: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
337: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
338: payerid_in IN iby_trxn_summaries_all.payerid%type,
339: instrtype_in IN iby_trxn_summaries_all.instrType%type,
340: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
341: subkey_seed_in IN RAW,
342: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

Line 339: instrtype_in IN iby_trxn_summaries_all.instrType%type,

335: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
336: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
337: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
338: payerid_in IN iby_trxn_summaries_all.payerid%type,
339: instrtype_in IN iby_trxn_summaries_all.instrType%type,
340: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
341: subkey_seed_in IN RAW,
342: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
343: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,

Line 342: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,

338: payerid_in IN iby_trxn_summaries_all.payerid%type,
339: instrtype_in IN iby_trxn_summaries_all.instrType%type,
340: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
341: subkey_seed_in IN RAW,
342: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
343: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
344: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
345: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
346: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

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

339: instrtype_in IN iby_trxn_summaries_all.instrType%type,
340: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
341: subkey_seed_in IN RAW,
342: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
343: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
344: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
345: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
346: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
347: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,

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

340: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
341: subkey_seed_in IN RAW,
342: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
343: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
344: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
345: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
346: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
347: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
348: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE

Line 345: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

341: subkey_seed_in IN RAW,
342: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
343: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
344: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
345: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
346: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
347: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
348: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE
349: );

Line 346: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

342: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
343: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
344: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
345: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
346: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
347: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
348: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE
349: );
350:

Line 347: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,

343: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
344: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
345: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
346: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
347: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
348: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE
349: );
350:
351:

Line 348: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE

344: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
345: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
346: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
347: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
348: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE
349: );
350:
351:
352: /* Checks if a row exists for a set of parameters */

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

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

Line 429: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

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

Line 435: f_pmt_channel_in IN iby_trxn_summaries_all.

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

Line 437: f_curr_in IN iby_trxn_summaries_all.

433: instr_type_in IN iby_batches_all.instrument_type%TYPE,
434: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
435: f_pmt_channel_in IN iby_trxn_summaries_all.
436: payment_channel_code%TYPE,
437: f_curr_in IN iby_trxn_summaries_all.
438: currencynamecode%TYPE,
439: f_settle_date IN iby_trxn_summaries_all.
440: settledate%TYPE,
441: f_due_date IN iby_trxn_summaries_all.

Line 439: f_settle_date IN iby_trxn_summaries_all.

435: f_pmt_channel_in IN iby_trxn_summaries_all.
436: payment_channel_code%TYPE,
437: f_curr_in IN iby_trxn_summaries_all.
438: currencynamecode%TYPE,
439: f_settle_date IN iby_trxn_summaries_all.
440: settledate%TYPE,
441: f_due_date IN iby_trxn_summaries_all.
442: settlement_due_date%TYPE,
443: f_maturity_date IN iby_trxn_summaries_all.

Line 441: f_due_date IN iby_trxn_summaries_all.

437: f_curr_in IN iby_trxn_summaries_all.
438: currencynamecode%TYPE,
439: f_settle_date IN iby_trxn_summaries_all.
440: settledate%TYPE,
441: f_due_date IN iby_trxn_summaries_all.
442: settlement_due_date%TYPE,
443: f_maturity_date IN iby_trxn_summaries_all.
444: br_maturity_date%TYPE,
445: f_instr_type IN iby_trxn_summaries_all.

Line 443: f_maturity_date IN iby_trxn_summaries_all.

439: f_settle_date IN iby_trxn_summaries_all.
440: settledate%TYPE,
441: f_due_date IN iby_trxn_summaries_all.
442: settlement_due_date%TYPE,
443: f_maturity_date IN iby_trxn_summaries_all.
444: br_maturity_date%TYPE,
445: f_instr_type IN iby_trxn_summaries_all.
446: instrtype%TYPE,
447: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,

Line 445: f_instr_type IN iby_trxn_summaries_all.

441: f_due_date IN iby_trxn_summaries_all.
442: settlement_due_date%TYPE,
443: f_maturity_date IN iby_trxn_summaries_all.
444: br_maturity_date%TYPE,
445: f_instr_type IN iby_trxn_summaries_all.
446: instrtype%TYPE,
447: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
448: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
449: );

Line 476: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

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

Line 482: f_pmt_channel_in IN iby_trxn_summaries_all.

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

Line 484: f_curr_in IN iby_trxn_summaries_all.

480: instr_type_in IN iby_batches_all.instrument_type%TYPE,
481: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
482: f_pmt_channel_in IN iby_trxn_summaries_all.
483: payment_channel_code%TYPE,
484: f_curr_in IN iby_trxn_summaries_all.
485: currencynamecode%TYPE,
486: f_settle_date IN iby_trxn_summaries_all.
487: settledate%TYPE,
488: f_due_date IN iby_trxn_summaries_all.

Line 486: f_settle_date IN iby_trxn_summaries_all.

482: f_pmt_channel_in IN iby_trxn_summaries_all.
483: payment_channel_code%TYPE,
484: f_curr_in IN iby_trxn_summaries_all.
485: currencynamecode%TYPE,
486: f_settle_date IN iby_trxn_summaries_all.
487: settledate%TYPE,
488: f_due_date IN iby_trxn_summaries_all.
489: settlement_due_date%TYPE,
490: f_maturity_date IN iby_trxn_summaries_all.

Line 488: f_due_date IN iby_trxn_summaries_all.

484: f_curr_in IN iby_trxn_summaries_all.
485: currencynamecode%TYPE,
486: f_settle_date IN iby_trxn_summaries_all.
487: settledate%TYPE,
488: f_due_date IN iby_trxn_summaries_all.
489: settlement_due_date%TYPE,
490: f_maturity_date IN iby_trxn_summaries_all.
491: br_maturity_date%TYPE,
492: f_instr_type IN iby_trxn_summaries_all.

Line 490: f_maturity_date IN iby_trxn_summaries_all.

486: f_settle_date IN iby_trxn_summaries_all.
487: settledate%TYPE,
488: f_due_date IN iby_trxn_summaries_all.
489: settlement_due_date%TYPE,
490: f_maturity_date IN iby_trxn_summaries_all.
491: br_maturity_date%TYPE,
492: f_instr_type IN iby_trxn_summaries_all.
493: instrtype%TYPE,
494: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,

Line 492: f_instr_type IN iby_trxn_summaries_all.

488: f_due_date IN iby_trxn_summaries_all.
489: settlement_due_date%TYPE,
490: f_maturity_date IN iby_trxn_summaries_all.
491: br_maturity_date%TYPE,
492: f_instr_type IN iby_trxn_summaries_all.
493: instrtype%TYPE,
494: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
495: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
496: );

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

499:
500: /* Inserts the transaction record for the closebatch operation */
501:
502: PROCEDURE insert_batch_txn
503: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
504: order_id_in IN iby_transactions_v.order_id%TYPE,
505: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
506: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
507: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

Line 522: org_id_in IN iby_trxn_summaries_all.org_id%type

518: DEFAULT NULL,
519: trace_number_in IN iby_transactions_v.TraceNumber%TYPE
520: DEFAULT NULL,
521:
522: org_id_in IN iby_trxn_summaries_all.org_id%type
523: DEFAULT NULL,
524: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE);
525:
526:

Line 524: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE);

520: DEFAULT NULL,
521:
522: org_id_in IN iby_trxn_summaries_all.org_id%type
523: DEFAULT NULL,
524: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE);
525:
526:
527: /* Inserts transaction record for transaction query operation */
528:

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

527: /* Inserts transaction record for transaction query operation */
528:
529:
530: PROCEDURE insert_query_txn
531: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
532: order_id_in IN iby_transactions_v.order_id%TYPE,
533: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
534: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
535: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

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

547: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
548: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
549: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
550: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
551: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
552: ecappid_in IN iby_ecapp.ecappid%type,
553: req_type_in IN iby_trxn_summaries_all.reqtype%type);
554:
555:

Line 553: req_type_in IN iby_trxn_summaries_all.reqtype%type);

549: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
550: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
551: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
552: ecappid_in IN iby_ecapp.ecappid%type,
553: req_type_in IN iby_trxn_summaries_all.reqtype%type);
554:
555:
556:
557: /*

Line 588: i_reqtype in iby_trxn_summaries_all.reqtype%type)

584:
585:
586: Function getNumPendingTrxns(i_payeeid in iby_payee.payeeid%type,
587: i_tangibleid in iby_tangible.tangibleid%type,
588: i_reqtype in iby_trxn_summaries_all.reqtype%type)
589: return number;
590:
591: Function getOrgId(i_tid in iby_trxn_summaries_all.transactionid%type)
592: return number;

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

587: i_tangibleid in iby_tangible.tangibleid%type,
588: i_reqtype in iby_trxn_summaries_all.reqtype%type)
589: return number;
590:
591: Function getOrgId(i_tid in iby_trxn_summaries_all.transactionid%type)
592: return number;
593:
594: /*
595: * USE: Updates the status of trxns stored in an iPayment internal batch.

Line 609: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,

605: * 6. the id of the batch to which the trxns will belong
606: */
607: PROCEDURE updateBatchedTrxns
608: (
609: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
610: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
611: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
612: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
613: newstatus_in IN iby_trxn_summaries_all.status%TYPE,

Line 610: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,

606: */
607: PROCEDURE updateBatchedTrxns
608: (
609: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
610: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
611: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
612: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
613: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
614: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,

Line 611: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,

607: PROCEDURE updateBatchedTrxns
608: (
609: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
610: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
611: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
612: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
613: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
614: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,
615: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE

Line 612: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,

608: (
609: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
610: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
611: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
612: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
613: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
614: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,
615: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE
616: );

Line 613: newstatus_in IN iby_trxn_summaries_all.status%TYPE,

609: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
610: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
611: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
612: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
613: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
614: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,
615: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE
616: );
617:

Line 614: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,

610: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
611: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
612: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
613: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
614: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,
615: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE
616: );
617:
618: /*

Line 615: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE

611: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
612: oldstatus_in IN iby_trxn_summaries_all.status%TYPE,
613: newstatus_in IN iby_trxn_summaries_all.status%TYPE,
614: oldbatchid_in IN iby_trxn_summaries_all.batchid%TYPE,
615: newbatchid_in IN iby_trxn_summaries_all.batchid%TYPE
616: );
617:
618: /*
619: * USE: Updates a batched trxn based on batch query values.

Line 640: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,

636: * set then the applicable row in the table will not be updated
637: */
638: PROCEDURE updateBatchQueryTrxn
639: (
640: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
641: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
642: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
643: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
644: status_in IN iby_trxn_summaries_all.status%TYPE,

Line 641: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,

637: */
638: PROCEDURE updateBatchQueryTrxn
639: (
640: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
641: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
642: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
643: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
644: status_in IN iby_trxn_summaries_all.status%TYPE,
645: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,

Line 642: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

638: PROCEDURE updateBatchQueryTrxn
639: (
640: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
641: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
642: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
643: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
644: status_in IN iby_trxn_summaries_all.status%TYPE,
645: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
646: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,

Line 643: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,

639: (
640: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
641: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
642: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
643: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
644: status_in IN iby_trxn_summaries_all.status%TYPE,
645: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
646: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,
647: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,

Line 644: status_in IN iby_trxn_summaries_all.status%TYPE,

640: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
641: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
642: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
643: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
644: status_in IN iby_trxn_summaries_all.status%TYPE,
645: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
646: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,
647: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,
648: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE

Line 645: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,

641: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
642: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
643: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
644: status_in IN iby_trxn_summaries_all.status%TYPE,
645: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
646: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,
647: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,
648: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
649: );

Line 646: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,

642: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
643: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
644: status_in IN iby_trxn_summaries_all.status%TYPE,
645: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
646: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,
647: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,
648: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
649: );
650:

Line 647: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,

643: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
644: status_in IN iby_trxn_summaries_all.status%TYPE,
645: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
646: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,
647: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,
648: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
649: );
650:
651: /*

Line 648: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE

644: status_in IN iby_trxn_summaries_all.status%TYPE,
645: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
646: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,
647: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,
648: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
649: );
650:
651: /*
652: * USE: Overloaded version of the above method used for batched

Line 670: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,

666: * set then the applicable row in the table will not be updated
667: */
668: PROCEDURE updateBatchQueryTrxn
669: (
670: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
671: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
672: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
673: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
674: status_in IN iby_trxn_summaries_all.status%TYPE,

Line 671: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,

667: */
668: PROCEDURE updateBatchQueryTrxn
669: (
670: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
671: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
672: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
673: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
674: status_in IN iby_trxn_summaries_all.status%TYPE,
675: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,

Line 672: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

668: PROCEDURE updateBatchQueryTrxn
669: (
670: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
671: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
672: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
673: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
674: status_in IN iby_trxn_summaries_all.status%TYPE,
675: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
676: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,

Line 673: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,

669: (
670: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
671: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
672: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
673: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
674: status_in IN iby_trxn_summaries_all.status%TYPE,
675: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
676: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,
677: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,

Line 674: status_in IN iby_trxn_summaries_all.status%TYPE,

670: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
671: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
672: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
673: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
674: status_in IN iby_trxn_summaries_all.status%TYPE,
675: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
676: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,
677: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,
678: authcode_in IN iby_trxn_core.authcode%TYPE DEFAULT NULL,

Line 675: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,

671: orderid_in IN iby_trxn_summaries_all.batchid%TYPE,
672: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
673: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
674: status_in IN iby_trxn_summaries_all.status%TYPE,
675: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
676: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,
677: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,
678: authcode_in IN iby_trxn_core.authcode%TYPE DEFAULT NULL,
679: avscode_in IN iby_trxn_core.avscode%TYPE DEFAULT NULL,

Line 676: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,

672: trxn_type_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
673: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
674: status_in IN iby_trxn_summaries_all.status%TYPE,
675: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
676: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,
677: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,
678: authcode_in IN iby_trxn_core.authcode%TYPE DEFAULT NULL,
679: avscode_in IN iby_trxn_core.avscode%TYPE DEFAULT NULL,
680: cvv2result_in IN iby_trxn_core.cvv2result%TYPE DEFAULT NULL,

Line 677: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,

673: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
674: status_in IN iby_trxn_summaries_all.status%TYPE,
675: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE DEFAULT NULL,
676: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE DEFAULT NULL,
677: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,
678: authcode_in IN iby_trxn_core.authcode%TYPE DEFAULT NULL,
679: avscode_in IN iby_trxn_core.avscode%TYPE DEFAULT NULL,
680: cvv2result_in IN iby_trxn_core.cvv2result%TYPE DEFAULT NULL,
681: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE

Line 681: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE

677: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE DEFAULT NULL,
678: authcode_in IN iby_trxn_core.authcode%TYPE DEFAULT NULL,
679: avscode_in IN iby_trxn_core.avscode%TYPE DEFAULT NULL,
680: cvv2result_in IN iby_trxn_core.cvv2result%TYPE DEFAULT NULL,
681: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
682: );
683:
684: PROCEDURE Update_Batch
685: (

Line 687: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,

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

Line 688: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,

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

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

707: );
708:
709:
710: FUNCTION unencrypt_instr_num
711: (p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
712: p_payee_key IN iby_security_pkg.des3_key_type,
713: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%TYPE,
714: p_sys_key IN RAW,
715: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,

Line 722: RETURN iby_trxn_summaries_all.instrnumber%TYPE;

718: p_card_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
719: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
720: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE
721: )
722: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
723:
724: /*
725: * USE: Unencrypts the instrument number associated with the given trxn
726: * master id.

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

736: * For all parameters that default to null- if not
737: * set then the applicable row in the table will not be updated
738: */
739: PROCEDURE unencrypt_instr_num
740: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
741: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
742: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE
743: );
744:

Line 742: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE

738: */
739: PROCEDURE unencrypt_instr_num
740: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
741: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
742: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE
743: );
744:
745: /* Functional version of above procedure so that it can be used
746: * 'in-line' in SQL statements.

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

745: /* Functional version of above procedure so that it can be used
746: * 'in-line' in SQL statements.
747: */
748: FUNCTION unencrypt_instr_num
749: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
750: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
751: )
752: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
753:

Line 752: RETURN iby_trxn_summaries_all.instrnumber%TYPE;

748: FUNCTION unencrypt_instr_num
749: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
750: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
751: )
752: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
753:
754: /* Wrapper of above function for UI. In the UI the
755: * SQL is executed by the framework. We can not catch
756: * the exception thrown from the function call.

Line 765: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,

761: * for this case.
762: */
763: FUNCTION unencrypt_instr_num_ui_wrp
764: (
765: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
766: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
767: )
768: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
769:

Line 768: RETURN iby_trxn_summaries_all.instrnumber%TYPE;

764: (
765: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
766: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
767: )
768: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
769:
770: -- USE
771: -- Encrypts (historical) transactional credit card data
772: --

Line 800: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,

796: *
797: */
798: PROCEDURE check_batch_size
799: (
800: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,
801: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
802: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
803: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
804: orgid_in IN iby_batches_all.org_id%TYPE,

Line 801: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,

797: */
798: PROCEDURE check_batch_size
799: (
800: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,
801: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
802: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
803: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
804: orgid_in IN iby_batches_all.org_id%TYPE,
805: seckey_present_in IN VARCHAR2,

Line 802: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,

798: PROCEDURE check_batch_size
799: (
800: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,
801: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
802: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
803: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
804: orgid_in IN iby_batches_all.org_id%TYPE,
805: seckey_present_in IN VARCHAR2,
806: trxncount_out OUT NOCOPY NUMBER,

Line 803: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,

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

Line 833: instr_type IN IBY_TRXN_SUMMARIES_ALL.

829: *---------------------------------------------------------------------*/
830: PROCEDURE performTransactionGrouping(
831: p_profile_code IN IBY_FNDCPT_USER_CC_PF_B.
832: user_cc_profile_code%TYPE,
833: instr_type IN IBY_TRXN_SUMMARIES_ALL.
834: instrtype%TYPE,
835: req_type IN IBY_BATCHES_ALL.
836: reqtype%TYPE,
837: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.

Line 837: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.

833: instr_type IN IBY_TRXN_SUMMARIES_ALL.
834: instrtype%TYPE,
835: req_type IN IBY_BATCHES_ALL.
836: reqtype%TYPE,
837: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
838: payment_channel_code%TYPE,
839: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
840: currencynamecode%TYPE,
841: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.

Line 839: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

835: req_type IN IBY_BATCHES_ALL.
836: reqtype%TYPE,
837: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
838: payment_channel_code%TYPE,
839: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
840: currencynamecode%TYPE,
841: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
842: settledate%TYPE,
843: f_due_date IN IBY_TRXN_SUMMARIES_ALL.

Line 841: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.

837: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
838: payment_channel_code%TYPE,
839: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
840: currencynamecode%TYPE,
841: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
842: settledate%TYPE,
843: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
844: settlement_due_date%TYPE,
845: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.

Line 843: f_due_date IN IBY_TRXN_SUMMARIES_ALL.

839: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
840: currencynamecode%TYPE,
841: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
842: settledate%TYPE,
843: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
844: settlement_due_date%TYPE,
845: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
846: br_maturity_date%TYPE,
847: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.

Line 845: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.

841: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
842: settledate%TYPE,
843: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
844: settlement_due_date%TYPE,
845: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
846: br_maturity_date%TYPE,
847: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
848: instrtype%TYPE,
849: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

Line 847: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.

843: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
844: settlement_due_date%TYPE,
845: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
846: br_maturity_date%TYPE,
847: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
848: instrtype%TYPE,
849: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
850: batchAttrTabType,
851: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

Line 879: instr_type IN IBY_TRXN_SUMMARIES_ALL.

875: |
876: *---------------------------------------------------------------------*/
877: PROCEDURE performTransactionGrouping(
878: profile_code_array IN JTF_VARCHAR2_TABLE_100,
879: instr_type IN IBY_TRXN_SUMMARIES_ALL.
880: instrtype%TYPE,
881: req_type IN IBY_BATCHES_ALL.
882: reqtype%TYPE,
883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.

Line 883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.

879: instr_type IN IBY_TRXN_SUMMARIES_ALL.
880: instrtype%TYPE,
881: req_type IN IBY_BATCHES_ALL.
882: reqtype%TYPE,
883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
884: payment_channel_code%TYPE,
885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
886: currencynamecode%TYPE,
887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.

Line 885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

881: req_type IN IBY_BATCHES_ALL.
882: reqtype%TYPE,
883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
884: payment_channel_code%TYPE,
885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
886: currencynamecode%TYPE,
887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
888: settledate%TYPE,
889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.

Line 887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.

883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
884: payment_channel_code%TYPE,
885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
886: currencynamecode%TYPE,
887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
888: settledate%TYPE,
889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
890: settlement_due_date%TYPE,
891: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.

Line 889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.

885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.
886: currencynamecode%TYPE,
887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
888: settledate%TYPE,
889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
890: settlement_due_date%TYPE,
891: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
892: br_maturity_date%TYPE,
893: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.

Line 891: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.

887: f_settle_date IN IBY_TRXN_SUMMARIES_ALL.
888: settledate%TYPE,
889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
890: settlement_due_date%TYPE,
891: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
892: br_maturity_date%TYPE,
893: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
894: instrtype%TYPE,
895: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

Line 893: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.

889: f_due_date IN IBY_TRXN_SUMMARIES_ALL.
890: settlement_due_date%TYPE,
891: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
892: br_maturity_date%TYPE,
893: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
894: instrtype%TYPE,
895: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
896: batchAttrTabType,
897: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.