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 298: cvv2result_in IN iby_trxn_core.CVV2Result%type,

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

Line 302: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,

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

Line 303: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,

299: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
300: subkey_seed_in IN RAW,
301: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
302: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
303: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
304: instr_sec_val_in IN VARCHAR2,
305: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
306: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
307: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,

Line 305: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,

301: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
302: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
303: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
304: instr_sec_val_in IN VARCHAR2,
305: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
306: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
307: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
308: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
309: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,

Line 306: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,

302: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
303: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
304: instr_sec_val_in IN VARCHAR2,
305: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
306: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
307: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
308: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
309: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
310: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,

Line 307: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,

303: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
304: instr_sec_val_in IN VARCHAR2,
305: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
306: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
307: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
308: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
309: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
310: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
311: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,

Line 308: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,

304: instr_sec_val_in IN VARCHAR2,
305: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
306: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
307: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
308: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
309: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
310: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
311: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
312: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,

Line 309: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,

305: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
306: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
307: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
308: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
309: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
310: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
311: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
312: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
313: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,

Line 310: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,

306: card_data_level_in IN iby_trxn_core.card_data_level%TYPE,
307: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
308: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
309: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
310: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
311: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
312: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
313: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
314: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,

Line 311: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,

307: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
308: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
309: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
310: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
311: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
312: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
313: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
314: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
315: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,

Line 312: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,

308: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
309: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
310: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
311: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
312: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
313: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
314: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
315: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
316: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,

Line 313: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,

309: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
310: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
311: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
312: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
313: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
314: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
315: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
316: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
317: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,

Line 314: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,

310: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
311: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
312: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
313: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
314: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
315: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
316: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
317: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
318: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,

Line 315: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,

311: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
312: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
313: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
314: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
315: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
316: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
317: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
318: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
319: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,

Line 316: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,

312: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
313: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
314: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
315: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
316: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
317: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
318: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
319: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
320: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,

Line 317: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,

313: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
314: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
315: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
316: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
317: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
318: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
319: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
320: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
321: reader_data_in IN iby_trxn_core.reader_data%TYPE,

Line 318: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,

314: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
315: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
316: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
317: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
318: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
319: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
320: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
321: reader_data_in IN iby_trxn_core.reader_data%TYPE,
322: extend_names_in IN JTF_VARCHAR2_TABLE_100,

Line 319: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,

315: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
316: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
317: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
318: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
319: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
320: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
321: reader_data_in IN iby_trxn_core.reader_data%TYPE,
322: extend_names_in IN JTF_VARCHAR2_TABLE_100,
323: extend_vals_in IN JTF_VARCHAR2_TABLE_200,

Line 320: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,

316: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
317: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
318: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
319: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
320: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
321: reader_data_in IN iby_trxn_core.reader_data%TYPE,
322: extend_names_in IN JTF_VARCHAR2_TABLE_100,
323: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
324: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,

Line 321: reader_data_in IN iby_trxn_core.reader_data%TYPE,

317: pos_reader_cap_in IN iby_trxn_core.pos_reader_capability_code%TYPE,
318: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
319: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
320: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
321: reader_data_in IN iby_trxn_core.reader_data%TYPE,
322: extend_names_in IN JTF_VARCHAR2_TABLE_100,
323: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
324: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
325: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,

Line 324: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,

320: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
321: reader_data_in IN iby_trxn_core.reader_data%TYPE,
322: extend_names_in IN JTF_VARCHAR2_TABLE_100,
323: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
324: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
325: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
326: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
327: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
328: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,

Line 325: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,

321: reader_data_in IN iby_trxn_core.reader_data%TYPE,
322: extend_names_in IN JTF_VARCHAR2_TABLE_100,
323: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
324: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
325: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
326: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,
327: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
328: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
329: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

Line 326: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,

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

Line 334: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE

