APPS.OE_BLANKET_UTIL dependencies on QP_LIST_HEADERS

Line 3481: FROM qp_list_headers_vl

3477: end if;
3478: -- START Need to check why we need to pass ORG_ID?
3479: SELECT list_header_id
3480: INTO p_header_rec.price_list_id
3481: FROM qp_list_headers_vl
3482: WHERE list_type_code in ('PRL' ,'AGR')
3483: AND p_header_rec.price_list_name = name
3484: AND (((nvl(global_flag,'Y') = 'Y'
3485: OR orig_org_id = mo_global.get_current_org_id)

Line 3537: FROM qp_list_headers_vl

3533:
3534: -- Check if name already exists
3535: SELECT list_header_id
3536: INTO l_list_header_id
3537: FROM qp_list_headers_vl
3538: WHERE name = p_header_rec.new_price_list_name
3539: AND rownum = 1;
3540:
3541: fnd_message.set_name('ONT','OE_BLKT_PRICE_LIST_EXISTS');

Line 3577: FROM qp_list_headers_vl

3573:
3574: -- Check if name already exists
3575: SELECT list_header_id
3576: INTO l_list_header_id
3577: FROM qp_list_headers_vl
3578: WHERE name = p_header_rec.new_modifier_list_name
3579: AND rownum = 1;
3580:
3581: fnd_message.set_name('ONT','OE_BLKT_MOD_LIST_EXISTS');

Line 5433: FROM qp_list_headers_vl

5429: ;
5430: IF x_header_rec.new_price_list_id IS NOT NULL THEN
5431: SELECT name
5432: INTO x_header_rec.new_price_list_name
5433: FROM qp_list_headers_vl
5434: WHERE list_header_id = x_header_rec.new_price_list_id;
5435: END IF;
5436: IF x_header_rec.new_modifier_list_id IS NOT NULL THEN
5437: SELECT name

Line 5439: FROM qp_list_headers_vl

5435: END IF;
5436: IF x_header_rec.new_modifier_list_id IS NOT NULL THEN
5437: SELECT name
5438: INTO x_header_rec.new_modifier_list_name
5439: FROM qp_list_headers_vl
5440: WHERE list_header_id = x_header_rec.new_modifier_list_id;
5441: END IF;
5442: CLOSE l_hdr_csr;
5443: ELSE

Line 5541: FROM qp_list_headers_vl

5537: ;
5538: IF x_header_rec.new_price_list_id IS NOT NULL THEN
5539: SELECT name
5540: INTO x_header_rec.new_price_list_name
5541: FROM qp_list_headers_vl
5542: WHERE list_header_id = x_header_rec.new_price_list_id;
5543: END IF;
5544: IF x_header_rec.new_modifier_list_id IS NOT NULL THEN
5545: SELECT name

Line 5547: FROM qp_list_headers_vl

5543: END IF;
5544: IF x_header_rec.new_modifier_list_id IS NOT NULL THEN
5545: SELECT name
5546: INTO x_header_rec.new_modifier_list_name
5547: FROM qp_list_headers_vl
5548: WHERE list_header_id = x_header_rec.new_modifier_list_id;
5549: END IF;
5550: CLOSE l_hdr_hist_csr;
5551: END IF;

Line 7507: FROM QP_LIST_HEADERS

7503: IF OE_Code_Control.Get_Code_Release_Level < '110510' THEN
7504:
7505: SELECT 'VALID'
7506: INTO l_dummy
7507: FROM QP_LIST_HEADERS
7508: WHERE LIST_HEADER_ID = p_price_list_id
7509: AND LIST_SOURCE_CODE = 'BLKT';
7510:
7511: ELSE

Line 7523: FROM QP_LIST_HEADERS

7519:
7520: /*
7521: SELECT 'VALID'
7522: INTO l_dummy
7523: FROM QP_LIST_HEADERS
7524: WHERE LIST_HEADER_ID = p_price_list_id
7525: AND LIST_SOURCE_CODE = 'BSO'
7526: AND orig_system_header_ref = p_blanket_header_id
7527: ;