APPS.OE_BLANKET_UTIL dependencies on OE_ORDER_LINES

Line 2754: FROM OE_ORDER_LINES

2750: IF p_line_rec.end_date_active IS NOT NULL THEN
2751: BEGIN
2752: SELECT 'ERROR'
2753: INTO l_dummy
2754: FROM OE_ORDER_LINES
2755: WHERE trunc(request_date) > trunc(p_line_rec.end_date_active)
2756: AND BLANKET_NUMBER = p_line_rec.order_number
2757: AND BLANKET_LINE_NUMBER = p_line_rec.line_number
2758: AND ROWNUM = 1;

Line 3777: FROM OE_ORDER_LINES

3773: BEGIN
3774:
3775: SELECT /* MOAC_SQL_NO_CHANGE */ 'ERROR'
3776: INTO l_dummy
3777: FROM OE_ORDER_LINES
3778: WHERE trunc(request_date) > trunc(p_header_rec.end_date_active)
3779: AND BLANKET_NUMBER = p_header_rec.order_number
3780: AND ROWNUM = 1;
3781: IF l_dummy = 'ERROR' THEN

Line 6723: SELECT OE_ORDER_LINES_S.NEXTVAL

6719: END IF;
6720:
6721: -- Get Blanket Line
6722: IF p_x_line_rec.line_id IS NULL THEN
6723: SELECT OE_ORDER_LINES_S.NEXTVAL
6724: INTO p_x_line_rec.line_id
6725: FROM DUAL;
6726: END IF;
6727:

Line 7730: SELECT OE_ORDER_LINES_S.NEXTVAL

7726: l_line_tbl(l_count).header_id := l_header_rec.header_id;
7727: l_line_tbl(l_count).order_number := NULL;
7728:
7729: -- Pre-default header_id for proper message display
7730: SELECT OE_ORDER_LINES_S.NEXTVAL
7731: INTO l_line_tbl(l_count).line_id
7732: FROM DUAL;
7733:
7734: l_line_tbl(l_count).operation := oe_globals.g_opr_create;

Line 8352: from oe_order_lines

8348: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8349:
8350: BEGIN
8351: Select 1 into p_result
8352: from oe_order_lines
8353: where blanket_number = l_blanket_number
8354: and blanket_line_number = l_blanket_line_number
8355: and line_category_code = 'RETURN'
8356: and rownum = 1;

Line 8367: from oe_order_lines

8363: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8364:
8365: BEGIN
8366: Select 1 into p_result
8367: from oe_order_lines
8368: where blanket_number = l_blanket_number
8369: and line_category_code = 'RETURN'
8370: and rownum = 1;
8371: EXCEPTION

Line 8404: from oe_order_lines

8400: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8401:
8402: BEGIN
8403: Select 1 into p_result
8404: from oe_order_lines
8405: where blanket_number = l_blanket_number
8406: and blanket_line_number = l_blanket_line_number
8407: and rownum = 1;
8408: EXCEPTION

Line 8418: from oe_order_lines

8414: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8415:
8416: BEGIN
8417: Select 1 into p_result
8418: from oe_order_lines
8419: where blanket_number = l_blanket_number
8420: and rownum = 1;
8421: EXCEPTION
8422: WHEN NO_DATA_FOUND THEN

Line 8502: from oe_order_lines

8498: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8499:
8500: BEGIN
8501: Select 1 into p_result
8502: from oe_order_lines
8503: where blanket_number = l_blanket_number
8504: and blanket_line_number = l_blanket_line_number
8505: and open_flag = 'Y'
8506: and rownum = 1;

Line 8517: from oe_order_lines

8513: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8514:
8515: BEGIN
8516: Select 1 into p_result
8517: from oe_order_lines
8518: where blanket_number = l_blanket_number
8519: and open_flag = 'Y'
8520: and rownum = 1;
8521: EXCEPTION