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 1838: from xtr_interacct_transfers A,

1834: l_tran_num NUMBER := null;
1835:
1836: cursor chk_reconcile (l_deal_type VARCHAR2) is
1837: select A.transaction_number
1838: from xtr_interacct_transfers A,
1839: xtr_deal_date_amounts B,
1840: xtr_deal_date_amounts C
1841: where A.company_code = l_company_code
1842: and A.transfer_amount = l_transfer_amount

Line 2395: l_Ext_IAC xtr_interacct_transfers%rowtype;

2391: select dealer_code
2392: from xtr_dealer_codes_v
2393: where user_id = p_fnd_user;
2394:
2395: l_Ext_IAC xtr_interacct_transfers%rowtype;
2396: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2397: l_company_code xtr_interacct_transfers.company_code%TYPE;
2398: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2399: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;

Line 2396: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;

2392: from xtr_dealer_codes_v
2393: where user_id = p_fnd_user;
2394:
2395: l_Ext_IAC xtr_interacct_transfers%rowtype;
2396: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2397: l_company_code xtr_interacct_transfers.company_code%TYPE;
2398: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2399: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2400: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;

Line 2397: l_company_code xtr_interacct_transfers.company_code%TYPE;

2393: where user_id = p_fnd_user;
2394:
2395: l_Ext_IAC xtr_interacct_transfers%rowtype;
2396: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2397: l_company_code xtr_interacct_transfers.company_code%TYPE;
2398: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2399: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2400: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2401: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;

Line 2398: l_company_product_type xtr_interacct_transfers.product_type%TYPE;

2394:
2395: l_Ext_IAC xtr_interacct_transfers%rowtype;
2396: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2397: l_company_code xtr_interacct_transfers.company_code%TYPE;
2398: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2399: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2400: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2401: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;
2402: l_currency xtr_interacct_transfers.currency%TYPE;

Line 2399: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;

2395: l_Ext_IAC xtr_interacct_transfers%rowtype;
2396: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2397: l_company_code xtr_interacct_transfers.company_code%TYPE;
2398: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2399: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2400: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2401: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;
2402: l_currency xtr_interacct_transfers.currency%TYPE;
2403: l_auto_validation BOOLEAN;

Line 2400: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;

2396: l_dealer_code xtr_interacct_transfers.dealer_code%TYPE;
2397: l_company_code xtr_interacct_transfers.company_code%TYPE;
2398: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2399: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2400: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2401: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;
2402: l_currency xtr_interacct_transfers.currency%TYPE;
2403: l_auto_validation BOOLEAN;
2404: l_auto_settlement BOOLEAN;

Line 2401: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;

2397: l_company_code xtr_interacct_transfers.company_code%TYPE;
2398: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2399: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2400: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2401: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;
2402: l_currency xtr_interacct_transfers.currency%TYPE;
2403: l_auto_validation BOOLEAN;
2404: l_auto_settlement BOOLEAN;
2405: user_error BOOLEAN;

Line 2402: l_currency xtr_interacct_transfers.currency%TYPE;

2398: l_company_product_type xtr_interacct_transfers.product_type%TYPE;
2399: l_company_portfolio xtr_interacct_transfers.portfolio_code%TYPE;
2400: l_account_no_from xtr_interacct_transfers.account_no_from%TYPE;
2401: l_account_no_to xtr_interacct_transfers.account_no_to%TYPE;
2402: l_currency xtr_interacct_transfers.currency%TYPE;
2403: l_auto_validation BOOLEAN;
2404: l_auto_settlement BOOLEAN;
2405: user_error BOOLEAN;
2406: mandatory_error BOOLEAN;

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

2444: END IF;
2445:
2446:
2447: -------------------------------------------------------------------
2448: -- 3) Set other attributes of XTR_INTERACCT_TRANSFERS
2449: -------------------------------------------------------------------
2450: l_Ext_IAC.deal_type := 'IAC';
2451: l_Ext_IAC.deal_subtype := 'FIRM';
2452: l_Ext_IAC.status_code := 'CURRENT';

Line 2464: -- 4) Set DEALER_CODE of XTR_INTERACCT_TRANSFERS

2460: l_Ext_IAC.portfolio_code := l_company_portfolio;
2461: l_Ext_IAC.External_Source := l_ext_source ;
2462:
2463: ------------------------------------------------------------------
2464: -- 4) Set DEALER_CODE of XTR_INTERACCT_TRANSFERS
2465: ------------------------------------------------------------------
2466: open get_user(fnd_global.user_id);
2467: fetch get_user into l_Ext_IAC.dealer_code;
2468: close get_user;

Line 2471: -- 5) Set DEAL_DATE of XTR_INTERACCT_TRANSFERS

2467: fetch get_user into l_Ext_IAC.dealer_code;
2468: close get_user;
2469:
2470: ------------------------------------------------------------------
2471: -- 5) Set DEAL_DATE of XTR_INTERACCT_TRANSFERS
2472: ------------------------------------------------------------------
2473: if l_Ext_IAC.Transfer_Date > l_sysdate then
2474: l_Ext_IAC.deal_date := l_sysdate;
2475: else

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

2476: l_Ext_IAC.deal_date := l_Ext_IAC.Transfer_Date;
2477: end if;
2478:
2479: ------------------------------------------------------------------
2480: -- 6) Set Validation + Settlement flag of XTR_INTERACCT_TRANSFERS
2481: ------------------------------------------------------------------
2482: SET_IAC_VALIDATE_SETTLE(l_Ext_IAC.product_type,
2483: l_Ext_IAC.dealer_code,
2484: p_process_flag,