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.QP_MULTI_CURRENCY_PVT dependencies on QP_CURRENCY_DETAILS

Line 428: l_user_conversion_type qp_currency_details.conversion_type%TYPE; --bug 9503901

424: l_formula_status VARCHAR2(1);
425: l_modifier_value NUMBER;
426: l_round_price_status VARCHAR2(1);
427:
428: l_user_conversion_type qp_currency_details.conversion_type%TYPE; --bug 9503901
429:
430: rows NATURAL := 5000;
431:
432: TYPE line_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_index%TYPE INDEX BY BINARY_INTEGER;

Line 438: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;

434: TYPE operand_value_tab IS TABLE OF qp_npreq_ldets_tmp.operand_value%TYPE INDEX BY BINARY_INTEGER;
435: TYPE operand_calc_code_tab IS TABLE OF qp_npreq_ldets_tmp.operand_calculation_code%TYPE INDEX BY BINARY_INTEGER;
436: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;
437: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
438: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
439: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
440: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
441: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
442: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;

Line 439: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;

435: TYPE operand_calc_code_tab IS TABLE OF qp_npreq_ldets_tmp.operand_calculation_code%TYPE INDEX BY BINARY_INTEGER;
436: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;
437: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
438: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
439: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
440: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
441: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
442: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
443: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;

Line 440: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;

436: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;
437: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
438: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
439: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
440: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
441: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
442: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
443: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
444: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;

Line 441: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;

437: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
438: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
439: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
440: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
441: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
442: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
443: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
444: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
445: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;

Line 442: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;

438: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
439: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
440: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
441: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
442: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
443: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
444: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
445: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
446: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;

Line 443: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;

439: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
440: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
441: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
442: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
443: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
444: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
445: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
446: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
447: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;

Line 444: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;

440: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
441: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
442: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
443: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
444: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
445: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
446: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
447: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;
448: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;

Line 445: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;

441: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
442: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
443: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
444: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
445: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
446: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
447: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;
448: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;
449: TYPE error_message_tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;

Line 446: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;

442: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
443: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
444: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
445: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
446: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
447: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;
448: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;
449: TYPE error_message_tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
450: TYPE status_code_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 447: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;

443: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
444: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
445: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
446: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
447: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;
448: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;
449: TYPE error_message_tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
450: TYPE status_code_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
451: TYPE lines_status_code_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 448: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;

444: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
445: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
446: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
447: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;
448: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;
449: TYPE error_message_tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
450: TYPE status_code_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
451: TYPE lines_status_code_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
452:

Line 506: qp_currency_details a,

502: ,a.markup_operator
503: ,a.markup_value
504: ,a.markup_formula_id
505: FROM
506: qp_currency_details a,
507: qp_npreq_ldets_tmp b
508: --j_qp_npreq_ldets_tmp b
509: WHERE
510: a.currency_header_id = b.currency_header_id