APPS.XTR_FX_TRANSFERS_PKG dependencies on XTR_DEALS

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 30: select xtr_deals_s.nextval

26: l_limit_amount NUMBER;
27: v_limit_log_return NUMBER;
28:
29: cursor c_deal_no is
30: select xtr_deals_s.nextval
31: from dual;
32:
33: BEGIN
34:

Line 136: /* Call the insert procedure to insert into xtr_deals */

132: Fnd_Global.User_Id,
133: v_limit_log_return);
134:
135: /*----------------------------------------------------*/
136: /* Call the insert procedure to insert into xtr_deals */
137: /*----------------------------------------------------*/
138: CREATE_FX_DEAL(G_Fx_Main_Rec, deal_num);
139:
140: /*---------------------------------------------------------------------------------*/

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 575: if not ( xtr_import_deal_data.val_desc_flex(ARec_Interface,'XTR_DEALS_DESC_FLEX',l_err_segment)) then

571: /*-------------------------------------------------------------------------------*/
572: /* Flexfields Validation */
573: /*-------------------------------------------------------------------------------*/
574:
575: if not ( xtr_import_deal_data.val_desc_flex(ARec_Interface,'XTR_DEALS_DESC_FLEX',l_err_segment)) then
576: l_error := l_error +1;
577: if l_err_segment is not null and l_err_segment = 'Attribute16' then
578: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
579: ARec_Interface.Deal_Type,

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 1076: IF fnd_flex_descval.validate_desccols('XTR','XTR_DEALS_DESC_FLEX') then

1072: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_Interface_Rec.ATTRIBUTE15);
1073:
1074: fnd_flex_descval.set_context_value(p_Interface_Rec.ATTRIBUTE_CATEGORY);
1075:
1076: IF fnd_flex_descval.validate_desccols('XTR','XTR_DEALS_DESC_FLEX') then
1077: if (fnd_flex_descval.is_valid) then
1078: null;
1079: else
1080: --RV l_segment := to_char(fnd_flex_descval.error_segment) ;

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);

Line 1661: PROCEDURE CREATE_FX_DEAL(ARec_Fx IN XTR_DEALS%ROWTYPE,

1657: END CHK_BUY_SELL_AMOUNT;
1658:
1659:
1660: /*------------------------------------------------------------*/
1661: PROCEDURE CREATE_FX_DEAL(ARec_Fx IN XTR_DEALS%ROWTYPE,
1662: p_deal_no IN NUMBER) IS
1663: /*------------------------------------------------------------*/
1664:
1665: cursor FIND_USER (p_fnd_user in number) is

Line 1691: INSERT INTO xtr_deals

1687: l_dual_user := l_user;
1688: end if;
1689: end if;
1690:
1691: INSERT INTO xtr_deals
1692: (
1693: EXTERNAL_DEAL_ID ,
1694: DEAL_NO ,
1695: DEAL_TYPE ,

Line 1841: UPDATE xtr_deals

1837: SET confirmation_validated_by = l_dual_user,
1838: confirmation_validated_on = l_dual_date
1839: WHERE deal_no = p_deal_no;
1840:
1841: UPDATE xtr_deals
1842: SET dual_authorisation_on = l_dual_date
1843: WHERE deal_no = p_deal_no;
1844: end if;
1845: