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_CORE

Line 242: cvv2result_in IN iby_trxn_core.CVV2Result%type,

238: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
239: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
240: payerid_in IN iby_trxn_summaries_all.payerid%type,
241: instrtype_in IN iby_trxn_summaries_all.instrType%type,
242: cvv2result_in IN iby_trxn_core.CVV2Result%type,
243: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
244: subkey_seed_in IN RAW,
245: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
246: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,

Line 246: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,

242: cvv2result_in IN iby_trxn_core.CVV2Result%type,
243: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
244: subkey_seed_in IN RAW,
245: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
246: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
247: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
248: instr_sec_val_in IN VARCHAR2,
249: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
250: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,

Line 247: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,

243: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
244: subkey_seed_in IN RAW,
245: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
246: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
247: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
248: instr_sec_val_in IN VARCHAR2,
249: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
250: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
251: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,

Line 249: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,

245: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
246: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
247: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
248: instr_sec_val_in IN VARCHAR2,
249: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
250: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
251: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
252: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
253: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,

Line 250: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,

246: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
247: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
248: instr_sec_val_in IN VARCHAR2,
249: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
250: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
251: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
252: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
253: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
254: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,

Line 251: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,

247: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
248: instr_sec_val_in IN VARCHAR2,
249: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
250: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
251: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
252: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
253: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
254: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
255: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,

Line 252: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,

248: instr_sec_val_in IN VARCHAR2,
249: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
250: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
251: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
252: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
253: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
254: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
255: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
256: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,

Line 253: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,

249: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
250: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
251: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
252: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
253: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
254: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
255: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
256: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
257: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,

Line 254: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,

250: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
251: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
252: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
253: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
254: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
255: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
256: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
257: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
258: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,

Line 255: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,

251: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
252: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
253: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
254: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
255: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
256: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
257: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
258: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
259: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,

Line 256: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,

252: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
253: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
254: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
255: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
256: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
257: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
258: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
259: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
260: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,

Line 257: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,

253: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
254: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
255: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
256: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
257: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
258: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
259: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
260: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
261: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,

Line 258: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,

254: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
255: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
256: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
257: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
258: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
259: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
260: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
261: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
262: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,

Line 259: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,

255: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
256: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
257: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
258: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
259: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
260: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
261: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
262: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
263: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,

Line 260: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,

256: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
257: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
258: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
259: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
260: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
261: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
262: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
263: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
264: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,

Line 261: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,

257: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
258: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
259: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
260: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
261: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
262: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
263: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
264: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
265: reader_data_in IN iby_trxn_core.reader_data%TYPE,

Line 262: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,

258: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
259: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
260: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
261: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
262: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
263: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
264: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
265: reader_data_in IN iby_trxn_core.reader_data%TYPE,
266: extend_names_in IN JTF_VARCHAR2_TABLE_100,

Line 263: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,

259: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
260: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
261: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
262: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
263: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
264: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
265: reader_data_in IN iby_trxn_core.reader_data%TYPE,
266: extend_names_in IN JTF_VARCHAR2_TABLE_100,
267: extend_vals_in IN JTF_VARCHAR2_TABLE_200,

Line 264: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,

260: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
261: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
262: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
263: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
264: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
265: reader_data_in IN iby_trxn_core.reader_data%TYPE,
266: extend_names_in IN JTF_VARCHAR2_TABLE_100,
267: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
268: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,

Line 265: reader_data_in IN iby_trxn_core.reader_data%TYPE,

261: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
262: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
263: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
264: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
265: reader_data_in IN iby_trxn_core.reader_data%TYPE,
266: extend_names_in IN JTF_VARCHAR2_TABLE_100,
267: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
268: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
269: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,

Line 268: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,

264: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
265: reader_data_in IN iby_trxn_core.reader_data%TYPE,
266: extend_names_in IN JTF_VARCHAR2_TABLE_100,
267: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
268: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
269: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
270: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
271: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
272: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,

Line 269: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,

265: reader_data_in IN iby_trxn_core.reader_data%TYPE,
266: extend_names_in IN JTF_VARCHAR2_TABLE_100,
267: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
268: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
269: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
270: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
271: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
272: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
273: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

Line 270: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,

266: extend_names_in IN JTF_VARCHAR2_TABLE_100,
267: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
268: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
269: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
270: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
271: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
272: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
273: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,
274: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,

Line 278: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE,

