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 JTF_VARCHAR2_TABLE_100

Line 173: p_extend_names IN JTF_VARCHAR2_TABLE_100,

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: );
176:
177: /* Inserts a new row into the IBY_TRANSACTIONS table. This method */

Line 238: extend_names_in IN JTF_VARCHAR2_TABLE_100,

234: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
235: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
236: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
237: reader_data_in IN iby_trxn_core.reader_data%TYPE,
238: extend_names_in IN JTF_VARCHAR2_TABLE_100,
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,

Line 303: extend_names_in IN JTF_VARCHAR2_TABLE_100,

299: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
300: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%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,

Line 448: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

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: );
450:
451: /* Overloaded form of the above API. This one takes an
452: Array of user profiles instead of a single one.

Line 456: profile_code_array IN JTF_VARCHAR2_TABLE_100,

452: Array of user profiles instead of a single one.
453: */
454: PROCEDURE insert_batch_status_new
455: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
456: profile_code_array IN JTF_VARCHAR2_TABLE_100,
457: merchant_id_in IN iby_batches_all.payeeid%TYPE,
458: vendor_id_in IN iby_batches_all.bepid%TYPE,
459: vendor_key_in IN iby_batches_all.bepkey%TYPE,
460: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 495: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

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: );
497:
498:
499:

Line 697: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,

693: bep_code_in IN iby_batches_all.bepcode%TYPE,
694: bep_message_in IN iby_batches_all.bepmessage%TYPE,
695: error_location_in IN iby_batches_all.errorlocation%TYPE,
696: ack_type_in IN VARCHAR2,
697: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
698: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
699: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
700: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
701: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,

Line 698: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,

694: bep_message_in IN iby_batches_all.bepmessage%TYPE,
695: error_location_in IN iby_batches_all.errorlocation%TYPE,
696: ack_type_in IN VARCHAR2,
697: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
698: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
699: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
700: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
701: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
702: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,

Line 699: trxn_status_in IN JTF_VARCHAR2_TABLE_100,

695: error_location_in IN iby_batches_all.errorlocation%TYPE,
696: ack_type_in IN VARCHAR2,
697: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
698: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
699: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
700: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
701: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
702: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
703: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,

Line 700: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,

696: ack_type_in IN VARCHAR2,
697: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
698: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
699: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
700: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
701: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
702: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
703: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
704: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,

Line 701: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,

697: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
698: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
699: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
700: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
701: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
702: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
703: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
704: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
705: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,

Line 702: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,

698: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
699: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
700: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
701: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
702: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
703: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
704: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
705: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
706: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100

Line 703: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,

699: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
700: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
701: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
702: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
703: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
704: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
705: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
706: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
707: );

Line 704: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,

700: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
701: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
702: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
703: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
704: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
705: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
706: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
707: );
708:

Line 705: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,

701: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
702: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
703: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
704: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
705: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
706: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
707: );
708:
709:

Line 706: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100

702: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
703: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
704: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
705: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
706: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
707: );
708:
709:
710: FUNCTION unencrypt_instr_num

Line 878: profile_code_array IN JTF_VARCHAR2_TABLE_100,

874: | NOTES:
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,