DBA Data[Home] [Help]

APPS.QP_MULTI_CURRENCY_PVT dependencies on QP_NPREQ_LINES_TMP

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

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
611:
612: lines_status_code_t(J) := 'UPDATED';
613:
614: l_conversion_rate := NULL;

Line 1138: UPDATE qp_npreq_lines_tmp

1134: AND pricing_status_code = 'N';
1135:
1136: FORALL K IN line_index_t.FIRST..line_index_t.LAST
1137:
1138: UPDATE qp_npreq_lines_tmp
1139: SET unit_price = decode(operand_calc_code_t(K) , 'LIST_PRICE', result_operand_value_t(K),NULL),
1140: percent_price = decode(operand_calc_code_t(K) , 'PERCENT_PRICE', result_operand_value_t(K)
1141: , NULL)
1142: ,pricing_status_text = error_message_t(K)