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

173: PROCEDURE insert_extensibility
174: (
175: p_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE,
176: p_commit IN VARCHAR2,
177: p_extend_names IN JTF_VARCHAR2_TABLE_100,
178: p_extend_vals IN JTF_VARCHAR2_TABLE_200
179: )
180: IS
181: BEGIN

Line 266: extend_names_in IN JTF_VARCHAR2_TABLE_100,

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

Line 641: extend_names_in IN JTF_VARCHAR2_TABLE_100,

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
645: l_dbg_mod VARCHAR2(100) := 'IBY_TRANSACTIONCC_PKG' || '.insert_rev_result';

Line 864: extend_names_in IN JTF_VARCHAR2_TABLE_100,

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

Line 1756: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

1752: br_maturity_date%TYPE,
1753: f_instr_type IN iby_trxn_summaries_all.
1754: instrtype%TYPE,
1755: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
1756: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
1757: )
1758: IS
1759:
1760: numrows NUMBER;

Line 1806: batch_ids_out := JTF_VARCHAR2_TABLE_100();

1802: print_debuginfo(l_module_name, 'ENTER');
1803:
1804: END IF;
1805: mbatch_ids_out := JTF_NUMBER_TABLE();
1806: batch_ids_out := JTF_VARCHAR2_TABLE_100();
1807:
1808: /* First check if a row already exists for this batch status */
1809: SELECT
1810: COUNT(*)

Line 2350: profile_code_array IN JTF_VARCHAR2_TABLE_100,

2346: *---------------------------------------------------------------------*/
2347: PROCEDURE insert_batch_status_new
2348: (
2349: merch_batchid_in IN iby_batches_all.batchid%TYPE,
2350: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2351: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2352: vendor_id_in IN iby_batches_all.bepid%TYPE,
2353: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2354: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 2389: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

2385: br_maturity_date%TYPE,
2386: f_instr_type IN iby_trxn_summaries_all.
2387: instrtype%TYPE,
2388: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
2389: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
2390: )
2391: IS
2392:
2393: numrows NUMBER;

Line 2446: batch_ids_out := JTF_VARCHAR2_TABLE_100();

2442: print_debuginfo(l_module_name, 'ENTER: overloaded API.');
2443:
2444: END IF;
2445: mbatch_ids_out := JTF_NUMBER_TABLE();
2446: batch_ids_out := JTF_VARCHAR2_TABLE_100();
2447:
2448: /* Form a comma separated string for the profile codes */
2449: numProfiles := profile_code_array.count;
2450: FOR i IN 1..(numProfiles-1) LOOP

Line 4192: profile_code_array IN JTF_VARCHAR2_TABLE_100,

4188: | NOTES:
4189: |
4190: *---------------------------------------------------------------------*/
4191: PROCEDURE performTransactionGrouping(
4192: profile_code_array IN JTF_VARCHAR2_TABLE_100,
4193: instr_type IN IBY_TRXN_SUMMARIES_ALL.
4194: instrtype%TYPE,
4195: req_type IN IBY_BATCHES_ALL.
4196: reqtype%TYPE,

Line 6454: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,

6450: bep_code_in IN iby_batches_all.bepcode%TYPE,
6451: bep_message_in IN iby_batches_all.bepmessage%TYPE,
6452: error_location_in IN iby_batches_all.errorlocation%TYPE,
6453: ack_type_in IN VARCHAR2,
6454: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
6455: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
6456: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
6457: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
6458: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,

Line 6455: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,

6451: bep_message_in IN iby_batches_all.bepmessage%TYPE,
6452: error_location_in IN iby_batches_all.errorlocation%TYPE,
6453: ack_type_in IN VARCHAR2,
6454: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
6455: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
6456: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
6457: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
6458: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
6459: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,

Line 6456: trxn_status_in IN JTF_VARCHAR2_TABLE_100,

6452: error_location_in IN iby_batches_all.errorlocation%TYPE,
6453: ack_type_in IN VARCHAR2,
6454: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
6455: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
6456: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
6457: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
6458: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
6459: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
6460: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,

Line 6457: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,

6453: ack_type_in IN VARCHAR2,
6454: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
6455: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
6456: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
6457: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
6458: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
6459: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
6460: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
6461: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,

Line 6458: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,

6454: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
6455: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
6456: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
6457: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
6458: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
6459: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
6460: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
6461: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
6462: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,

Line 6459: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,

6455: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
6456: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
6457: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
6458: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
6459: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
6460: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
6461: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
6462: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
6463: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100

Line 6460: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,

6456: trxn_status_in IN JTF_VARCHAR2_TABLE_100,
6457: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
6458: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
6459: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
6460: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
6461: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
6462: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
6463: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
6464: )

Line 6461: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,

6457: trxn_bep_code_in IN JTF_VARCHAR2_TABLE_100,
6458: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
6459: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
6460: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
6461: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
6462: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
6463: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
6464: )
6465: IS

Line 6462: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,

6458: trxn_bep_msg_in IN JTF_VARCHAR2_TABLE_100,
6459: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
6460: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
6461: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
6462: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
6463: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
6464: )
6465: IS
6466: l_tmid iby_trxn_summaries_all.trxnmid%TYPE;

Line 6463: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100

6459: trxn_error_loc_in IN JTF_VARCHAR2_TABLE_100,
6460: trxn_authcode_in IN JTF_VARCHAR2_TABLE_100,
6461: trxn_avscode_in IN JTF_VARCHAR2_TABLE_100,
6462: trxn_cvv2result_in IN JTF_VARCHAR2_TABLE_100,
6463: trxn_tracenumber IN JTF_VARCHAR2_TABLE_100
6464: )
6465: IS
6466: l_tmid iby_trxn_summaries_all.trxnmid%TYPE;
6467: l_tid iby_trxn_summaries_all.transactionid%TYPE;