APPS.QP_UTIL_PUB dependencies on QP_NPREQ_LINES_TMP

Line 3343: UPDATE qp_npreq_lines_tmp SET line_id = p_line_id

3339: ||' p_priced_quantity '||p_priced_quantity||' p_update_type '||p_update_type);
3340: END IF;
3341: IF p_update_type = 'UPDATE_LINE_ID' THEN
3342: IF p_line_index IS NOT NULL THEN
3343: UPDATE qp_npreq_lines_tmp SET line_id = p_line_id
3344: WHERE line_index = p_line_index;
3345: END IF;--p_line_index IS NOT NULL
3346: ELSIF p_update_type = 'UPDATE_PRICED_QUANTITY' THEN
3347: IF p_line_id IS NOT NULL THEN

Line 3348: UPDATE qp_npreq_lines_tmp SET priced_quantity = p_priced_quantity

3344: WHERE line_index = p_line_index;
3345: END IF;--p_line_index IS NOT NULL
3346: ELSIF p_update_type = 'UPDATE_PRICED_QUANTITY' THEN
3347: IF p_line_id IS NOT NULL THEN
3348: UPDATE qp_npreq_lines_tmp SET priced_quantity = p_priced_quantity
3349: WHERE line_id = p_line_id;
3350: END IF;--p_line_id IS NOT NULL
3351: ELSIF p_update_type = 'MAKE_STATUS_INVALID' THEN
3352: IF p_line_id IS NOT NULL THEN

Line 3353: UPDATE qp_npreq_lines_tmp SET process_status = 'NOT_VALID'

3349: WHERE line_id = p_line_id;
3350: END IF;--p_line_id IS NOT NULL
3351: ELSIF p_update_type = 'MAKE_STATUS_INVALID' THEN
3352: IF p_line_id IS NOT NULL THEN
3353: UPDATE qp_npreq_lines_tmp SET process_status = 'NOT_VALID'
3354: WHERE line_id = p_line_id;
3355: END IF;--p_line_id IS NOT NULL
3356: END IF;
3357: ELSE