274: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
275: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
276: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
277: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,
278: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE,
279: reauth_trxnid_in IN iby_trxn_summaries_all.TransactionID%TYPE
280: )
281: IS
282:

Line 302: l_expirydate iby_trxn_core.instr_expirydate%type;

298: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
299: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
300:
301: l_instrnum iby_trxn_summaries_all.instrnumber%type;
302: l_expirydate iby_trxn_core.instr_expirydate%type;
303:
304: l_pos_txn iby_trxn_core.pos_trxn_flag%TYPE;
305: l_payer_party_id iby_trxn_summaries_all.payer_party_id%type;
306:

Line 304: l_pos_txn iby_trxn_core.pos_trxn_flag%TYPE;

300:
301: l_instrnum iby_trxn_summaries_all.instrnumber%type;
302: l_expirydate iby_trxn_core.instr_expirydate%type;
303:
304: l_pos_txn iby_trxn_core.pos_trxn_flag%TYPE;
305: l_payer_party_id iby_trxn_summaries_all.payer_party_id%type;
306:
307: l_voiceauth_flag iby_trxn_core.voiceauthflag%type;
308: l_sub_key_id iby_trxn_summaries_all.sub_key_id%TYPE;

Line 307: l_voiceauth_flag iby_trxn_core.voiceauthflag%type;

303:
304: l_pos_txn iby_trxn_core.pos_trxn_flag%TYPE;
305: l_payer_party_id iby_trxn_summaries_all.payer_party_id%type;
306:
307: l_voiceauth_flag iby_trxn_core.voiceauthflag%type;
308: l_sub_key_id iby_trxn_summaries_all.sub_key_id%TYPE;
309:
310: -- variables for CHNAME and EXPDATE encryption
311: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

Line 339: -- record in IBY_TRXN_CORE

