DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on QP_INT_LINES

Line 3365: UPDATE qp_int_lines SET line_id = p_line_id

3361: ||' p_priced_quantity '||p_priced_quantity||' p_update_type '||p_update_type);
3362: END IF;
3363: IF p_update_type = 'UPDATE_LINE_ID' THEN
3364: IF p_line_index IS NOT NULL THEN
3365: UPDATE qp_int_lines SET line_id = p_line_id
3366: WHERE line_index = p_line_index;
3367: END IF;--p_line_index IS NOT NULL
3368: ELSIF p_update_type = 'UPDATE_PRICED_QUANTITY' THEN
3369: IF p_line_id IS NOT NULL THEN

Line 3370: UPDATE qp_int_lines SET priced_quantity = p_priced_quantity

3366: WHERE line_index = p_line_index;
3367: END IF;--p_line_index IS NOT NULL
3368: ELSIF p_update_type = 'UPDATE_PRICED_QUANTITY' THEN
3369: IF p_line_id IS NOT NULL THEN
3370: UPDATE qp_int_lines SET priced_quantity = p_priced_quantity
3371: WHERE line_id = p_line_id;
3372: END IF;--p_line_id IS NOT NULL
3373: ELSIF p_update_type = 'MAKE_STATUS_INVALID' THEN
3374: IF p_line_id IS NOT NULL THEN

Line 3375: UPDATE qp_int_lines SET process_status = 'NOT_VALID'

3371: WHERE line_id = p_line_id;
3372: END IF;--p_line_id IS NOT NULL
3373: ELSIF p_update_type = 'MAKE_STATUS_INVALID' THEN
3374: IF p_line_id IS NOT NULL THEN
3375: UPDATE qp_int_lines SET process_status = 'NOT_VALID'
3376: WHERE line_id = p_line_id;
3377: END IF;--p_line_id IS NOT NULL
3378: END IF;
3379: END IF;--java engine installed