APPS.QP_UTIL_PUB dependencies on QP_NPREQ_LINES_TMP

Line 3013: UPDATE qp_npreq_lines_tmp SET line_id = p_line_id

3009: ||' p_priced_quantity '||p_priced_quantity||' p_update_type '||p_update_type);
3010: END IF;
3011: IF p_update_type = 'UPDATE_LINE_ID' THEN
3012: IF p_line_index IS NOT NULL THEN
3013: UPDATE qp_npreq_lines_tmp SET line_id = p_line_id
3014: WHERE line_index = p_line_index;
3015: END IF;--p_line_index IS NOT NULL
3016: ELSIF p_update_type = 'UPDATE_PRICED_QUANTITY' THEN
3017: IF p_line_id IS NOT NULL THEN

Line 3018: UPDATE qp_npreq_lines_tmp SET priced_quantity = p_priced_quantity

3014: WHERE line_index = p_line_index;
3015: END IF;--p_line_index IS NOT NULL
3016: ELSIF p_update_type = 'UPDATE_PRICED_QUANTITY' THEN
3017: IF p_line_id IS NOT NULL THEN
3018: UPDATE qp_npreq_lines_tmp SET priced_quantity = p_priced_quantity
3019: WHERE line_id = p_line_id;
3020: END IF;--p_line_id IS NOT NULL
3021: ELSIF p_update_type = 'MAKE_STATUS_INVALID' THEN
3022: IF p_line_id IS NOT NULL THEN

Line 3023: UPDATE qp_npreq_lines_tmp SET process_status = 'NOT_VALID'

3019: WHERE line_id = p_line_id;
3020: END IF;--p_line_id IS NOT NULL
3021: ELSIF p_update_type = 'MAKE_STATUS_INVALID' THEN
3022: IF p_line_id IS NOT NULL THEN
3023: UPDATE qp_npreq_lines_tmp SET process_status = 'NOT_VALID'
3024: WHERE line_id = p_line_id;
3025: END IF;--p_line_id IS NOT NULL
3026: END IF;
3027: ELSE