[Home] [Help]
456: br_maturity_date%TYPE,
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:
480: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
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.
871: br_maturity_date%TYPE,
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:
907: END LOOP;
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.
1378:
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,
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: )
1390:
1395: c_SUCCESS NUMBER := 0;
1396:
1397: BEGIN
1398:
1399: o_status_arr := JTF_NUMBER_TABLE();
1400: o_status_arr.extend( i_tangibleId_arr.count );
1401:
1402: o_error_code := 0;
1403:
1454: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1455: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
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,
1455: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
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,
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();
1475: l_trxnmid JTF_NUMBER_TABLE := JTF_NUMBER_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();
1475: l_trxnmid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1476: l_mpayeeid iby_payee.mpayeeid%TYPE;
1477: l_count NUMBER;
1478:
1471: o_trxnId OUT NOCOPY JTF_NUMBER_TABLE
1472: )
1473: IS
1474: l_mtangibleid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1475: l_trxnmid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1476: l_mpayeeid iby_payee.mpayeeid%TYPE;
1477: l_count NUMBER;
1478:
1479: CURSOR c_trxnmid IS
1511:
1512: l_mtangibleid.EXTEND(i_tangibleid.COUNT);
1513: l_trxnmid.EXTEND(i_tangibleid.COUNT);
1514:
1515: o_trxnid := JTF_NUMBER_TABLE();
1516: o_trxnid.EXTEND(i_tangibleid.COUNT);
1517:
1518: /**
1519: * Obtain the master payeeid for the given payee.