APPS.OE_BLANKET_UTIL dependencies on DUAL

Line 156: SELECT p_sold_to_org_id FROM DUAL

152: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
153: AND SITE.STATUS = 'A'
154: AND ACCT_SITE.STATUS ='A' AND --bug 2752321
155: ACCT_SITE.CUST_ACCOUNT_ID in (
156: SELECT p_sold_to_org_id FROM DUAL
157: UNION
158: SELECT CUST_ACCOUNT_ID FROM
159: HZ_CUST_ACCT_RELATE_ALL h WHERE
160: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 235: SELECT p_sold_to_org_id FROM DUAL

231: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
232: AND SITE.STATUS = 'A'
233: AND ACCT_SITE.STATUS ='A' AND
234: ACCT_SITE.CUST_ACCOUNT_ID in (
235: SELECT p_sold_to_org_id FROM DUAL
236: UNION
237: SELECT CUST_ACCOUNT_ID FROM
238: HZ_CUST_ACCT_RELATE_ALL h WHERE
239: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 323: SELECT p_sold_to_org_id FROM DUAL

319: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
320: AND SITE.STATUS = 'A'
321: AND ACCT_SITE.STATUS ='A' AND
322: ACCT_SITE.CUST_ACCOUNT_ID in (
323: SELECT p_sold_to_org_id FROM DUAL
324: UNION
325: SELECT CUST_ACCOUNT_ID FROM
326: HZ_CUST_ACCT_RELATE_ALL h WHERE
327: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 468: select QP_LIST_LINES_S.NEXTVAL into l_list_line_seq from dual; --bug8344368

464: GOTO SKIP_LINE;
465: END IF;
466: g_line_id_tbl(ind).line_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
467:
468: select QP_LIST_LINES_S.NEXTVAL into l_list_line_seq from dual; --bug8344368
469: gpr_price_list_line_tbl(ind).list_line_id := l_list_line_seq;
470: gpr_price_list_line_tbl(ind).list_line_type_code := 'PLL';
471: gpr_price_list_line_tbl(ind).operation := QP_GLOBALS.G_OPR_CREATE;
472: gpr_price_list_line_tbl(ind).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;

Line 771: select QP_LIST_LINES_S.NEXTVAL into l_list_line_seq from dual; --bug8344368

767: oe_delayed_requests_pvt.g_delayed_requests.delete(I);
768: GOTO SKIP_LINE1;
769: END IF;
770:
771: select QP_LIST_LINES_S.NEXTVAL into l_list_line_seq from dual; --bug8344368
772: gpr_price_list_line_tbl(k).list_line_id := l_list_line_seq;
773: gpr_price_list_line_tbl(k).list_line_type_code := 'PLL';
774: gpr_price_list_line_tbl(k).operation := QP_GLOBALS.G_OPR_CREATE;
775: gpr_price_list_line_tbl(k).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;

Line 6745: FROM DUAL;

6741: -- Default Blanket Header ID
6742: IF p_x_header_rec.header_id IS NULL THEN
6743: SELECT OE_ORDER_HEADERS_S.NEXTVAL
6744: INTO p_x_header_rec.header_id
6745: FROM DUAL;
6746: END IF;
6747:
6748: -- Default Start Date Active
6749: IF p_x_header_rec.start_Date_active IS NULL THEN

Line 6919: FROM DUAL;

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:
6922: -- Get Blanket Line Number
6923: IF p_x_line_rec.line_number IS NULL THEN

Line 7877: FROM DUAL;

7873:
7874: -- Pre-default header_id for proper message display
7875: SELECT OE_ORDER_HEADERS_S.NEXTVAL
7876: INTO l_header_rec.header_id
7877: FROM DUAL;
7878:
7879: l_header_rec.order_number := NULL;
7880: l_header_rec.version_number := 0;
7881: l_header_rec.operation := oe_globals.g_opr_create;

Line 7929: FROM DUAL;

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;
7932: l_line_tbl(l_count).order_number := NULL;
7933: l_line_tbl(l_count).line_number := NULL;