335:
336: -- PABP Fixes
337: -- card holder name and instrument expiry are also considered to be
338: -- sensitive. We need to encrypt those before inserting/updating the
339: -- record in IBY_TRXN_CORE
340:
341: IF ((IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode() <>
342: IBY_SECURITY_PKG.G_ENCRYPT_MODE_NONE)
343: -- AND ( IBY_CREDITCARD_PKG.Other_CC_Attribs_Encrypted = 'Y')

Line 451: * Set the voice auth flag in iby_trxn_core to 'Y'

447:
448: /*
449: * Fix for bug 5190504:
450: *
451: * Set the voice auth flag in iby_trxn_core to 'Y'
452: * in case, the voice auth date is not null.
453: */
454: -- IF (dateofvoiceauth_in IS NOT NULL) THEN
455: -- l_voiceauth_flag := 'Y';

Line 468: INSERT INTO iby_trxn_core (

464: * input parameter.
465: */
466: l_voiceauth_flag := voiceAuthFlag_in;
467:
468: INSERT INTO iby_trxn_core (
469: TrxnMID, AuthCode, date_of_voice_authorization, voiceauthflag,
470: ReferenceCode, TraceNumber,AVSCode, CVV2Result, Acquirer,
471: Auxmsg, InstrName,
472: Instr_Expirydate, expiry_sec_segment_id,

Line 575: UPDATE iby_trxn_core

571: WHERE TrxnMID = l_trxn_mid;
572:
573: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;
574:
575: UPDATE iby_trxn_core
576: SET AuthCode = authcode_in,
577: date_of_voice_authorization = dateofvoiceauth_in,
578: --voiceauthflag = DECODE(dateofvoiceauth_in, NULL, 'N', 'Y'),
579: voiceauthflag = voiceAuthFlag_in,

Line 635: cvv2result_in IN iby_trxn_core.CVV2Result%type,

631: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
632: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
633: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
634: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
635: cvv2result_in IN iby_trxn_core.CVV2Result%type,
636: bepcode_in IN iby_trxn_summaries_all.bepcode%TYPE,
637: bepmessage_in IN iby_trxn_summaries_all.bepmessage%TYPE,
638: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
639: tracenumber_in IN iby_trxn_core.tracenumber%TYPE,

Line 639: tracenumber_in IN iby_trxn_core.tracenumber%TYPE,

635: cvv2result_in IN iby_trxn_core.CVV2Result%type,
636: bepcode_in IN iby_trxn_summaries_all.bepcode%TYPE,
637: bepmessage_in IN iby_trxn_summaries_all.bepmessage%TYPE,
638: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
639: tracenumber_in IN iby_trxn_core.tracenumber%TYPE,
640: authcode_in IN iby_trxn_core.authcode%TYPE,
641: extend_names_in IN JTF_VARCHAR2_TABLE_100,
642: extend_vals_in IN JTF_VARCHAR2_TABLE_200
643: )

Line 640: authcode_in IN iby_trxn_core.authcode%TYPE,

636: bepcode_in IN iby_trxn_summaries_all.bepcode%TYPE,
637: bepmessage_in IN iby_trxn_summaries_all.bepmessage%TYPE,
638: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
639: tracenumber_in IN iby_trxn_core.tracenumber%TYPE,
640: authcode_in IN iby_trxn_core.authcode%TYPE,
641: extend_names_in IN JTF_VARCHAR2_TABLE_100,
642: extend_vals_in IN JTF_VARCHAR2_TABLE_200
643: )
644: IS

Line 710: UPDATE iby_trxn_core

706: Last_Updated_by = fnd_global.user_id,
707: Object_Version_Number = object_version_number + 1
708: WHERE trxnmid = l_old_auth_trxnmid;
709:
710: UPDATE iby_trxn_core
711: SET authcode = authcode_in,
712: ReferenceCode = referencecode_in,
713: AVSCode = AVScode_in,
714: CVV2Result = cvv2result_in,

Line 756: INSERT INTO iby_trxn_core (

752: salt_version,needsupdt,sub_key_id,initiator_extension_id
753: FROM iby_trxn_summaries_all
754: WHERE trxnmid = l_old_auth_trxnmid);
755:
756: INSERT INTO iby_trxn_core (
757: TrxnMID, AuthCode, date_of_voice_authorization, voiceauthflag,
758: ReferenceCode, TraceNumber,AVSCode, CVV2Result, Acquirer,
759: Auxmsg, InstrName,
760: Instr_Expirydate, expiry_sec_segment_id,

Line 789: FROM iby_trxn_core

785: POS_Id_Method_Code, POS_Auth_Source_Code, Reader_Data, POS_Trxn_Flag,
786: debit_network_code, surcharge_amount, proc_tracenumber,
787: sysdate,fnd_global.user_id,
788: sysdate,fnd_global.user_id,fnd_global.login_id,1
789: FROM iby_trxn_core
790: WHERE trxnmid = l_old_auth_trxnmid);
791:
792: --insert_extensibility(l_new_auth_trxnmid,'N',extend_names_in,extend_vals_in);
793:

Line 852: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,

848: payerid_in IN iby_trxn_summaries_all.payerid%type,
849: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
850: subkey_seed_in IN RAW,
851: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
852: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
853: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
854: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
855: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
856: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,

Line 853: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,

849: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
850: subkey_seed_in IN RAW,
851: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
852: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
853: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
854: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
855: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
856: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
857: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,

Line 854: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,

850: subkey_seed_in IN RAW,
851: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
852: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
853: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
854: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
855: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
856: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
857: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
858: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,

Line 855: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,

851: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
852: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
853: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
854: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
855: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
856: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
857: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
858: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
859: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,

Line 856: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,

852: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
853: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
854: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
855: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
856: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
857: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
858: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
859: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
860: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,

Line 857: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,

853: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
854: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
855: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
856: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
857: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
858: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
859: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
860: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
861: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,

Line 858: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,

854: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
855: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
856: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
857: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
858: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
859: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
860: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
861: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
862: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,

Line 859: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,

855: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
856: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
857: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
858: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
859: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
860: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
861: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
862: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
863: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,

Line 860: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,

856: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
857: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
858: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
859: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
860: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
861: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
862: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
863: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
864: extend_names_in IN JTF_VARCHAR2_TABLE_100,

Line 861: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,

857: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
858: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
859: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
860: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
861: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
862: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
863: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
864: extend_names_in IN JTF_VARCHAR2_TABLE_100,
865: extend_vals_in IN JTF_VARCHAR2_TABLE_200,

Line 862: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,

858: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
859: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
860: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
861: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
862: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
863: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
864: extend_names_in IN JTF_VARCHAR2_TABLE_100,
865: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
866: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,

Line 863: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,

859: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
860: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
861: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
862: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
863: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
864: extend_names_in IN JTF_VARCHAR2_TABLE_100,
865: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
866: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
867: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,

Line 896: l_expirydate iby_trxn_core.instr_expirydate%type;

892: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
893: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
894:
895: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
896: l_expirydate iby_trxn_core.instr_expirydate%type;
897:
898: l_cursor_empty BOOLEAN;
899: l_process_profile_code iby_trxn_summaries_all.process_profile_code%TYPE;
900: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;

Line 1094: INSERT INTO iby_trxn_core

1090: l_payer_party_id, l_process_profile_code,
1091: iby_security_pkg.get_salt_version,'Y', settlement_date_in, settlement_due_date_in
1092: );
1093:
1094: INSERT INTO iby_trxn_core
1095: (TrxnMID, ReferenceCode, TraceNumber, InstrName,
1096: Instr_Expirydate, Card_Subtype_Code,
1097: Instr_Owner_Name, Instr_Owner_Address_Line1,
1098: Instr_Owner_Address_Line2, Instr_Owner_Address_Line3,

Line 1184: UPDATE iby_trxn_core

1180: WHERE TrxnMID = l_trxn_mid;
1181:
1182: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;
1183:
1184: UPDATE iby_trxn_core
1185: SET ReferenceCode = referencecode_in,
1186: TraceNumber = trace_number_in,
1187: InstrName = NVL(payment_name_in,InstrName),
1188: Instr_Expirydate = instr_expirydate_in,

Line 1413: INSERT INTO iby_trxn_core

1409: fnd_global.login_id,1,l_cc_type,trxntypeid_in,trxnref_in,
1410: org_type_in, payment_channel_code_in, factored_flag_in,'Y');
1411:
1412:
1413: INSERT INTO iby_trxn_core
1414: (TrxnMID,
1415: last_update_date,last_updated_by,creation_date,created_by,
1416: last_update_login,object_version_number)
1417: VALUES (l_trxn_mid,

Line 6008: -- 1) there is no corresponding entry in ibY_trxn_core table

