APPS.IBY_TRANSACTIONEFT_PKG dependencies on IBY_TANGIBLE

Line 1484: SELECT iby_tangible_s.nextval

1480: SELECT iby_trxnsumm_mid_s.nextval
1481: FROM DUAL;
1482:
1483: CURSOR c_mtangibleid IS
1484: SELECT iby_tangible_s.nextval
1485: FROM DUAL;
1486:
1487: BEGIN
1488: /**

Line 1551: * Create tangible records in iby_tangible.

1547:
1548: END LOOP;
1549:
1550: /**
1551: * Create tangible records in iby_tangible.
1552: */
1553: FOR j IN i_tangibleid.FIRST..i_tangibleid.LAST LOOP
1554:
1555: /**

Line 1566: INSERT INTO iby_tangible

1562: and UPPER(reqType) = UPPER(i_reqType);
1563:
1564: IF (l_count=0) THEN
1565:
1566: INSERT INTO iby_tangible
1567: (
1568: mtangibleId, tangibleid, amount,
1569: currencyNameCode, refinfo, memo, issuedate,
1570: order_medium, eft_auth_method,

Line 1623: UPDATE iby_tangible

1619: * it has to be in a failed status, as 'requestExists' has already
1620: * been checked, hence updating the duplicate failed request.
1621: */
1622:
1623: UPDATE iby_tangible
1624: set mtangibleId = l_mtangibleid(j),
1625: amount = i_amount(j),
1626: currencyNameCode = i_currency(j),
1627: refinfo = i_refinfo(j),

Line 1705: i_refinfo IN iby_tangible.refinfo%TYPE,

1701: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1702: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1703: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1704: i_status IN iby_trxn_summaries_all.status%TYPE,
1705: i_refinfo IN iby_tangible.refinfo%TYPE,
1706: i_memo IN iby_tangible.memo%TYPE,
1707: i_acctno IN iby_tangible.acctno%TYPE,
1708: i_ordermedium IN iby_tangible.order_medium%TYPE,
1709: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,

Line 1706: i_memo IN iby_tangible.memo%TYPE,

1702: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1703: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1704: i_status IN iby_trxn_summaries_all.status%TYPE,
1705: i_refinfo IN iby_tangible.refinfo%TYPE,
1706: i_memo IN iby_tangible.memo%TYPE,
1707: i_acctno IN iby_tangible.acctno%TYPE,
1708: i_ordermedium IN iby_tangible.order_medium%TYPE,
1709: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1710: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,

Line 1707: i_acctno IN iby_tangible.acctno%TYPE,

1703: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1704: i_status IN iby_trxn_summaries_all.status%TYPE,
1705: i_refinfo IN iby_tangible.refinfo%TYPE,
1706: i_memo IN iby_tangible.memo%TYPE,
1707: i_acctno IN iby_tangible.acctno%TYPE,
1708: i_ordermedium IN iby_tangible.order_medium%TYPE,
1709: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1710: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1711: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,

Line 1708: i_ordermedium IN iby_tangible.order_medium%TYPE,

1704: i_status IN iby_trxn_summaries_all.status%TYPE,
1705: i_refinfo IN iby_tangible.refinfo%TYPE,
1706: i_memo IN iby_tangible.memo%TYPE,
1707: i_acctno IN iby_tangible.acctno%TYPE,
1708: i_ordermedium IN iby_tangible.order_medium%TYPE,
1709: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1710: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1711: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1712: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,

Line 1709: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,

1705: i_refinfo IN iby_tangible.refinfo%TYPE,
1706: i_memo IN iby_tangible.memo%TYPE,
1707: i_acctno IN iby_tangible.acctno%TYPE,
1708: i_ordermedium IN iby_tangible.order_medium%TYPE,
1709: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1710: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1711: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1712: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1713: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,

Line 1839: --Create an entry in iby_tangible table

1835:
1836: END IF;
1837:
1838: IF (NVL(l_trxn_exists, 'N') = 'N') THEN
1839: --Create an entry in iby_tangible table
1840: iby_bill_pkg.createBill(
1841: i_tangibleid, -- IN i_billId
1842: i_amount, -- IN i_billAmount
1843: i_currency, -- IN i_billCurDef

Line 1950: -- Update iby_tangible table

1946:
1947: ELSE
1948: -- A transaction is already created.
1949:
1950: -- Update iby_tangible table
1951:
1952: iby_bill_pkg.modBill(
1953: l_mtangibleid, -- IN i_mtangibleid
1954: i_tangibleid, -- IN i_billId