DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONEFT_PKG dependencies on JTF_VARCHAR2_TABLE_100

Line 174: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

170: f_instr_type IN iby_trxn_summaries_all.
171: instrtype%TYPE,
172: numtrxns_out OUT NOCOPY NUMBER,
173: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
174: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
175: )
176: IS
177:
178: numrows NUMBER;

Line 194: batch_ids_out := JTF_VARCHAR2_TABLE_100();

190:
191: print_debuginfo(l_module_name, 'ENTER');
192:
193: mbatch_ids_out := JTF_NUMBER_TABLE();
194: batch_ids_out := JTF_VARCHAR2_TABLE_100();
195:
196: /*
197: * BEP and vendor related params.
198: */

Line 490: profile_code_array IN JTF_VARCHAR2_TABLE_100,

486: * will not allow any modification and cancellation to these transactions.
487: */
488: PROCEDURE createBatchCloseTrxnsNew(
489: merch_batchid_in IN VARCHAR2,
490: profile_code_array IN JTF_VARCHAR2_TABLE_100,
491: merchant_id_in IN VARCHAR2,
492: vendor_id_in IN NUMBER,
493: vendor_key_in IN VARCHAR2,
494: newstatus_in IN NUMBER,

Line 517: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

513: f_instr_type IN iby_trxn_summaries_all.
514: instrtype%TYPE,
515: numtrxns_out OUT NOCOPY NUMBER,
516: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
517: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
518: )
519: IS
520:
521: numrows NUMBER;

Line 550: batch_ids_out := JTF_VARCHAR2_TABLE_100();

546: /* Append the last profile code without comma at the end */
547: strProfCodes := strProfCodes||''''||profile_code_array(numProfCodes)||'''';
548:
549: mbatch_ids_out := JTF_NUMBER_TABLE();
550: batch_ids_out := JTF_VARCHAR2_TABLE_100();
551:
552: /*
553: * BEP and vendor related params.
554: */

Line 940: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,

936: /*Update the transactions status and other informations by passed the data in as array.*/
937: procedure updateTrxnResultStatus(i_merch_batchid IN VARCHAR2,
938: i_merchant_id IN VARCHAR2,
939: i_status_arr IN JTF_NUMBER_TABLE,
940: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
941: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
942: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
943: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
944: o_error_code OUT NOCOPY NUMBER,

Line 942: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,

938: i_merchant_id IN VARCHAR2,
939: i_status_arr IN JTF_NUMBER_TABLE,
940: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
941: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
942: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
943: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
944: o_error_code OUT NOCOPY NUMBER,
945: o_error_msg OUT NOCOPY VARCHAR2
946: )

Line 1017: i_payerid IN JTF_VARCHAR2_TABLE_100,

1013: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1014:
1015: i_payerinstrid IN JTF_NUMBER_TABLE,
1016: i_amount IN JTF_NUMBER_TABLE,
1017: i_payerid IN JTF_VARCHAR2_TABLE_100,
1018: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1019: i_currency IN JTF_VARCHAR2_TABLE_100,
1020: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1021: i_memo IN JTF_VARCHAR2_TABLE_100,

Line 1018: i_tangibleid IN JTF_VARCHAR2_TABLE_100,

1014:
1015: i_payerinstrid IN JTF_NUMBER_TABLE,
1016: i_amount IN JTF_NUMBER_TABLE,
1017: i_payerid IN JTF_VARCHAR2_TABLE_100,
1018: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1019: i_currency IN JTF_VARCHAR2_TABLE_100,
1020: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1021: i_memo IN JTF_VARCHAR2_TABLE_100,
1022: i_ordermedium IN JTF_VARCHAR2_TABLE_100,

Line 1019: i_currency IN JTF_VARCHAR2_TABLE_100,

1015: i_payerinstrid IN JTF_NUMBER_TABLE,
1016: i_amount IN JTF_NUMBER_TABLE,
1017: i_payerid IN JTF_VARCHAR2_TABLE_100,
1018: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1019: i_currency IN JTF_VARCHAR2_TABLE_100,
1020: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1021: i_memo IN JTF_VARCHAR2_TABLE_100,
1022: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1023: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,

Line 1020: i_refinfo IN JTF_VARCHAR2_TABLE_100,

1016: i_amount IN JTF_NUMBER_TABLE,
1017: i_payerid IN JTF_VARCHAR2_TABLE_100,
1018: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1019: i_currency IN JTF_VARCHAR2_TABLE_100,
1020: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1021: i_memo IN JTF_VARCHAR2_TABLE_100,
1022: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1023: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1024: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,

Line 1021: i_memo IN JTF_VARCHAR2_TABLE_100,

1017: i_payerid IN JTF_VARCHAR2_TABLE_100,
1018: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1019: i_currency IN JTF_VARCHAR2_TABLE_100,
1020: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1021: i_memo IN JTF_VARCHAR2_TABLE_100,
1022: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1023: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1024: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
1025: i_settledate IN JTF_DATE_TABLE,

Line 1022: i_ordermedium IN JTF_VARCHAR2_TABLE_100,

1018: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1019: i_currency IN JTF_VARCHAR2_TABLE_100,
1020: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1021: i_memo IN JTF_VARCHAR2_TABLE_100,
1022: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1023: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1024: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
1025: i_settledate IN JTF_DATE_TABLE,
1026: i_issuedate IN JTF_DATE_TABLE,

Line 1023: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,

1019: i_currency IN JTF_VARCHAR2_TABLE_100,
1020: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1021: i_memo IN JTF_VARCHAR2_TABLE_100,
1022: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1023: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1024: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
1025: i_settledate IN JTF_DATE_TABLE,
1026: i_issuedate IN JTF_DATE_TABLE,
1027: i_customerref IN JTF_VARCHAR2_TABLE_100,

Line 1024: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,

1020: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1021: i_memo IN JTF_VARCHAR2_TABLE_100,
1022: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1023: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1024: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
1025: i_settledate IN JTF_DATE_TABLE,
1026: i_issuedate IN JTF_DATE_TABLE,
1027: i_customerref IN JTF_VARCHAR2_TABLE_100,
1028: o_trxnId OUT NOCOPY JTF_NUMBER_TABLE

Line 1027: i_customerref IN JTF_VARCHAR2_TABLE_100,

1023: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1024: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
1025: i_settledate IN JTF_DATE_TABLE,
1026: i_issuedate IN JTF_DATE_TABLE,
1027: i_customerref IN JTF_VARCHAR2_TABLE_100,
1028: o_trxnId OUT NOCOPY JTF_NUMBER_TABLE
1029: )
1030: IS
1031: l_mtangibleid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();