6004: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
6005:
6006:
6007: -- this insertion from close/query batch is problematic
6008: -- 1) there is no corresponding entry in ibY_trxn_core table
6009: -- 2) mtangible id might not be correct, there might not be
6010: -- an entry in iby_tangible table
6011: -- 3) currency, amount is missing
6012: -- regardless, this should be a rare case, it exists because

Line 6161: UPDATE iby_trxn_core

6157: last_update_login = fnd_global.login_id,
6158: object_version_number = object_version_number+1
6159: WHERE (trxnmid = l_trxn_mid);
6160:
6161: UPDATE iby_trxn_core
6162: SET AuthCode = authcode_in,
6163: ReferenceCode = referencecode_in,
6164: AVSCode = avscode_in,
6165: Acquirer = acquirer_in,

Line 6253: INSERT INTO iby_trxn_core

6249: vendor_code_in, vendor_message_in, error_location_in, org_id_in,
6250: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
6251: fnd_global.login_id,1,l_instrtype,l_instrsubtype,l_trxnref,'Y');
6252:
6253: INSERT INTO iby_trxn_core
6254: (TrxnMID, AuthCode, ReferenceCode, AVSCode, Acquirer, Auxmsg,
6255: TraceNumber, InstrName,
6256: last_update_date,last_updated_by,creation_date,created_by,last_update_login,
6257:

Line 6390: authcode_in IN iby_trxn_core.authcode%TYPE,

6386: status_in IN iby_trxn_summaries_all.status%TYPE,
6387: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
6388: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
6389: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
6390: authcode_in IN iby_trxn_core.authcode%TYPE,
6391: avscode_in IN iby_trxn_core.avscode%TYPE,
6392: cvv2result_in IN iby_trxn_core.cvv2result%TYPE,
6393: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
6394: )

Line 6391: avscode_in IN iby_trxn_core.avscode%TYPE,

6387: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
6388: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
6389: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
6390: authcode_in IN iby_trxn_core.authcode%TYPE,
6391: avscode_in IN iby_trxn_core.avscode%TYPE,
6392: cvv2result_in IN iby_trxn_core.cvv2result%TYPE,
6393: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
6394: )
6395: IS

Line 6392: cvv2result_in IN iby_trxn_core.cvv2result%TYPE,

6388: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
6389: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
6390: authcode_in IN iby_trxn_core.authcode%TYPE,
6391: avscode_in IN iby_trxn_core.avscode%TYPE,
6392: cvv2result_in IN iby_trxn_core.cvv2result%TYPE,
6393: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
6394: )
6395: IS
6396: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;

Line 6429: iby_trxn_core

