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 233: p_extend_names IN JTF_VARCHAR2_TABLE_100,

229: PROCEDURE insert_extensibility
230: (
231: p_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE,
232: p_commit IN VARCHAR2,
233: p_extend_names IN JTF_VARCHAR2_TABLE_100,
234: p_extend_vals IN JTF_VARCHAR2_TABLE_200
235: )
236: IS
237: BEGIN

Line 322: extend_names_in IN JTF_VARCHAR2_TABLE_100,

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,
326: proc_tracenumber_in IN iby_trxn_core.proc_tracenumber%TYPE,

Line 723: extend_names_in IN JTF_VARCHAR2_TABLE_100,

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,
727: org_type_in IN iby_trxn_summaries_all.org_type%TYPE,

Line 1548: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

1544: br_maturity_date%TYPE,
1545: f_instr_type IN iby_trxn_summaries_all.
1546: instrtype%TYPE,
1547: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
1548: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
1549: )
1550: IS
1551:
1552: numrows NUMBER;

Line 1596: batch_ids_out := JTF_VARCHAR2_TABLE_100();

1592:
1593: print_debuginfo(l_module_name, 'ENTER');
1594:
1595: mbatch_ids_out := JTF_NUMBER_TABLE();
1596: batch_ids_out := JTF_VARCHAR2_TABLE_100();
1597:
1598: /* First check if a row already exists for this batch status */
1599: SELECT
1600: COUNT(*)

Line 2120: profile_code_array IN JTF_VARCHAR2_TABLE_100,

2116: *---------------------------------------------------------------------*/
2117: PROCEDURE insert_batch_status_new
2118: (
2119: merch_batchid_in IN iby_batches_all.batchid%TYPE,
2120: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2121: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2122: vendor_id_in IN iby_batches_all.bepid%TYPE,
2123: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2124: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 2159: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

2155: br_maturity_date%TYPE,
2156: f_instr_type IN iby_trxn_summaries_all.
2157: instrtype%TYPE,
2158: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
2159: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
2160: )
2161: IS
2162:
2163: numrows NUMBER;

Line 2214: batch_ids_out := JTF_VARCHAR2_TABLE_100();

2210:
2211: print_debuginfo(l_module_name, 'ENTER: overloaded API.');
2212:
2213: mbatch_ids_out := JTF_NUMBER_TABLE();
2214: batch_ids_out := JTF_VARCHAR2_TABLE_100();
2215:
2216: /* Form a comma separated string for the profile codes */
2217: numProfiles := profile_code_array.count;
2218: FOR i IN 1..(numProfiles-1) LOOP

Line 3878: profile_code_array IN JTF_VARCHAR2_TABLE_100,

3874: | NOTES:
3875: |
3876: *---------------------------------------------------------------------*/
3877: PROCEDURE performTransactionGrouping(
3878: profile_code_array IN JTF_VARCHAR2_TABLE_100,
3879: instr_type IN IBY_TRXN_SUMMARIES_ALL.
3880: instrtype%TYPE,
3881: req_type IN IBY_BATCHES_ALL.
3882: reqtype%TYPE,

Line 5952: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,

5948: bep_code_in IN iby_batches_all.bepcode%TYPE,
5949: bep_message_in IN iby_batches_all.bepmessage%TYPE,
5950: error_location_in IN iby_batches_all.errorlocation%TYPE,
5951: ack_type_in IN VARCHAR2,
5952: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
5953: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
5954: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
5955: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
5956: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,

Line 5953: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,

5949: bep_message_in IN iby_batches_all.bepmessage%TYPE,
5950: error_location_in IN iby_batches_all.errorlocation%TYPE,
5951: ack_type_in IN VARCHAR2,
5952: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
5953: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
5954: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
5955: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
5956: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
5957: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,

Line 5954: trxn_status_in IN JTF_VARCHAR2_TABLE_100,

5950: error_location_in IN iby_batches_all.errorlocation%TYPE,
5951: ack_type_in IN VARCHAR2,
5952: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
5953: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
5954: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
5955: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
5956: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
5957: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
5958: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,

Line 5955: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,

5951: ack_type_in IN VARCHAR2,
5952: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
5953: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
5954: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
5955: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
5956: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
5957: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
5958: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
5959: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,

Line 5956: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,

5952: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
5953: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
5954: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
5955: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
5956: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
5957: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
5958: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
5959: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
5960: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,

Line 5957: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,

5953: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
5954: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
5955: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
5956: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
5957: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
5958: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
5959: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
5960: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
5961: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100

Line 5958: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,

5954: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
5955: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
5956: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
5957: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
5958: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
5959: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
5960: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
5961: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
5962: )

Line 5959: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,

5955: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
5956: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
5957: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
5958: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
5959: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
5960: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
5961: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
5962: )
5963: IS

Line 5960: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,

5956: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
5957: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
5958: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
5959: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
5960: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
5961: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
5962: )
5963: IS
5964: l_tmid iby_trxn_summaries_all.trxnmid%TYPE;

Line 5961: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100

5957: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
5958: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
5959: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
5960: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
5961: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
5962: )
5963: IS
5964: l_tmid iby_trxn_summaries_all.trxnmid%TYPE;
5965: l_tid iby_trxn_summaries_all.transactionid%TYPE;