eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_IMPORT_DEAL_DATA dependencies on XTR_DEALS

Line 91: /* check for duplicate External Deal ID in XTR_DEALS */

87: l_count NUMBER;
88:
89: begin
90:
91: /* check for duplicate External Deal ID in XTR_DEALS */
92: if p_deal_type = 'FX' then
93: select count(*)
94: into l_count
95: from XTR_DEALS

Line 95: from XTR_DEALS

91: /* check for duplicate External Deal ID in XTR_DEALS */
92: if p_deal_type = 'FX' then
93: select count(*)
94: into l_count
95: from XTR_DEALS
96: where external_deal_id = p_external_deal_id
97: and deal_type = p_deal_type
98: and status_code <> 'CANCELLED';
99:

Line 109: from XTR_DEALS

105:
106: elsif p_deal_type = 'NI' then
107: select count(*)
108: into l_count
109: from XTR_DEALS
110: where external_deal_id = p_external_deal_id
111: and deal_type = p_deal_type
112: and status_code <> 'CANCELLED';
113:

Line 123: update xtr_deals_interface

119: error := FALSE;
120: end if;
121:
122: if (error = TRUE) then
123: update xtr_deals_interface
124: set load_status_code = 'DUPLICATE_DEAL_ID',
125: last_update_date = trunc(SYSDATE),
126: Last_Updated_by = fnd_global.user_id
127: where external_deal_id = p_external_deal_id

Line 182: FUNCTION val_desc_flex( p_Interface_Rec IN XTR_DEALS_INTERFACE%ROWTYPE,

178: END CHECK_USER_AUTH;
179:
180:
181: /*--------------------------------------------------------------------------------*/
182: FUNCTION val_desc_flex( p_Interface_Rec IN XTR_DEALS_INTERFACE%ROWTYPE,
183: p_desc_flex IN VARCHAR2,
184: p_error_segment IN OUT NOCOPY VARCHAR2) return BOOLEAN is
185: /*--------------------------------------------------------------------------------*/
186: l_segment number(3);

Line 357: ARec In Out NOCOPY xtr_deals_interface%rowtype) is

353: name / number translaction is also placed in this procedure
354: */
355: /*--------------------------------------------------------------*/
356: Procedure Translate_Deal_Details( deal_type In Varchar2,
357: ARec In Out NOCOPY xtr_deals_interface%rowtype) is
358: /*--------------------------------------------------------------*/
359:
360: b_updated Boolean:=false;
361:

Line 397: p_new_name XTR_DEALS_INTERFACE.CPARTY_REF%TYPE;

393: */
394: Procedure Translate_Accounts(p_account_number In Out nocopy Varchar2,
395: p_account_name In Out nocopy Varchar2
396: ) is
397: p_new_name XTR_DEALS_INTERFACE.CPARTY_REF%TYPE;
398: p_new_number XTR_DEALS_INTERFACE.CPARTY_ACCOUNT_NO%TYPE;
399: b_local_updated BOOLEAN := FALSE;
400: CURSOR translate_by_number(p_number VARCHAR2) is
401: SELECT bank_short_code

Line 398: p_new_number XTR_DEALS_INTERFACE.CPARTY_ACCOUNT_NO%TYPE;

394: Procedure Translate_Accounts(p_account_number In Out nocopy Varchar2,
395: p_account_name In Out nocopy Varchar2
396: ) is
397: p_new_name XTR_DEALS_INTERFACE.CPARTY_REF%TYPE;
398: p_new_number XTR_DEALS_INTERFACE.CPARTY_ACCOUNT_NO%TYPE;
399: b_local_updated BOOLEAN := FALSE;
400: CURSOR translate_by_number(p_number VARCHAR2) is
401: SELECT bank_short_code
402: FROM xtr_bank_accounts_v

Line 457: update xtr_deals_interface

453: end if;
454:
455:
456: if (b_updated) then
457: update xtr_deals_interface
458: set PRICING_MODEL = ARec.PRICING_MODEL,
459: MIRROR_PRICING_MODEL = ARec.MIRROR_PRICING_MODEL,
460: SETTLE_ACTION_REQD = ARec.SETTLE_ACTION_REQD,
461: BASIS_TYPE = ARec.BASIS_TYPE,

Line 479: Procedure Translate_Deal_Details_UI(p_external_deal_id xtr_deals_interface.external_deal_id%type,

475: This is the call to be made from the UI, pass in the external_deal_id
476: and user_deal_type and this call will then call Translate_Deal_Details
477: */
478: /*--------------------------------------------------------------*/
479: Procedure Translate_Deal_Details_UI(p_external_deal_id xtr_deals_interface.external_deal_id%type,
480: p_user_deal_type xtr_deals_interface.deal_type%type) is
481: /*--------------------------------------------------------------*/
482:
483: l_deal_type xtr_deals_interface.external_deal_id%type:=null;

Line 480: p_user_deal_type xtr_deals_interface.deal_type%type) is

