APPS.OE_BLANKET_UTIL dependencies on QP_LIST_LINES

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 3170: FROM QP_LIST_LINES

3166: BEGIN
3167:
3168: SELECT 'Y'
3169: INTO l_list_line_exists
3170: FROM QP_LIST_LINES
3171: WHERE LIST_LINE_ID = p_line_rec.qp_list_line_id;
3172:
3173: EXCEPTION
3174: WHEN NO_DATA_FOUND THEN

Line 6136: from qp_list_lines

6132: select decode(arithmetic_operator,'%',operand,null)
6133: ,decode(arithmetic_operator,'AMT',operand,null)
6134: into x_line_tbl(l_count).discount_percent
6135: ,x_line_tbl(l_count).discount_amount
6136: from qp_list_lines
6137: where list_line_id = x_line_tbl(l_count).modifier_list_line_id;
6138: EXCEPTION
6139: WHEN NO_DATA_FOUND THEN
6140: Null;

Line 6274: from qp_list_lines

6270: select decode(arithmetic_operator,'%',operand,null)
6271: ,decode(arithmetic_operator,'AMT',operand,null)
6272: into x_line_tbl(l_count).discount_percent
6273: ,x_line_tbl(l_count).discount_amount
6274: from qp_list_lines
6275: where list_line_id = x_line_tbl(l_count).modifier_list_line_id;
6276: EXCEPTION
6277: WHEN NO_DATA_FOUND THEN
6278: Null;