APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_TANGIBLE

Line 4397: TYPE TangibleTabType IS TABLE OF IBY_TANGIBLE%ROWTYPE

4393:
4394: l_TrxnCore_Tab TrxnCoreTabType;
4395: empty_TrxnCore_Tab TrxnCoreTabType;
4396:
4397: TYPE TangibleTabType IS TABLE OF IBY_TANGIBLE%ROWTYPE
4398: INDEX BY BINARY_INTEGER;
4399:
4400: -- This record would be used in the create_settlements API to update the PSON
4401: -- attribute of an extension.

Line 5047: -- get tangible id from API and populate IBY_TANGIBLE table

5043: l_Trxn_Tab(indx).SALES_REP_PARTY_ID := l_settlement_trxn_rec.auth_SALES_REP_PARTY_ID;
5044: l_Trxn_Tab(indx).TRXNMID := l_settlement_trxn_rec.TRXNMID;
5045: l_Trxn_Tab(indx).TRANSACTIONID := l_settlement_trxn_rec.auth_transactionid;
5046: -- In the case of Bank Accounts and multiple authorizations,
5047: -- get tangible id from API and populate IBY_TANGIBLE table
5048: CASE (l_settlement_trxn_rec.auth_instrtype = BA_INSTR_TYPE
5049: AND l_settlement_trxn_rec.auth_count > 1)
5050: WHEN (TRUE) THEN
5051: print_debuginfo(l_module_name,'Calling IBY_FNDCPT_TRXN_PUB.Get_Tangible_Id...');

Line 5074: -- insert row into IBY_TANGIBLE

5070: l_Trxn_Tab(indx).TANGIBLEID := substr(l_tangibleid,0,80);
5071: print_debuginfo(l_module_name, 'Got Tangible Id '||
5072: l_Trxn_Tab(indx).TANGIBLEID);
5073:
5074: -- insert row into IBY_TANGIBLE
5075: SELECT IBY_TANGIBLE_S.NEXTVAL
5076: INTO l_mtangible
5077: FROM DUAL;
5078:

Line 5075: SELECT IBY_TANGIBLE_S.NEXTVAL

5071: print_debuginfo(l_module_name, 'Got Tangible Id '||
5072: l_Trxn_Tab(indx).TANGIBLEID);
5073:
5074: -- insert row into IBY_TANGIBLE
5075: SELECT IBY_TANGIBLE_S.NEXTVAL
5076: INTO l_mtangible
5077: FROM DUAL;
5078:
5079: print_debuginfo(l_module_name, 'Got MTtangible Id '

Line 5487: -- insert into IBY_TANGIBLE

5483: INSERT INTO IBY_TRXN_CORE VALUES l_TrxnCore_Tab(j);
5484: END IF;
5485:
5486: IF (l_Tangible_Tab.COUNT > 0) THEN
5487: -- insert into IBY_TANGIBLE
5488: FORALL j IN l_Tangible_Tab.first..l_Tangible_Tab.last
5489: INSERT INTO IBY_TANGIBLE VALUES l_Tangible_Tab(j);
5490: END IF;
5491:

Line 5489: INSERT INTO IBY_TANGIBLE VALUES l_Tangible_Tab(j);

5485:
5486: IF (l_Tangible_Tab.COUNT > 0) THEN
5487: -- insert into IBY_TANGIBLE
5488: FORALL j IN l_Tangible_Tab.first..l_Tangible_Tab.last
5489: INSERT INTO IBY_TANGIBLE VALUES l_Tangible_Tab(j);
5490: END IF;
5491:
5492: l_caOrdersTab := emptyOrdersTab;
5493: l_Trxn_Tab := empty_Trxn_Tab;

Line 6148: iby_tangible tg,

6144: auth.factored_flag, auth.ar_receipt_method_id
6145: FROM iby_fndcpt_tx_extensions xt,
6146: iby_fndcpt_tx_operations op,
6147: iby_trxn_summaries_all auth,
6148: iby_tangible tg,
6149: iby_trxn_core core,
6150: iby_bepinfo bep,
6151: iby_creditcard_issuers_b brand
6152: WHERE (xt.trxn_extension_id = ci_extension_id)