DBA Data[Home] [Help]

APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_TRANSACTIONS_INTERFACE

Line 146: delete from xtr_transactions_interface

142: delete from xtr_deals_interface
143: where external_deal_id = ARec_Interface.external_deal_id
144: and deal_type = ARec_Interface.deal_type;
145:
146: delete from xtr_transactions_interface
147: where external_deal_id = ARec_Interface.external_deal_id
148: and deal_type = ARec_Interface.deal_type;
149:
150: else

Line 174: FROM XTR_TRANSACTIONS_INTERFACE

170: PROCEDURE CHECK_MANDATORY_TR_FIELDS IS
171:
172: CURSOR GET_TRANSACTIONS IS
173: SELECT *
174: FROM XTR_TRANSACTIONS_INTERFACE
175: WHERE EXTERNAL_DEAL_ID = ARec_Interface.external_deal_id
176: AND DEAL_TYPE = ARec_Interface.deal_type;
177:
178: l_has_transactions boolean:=false;

Line 389: FROM XTR_TRANSACTIONS_INTERFACE

385: PROCEDURE VALIDATE_TRANSACTIONS IS
386:
387: CURSOR GET_TRANSACTIONS IS
388: SELECT *
389: FROM XTR_TRANSACTIONS_INTERFACE
390: WHERE EXTERNAL_DEAL_ID = ARec_Interface.external_deal_id
391: AND DEAL_TYPE = ARec_Interface.deal_type;
392:
393: BEGIN

Line 1662: FROM XTR_TRANSACTIONS_INTERFACE

1658:
1659: PROCEDURE COPY_TR_FROM_INTERFACE IS
1660: CURSOR GET_TRANSACTIONS IS
1661: SELECT *
1662: FROM XTR_TRANSACTIONS_INTERFACE
1663: WHERE EXTERNAL_DEAL_ID = ARec_Interface.external_deal_id
1664: AND DEAL_TYPE = ARec_Interface.deal_type;
1665:
1666: