APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_TANGIBLE

Line 3602: TYPE TangibleTabType IS TABLE OF IBY_TANGIBLE%ROWTYPE

3598:
3599: l_TrxnCore_Tab TrxnCoreTabType;
3600: empty_TrxnCore_Tab TrxnCoreTabType;
3601:
3602: TYPE TangibleTabType IS TABLE OF IBY_TANGIBLE%ROWTYPE
3603: INDEX BY BINARY_INTEGER;
3604:
3605: -- This record would be used in the create_settlements API to update the PSON
3606: -- attribute of an extension.

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

4172: l_Trxn_Tab(indx).SALES_REP_PARTY_ID := l_settlement_trxn_rec.auth_SALES_REP_PARTY_ID;
4173: l_Trxn_Tab(indx).TRXNMID := l_settlement_trxn_rec.TRXNMID;
4174: l_Trxn_Tab(indx).TRANSACTIONID := l_settlement_trxn_rec.auth_transactionid;
4175: -- In the case of Bank Accounts and multiple authorizations,
4176: -- get tangible id from API and populate IBY_TANGIBLE table
4177: CASE (l_settlement_trxn_rec.auth_instrtype = BA_INSTR_TYPE
4178: AND l_settlement_trxn_rec.auth_count > 1)
4179: WHEN (TRUE) THEN
4180: print_debuginfo(l_module_name,'Calling IBY_FNDCPT_TRXN_PUB.Get_Tangible_Id...');

Line 4203: -- insert row into IBY_TANGIBLE

4199: l_Trxn_Tab(indx).TANGIBLEID := substr(l_tangibleid,0,80);
4200: print_debuginfo(l_module_name, 'Got Tangible Id '||
4201: l_Trxn_Tab(indx).TANGIBLEID);
4202:
4203: -- insert row into IBY_TANGIBLE
4204: SELECT IBY_TANGIBLE_S.NEXTVAL
4205: INTO l_mtangible
4206: FROM DUAL;
4207:

Line 4204: SELECT IBY_TANGIBLE_S.NEXTVAL

4200: print_debuginfo(l_module_name, 'Got Tangible Id '||
4201: l_Trxn_Tab(indx).TANGIBLEID);
4202:
4203: -- insert row into IBY_TANGIBLE
4204: SELECT IBY_TANGIBLE_S.NEXTVAL
4205: INTO l_mtangible
4206: FROM DUAL;
4207:
4208: print_debuginfo(l_module_name, 'Got MTtangible Id '

Line 4457: -- insert into IBY_TANGIBLE

4453: INSERT INTO IBY_TRXN_CORE VALUES l_TrxnCore_Tab(j);
4454: END IF;
4455:
4456: IF (l_Tangible_Tab.COUNT > 0) THEN
4457: -- insert into IBY_TANGIBLE
4458: FORALL j IN l_Tangible_Tab.first..l_Tangible_Tab.last
4459: INSERT INTO IBY_TANGIBLE VALUES l_Tangible_Tab(j);
4460: END IF;
4461:

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

4455:
4456: IF (l_Tangible_Tab.COUNT > 0) THEN
4457: -- insert into IBY_TANGIBLE
4458: FORALL j IN l_Tangible_Tab.first..l_Tangible_Tab.last
4459: INSERT INTO IBY_TANGIBLE VALUES l_Tangible_Tab(j);
4460: END IF;
4461:
4462: l_caOrdersTab := emptyOrdersTab;
4463: l_Trxn_Tab := empty_Trxn_Tab;