APPS.OE_BLANKET_UTIL dependencies on QP_LIST_HEADERS

Line 3672: FROM qp_list_headers_vl

3668: end if;
3669: -- START Need to check why we need to pass ORG_ID?
3670: SELECT list_header_id
3671: INTO p_header_rec.price_list_id
3672: FROM qp_list_headers_vl
3673: WHERE list_type_code in ('PRL' ,'AGR')
3674: AND p_header_rec.price_list_name = name
3675: AND (((nvl(global_flag,'Y') = 'Y'
3676: OR orig_org_id = mo_global.get_current_org_id)

Line 3728: FROM qp_list_headers_vl

3724:
3725: -- Check if name already exists
3726: SELECT list_header_id
3727: INTO l_list_header_id
3728: FROM qp_list_headers_vl
3729: WHERE name = p_header_rec.new_price_list_name
3730: AND rownum = 1;
3731:
3732: fnd_message.set_name('ONT','OE_BLKT_PRICE_LIST_EXISTS');

Line 3768: FROM qp_list_headers_vl

3764:
3765: -- Check if name already exists
3766: SELECT list_header_id
3767: INTO l_list_header_id
3768: FROM qp_list_headers_vl
3769: WHERE name = p_header_rec.new_modifier_list_name
3770: AND rownum = 1;
3771:
3772: fnd_message.set_name('ONT','OE_BLKT_MOD_LIST_EXISTS');

Line 5627: FROM qp_list_headers_vl

5623: ;
5624: IF x_header_rec.new_price_list_id IS NOT NULL THEN
5625: SELECT name
5626: INTO x_header_rec.new_price_list_name
5627: FROM qp_list_headers_vl
5628: WHERE list_header_id = x_header_rec.new_price_list_id;
5629: END IF;
5630: IF x_header_rec.new_modifier_list_id IS NOT NULL THEN
5631: SELECT name

Line 5633: FROM qp_list_headers_vl

5629: END IF;
5630: IF x_header_rec.new_modifier_list_id IS NOT NULL THEN
5631: SELECT name
5632: INTO x_header_rec.new_modifier_list_name
5633: FROM qp_list_headers_vl
5634: WHERE list_header_id = x_header_rec.new_modifier_list_id;
5635: END IF;
5636: CLOSE l_hdr_csr;
5637: ELSE

Line 5735: FROM qp_list_headers_vl

5731: ;
5732: IF x_header_rec.new_price_list_id IS NOT NULL THEN
5733: SELECT name
5734: INTO x_header_rec.new_price_list_name
5735: FROM qp_list_headers_vl
5736: WHERE list_header_id = x_header_rec.new_price_list_id;
5737: END IF;
5738: IF x_header_rec.new_modifier_list_id IS NOT NULL THEN
5739: SELECT name

Line 5741: FROM qp_list_headers_vl

5737: END IF;
5738: IF x_header_rec.new_modifier_list_id IS NOT NULL THEN
5739: SELECT name
5740: INTO x_header_rec.new_modifier_list_name
5741: FROM qp_list_headers_vl
5742: WHERE list_header_id = x_header_rec.new_modifier_list_id;
5743: END IF;
5744: CLOSE l_hdr_hist_csr;
5745: END IF;

Line 7704: FROM QP_LIST_HEADERS

7700: IF OE_Code_Control.Get_Code_Release_Level < '110510' THEN
7701:
7702: SELECT 'VALID'
7703: INTO l_dummy
7704: FROM QP_LIST_HEADERS
7705: WHERE LIST_HEADER_ID = p_price_list_id
7706: AND LIST_SOURCE_CODE = 'BLKT';
7707:
7708: ELSE

Line 7720: FROM QP_LIST_HEADERS

7716:
7717: /*
7718: SELECT 'VALID'
7719: INTO l_dummy
7720: FROM QP_LIST_HEADERS
7721: WHERE LIST_HEADER_ID = p_price_list_id
7722: AND LIST_SOURCE_CODE = 'BSO'
7723: AND orig_system_header_ref = p_blanket_header_id
7724: ;