DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on QP_INT_LINES

Line 3035: UPDATE qp_int_lines SET line_id = p_line_id

3031: ||' p_priced_quantity '||p_priced_quantity||' p_update_type '||p_update_type);
3032: END IF;
3033: IF p_update_type = 'UPDATE_LINE_ID' THEN
3034: IF p_line_index IS NOT NULL THEN
3035: UPDATE qp_int_lines SET line_id = p_line_id
3036: WHERE line_index = p_line_index;
3037: END IF;--p_line_index IS NOT NULL
3038: ELSIF p_update_type = 'UPDATE_PRICED_QUANTITY' THEN
3039: IF p_line_id IS NOT NULL THEN

Line 3040: UPDATE qp_int_lines SET priced_quantity = p_priced_quantity

3036: WHERE line_index = p_line_index;
3037: END IF;--p_line_index IS NOT NULL
3038: ELSIF p_update_type = 'UPDATE_PRICED_QUANTITY' THEN
3039: IF p_line_id IS NOT NULL THEN
3040: UPDATE qp_int_lines SET priced_quantity = p_priced_quantity
3041: WHERE line_id = p_line_id;
3042: END IF;--p_line_id IS NOT NULL
3043: ELSIF p_update_type = 'MAKE_STATUS_INVALID' THEN
3044: IF p_line_id IS NOT NULL THEN

Line 3045: UPDATE qp_int_lines SET process_status = 'NOT_VALID'

3041: WHERE line_id = p_line_id;
3042: END IF;--p_line_id IS NOT NULL
3043: ELSIF p_update_type = 'MAKE_STATUS_INVALID' THEN
3044: IF p_line_id IS NOT NULL THEN
3045: UPDATE qp_int_lines SET process_status = 'NOT_VALID'
3046: WHERE line_id = p_line_id;
3047: END IF;--p_line_id IS NOT NULL
3048: END IF;
3049: END IF;--java engine installed