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_WRAPPER_API_P dependencies on XTR_INTERACCT_TRANSFERS

Line 1604: from xtr_interacct_transfers A,

1600: l_tran_num NUMBER := null;
1601:
1602: cursor chk_reconcile (l_deal_type VARCHAR2) is
1603: select A.transaction_number
1604: from xtr_interacct_transfers A,
1605: xtr_deal_date_amounts B,
1606: xtr_deal_date_amounts C
1607: where A.company_code = l_company_code
1608: and A.transfer_amount = l_transfer_amount

Line 2161: l_Ext_IAC xtr_interacct_transfers%rowtype;

2157: select dealer_code
2158: from xtr_dealer_codes_v
2159: where user_id = p_fnd_user;
2160:
2161: l_Ext_IAC xtr_interacct_transfers%rowtype;
2162: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2163: l_company_code xtr_interacct_transfers.company_code%TYPE;
2164: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2165: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;

Line 2162: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;

2158: from xtr_dealer_codes_v
2159: where user_id = p_fnd_user;
2160:
2161: l_Ext_IAC xtr_interacct_transfers%rowtype;
2162: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2163: l_company_code xtr_interacct_transfers.company_code%TYPE;
2164: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2165: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2166: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;

Line 2163: l_company_code xtr_interacct_transfers.company_code%TYPE;

2159: where user_id = p_fnd_user;
2160:
2161: l_Ext_IAC xtr_interacct_transfers%rowtype;
2162: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2163: l_company_code xtr_interacct_transfers.company_code%TYPE;
2164: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2165: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2166: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2167: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;

Line 2164: l_company_product_type xtr_interacct_transfers.product_type%TYPE;

2160:
2161: l_Ext_IAC xtr_interacct_transfers%rowtype;
2162: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2163: l_company_code xtr_interacct_transfers.company_code%TYPE;
2164: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2165: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2166: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2167: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;
2168: l_currency xtr_interacct_transfers.currency%TYPE;

Line 2165: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;

2161: l_Ext_IAC xtr_interacct_transfers%rowtype;
2162: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2163: l_company_code xtr_interacct_transfers.company_code%TYPE;
2164: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2165: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2166: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2167: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;
2168: l_currency xtr_interacct_transfers.currency%TYPE;
2169: l_auto_validation BOOLEAN;

Line 2166: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;

2162: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2163: l_company_code xtr_interacct_transfers.company_code%TYPE;
2164: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2165: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2166: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2167: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;
2168: l_currency xtr_interacct_transfers.currency%TYPE;
2169: l_auto_validation BOOLEAN;
2170: l_auto_settlement BOOLEAN;

Line 2167: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;

2163: l_company_code xtr_interacct_transfers.company_code%TYPE;
2164: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2165: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2166: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2167: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;
2168: l_currency xtr_interacct_transfers.currency%TYPE;
2169: l_auto_validation BOOLEAN;
2170: l_auto_settlement BOOLEAN;
2171: user_error BOOLEAN;

Line 2168: l_currency xtr_interacct_transfers.currency%TYPE;

2164: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2165: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2166: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2167: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;
2168: l_currency xtr_interacct_transfers.currency%TYPE;
2169: l_auto_validation BOOLEAN;
2170: l_auto_settlement BOOLEAN;
2171: user_error BOOLEAN;
2172: mandatory_error BOOLEAN;

Line 2214: -- 3) Set other attributes of XTR_INTERACCT_TRANSFERS

2210: END IF;
2211:
2212:
2213: -------------------------------------------------------------------
2214: -- 3) Set other attributes of XTR_INTERACCT_TRANSFERS
2215: -------------------------------------------------------------------
2216: l_Ext_IAC.deal_type := 'IAC';
2217: l_Ext_IAC.deal_subtype := 'FIRM';
2218: l_Ext_IAC.status_code := 'CURRENT';

Line 2230: -- 4) Set DEALER_CODE of XTR_INTERACCT_TRANSFERS

2226: l_Ext_IAC.portfolio_code := l_company_portfolio;
2227: l_Ext_IAC.External_Source := l_ext_source ;
2228:
2229: ------------------------------------------------------------------
2230: -- 4) Set DEALER_CODE of XTR_INTERACCT_TRANSFERS
2231: ------------------------------------------------------------------
2232: open get_user(fnd_global.user_id);
2233: fetch get_user into l_Ext_IAC.dealer_code;
2234: close get_user;

Line 2237: -- 5) Set DEAL_DATE of XTR_INTERACCT_TRANSFERS

2233: fetch get_user into l_Ext_IAC.dealer_code;
2234: close get_user;
2235:
2236: ------------------------------------------------------------------
2237: -- 5) Set DEAL_DATE of XTR_INTERACCT_TRANSFERS
2238: ------------------------------------------------------------------
2239: if l_Ext_IAC.Transfer_Date > l_sysdate then
2240: l_Ext_IAC.deal_date := l_sysdate;
2241: else

Line 2246: -- 6) Set Validation + Settlement flag of XTR_INTERACCT_TRANSFERS

2242: l_Ext_IAC.deal_date := l_Ext_IAC.Transfer_Date;
2243: end if;
2244:
2245: ------------------------------------------------------------------
2246: -- 6) Set Validation + Settlement flag of XTR_INTERACCT_TRANSFERS
2247: ------------------------------------------------------------------
2248: SET_IAC_VALIDATE_SETTLE(l_Ext_IAC.product_type,
2249: l_Ext_IAC.dealer_code,
2250: p_process_flag,