APPS.XTR_EXP_TRANSFERS_PKG dependencies on XTR_DEALS_INTERFACE

Line 726: This procedure maps the XTR_DEALS_INTERFACE to XTR_EXPOSURE_TRANSACTIONS

722:
723:
724:
725: /*------------------------------------------------------------------------
726: This procedure maps the XTR_DEALS_INTERFACE to XTR_EXPOSURE_TRANSACTIONS
727: table.
728: ------------------------------------------------------------------------*/
729: procedure COPY_FROM_INTERFACE_TO_EXP
730: (ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,

Line 730: (ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,

726: This procedure maps the XTR_DEALS_INTERFACE to XTR_EXPOSURE_TRANSACTIONS
727: table.
728: ------------------------------------------------------------------------*/
729: procedure COPY_FROM_INTERFACE_TO_EXP
730: (ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,
731: p_error OUT NOCOPY BOOLEAN) IS
732:
733: v_fx_rate NUMBER;
734:

Line 967: procedure CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype

963: This procedure is used to check whether all the mandatory fields are
964: NOT NULL.
965: If there is error then log the error.
966: ------------------------------------------------------------------------*/
967: procedure CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype
968: ,p_error OUT NOCOPY BOOLEAN) IS
969:
970: BEGIN
971: IF xtr_risk_debug_pkg.g_Debug THEN

Line 1051: procedure VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,

1047:
1048: /*------------------------------------------------------------------------
1049: This procedure validates the business logic for the deal items.
1050: ------------------------------------------------------------------------*/
1051: procedure VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,
1052: p_error OUT NOCOPY BOOLEAN) IS
1053:
1054: -- v_holiday_level VARCHAR2(1);
1055: -- v_holiday_error NUMBER;

Line 1533: -- UPDATE Xtr_Deals_Interface

1529: --otherwise be deleted from the list
1530:
1531: --exception
1532: -- when OTHERS then
1533: -- UPDATE Xtr_Deals_Interface
1534: -- SET Load_Status_Code='ERROR'
1535: -- WHERE External_Deal_Id=Arec_Exp.External_Deal_Id;
1536:
1537: END CREATE_EXP_DEAL;

Line 1685: procedure TRANSFER_EXP_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,

1681: the concurrent program.
1682: p_source = CONC (if called from CONC Program for Deal Import)
1683: Stub for backwards compatibility
1684: ------------------------------------------------------------------------*/
1685: procedure TRANSFER_EXP_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,
1686: p_source IN VARCHAR2,
1687: user_error OUT NOCOPY BOOLEAN,
1688: mandatory_error OUT NOCOPY BOOLEAN,
1689: validation_error OUT NOCOPY BOOLEAN,

Line 1703: procedure TRANSFER_EXP_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,

1699: This procedure is used to transfer EXP deals for the open API from
1700: the concurrent program.
1701: p_source = CONC (if called from CONC Program for Deal Import)
1702: ------------------------------------------------------------------------*/
1703: procedure TRANSFER_EXP_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,
1704: p_source IN VARCHAR2,
1705: user_error OUT NOCOPY BOOLEAN,
1706: mandatory_error OUT NOCOPY BOOLEAN,
1707: validation_error OUT NOCOPY BOOLEAN,

Line 1817: delete from xtr_deals_interface

1813: --Since the insert is done, we can now delete the rows from the
1814: --interface table.
1815: --
1816: if G_Source is null then
1817: delete from xtr_deals_interface
1818: where external_deal_id = ARec_Interface.external_deal_id
1819: and deal_type = ARec_Interface.deal_type;
1820: end if;
1821:

Line 1827: update xtr_deals_interface

1823: /*---------------------------------------------*/
1824: /* Deal interface has error. Do not import. */
1825: /*---------------------------------------------*/
1826: if G_Source is null then
1827: update xtr_deals_interface
1828: set load_status_code = 'ERROR',
1829: last_update_date = G_curr_date,
1830: last_Updated_by = G_user_id
1831: where external_deal_id = ARec_Interface.external_deal_id