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

286: l_round_price_status VARCHAR2(1);
287:
288: rows NATURAL := 5000;
289:
290: TYPE line_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_index%TYPE INDEX BY BINARY_INTEGER;
291: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%TYPE INDEX BY BINARY_INTEGER;
292: TYPE operand_value_tab IS TABLE OF qp_npreq_ldets_tmp.operand_value%TYPE INDEX BY BINARY_INTEGER;
293: TYPE operand_calc_code_tab IS TABLE OF qp_npreq_ldets_tmp.operand_calculation_code%TYPE INDEX BY BINARY_INTEGER;
294: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;

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

287:
288: rows NATURAL := 5000;
289:
290: TYPE line_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_index%TYPE INDEX BY BINARY_INTEGER;
291: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%TYPE INDEX BY BINARY_INTEGER;
292: TYPE operand_value_tab IS TABLE OF qp_npreq_ldets_tmp.operand_value%TYPE INDEX BY BINARY_INTEGER;
293: TYPE operand_calc_code_tab IS TABLE OF qp_npreq_ldets_tmp.operand_calculation_code%TYPE INDEX BY BINARY_INTEGER;
294: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;
295: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;

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

288: rows NATURAL := 5000;
289:
290: TYPE line_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_index%TYPE INDEX BY BINARY_INTEGER;
291: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%TYPE INDEX BY BINARY_INTEGER;
292: TYPE operand_value_tab IS TABLE OF qp_npreq_ldets_tmp.operand_value%TYPE INDEX BY BINARY_INTEGER;
293: TYPE operand_calc_code_tab IS TABLE OF qp_npreq_ldets_tmp.operand_calculation_code%TYPE INDEX BY BINARY_INTEGER;
294: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;
295: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
296: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;

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

289:
290: TYPE line_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_index%TYPE INDEX BY BINARY_INTEGER;
291: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%TYPE INDEX BY BINARY_INTEGER;
292: TYPE operand_value_tab IS TABLE OF qp_npreq_ldets_tmp.operand_value%TYPE INDEX BY BINARY_INTEGER;
293: TYPE operand_calc_code_tab IS TABLE OF qp_npreq_ldets_tmp.operand_calculation_code%TYPE INDEX BY BINARY_INTEGER;
294: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;
295: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
296: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
297: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;

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

290: TYPE line_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_index%TYPE INDEX BY BINARY_INTEGER;
291: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%TYPE INDEX BY BINARY_INTEGER;
292: TYPE operand_value_tab IS TABLE OF qp_npreq_ldets_tmp.operand_value%TYPE INDEX BY BINARY_INTEGER;
293: TYPE operand_calc_code_tab IS TABLE OF qp_npreq_ldets_tmp.operand_calculation_code%TYPE INDEX BY BINARY_INTEGER;
294: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;
295: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
296: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
297: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
298: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;

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

291: TYPE line_detail_index_tab IS TABLE OF qp_npreq_ldets_tmp.line_detail_index%TYPE INDEX BY BINARY_INTEGER;
292: TYPE operand_value_tab IS TABLE OF qp_npreq_ldets_tmp.operand_value%TYPE INDEX BY BINARY_INTEGER;
293: TYPE operand_calc_code_tab IS TABLE OF qp_npreq_ldets_tmp.operand_calculation_code%TYPE INDEX BY BINARY_INTEGER;
294: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;
295: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
296: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
297: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
298: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
299: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;

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

332: lines_status_code_t lines_status_code_tab;
333: operand_calc_code_t operand_calc_code_tab;
334:
335: -- Added operand_calculation_code in ('UNIT_PRICE','BLOCK_PRICE','BREAKUNIT_PRICE') in the where
336: -- condition. operand_calculation_code in qp_npreq_ldets_tmp is the same as arithmetic_operator in
337: -- qp_list_lines. This is to not process the currency conversion of service items which have
338: -- PERCENT_PRICE as the aritmetic operator . This is because the pricing engine computes the
339: -- price of the parent item after doing the currency conversion and them simply applies the
340: -- percent price on the parent item's price to compute the price of the service item.

Line 365: qp_npreq_ldets_tmp b

361: ,a.markup_value
362: ,a.markup_formula_id
363: FROM
364: qp_currency_details a,
365: qp_npreq_ldets_tmp b
366: --j_qp_npreq_ldets_tmp b
367: WHERE
368: a.currency_header_id = b.currency_header_id
369: AND a.to_currency_code = b.order_currency

Line 366: --j_qp_npreq_ldets_tmp b

362: ,a.markup_formula_id
363: FROM
364: qp_currency_details a,
365: qp_npreq_ldets_tmp b
366: --j_qp_npreq_ldets_tmp b
367: WHERE
368: a.currency_header_id = b.currency_header_id
369: AND a.to_currency_code = b.order_currency
370: AND a.currency_detail_id = b.currency_detail_id

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

454: --l_process_status := FND_API.G_RET_STS_SUCCESS;
455:
456: error_message_t(J) := NULL;
457:
458: -- status_code_t is used for updating the qp_npreq_ldets_tmp table Bug 2327718
459:
460: status_code_t(J) := 'N';
461:
462: -- Added lines_status_code_t for updating the qp_npreq_lines_tmp table Bug 2327718

Line 933: UPDATE qp_npreq_ldets_tmp

929:
930: END IF;
931: FORALL K IN line_index_t.FIRST..line_index_t.LAST
932:
933: UPDATE qp_npreq_ldets_tmp
934: SET operand_value = result_operand_value_t(K)
935: ,pricing_status_text = error_message_t(K)
936: ,pricing_status_code = status_code_t(K)
937: WHERE line_index = line_index_t(K)