DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONEFT_PKG dependencies on JTF_NUMBER_TABLE

Line 173: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,

169: br_maturity_date%TYPE,
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:

Line 193: mbatch_ids_out := JTF_NUMBER_TABLE();

189: BEGIN
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.

Line 516: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,

512: br_maturity_date%TYPE,
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:

Line 549: mbatch_ids_out := JTF_NUMBER_TABLE();

545: END LOOP;
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.

Line 939: i_status_arr IN JTF_NUMBER_TABLE,

935:
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,

Line 943: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,

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: )
947:

Line 956: o_status_arr := JTF_NUMBER_TABLE();

952: c_SUCCESS NUMBER := 0;
953:
954: BEGIN
955:
956: o_status_arr := JTF_NUMBER_TABLE();
957: o_status_arr.extend( i_tangibleId_arr.count );
958:
959: o_error_code := 0;
960:

Line 1015: i_payerinstrid IN JTF_NUMBER_TABLE,

1011: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1012: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
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,

Line 1016: i_amount IN JTF_NUMBER_TABLE,

1012: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
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,

Line 1028: o_trxnId OUT NOCOPY JTF_NUMBER_TABLE

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();
1032: l_trxnmid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1031: l_mtangibleid JTF_NUMBER_TABLE := JTF_NUMBER_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();
1032: l_trxnmid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1033: l_mpayeeid iby_payee.mpayeeid%TYPE;
1034: l_count NUMBER;
1035:

Line 1032: l_trxnmid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1028: o_trxnId OUT NOCOPY JTF_NUMBER_TABLE
1029: )
1030: IS
1031: l_mtangibleid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1032: l_trxnmid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1033: l_mpayeeid iby_payee.mpayeeid%TYPE;
1034: l_count NUMBER;
1035:
1036: CURSOR c_trxnmid IS

Line 1072: o_trxnid := JTF_NUMBER_TABLE();

1068:
1069: l_mtangibleid.EXTEND(i_tangibleid.COUNT);
1070: l_trxnmid.EXTEND(i_tangibleid.COUNT);
1071:
1072: o_trxnid := JTF_NUMBER_TABLE();
1073: o_trxnid.EXTEND(i_tangibleid.COUNT);
1074:
1075: /**
1076: * Obtain the master payeeid for the given payee.