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_INTERGROUP_TRANSFERS

Line 1489: from xtr_intergroup_transfers_v

1485: DAY_COUNT_TYPE,
1486: PRICING_MODEL,
1487: BALANCE_OUT -- not BALANCE_BF
1488: ,deal_number, transaction_number -- not used
1489: from xtr_intergroup_transfers_v
1490: where company_code = p_company_code
1491: and party_code = p_party_code
1492: and currency = p_currency
1493: and transfer_date <= p_transfer_date

Line 1562: l_dummy_char1 xtr_intergroup_transfers.rounding_type%TYPE;

1558: IS -- pass to IG API
1559:
1560: l_balance_out NUMBER;
1561: l_dummy_num NUMBER;
1562: l_dummy_char1 xtr_intergroup_transfers.rounding_type%TYPE;
1563: l_dummy_char2 xtr_intergroup_transfers.day_count_type%TYPE;
1564: l_specific_global NUMBER;
1565: l_dummy_msg VARCHAR2(30);
1566: l_mirror_action VARCHAR2(3);

Line 1563: l_dummy_char2 xtr_intergroup_transfers.day_count_type%TYPE;

1559:
1560: l_balance_out NUMBER;
1561: l_dummy_num NUMBER;
1562: l_dummy_char1 xtr_intergroup_transfers.rounding_type%TYPE;
1563: l_dummy_char2 xtr_intergroup_transfers.day_count_type%TYPE;
1564: l_specific_global NUMBER;
1565: l_dummy_msg VARCHAR2(30);
1566: l_mirror_action VARCHAR2(3);
1567:

Line 1704: from xtr_intergroup_transfers

1700:
1701: cursor find_ig_deal is
1702: select deal_number,
1703: transaction_number
1704: from xtr_intergroup_transfers
1705: where company_code = l_company_code
1706: and party_code = l_party_code
1707: and currency = l_currency
1708: and principal_adjust = l_principal_adjust

Line 2170: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;

2166: validation_error BOOLEAN;
2167: limit_error BOOLEAN;
2168: l_ext_source VARCHAR2(30);
2169:
2170: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;
2171: l_company_code xtr_intergroup_transfers.company_code%TYPE;
2172: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
2173: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2174: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;

Line 2171: l_company_code xtr_intergroup_transfers.company_code%TYPE;

2167: limit_error BOOLEAN;
2168: l_ext_source VARCHAR2(30);
2169:
2170: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;
2171: l_company_code xtr_intergroup_transfers.company_code%TYPE;
2172: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
2173: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2174: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
2175: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;

Line 2172: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;

2168: l_ext_source VARCHAR2(30);
2169:
2170: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;
2171: l_company_code xtr_intergroup_transfers.company_code%TYPE;
2172: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
2173: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2174: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
2175: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2176: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;

Line 2173: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;

2169:
2170: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;
2171: l_company_code xtr_intergroup_transfers.company_code%TYPE;
2172: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
2173: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2174: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
2175: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2176: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2177: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;

Line 2174: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;

2170: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;
2171: l_company_code xtr_intergroup_transfers.company_code%TYPE;
2172: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
2173: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2174: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
2175: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2176: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2177: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2178: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;

Line 2175: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;

2171: l_company_code xtr_intergroup_transfers.company_code%TYPE;
2172: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
2173: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2174: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
2175: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2176: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2177: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2178: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2179: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;

Line 2176: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;

2172: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
2173: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2174: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
2175: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2176: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2177: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2178: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2179: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
2180:

Line 2177: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;

2173: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2174: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
2175: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2176: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2177: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2178: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2179: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
2180:
2181: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;

Line 2178: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;

2174: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
2175: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2176: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2177: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2178: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2179: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
2180:
2181: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
2182: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;

Line 2179: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;

2175: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2176: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2177: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2178: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2179: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
2180:
2181: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
2182: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
2183: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;

Line 2181: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;

2177: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2178: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2179: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
2180:
2181: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
2182: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
2183: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2184: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
2185: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;

Line 2182: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;

2178: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2179: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
2180:
2181: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
2182: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
2183: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2184: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
2185: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2186: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;

Line 2183: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;

2179: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
2180:
2181: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
2182: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
2183: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2184: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
2185: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2186: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2187: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;

Line 2184: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;

2180:
2181: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
2182: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
2183: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2184: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
2185: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2186: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2187: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2188: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;

Line 2185: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;

2181: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
2182: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
2183: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2184: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
2185: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2186: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2187: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2188: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
2189:

Line 2186: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;

2182: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
2183: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2184: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
2185: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2186: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2187: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2188: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
2189:
2190: l_interest_rate NUMBER;

Line 2187: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;

2183: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2184: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
2185: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2186: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2187: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2188: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
2189:
2190: l_interest_rate NUMBER;
2191: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;

Line 2188: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;

2184: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
2185: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
2186: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
2187: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2188: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
2189:
2190: l_interest_rate NUMBER;
2191: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2192: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;

Line 2191: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;

2187: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
2188: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
2189:
2190: l_interest_rate NUMBER;
2191: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2192: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
2193: l_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2194: l_mirror_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2195:

Line 2192: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;

2188: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
2189:
2190: l_interest_rate NUMBER;
2191: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2192: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
2193: l_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2194: l_mirror_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2195:
2196:

Line 2193: l_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;

2189:
2190: l_interest_rate NUMBER;
2191: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2192: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
2193: l_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2194: l_mirror_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2195:
2196:
2197: /*---------------------------------------------------------------------------------------------------------------------------------------------

Line 2194: l_mirror_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;

2190: l_interest_rate NUMBER;
2191: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
2192: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
2193: l_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2194: l_mirror_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
2195:
2196:
2197: /*---------------------------------------------------------------------------------------------------------------------------------------------
2198: 1) Get parameters from CE