330: payment_channel_code_in IN iby_trxn_summaries_all.payment_channel_code%TYPE,
331: factored_flag_in IN iby_trxn_summaries_all.factored_flag%TYPE,
332: process_profile_code_in IN iby_trxn_summaries_all.process_profile_code%TYPE,
333: sub_key_id_in IN iby_trxn_summaries_all.sub_key_id%TYPE,
334: voiceAuthFlag_in IN iby_trxn_core.voiceauthflag%TYPE
335: )
336: IS
337:
338: l_num_trxns NUMBER := 0;

Line 357: l_expirydate iby_trxn_core.instr_expirydate%type;

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

Line 359: l_pos_txn iby_trxn_core.pos_trxn_flag%TYPE;

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

Line 362: l_voiceauth_flag iby_trxn_core.voiceauthflag%type;

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

Line 394: -- record in IBY_TRXN_CORE

390:
391: -- PABP Fixes
392: -- card holder name and instrument expiry are also considered to be
393: -- sensitive. We need to encrypt those before inserting/updating the
394: -- record in IBY_TRXN_CORE
395:
396: IF ((IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode() <>
397: IBY_SECURITY_PKG.G_ENCRYPT_MODE_NONE)
398: AND ( IBY_CREDITCARD_PKG.Other_CC_Attribs_Encrypted = 'Y'))

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

497:
498: /*
499: * Fix for bug 5190504:
500: *
501: * Set the voice auth flag in iby_trxn_core to 'Y'
502: * in case, the voice auth date is not null.
503: */
504: -- IF (dateofvoiceauth_in IS NOT NULL) THEN
505: -- l_voiceauth_flag := 'Y';

Line 518: INSERT INTO iby_trxn_core (

514: * input parameter.
515: */
516: l_voiceauth_flag := voiceAuthFlag_in;
517:
518: INSERT INTO iby_trxn_core (
519: TrxnMID, AuthCode, date_of_voice_authorization, voiceauthflag,
520: ReferenceCode, TraceNumber,AVSCode, CVV2Result, Acquirer,
521: Auxmsg, InstrName,
522: Instr_Expirydate, expiry_sec_segment_id,

Line 625: UPDATE iby_trxn_core

621: WHERE TrxnMID = l_trxn_mid;
622:
623: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;
624:
625: UPDATE iby_trxn_core
626: SET AuthCode = authcode_in,
627: date_of_voice_authorization = dateofvoiceauth_in,
628: --voiceauthflag = DECODE(dateofvoiceauth_in, NULL, 'N', 'Y'),
629: voiceauthflag = voiceAuthFlag_in,

Line 711: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,

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

Line 712: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,

708: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
709: subkey_seed_in IN RAW,
710: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
711: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
712: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
713: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
714: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
715: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
716: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,

Line 713: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,

709: subkey_seed_in IN RAW,
710: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
711: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
712: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
713: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
714: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
715: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
716: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
717: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,

Line 714: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,

710: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
711: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
712: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
713: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
714: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
715: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
716: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
717: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
718: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,

Line 715: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,

711: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
712: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
713: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
714: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
715: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
716: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
717: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
718: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
719: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,

Line 716: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,

712: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,
713: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
714: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
715: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
716: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
717: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
718: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
719: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
720: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,

Line 717: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,

713: instr_owner_name_in IN iby_trxn_core.instr_owner_name%TYPE,
714: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
715: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
716: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
717: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
718: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
719: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
720: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
721: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,

Line 718: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,

714: instr_address_line1_in IN iby_trxn_core.instr_owner_address_line1%TYPE,
715: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
716: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
717: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
718: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
719: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
720: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
721: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
722: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,

Line 719: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,

715: instr_address_line2_in IN iby_trxn_core.instr_owner_address_line2%TYPE,
716: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
717: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
718: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
719: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
720: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
721: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
722: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
723: extend_names_in IN JTF_VARCHAR2_TABLE_100,

Line 720: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,

716: instr_address_line3_in IN iby_trxn_core.instr_owner_address_line3%TYPE,
717: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
718: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
719: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
720: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
721: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
722: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
723: extend_names_in IN JTF_VARCHAR2_TABLE_100,
724: extend_vals_in IN JTF_VARCHAR2_TABLE_200,

Line 721: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,

717: instr_city_in IN iby_trxn_core.instr_owner_city%TYPE,
718: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
719: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
720: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
721: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
722: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
723: extend_names_in IN JTF_VARCHAR2_TABLE_100,
724: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
725: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,

Line 722: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,

718: instr_state_in IN iby_trxn_core.instr_owner_state_province%TYPE,
719: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
720: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
721: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
722: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
723: extend_names_in IN JTF_VARCHAR2_TABLE_100,
724: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
725: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
726: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,

Line 753: l_expirydate iby_trxn_core.instr_expirydate%type;

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

Line 894: INSERT INTO iby_trxn_core

890: l_payer_party_id, l_process_profile_code,
891: iby_security_pkg.get_salt_version,'Y', settlement_date_in, settlement_due_date_in
892: );
893:
894: INSERT INTO iby_trxn_core
895: (TrxnMID, ReferenceCode, TraceNumber, InstrName,
896: Instr_Expirydate, Card_Subtype_Code,
897: Instr_Owner_Name, Instr_Owner_Address_Line1,
898: Instr_Owner_Address_Line2, Instr_Owner_Address_Line3,

Line 982: UPDATE iby_trxn_core

978: WHERE TrxnMID = l_trxn_mid;
979:
980: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;
981:
982: UPDATE iby_trxn_core
983: SET ReferenceCode = referencecode_in,
984: TraceNumber = trace_number_in,
985: InstrName = NVL(payment_name_in,InstrName),
986: Instr_Expirydate = instr_expirydate_in,

Line 1206: INSERT INTO iby_trxn_core

1202: fnd_global.login_id,1,l_cc_type,trxntypeid_in,trxnref_in,
1203: org_type_in, payment_channel_code_in, factored_flag_in,'Y');
1204:
1205:
1206: INSERT INTO iby_trxn_core
1207: (TrxnMID,
1208: last_update_date,last_updated_by,creation_date,created_by,
1209: last_update_login,object_version_number)
1210: VALUES (l_trxn_mid,

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

5502: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
5503:
5504:
5505: -- this insertion from close/query batch is problematic
5506: -- 1) there is no corresponding entry in ibY_trxn_core table
5507: -- 2) mtangible id might not be correct, there might not be
5508: -- an entry in iby_tangible table
5509: -- 3) currency, amount is missing
5510: -- regardless, this should be a rare case, it exists because