476: and user_deal_type and this call will then call Translate_Deal_Details
477: */
478: /*--------------------------------------------------------------*/
479: Procedure Translate_Deal_Details_UI(p_external_deal_id xtr_deals_interface.external_deal_id%type,
480: p_user_deal_type xtr_deals_interface.deal_type%type) is
481: /*--------------------------------------------------------------*/
482:
483: l_deal_type xtr_deals_interface.external_deal_id%type:=null;
484: ARec xtr_deals_interface%rowtype;

Line 483: l_deal_type xtr_deals_interface.external_deal_id%type:=null;

479: Procedure Translate_Deal_Details_UI(p_external_deal_id xtr_deals_interface.external_deal_id%type,
480: p_user_deal_type xtr_deals_interface.deal_type%type) is
481: /*--------------------------------------------------------------*/
482:
483: l_deal_type xtr_deals_interface.external_deal_id%type:=null;
484: ARec xtr_deals_interface%rowtype;
485:
486: cursor getDeal is
487: select *

Line 484: ARec xtr_deals_interface%rowtype;

480: p_user_deal_type xtr_deals_interface.deal_type%type) is
481: /*--------------------------------------------------------------*/
482:
483: l_deal_type xtr_deals_interface.external_deal_id%type:=null;
484: ARec xtr_deals_interface%rowtype;
485:
486: cursor getDeal is
487: select *
488: from xtr_deals_interface

Line 488: from xtr_deals_interface

484: ARec xtr_deals_interface%rowtype;
485:
486: cursor getDeal is
487: select *
488: from xtr_deals_interface
489: where external_deal_id = p_external_deal_id
490: and deal_type=p_user_deal_type;
491: Cursor getDealType Is
492: Select Deal_Type

Line 583: From Xtr_Deals_Interface

579: Cursor Int_Form_Deal_Cursor(bDeal_Type In Varchar2,
580: bDeal_Fr In Varchar2,
581: bDeal_To In Varchar2) Is
582: Select *
583: From Xtr_Deals_Interface
584: Where Nvl(Load_Status_Code,'NEW') = 'SUBMIT'
585: Order By Deal_Type, company_code, cparty_code, currency_a, date_a, external_deal_id;
586:
587:

Line 597: From Xtr_Deals_Interface

593: bDeal_To In Varchar2,
594: bCompany_Code In Varchar2,
595: bLoad_Status In Varchar) Is
596: Select *
597: From Xtr_Deals_Interface
598: Where External_Deal_Id Between Nvl(bDeal_Fr,External_Deal_Id)
599: And Nvl(bDeal_To,External_Deal_Id)
600: And Company_Code Like Nvl(bCompany_Code,'%')
601: And Deal_Type Like Nvl(bDeal_Type,'%')

Line 626: LRec_External_Deal xtr_deals_interface%rowtype;

622:
623: /*-------------------*/
624: /* Local variables. */
625: /*-------------------*/
626: LRec_External_Deal xtr_deals_interface%rowtype;
627: L_Deal_Name xtr_deal_types_v.name%type;
628: L_Deal_Type xtr_deal_types_v.deal_type%type;
629: deal_error BOOLEAN Default FALSE;
630: user_error BOOLEAN Default FALSE;

Line 701: from xtr_deals_interface dl

697: delete
698: from xtr_transactions_interface tr
699: where not exists (
700: select dl.external_deal_id
701: from xtr_deals_interface dl
702: where dl.external_deal_id = tr.external_deal_id
703: and dl.deal_type = tr.deal_type
704: );
705:

Line 893: UPDATE xtr_deals_interface

889: ELSE
890: -------------------------------------------------------------
891: --* update as the same error for unsupported deal types also
892: -------------------------------------------------------------
893: UPDATE xtr_deals_interface
894: set load_status_code = 'DEAL_TYPE_ERROR',
895: last_update_date = trunc(SYSDATE),
896: Last_Updated_by = fnd_global.user_id
897: where external_deal_id = LRec_External_Deal.external_deal_id

Line 936: UPDATE Xtr_Deals_Interface

932: end if;
933:
934: Exception
935: When Others Then
936: UPDATE Xtr_Deals_Interface
937: SET Load_Status_Code='ERROR'
938: WHERE External_Deal_Id=LRec_External_Deal.External_Deal_Id;
939:
940: p_has_warnings:=true;

Line 1032: UPDATE xtr_deals_interface

1028:
1029:
1030: IF L_Deal_Type is null then
1031:
1032: UPDATE xtr_deals_interface
1033: set load_status_code = 'DEAL_TYPE_ERROR',
1034: last_update_date = trunc(SYSDATE),
1035: Last_Updated_by = fnd_global.user_id
1036: where external_deal_id = LRec_External_Deal.external_deal_id