APPS.OE_BLANKET_UTIL dependencies on OE_ORDER_LINES

Line 63: FROM OE_ORDER_LINES

59:
60: BEGIN
61: SELECT 'ERROR'
62: INTO l_dummy
63: FROM OE_ORDER_LINES
64: WHERE trunc(request_date) > trunc(p_line_rec.end_date_active)
65: --- Bug 14487632, FP of 14469059 Start
66: AND OPEN_FLAG = 'Y'
67: --- Bug 14487632, FP of 14469059 End

Line 2942: FROM OE_ORDER_LINES

2938: IF p_line_rec.end_date_active IS NOT NULL THEN
2939: BEGIN
2940: SELECT 'ERROR'
2941: INTO l_dummy
2942: FROM OE_ORDER_LINES
2943: WHERE trunc(request_date) > trunc(p_line_rec.end_date_active)
2944: --- Bug 14487632, FP of 14469059 Start
2945: AND OPEN_FLAG = 'Y'
2946: --- Bug 14487632, FP of 14469059 End

Line 3968: FROM OE_ORDER_LINES

3964: BEGIN
3965:
3966: SELECT /* MOAC_SQL_NO_CHANGE */ 'ERROR'
3967: INTO l_dummy
3968: FROM OE_ORDER_LINES
3969: WHERE trunc(request_date) > trunc(p_header_rec.end_date_active)
3970: --- Bug 14487632, FP of 14469059 Start
3971: AND OPEN_FLAG = 'Y'
3972: --- Bug 14487632, FP of 14469059 End

Line 6917: SELECT OE_ORDER_LINES_S.NEXTVAL

6913: END IF;
6914:
6915: -- Get Blanket Line
6916: IF p_x_line_rec.line_id IS NULL THEN
6917: SELECT OE_ORDER_LINES_S.NEXTVAL
6918: INTO p_x_line_rec.line_id
6919: FROM DUAL;
6920: END IF;
6921:

Line 7927: SELECT OE_ORDER_LINES_S.NEXTVAL

7923: l_line_tbl(l_count).header_id := l_header_rec.header_id;
7924: l_line_tbl(l_count).order_number := NULL;
7925:
7926: -- Pre-default header_id for proper message display
7927: SELECT OE_ORDER_LINES_S.NEXTVAL
7928: INTO l_line_tbl(l_count).line_id
7929: FROM DUAL;
7930:
7931: l_line_tbl(l_count).operation := oe_globals.g_opr_create;

Line 8549: from oe_order_lines

8545: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8546:
8547: BEGIN
8548: Select 1 into p_result
8549: from oe_order_lines
8550: where blanket_number = l_blanket_number
8551: and blanket_line_number = l_blanket_line_number
8552: and line_category_code = 'RETURN'
8553: and rownum = 1;

Line 8564: from oe_order_lines

8560: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8561:
8562: BEGIN
8563: Select 1 into p_result
8564: from oe_order_lines
8565: where blanket_number = l_blanket_number
8566: and line_category_code = 'RETURN'
8567: and rownum = 1;
8568: EXCEPTION

Line 8601: from oe_order_lines

8597: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8598:
8599: BEGIN
8600: Select 1 into p_result
8601: from oe_order_lines
8602: where blanket_number = l_blanket_number
8603: and blanket_line_number = l_blanket_line_number
8604: and rownum = 1;
8605: EXCEPTION

Line 8615: from oe_order_lines

8611: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8612:
8613: BEGIN
8614: Select 1 into p_result
8615: from oe_order_lines
8616: where blanket_number = l_blanket_number
8617: and rownum = 1;
8618: EXCEPTION
8619: WHEN NO_DATA_FOUND THEN

Line 8699: from oe_order_lines

8695: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8696:
8697: BEGIN
8698: Select 1 into p_result
8699: from oe_order_lines
8700: where blanket_number = l_blanket_number
8701: and blanket_line_number = l_blanket_line_number
8702: and open_flag = 'Y'
8703: and rownum = 1;

Line 8714: from oe_order_lines

8710: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8711:
8712: BEGIN
8713: Select 1 into p_result
8714: from oe_order_lines
8715: where blanket_number = l_blanket_number
8716: and open_flag = 'Y'
8717: and rownum = 1;
8718: EXCEPTION