Line 5659: UPDATE iby_trxn_core

5655: last_update_login = fnd_global.login_id,
5656: object_version_number = object_version_number+1
5657: WHERE (trxnmid = l_trxn_mid);
5658:
5659: UPDATE iby_trxn_core
5660: SET AuthCode = authcode_in,
5661: ReferenceCode = referencecode_in,
5662: AVSCode = avscode_in,
5663: Acquirer = acquirer_in,

Line 5751: INSERT INTO iby_trxn_core

5747: vendor_code_in, vendor_message_in, error_location_in, org_id_in,
5748: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
5749: fnd_global.login_id,1,l_instrtype,l_instrsubtype,l_trxnref,'Y');
5750:
5751: INSERT INTO iby_trxn_core
5752: (TrxnMID, AuthCode, ReferenceCode, AVSCode, Acquirer, Auxmsg,
5753: TraceNumber, InstrName,
5754: last_update_date,last_updated_by,creation_date,created_by,last_update_login,
5755:

Line 5888: authcode_in IN iby_trxn_core.authcode%TYPE,

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

Line 5889: avscode_in IN iby_trxn_core.avscode%TYPE,

5885: bep_code_in IN iby_trxn_summaries_all.bepcode%TYPE,
5886: bep_msg_in IN iby_trxn_summaries_all.bepmessage%TYPE,
5887: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
5888: authcode_in IN iby_trxn_core.authcode%TYPE,
5889: avscode_in IN iby_trxn_core.avscode%TYPE,
5890: cvv2result_in IN iby_trxn_core.cvv2result%TYPE,
5891: trxnid_out OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE
5892: )
5893: IS

Line 5890: cvv2result_in IN iby_trxn_core.cvv2result%TYPE,

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

Line 5927: iby_trxn_core