6425: RETURN;
6426: END IF;
6427:
6428: UPDATE
6429: iby_trxn_core
6430: SET
6431: authcode=authcode_in,
6432: cvv2result=cvv2result_in,
6433: avscode=avscode_in

Line 6506: (ci_tracenumber iby_trxn_core.tracenumber%TYPE,

6502: -- even more robust.)
6503: -- Bug# 12385267
6504: -- Inluded trxn type for RETURN and CREDIT
6505: CURSOR c_tracenumber
6506: (ci_tracenumber iby_trxn_core.tracenumber%TYPE,
6507: ci_mbatchid iby_trxn_summaries_all.mbatchid%TYPE
6508: ) IS
6509: SELECT ibs.trxnmid, ibs.transactionid, ibs.needsupdt
6510: FROM iby_trxn_summaries_all ibs,

Line 6512: iby_trxn_core ibc

6508: ) IS
6509: SELECT ibs.trxnmid, ibs.transactionid, ibs.needsupdt
6510: FROM iby_trxn_summaries_all ibs,
6511: iby_trxn_summaries_all orig_trxn,
6512: iby_trxn_core ibc
6513: WHERE ibs.transactionid = orig_trxn.transactionid
6514: AND ibs.trxntypeid IN(8, 5, 11)
6515: AND orig_trxn.trxnmid=ibc.trxnmid
6516: AND ibc.tracenumber=ci_tracenumber

Line 6601: UPDATE iby_trxn_core

6597: object_version_number = object_version_number + 1,
6598: needsupdt = l_needsupdt
6599: WHERE (trxnmid = l_tmid);
6600:
6601: UPDATE iby_trxn_core
6602: SET authcode = trxn_authcode_in(i),
6603: avscode = trxn_avscode_in(i),
6604: cvv2result = trxn_cvv2result_in(i),
6605: last_update_date = sysdate,

Line 6959: -- IBY_TRXN_CORE table. Though we could probably have merged this

6955: AND (instrnum_sec_segment_id IS NULL);
6956:
6957:
6958: -- The below cursor will fetch all un-encrypted rows from
6959: -- IBY_TRXN_CORE table. Though we could probably have merged this
6960: -- cursor with the earlier one, we maintain a separate one since
6961: -- there could be records in this table that are un-encrypted but the
6962: -- corresponding records in iby_trxn_summaries_all are encrypted.
6963: CURSOR c_trxn_core

Line 6970: iby_trxn_core core

6966: tx.trxnmid tmid,
6967: core.instr_expirydate expdate,
6968: core.instr_owner_name chname
6969: FROM iby_trxn_summaries_all tx,
6970: iby_trxn_core core
6971: WHERE
6972: (DECODE(tx.instrtype, 'PINLESSDEBITCARD','CREDITCARD',
6973: 'PURCHASECARD','CREDITCARD',
6974: -- instrument type will be NULL for credit card credit trxns

Line 7060: -- Loop thru the iby_trxn_core table only if the other card attributes

7056:
7057: COMMIT;
7058: END IF;
7059:
7060: -- Loop thru the iby_trxn_core table only if the other card attributes
7061: -- present here need to be secured
7062:
7063: --IF( IBY_CREDITCARD_PKG.Other_CC_Attribs_Encrypted = 'Y') THEN
7064: FOR core_rec IN c_trxn_core LOOP

Line 7085: UPDATE iby_trxn_core SET

7081: 'X'
7082: );
7083: l_encrypted := 'Y';
7084:
7085: UPDATE iby_trxn_core SET
7086: encrypted = 'Y',
7087: instr_owner_name = l_masked_chname,
7088: chname_sec_segment_id = l_chname_sec_segment_id,
7089: instr_expirydate = NULL,

Line 7162: FROM iby_trxn_core

7158: instr_expirydate,
7159: expiry_sec_segment_id,
7160: instr_owner_name,
7161: chname_sec_segment_id
7162: FROM iby_trxn_core
7163: WHERE NVL(encrypted, 'N') = 'Y';
7164:
7165: BEGIN
7166: IF (iby_creditcard_pkg.Get_CC_Encrypt_Mode() =

Line 7245: UPDATE iby_trxn_core SET

7241: -- CHNAME wasn't encrypted
7242: l_chname := core_rec.instr_owner_name;
7243: END IF;
7244:
7245: UPDATE iby_trxn_core SET
7246: encrypted = 'N',
7247: instr_owner_name = l_chname,
7248: chname_sec_segment_id = NULL,
7249: instr_expirydate = l_exp_date,