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 JTF_VARCHAR2_TABLE_100

Line 251: p_extend_names IN JTF_VARCHAR2_TABLE_100,

247: PROCEDURE insert_extensibility
248: (
249: p_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE,
250: p_commit IN VARCHAR2,
251: p_extend_names IN JTF_VARCHAR2_TABLE_100,
252: p_extend_vals IN JTF_VARCHAR2_TABLE_200
253: );
254:
255: /* Inserts a new row into the IBY_TRANSACTIONS table. This method */

Line 316: extend_names_in IN JTF_VARCHAR2_TABLE_100,

312: pos_entry_method_in IN iby_trxn_core.pos_entry_method_code%TYPE,
313: pos_card_id_method_in IN iby_trxn_core.pos_id_method_code%TYPE,
314: pos_auth_source_in IN iby_trxn_core.pos_auth_source_code%TYPE,
315: reader_data_in IN iby_trxn_core.reader_data%TYPE,
316: extend_names_in IN JTF_VARCHAR2_TABLE_100,
317: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
318: debit_network_code_in IN iby_trxn_core.debit_network_code%TYPE,
319: surcharge_amount_in IN iby_trxn_core.surcharge_amount%TYPE,
320: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,

Line 350: extend_names_in IN JTF_VARCHAR2_TABLE_100,

346: bepmessage_in IN iby_trxn_summaries_all.bepmessage%TYPE,
347: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,
348: tracenumber_in IN iby_trxn_core.tracenumber%TYPE,
349: authcode_in IN iby_trxn_core.authcode%TYPE,
350: extend_names_in IN JTF_VARCHAR2_TABLE_100,
351: extend_vals_in IN JTF_VARCHAR2_TABLE_200
352: );
353:
354:

Line 404: extend_names_in IN JTF_VARCHAR2_TABLE_100,

400: instr_country_in IN iby_trxn_core.instr_owner_country%TYPE,
401: instr_postalcode_in IN iby_trxn_core.instr_owner_postalcode%TYPE,
402: instr_phonenumber_in IN iby_trxn_core.instr_owner_phone%TYPE,
403: instr_email_in IN iby_trxn_core.instr_owner_email%TYPE,
404: extend_names_in IN JTF_VARCHAR2_TABLE_100,
405: extend_vals_in IN JTF_VARCHAR2_TABLE_200,
406: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
407: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,
408: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

Line 552: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

548: br_maturity_date%TYPE,
549: f_instr_type IN iby_trxn_summaries_all.
550: instrtype%TYPE,
551: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
552: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
553: );
554:
555: /* Overloaded form of the above API. This one takes an
556: Array of user profiles instead of a single one.

Line 560: profile_code_array IN JTF_VARCHAR2_TABLE_100,

556: Array of user profiles instead of a single one.
557: */
558: PROCEDURE insert_batch_status_new
559: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
560: profile_code_array IN JTF_VARCHAR2_TABLE_100,
561: merchant_id_in IN iby_batches_all.payeeid%TYPE,
562: vendor_id_in IN iby_batches_all.bepid%TYPE,
563: vendor_key_in IN iby_batches_all.bepkey%TYPE,
564: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 599: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

595: br_maturity_date%TYPE,
596: f_instr_type IN iby_trxn_summaries_all.
597: instrtype%TYPE,
598: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
599: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
600: );
601:
602:
603:

Line 801: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,

797: bep_code_in IN iby_batches_all.bepcode%TYPE,
798: bep_message_in IN iby_batches_all.bepmessage%TYPE,
799: error_location_in IN iby_batches_all.errorlocation%TYPE,
800: ack_type_in IN VARCHAR2,
801: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
802: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
803: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
804: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
805: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,

Line 802: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,

798: bep_message_in IN iby_batches_all.bepmessage%TYPE,
799: error_location_in IN iby_batches_all.errorlocation%TYPE,
800: ack_type_in IN VARCHAR2,
801: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
802: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
803: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
804: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
805: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
806: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,

Line 803: trxn_status_in IN JTF_VARCHAR2_TABLE_100,

799: error_location_in IN iby_batches_all.errorlocation%TYPE,
800: ack_type_in IN VARCHAR2,
801: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
802: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
803: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
804: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
805: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
806: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
807: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,

Line 804: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,

800: ack_type_in IN VARCHAR2,
801: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
802: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
803: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
804: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
805: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
806: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
807: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
808: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,

Line 805: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,

801: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
802: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
803: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
804: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
805: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
806: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
807: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
808: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
809: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,

Line 806: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,

802: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
803: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
804: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
805: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
806: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
807: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
808: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
809: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
810: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100

Line 807: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,

803: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
804: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
805: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
806: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
807: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
808: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
809: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
810: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
811: );

Line 808: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,

804: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
805: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
806: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
807: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
808: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
809: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
810: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
811: );
812:

Line 809: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,

805: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
806: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
807: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
808: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
809: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
810: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
811: );
812:
813:

Line 810: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100

806: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
807: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
808: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
809: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
810: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
811: );
812:
813:
814: FUNCTION unencrypt_instr_num

Line 982: profile_code_array IN JTF_VARCHAR2_TABLE_100,

978: | NOTES:
979: |
980: *---------------------------------------------------------------------*/
981: PROCEDURE performTransactionGrouping(
982: profile_code_array IN JTF_VARCHAR2_TABLE_100,
983: instr_type IN IBY_TRXN_SUMMARIES_ALL.
984: instrtype%TYPE,
985: req_type IN IBY_BATCHES_ALL.
986: reqtype%TYPE,