5923: RETURN;
5924: END IF;
5925:
5926: UPDATE
5927: iby_trxn_core
5928: SET
5929: authcode=authcode_in,
5930: cvv2result=cvv2result_in,
5931: avscode=avscode_in

Line 5986: (ci_tracenumber iby_trxn_core.tracenumber%TYPE)

5982: AND (status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING)
5983: AND (mbatchid = ci_mbatchid);
5984:
5985: CURSOR c_tracenumber
5986: (ci_tracenumber iby_trxn_core.tracenumber%TYPE)
5987:
5988: IS
5989: SELECT ibc.trxnmid, ibs.transactionid
5990: FROM iby_trxn_summaries_all ibs,

Line 5991: iby_trxn_core ibc

5987:
5988: IS
5989: SELECT ibc.trxnmid, ibs.transactionid
5990: FROM iby_trxn_summaries_all ibs,
5991: iby_trxn_core ibc
5992: WHERE ibs.trxnmid=ibc.trxnmid
5993: AND ibc.tracenumber=ci_tracenumber;
5994:
5995: BEGIN

Line 6053: UPDATE iby_trxn_core

6049: last_updated_by = fnd_global.user_id,
6050: object_version_number = object_version_number + 1
6051: WHERE (trxnmid = l_tmid);
6052:
6053: UPDATE iby_trxn_core
6054: SET authcode = trxn_authcode_in(i),
6055: avscode = trxn_avscode_in(i),
6056: cvv2result = trxn_cvv2result_in(i),
6057: last_update_date = sysdate,

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

6467: AND (instrnum_sec_segment_id IS NULL);
6468:
6469:
6470: -- The below cursor will fetch all un-encrypted rows from
6471: -- IBY_TRXN_CORE table. Though we could probably have merged this
6472: -- cursor with the earlier one, we maintain a separate one since
6473: -- there could be records in this table that are un-encrypted but the
6474: -- corresponding records in iby_trxn_summaries_all are encrypted.
6475: CURSOR c_trxn_core

Line 6482: iby_trxn_core core

6478: tx.trxnmid tmid,
6479: core.instr_expirydate expdate,
6480: core.instr_owner_name chname
6481: FROM iby_trxn_summaries_all tx,
6482: iby_trxn_core core
6483: WHERE
6484: (DECODE(tx.instrtype, 'PINLESSDEBITCARD','CREDITCARD',
6485: 'PURCHASECARD','CREDITCARD',
6486: -- instrument type will be NULL for credit card credit trxns

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

6560:
6561: COMMIT;
6562: END IF;
6563:
6564: -- Loop thru the iby_trxn_core table only if the other card attributes
6565: -- present here need to be secured
6566: IF( IBY_CREDITCARD_PKG.Other_CC_Attribs_Encrypted = 'Y') THEN
6567: FOR core_rec IN c_trxn_core LOOP
6568: l_chname_sec_segment_id :=

Line 6588: UPDATE iby_trxn_core SET

6584: 'X'
6585: );
6586: l_encrypted := 'Y';
6587:
6588: UPDATE iby_trxn_core SET
6589: encrypted = 'Y',
6590: instr_owner_name = l_masked_chname,
6591: chname_sec_segment_id = l_chname_sec_segment_id,
6592: instr_expirydate = NULL,

Line 6665: FROM iby_trxn_core

6661: instr_expirydate,
6662: expiry_sec_segment_id,
6663: instr_owner_name,
6664: chname_sec_segment_id
6665: FROM iby_trxn_core
6666: WHERE NVL(encrypted, 'N') = 'Y';
6667:
6668: BEGIN
6669: IF (iby_creditcard_pkg.Get_CC_Encrypt_Mode() =

Line 6748: UPDATE iby_trxn_core SET

6744: -- CHNAME wasn't encrypted
6745: l_chname := core_rec.instr_owner_name;
6746: END IF;
6747:
6748: UPDATE iby_trxn_core SET
6749: encrypted = 'N',
6750: instr_owner_name = l_chname,
6751: chname_sec_segment_id = NULL,
6752: instr_expirydate = l_exp_date,