eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_INT_LOADER_PUB dependencies on QP_LIST_HEADERS_TL

Line 254: SELECT count(1) INTO l_count FROM qp_list_headers_tl qp_lhdr_tl where qp_lhdr_tl.name = l_name;

250:
251: IF (l_interface_action_code = 'D') THEN
252:
253: -- see if data exists
254: SELECT count(1) INTO l_count FROM qp_list_headers_tl qp_lhdr_tl where qp_lhdr_tl.name = l_name;
255: IF l_count > 0 THEN
256:
257: -- obtain list_header_id
258: SELECT qp_lhdr_tl.list_header_id INTO l_list_header_id FROM qp_list_headers_tl qp_lhdr_tl WHERE qp_lhdr_tl.name = l_name AND qp_lhdr_tl.language='US' ;

Line 258: SELECT qp_lhdr_tl.list_header_id INTO l_list_header_id FROM qp_list_headers_tl qp_lhdr_tl WHERE qp_lhdr_tl.name = l_name AND qp_lhdr_tl.language='US' ;

254: SELECT count(1) INTO l_count FROM qp_list_headers_tl qp_lhdr_tl where qp_lhdr_tl.name = l_name;
255: IF l_count > 0 THEN
256:
257: -- obtain list_header_id
258: SELECT qp_lhdr_tl.list_header_id INTO l_list_header_id FROM qp_list_headers_tl qp_lhdr_tl WHERE qp_lhdr_tl.name = l_name AND qp_lhdr_tl.language='US' ;
259:
260: delete from qp_pricing_attributes qp_prc_att where qp_prc_att.list_header_id = l_list_header_id;
261: delete from qp_list_lines qp_ll where qp_ll.list_header_id = l_list_header_id;
262: delete from qp_qualifiers qp_qual where qp_qual.list_header_id = l_list_header_id;

Line 264: delete from qp_list_headers_tl qp_lhdr_tl where qp_lhdr_tl.list_header_id = l_list_header_id;

260: delete from qp_pricing_attributes qp_prc_att where qp_prc_att.list_header_id = l_list_header_id;
261: delete from qp_list_lines qp_ll where qp_ll.list_header_id = l_list_header_id;
262: delete from qp_qualifiers qp_qual where qp_qual.list_header_id = l_list_header_id;
263: delete from qp_list_headers_b qp_lhdr_b where qp_lhdr_b.list_header_id = l_list_header_id;
264: delete from qp_list_headers_tl qp_lhdr_tl where qp_lhdr_tl.list_header_id = l_list_header_id;
265:
266: /*
267: update fte_lanes set fte_lanes.pricelist_view_flag = NULL WHERE fte_lanes.pricelist_id = l_list_header_id;
268: update fte_lanes set fte_lanes.pricelist_name = NULL WHERE fte_lanes.pricelist_id = l_list_header_id;

Line 1300: SELECT count(1) into l_count from qp_list_headers_tl where name = p_prclst_name;

1296: )
1297: IS
1298: l_count NUMBER := NULL;
1299: BEGIN
1300: SELECT count(1) into l_count from qp_list_headers_tl where name = p_prclst_name;
1301: IF l_count = 0 THEN
1302: x_prclst_exists := FALSE;
1303: x_prclst_exists_err_msg := SUBSTR('Prclst specified as a qualifier does not exists. Please correct data for ATTRIBUTE_VALUE. ', 1,239);
1304: ELSE