DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONEFT_PKG dependencies on JTF_VARCHAR2_TABLE_100

Line 461: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

457: f_instr_type IN iby_trxn_summaries_all.
458: instrtype%TYPE,
459: numtrxns_out OUT NOCOPY NUMBER,
460: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
461: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
462: )
463: IS
464:
465: numrows NUMBER;

Line 485: batch_ids_out := JTF_VARCHAR2_TABLE_100();

481: print_debuginfo(l_module_name, 'ENTER');
482:
483: END IF;
484: mbatch_ids_out := JTF_NUMBER_TABLE();
485: batch_ids_out := JTF_VARCHAR2_TABLE_100();
486:
487: /*
488: * BEP and vendor related params.
489: */

Line 849: profile_code_array IN JTF_VARCHAR2_TABLE_100,

845: * will not allow any modification and cancellation to these transactions.
846: */
847: PROCEDURE createBatchCloseTrxnsNew(
848: merch_batchid_in IN VARCHAR2,
849: profile_code_array IN JTF_VARCHAR2_TABLE_100,
850: merchant_id_in IN VARCHAR2,
851: vendor_id_in IN NUMBER,
852: vendor_key_in IN VARCHAR2,
853: newstatus_in IN NUMBER,

Line 876: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

872: f_instr_type IN iby_trxn_summaries_all.
873: instrtype%TYPE,
874: numtrxns_out OUT NOCOPY NUMBER,
875: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
876: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
877: )
878: IS
879:
880: numrows NUMBER;

Line 912: batch_ids_out := JTF_VARCHAR2_TABLE_100();

908: /* Append the last profile code without comma at the end */
909: strProfCodes := strProfCodes||''''||profile_code_array(numProfCodes)||'''';
910:
911: mbatch_ids_out := JTF_NUMBER_TABLE();
912: batch_ids_out := JTF_VARCHAR2_TABLE_100();
913:
914: /*
915: * BEP and vendor related params.
916: */

Line 1383: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,

1379: /*Update the transactions status and other informations by passed the data in as array.*/
1380: procedure updateTrxnResultStatus(i_merch_batchid IN VARCHAR2,
1381: i_merchant_id IN VARCHAR2,
1382: i_status_arr IN JTF_NUMBER_TABLE,
1383: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
1384: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
1385: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
1386: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
1387: o_error_code OUT NOCOPY NUMBER,

Line 1385: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,

1381: i_merchant_id IN VARCHAR2,
1382: i_status_arr IN JTF_NUMBER_TABLE,
1383: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
1384: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
1385: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
1386: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
1387: o_error_code OUT NOCOPY NUMBER,
1388: o_error_msg OUT NOCOPY VARCHAR2
1389: )

Line 1460: i_payerid IN JTF_VARCHAR2_TABLE_100,

1456: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1457:
1458: i_payerinstrid IN JTF_NUMBER_TABLE,
1459: i_amount IN JTF_NUMBER_TABLE,
1460: i_payerid IN JTF_VARCHAR2_TABLE_100,
1461: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1462: i_currency IN JTF_VARCHAR2_TABLE_100,
1463: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1464: i_memo IN JTF_VARCHAR2_TABLE_100,

Line 1461: i_tangibleid IN JTF_VARCHAR2_TABLE_100,

1457:
1458: i_payerinstrid IN JTF_NUMBER_TABLE,
1459: i_amount IN JTF_NUMBER_TABLE,
1460: i_payerid IN JTF_VARCHAR2_TABLE_100,
1461: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1462: i_currency IN JTF_VARCHAR2_TABLE_100,
1463: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1464: i_memo IN JTF_VARCHAR2_TABLE_100,
1465: i_ordermedium IN JTF_VARCHAR2_TABLE_100,

Line 1462: i_currency IN JTF_VARCHAR2_TABLE_100,

1458: i_payerinstrid IN JTF_NUMBER_TABLE,
1459: i_amount IN JTF_NUMBER_TABLE,
1460: i_payerid IN JTF_VARCHAR2_TABLE_100,
1461: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1462: i_currency IN JTF_VARCHAR2_TABLE_100,
1463: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1464: i_memo IN JTF_VARCHAR2_TABLE_100,
1465: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1466: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,

Line 1463: i_refinfo IN JTF_VARCHAR2_TABLE_100,

1459: i_amount IN JTF_NUMBER_TABLE,
1460: i_payerid IN JTF_VARCHAR2_TABLE_100,
1461: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1462: i_currency IN JTF_VARCHAR2_TABLE_100,
1463: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1464: i_memo IN JTF_VARCHAR2_TABLE_100,
1465: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1466: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1467: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,

Line 1464: i_memo IN JTF_VARCHAR2_TABLE_100,

1460: i_payerid IN JTF_VARCHAR2_TABLE_100,
1461: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1462: i_currency IN JTF_VARCHAR2_TABLE_100,
1463: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1464: i_memo IN JTF_VARCHAR2_TABLE_100,
1465: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1466: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1467: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
1468: i_settledate IN JTF_DATE_TABLE,

Line 1465: i_ordermedium IN JTF_VARCHAR2_TABLE_100,

1461: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
1462: i_currency IN JTF_VARCHAR2_TABLE_100,
1463: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1464: i_memo IN JTF_VARCHAR2_TABLE_100,
1465: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1466: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1467: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
1468: i_settledate IN JTF_DATE_TABLE,
1469: i_issuedate IN JTF_DATE_TABLE,

Line 1466: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,

1462: i_currency IN JTF_VARCHAR2_TABLE_100,
1463: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1464: i_memo IN JTF_VARCHAR2_TABLE_100,
1465: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1466: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1467: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
1468: i_settledate IN JTF_DATE_TABLE,
1469: i_issuedate IN JTF_DATE_TABLE,
1470: i_customerref IN JTF_VARCHAR2_TABLE_100,

Line 1467: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,

1463: i_refinfo IN JTF_VARCHAR2_TABLE_100,
1464: i_memo IN JTF_VARCHAR2_TABLE_100,
1465: i_ordermedium IN JTF_VARCHAR2_TABLE_100,
1466: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1467: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
1468: i_settledate IN JTF_DATE_TABLE,
1469: i_issuedate IN JTF_DATE_TABLE,
1470: i_customerref IN JTF_VARCHAR2_TABLE_100,
1471: o_trxnId OUT NOCOPY JTF_NUMBER_TABLE

Line 1470: i_customerref IN JTF_VARCHAR2_TABLE_100,

1466: i_eftauthmethod IN JTF_VARCHAR2_TABLE_100,
1467: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
1468: i_settledate IN JTF_DATE_TABLE,
1469: i_issuedate IN JTF_DATE_TABLE,
1470: i_customerref IN JTF_VARCHAR2_TABLE_100,
1471: o_trxnId OUT NOCOPY JTF_NUMBER_TABLE
1472: )
1473: IS
1474: l_mtangibleid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();