APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_DEALS_INTERFACE

Line 6: PROCEDURE TRANSFER_NI_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

2: /* $Header: xtrimnib.pls 120.1 2005/06/29 10:06:24 csutaria noship $*/
3:
4: /* Stub for consistency sake */
5: /*-------------------------------------------------------------------------------------*/
6: PROCEDURE TRANSFER_NI_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
7: user_error OUT NOCOPY BOOLEAN,
8: mandatory_error OUT NOCOPY BOOLEAN,
9: validation_error OUT NOCOPY BOOLEAN,
10: limit_error OUT NOCOPY BOOLEAN) is

Line 18: PROCEDURE TRANSFER_NI_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

14: TRANSFER_NI_DEALS(ARec_Interface,user_error,mandatory_error,validation_error,limit_error,v_dummy);
15: END;
16:
17: /*-------------------------------------------------------------------------------------*/
18: PROCEDURE TRANSFER_NI_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
19: user_error OUT NOCOPY BOOLEAN,
20: mandatory_error OUT NOCOPY BOOLEAN,
21: validation_error OUT NOCOPY BOOLEAN,
22: limit_error OUT NOCOPY BOOLEAN,

Line 27: l_risk_code_holder XTR_DEALS_INTERFACE.cparty_code%TYPE;

23: deal_num OUT NOCOPY NUMBER) is
24: /*-------------------------------------------------------------------------------------*/
25:
26: v_limit_log_return NUMBER;
27: l_risk_code_holder XTR_DEALS_INTERFACE.cparty_code%TYPE;
28:
29: BEGIN
30:
31: -------------------------

Line 142: delete from xtr_deals_interface

138:
139: /*----------------------------------------------------------------------------------*/
140: /* Since the insert is done, we can now delete the rows from the interface tables. */
141: /*----------------------------------------------------------------------------------*/
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

Line 152: update xtr_deals_interface

148: and deal_type = ARec_Interface.deal_type;
149:
150: else
151:
152: update xtr_deals_interface
153: set load_status_code = 'ERROR',
154: last_update_date = G_Curr_Date,
155: Last_Updated_by = g_user_id
156: where external_deal_id = ARec_Interface.external_deal_id

Line 167: PROCEDURE CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

163:
164: /*------------------------------------------------------------------------------*/
165: /* The following code implements the CHECK_MANDATORY_FIELDS process */
166: /*------------------------------------------------------------------------------*/
167: PROCEDURE CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
168: error OUT NOCOPY BOOLEAN) is
169: /*------------------------------------------------------------------------------*/
170: PROCEDURE CHECK_MANDATORY_TR_FIELDS IS
171:

Line 342: PROCEDURE VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

338:
339: /*------------------------------------------------------------------------*/
340: /* The following code implements the VALIDATE_DEALS process */
341: /*------------------------------------------------------------------------*/
342: PROCEDURE VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
343: error OUT NOCOPY BOOLEAN) is
344: /*------------------------------------------------------------------------*/
345: rate_error boolean := FALSE;
346: validity_error boolean := FALSE;

Line 371: PROCEDURE CHECK_VALIDITY(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

367:
368:
369:
370: /*-------------------------------------------------------------------------*/
371: PROCEDURE CHECK_VALIDITY(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
372: error OUT NOCOPY BOOLEAN) is
373: /*-------------------------------------------------------------------------*/
374:
375:

Line 1499: PROCEDURE CHECK_ACCRUAL_REVAL(ARec_interface IN xtr_deals_interface%ROWTYPE) IS

1495:
1496:
1497: /* ------------- END FIELD VALIDATION SECTION ------------------------------------*/
1498:
1499: PROCEDURE CHECK_ACCRUAL_REVAL(ARec_interface IN xtr_deals_interface%ROWTYPE) IS
1500:
1501: /*--------------------------------------------------------------------------------*/
1502: PROCEDURE CHK_TRANS_RATE(p_trans_rate IN VARCHAR2,
1503: p_currency IN VARCHAR2) is

Line 1640: PROCEDURE copy_from_interface_to_ni(ARec_Interface IN xtr_deals_interface%rowtype ) is

1636:
1637: /* ------------- BEGIN DATA POPULATION SECTION -----------------------------------*/
1638:
1639: /*------------------------------------------------------------------------------------------*/
1640: PROCEDURE copy_from_interface_to_ni(ARec_Interface IN xtr_deals_interface%rowtype ) is
1641: /*------------------------------------------------------------------------------------------*/
1642:
1643: CURSOR GET_RISKPARTY_CODE IS
1644: select a.cparty_code

Line 1915: PROCEDURE CALC_RATES(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

1911:
1912: /*------------------------------------------------------------*/
1913: /* The following code implements the calc_rates process */
1914: /*------------------------------------------------------------*/
1915: PROCEDURE CALC_RATES(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
1916: error OUT NOCOPY boolean) is
1917:
1918: l_bkr_amt_type varchar2(30);
1919: l_dummy_char varchar2(30);