APPS.XTR_FX_TRANSFERS_PKG dependencies on XTR_DEALS_INTERFACE

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

2: /* $Header: xtrimfxb.pls 120.5 2005/06/29 09:22:27 badiredd ship $*/
3:
4: /* Stub for backwards compatability */
5: /*-------------------------------------------------------------------------------------*/
6: PROCEDURE TRANSFER_FX_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_FX_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

14: TRANSFER_FX_DEALS(ARec_Interface,user_error,mandatory_error,validation_error,limit_error,v_dummy);
15: END TRANSFER_FX_DEALS;
16:
17: /*-------------------------------------------------------------------------------------*/
18: PROCEDURE TRANSFER_FX_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 143: delete from xtr_deals_interface

139:
140: /*---------------------------------------------------------------------------------*/
141: /* Since the insert is done, we can now delete the rows from the interface table. */
142: /*---------------------------------------------------------------------------------*/
143: delete from xtr_deals_interface
144: where external_deal_id = ARec_Interface.external_deal_id
145: and deal_type = ARec_Interface.deal_type;
146:
147: else

Line 149: update xtr_deals_interface

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

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

193:
194: /*------------------------------------------------------------------------------*/
195: /* The following code implements the CHECK_MANDATORY_FIELDS process */
196: /*------------------------------------------------------------------------------*/
197: PROCEDURE CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
198: error OUT NOCOPY BOOLEAN) is
199: /*------------------------------------------------------------------------------*/
200: BEGIN
201:

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

305:
306: /*------------------------------------------------------------------------*/
307: /* The following code implements the VALIDATE_DEALS process */
308: /*------------------------------------------------------------------------*/
309: PROCEDURE VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
310: error OUT NOCOPY BOOLEAN) is
311: /*------------------------------------------------------------------------*/
312: rate_error boolean := FALSE;
313: validity_error boolean := FALSE;

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

334:
335:
336:
337: /*-------------------------------------------------------------------------*/
338: PROCEDURE CHECK_VALIDITY(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
339: error OUT NOCOPY BOOLEAN) is
340: /*-------------------------------------------------------------------------*/
341:
342: l_error number := 0;

Line 1050: --FUNCTION val_desc_flex( p_Interface_Rec IN XTR_DEALS_INTERFACE%ROWTYPE,

1046: return(TRUE);
1047: END val_brokerage_currency;
1048:
1049: /*--------------------------------------------------------------------------------*/
1050: --FUNCTION val_desc_flex( p_Interface_Rec IN XTR_DEALS_INTERFACE%ROWTYPE,
1051: -- p_error_segment IN OUT NOCOPY VARCHAR2) return BOOLEAN is
1052: /*--------------------------------------------------------------------------------*/
1053: /*
1054: l_segment number(3);

Line 1116: PROCEDURE copy_from_interface_to_fx(ARec_Interface IN xtr_deals_interface%rowtype ) is

1112: END val_desc_flex;
1113: */
1114:
1115: /*------------------------------------------------------------------------------------------*/
1116: PROCEDURE copy_from_interface_to_fx(ARec_Interface IN xtr_deals_interface%rowtype ) is
1117: /*------------------------------------------------------------------------------------------*/
1118: l_deal_subtype varchar2(10);
1119: BEGIN
1120:

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

1258:
1259: /*------------------------------------------------------------*/
1260: /* The following code implements the calc_rates process */
1261: /*------------------------------------------------------------*/
1262: PROCEDURE CALC_RATES(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
1263: error OUT NOCOPY boolean) is
1264:
1265: l_bkr_amt_type varchar2(30);
1266: l_dummy_char varchar2(30);