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_NPREQ_LDETS_TMP

Line 432: TYPE line_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_index%TYPE INDEX BY BINARY_INTEGER;

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;
433: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%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;

Line 433: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%TYPE INDEX BY BINARY_INTEGER;

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;
433: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%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;

Line 434: TYPE operand_value_tab IS TABLE OF qp_npreq_ldets_tmp.operand_value%TYPE INDEX BY BINARY_INTEGER;

430: rows NATURAL := 5000;
431:
432: TYPE line_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_index%TYPE INDEX BY BINARY_INTEGER;
433: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%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;

Line 435: TYPE operand_calc_code_tab IS TABLE OF qp_npreq_ldets_tmp.operand_calculation_code%TYPE INDEX BY BINARY_INTEGER;

431:
432: TYPE line_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_index%TYPE INDEX BY BINARY_INTEGER;
433: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%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;

Line 436: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;

432: TYPE line_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_index%TYPE INDEX BY BINARY_INTEGER;
433: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%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;

Line 437: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;

433: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%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;

Line 478: -- condition. operand_calculation_code in qp_npreq_ldets_tmp is the same as arithmetic_operator in

474: lines_status_code_t lines_status_code_tab;
475: operand_calc_code_t operand_calc_code_tab;
476:
477: -- Added operand_calculation_code in ('UNIT_PRICE','BLOCK_PRICE','BREAKUNIT_PRICE') in the where
478: -- condition. operand_calculation_code in qp_npreq_ldets_tmp is the same as arithmetic_operator in
479: -- qp_list_lines. This is to not process the currency conversion of service items which have
480: -- PERCENT_PRICE as the aritmetic operator . This is because the pricing engine computes the
481: -- price of the parent item after doing the currency conversion and them simply applies the
482: -- percent price on the parent item's price to compute the price of the service item.

Line 507: qp_npreq_ldets_tmp b

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
511: AND a.to_currency_code = b.order_currency

Line 508: --j_qp_npreq_ldets_tmp b

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
511: AND a.to_currency_code = b.order_currency
512: AND a.currency_detail_id = b.currency_detail_id

Line 606: -- status_code_t is used for updating the qp_npreq_ldets_tmp table Bug 2327718

602: --l_process_status := FND_API.G_RET_STS_SUCCESS;
603:
604: error_message_t(J) := NULL;
605:
606: -- status_code_t is used for updating the qp_npreq_ldets_tmp table Bug 2327718
607:
608: status_code_t(J) := 'N';
609:
610: -- Added lines_status_code_t for updating the qp_npreq_lines_tmp table Bug 2327718

Line 1128: UPDATE qp_npreq_ldets_tmp

1124:
1125: END IF;
1126: FORALL K IN line_index_t.FIRST..line_index_t.LAST
1127:
1128: UPDATE qp_npreq_ldets_tmp
1129: SET operand_value = result_operand_value_t(K)
1130: ,pricing_status_text = error_message_t(K)
1131: ,pricing_status_code = status_code_t(K)
1132: WHERE line_index = line_index_t(K)