DBA Data[Home] [Help]

APPS.QP_MULTI_CURRENCY_PVT dependencies on QP_NPREQ_LINES_TMP

Line 462: -- Added lines_status_code_t for updating the qp_npreq_lines_tmp table Bug 2327718

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
463:
464: lines_status_code_t(J) := 'UPDATED';
465:
466: l_conversion_rate := NULL;

Line 943: UPDATE qp_npreq_lines_tmp

939: AND pricing_status_code = 'N';
940:
941: FORALL K IN line_index_t.FIRST..line_index_t.LAST
942:
943: UPDATE qp_npreq_lines_tmp
944: SET unit_price = decode(operand_calc_code_t(K) , 'LIST_PRICE', result_operand_value_t(K),NULL),
945: percent_price = decode(operand_calc_code_t(K) , 'PERCENT_PRICE', result_operand_value_t(K)
946: , NULL)
947: ,pricing_status_text = error_message_t(K)