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 1255: from xtr_intergroup_transfers_v

1251: DAY_COUNT_TYPE,
1252: PRICING_MODEL,
1253: BALANCE_OUT -- not BALANCE_BF
1254: ,deal_number, transaction_number -- not used
1255: from xtr_intergroup_transfers_v
1256: where company_code = p_company_code
1257: and party_code = p_party_code
1258: and currency = p_currency
1259: and transfer_date <= p_transfer_date

Line 1328: l_dummy_char1 xtr_intergroup_transfers.rounding_type%TYPE;

1324: IS -- pass to IG API
1325:
1326: l_balance_out NUMBER;
1327: l_dummy_num NUMBER;
1328: l_dummy_char1 xtr_intergroup_transfers.rounding_type%TYPE;
1329: l_dummy_char2 xtr_intergroup_transfers.day_count_type%TYPE;
1330: l_specific_global NUMBER;
1331: l_dummy_msg VARCHAR2(30);
1332: l_mirror_action VARCHAR2(3);

Line 1329: l_dummy_char2 xtr_intergroup_transfers.day_count_type%TYPE;

1325:
1326: l_balance_out NUMBER;
1327: l_dummy_num NUMBER;
1328: l_dummy_char1 xtr_intergroup_transfers.rounding_type%TYPE;
1329: l_dummy_char2 xtr_intergroup_transfers.day_count_type%TYPE;
1330: l_specific_global NUMBER;
1331: l_dummy_msg VARCHAR2(30);
1332: l_mirror_action VARCHAR2(3);
1333:

Line 1470: from xtr_intergroup_transfers

1466:
1467: cursor find_ig_deal is
1468: select deal_number,
1469: transaction_number
1470: from xtr_intergroup_transfers
1471: where company_code = l_company_code
1472: and party_code = l_party_code
1473: and currency = l_currency
1474: and principal_adjust = l_principal_adjust

Line 1936: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;

1932: validation_error BOOLEAN;
1933: limit_error BOOLEAN;
1934: l_ext_source VARCHAR2(30);
1935:
1936: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;
1937: l_company_code xtr_intergroup_transfers.company_code%TYPE;
1938: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
1939: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1940: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;

Line 1937: l_company_code xtr_intergroup_transfers.company_code%TYPE;

1933: limit_error BOOLEAN;
1934: l_ext_source VARCHAR2(30);
1935:
1936: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;
1937: l_company_code xtr_intergroup_transfers.company_code%TYPE;
1938: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
1939: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1940: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
1941: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;

Line 1938: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;

1934: l_ext_source VARCHAR2(30);
1935:
1936: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;
1937: l_company_code xtr_intergroup_transfers.company_code%TYPE;
1938: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
1939: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1940: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
1941: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1942: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;

Line 1939: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;

1935:
1936: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;
1937: l_company_code xtr_intergroup_transfers.company_code%TYPE;
1938: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
1939: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1940: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
1941: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1942: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1943: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;

Line 1940: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;

1936: l_company_dealer xtr_intergroup_transfers.dealer_code%TYPE;
1937: l_company_code xtr_intergroup_transfers.company_code%TYPE;
1938: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
1939: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1940: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
1941: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1942: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1943: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1944: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;

Line 1941: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;

1937: l_company_code xtr_intergroup_transfers.company_code%TYPE;
1938: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
1939: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1940: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
1941: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1942: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1943: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1944: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1945: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;

Line 1942: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;

1938: l_company_account_no xtr_intergroup_transfers.company_account_no%TYPE;
1939: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1940: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
1941: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1942: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1943: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1944: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1945: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
1946:

Line 1943: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;

1939: l_company_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1940: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
1941: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1942: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1943: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1944: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1945: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
1946:
1947: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;

Line 1944: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;

1940: l_company_product_type xtr_intergroup_transfers.product_type%TYPE;
1941: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1942: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1943: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1944: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1945: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
1946:
1947: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
1948: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;

Line 1945: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;

1941: l_company_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1942: l_company_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1943: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1944: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1945: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
1946:
1947: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
1948: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
1949: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;

Line 1947: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;

1943: l_company_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1944: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1945: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
1946:
1947: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
1948: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
1949: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1950: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
1951: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;

Line 1948: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;

1944: l_company_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1945: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
1946:
1947: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
1948: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
1949: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1950: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
1951: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1952: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;

Line 1949: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;

1945: l_company_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
1946:
1947: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
1948: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
1949: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1950: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
1951: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1952: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1953: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;

Line 1950: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;

1946:
1947: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
1948: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
1949: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1950: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
1951: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1952: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1953: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1954: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;

Line 1951: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;

1947: l_intercompany_code xtr_intergroup_transfers.party_code%TYPE;
1948: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
1949: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1950: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
1951: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1952: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1953: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1954: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
1955:

Line 1952: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;

1948: l_intercompany_account_no xtr_intergroup_transfers.party_account_no%TYPE;
1949: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1950: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
1951: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1952: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1953: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1954: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
1955:
1956: l_interest_rate NUMBER;

Line 1953: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;

1949: l_intercompany_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1950: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
1951: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1952: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1953: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1954: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
1955:
1956: l_interest_rate NUMBER;
1957: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;

Line 1954: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;

1950: l_intercompany_product_type xtr_intergroup_transfers.product_type%TYPE;
1951: l_intercompany_portfolio xtr_intergroup_transfers.portfolio%TYPE;
1952: l_intercompany_fund_limit xtr_intergroup_transfers.limit_code%TYPE;
1953: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1954: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
1955:
1956: l_interest_rate NUMBER;
1957: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1958: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;

Line 1957: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;

1953: l_intercompany_inv_limit xtr_intergroup_transfers.limit_code%TYPE;
1954: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
1955:
1956: l_interest_rate NUMBER;
1957: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1958: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
1959: l_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1960: l_mirror_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1961:

Line 1958: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;

1954: l_intercompany_dealer xtr_intergroup_transfers.dealer_code%TYPE;
1955:
1956: l_interest_rate NUMBER;
1957: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1958: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
1959: l_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1960: l_mirror_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1961:
1962:

Line 1959: l_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;

1955:
1956: l_interest_rate NUMBER;
1957: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1958: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
1959: l_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1960: l_mirror_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1961:
1962:
1963: /*---------------------------------------------------------------------------------------------------------------------------------------------

Line 1960: l_mirror_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;

1956: l_interest_rate NUMBER;
1957: l_rounding_type xtr_intergroup_transfers.rounding_type%TYPE;
1958: l_day_count_type xtr_intergroup_transfers.day_count_type%TYPE;
1959: l_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1960: l_mirror_pricing_model xtr_intergroup_transfers.pricing_model%TYPE;
1961:
1962:
1963: /*---------------------------------------------------------------------------------------------------------------------------------------------
1964: 1) Get parameters from CE