APPS.QP_COPY_PRICELIST_PVT dependencies on QP_LIST_HEADERS_ALL_B

Line 354: FROM qp_list_headers_all_b

350: AND a.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
351: AND a.list_header_id IN
352: (SELECT list_header_id
353: --fix for bug 4673872
354: FROM qp_list_headers_all_b
355: WHERE list_type_code = 'DLT');
356:
357: CURSOR qp_hdr_qualifiers_cur(p_from_discount_header_id NUMBER) -- Name changed for cursor for bug 8326619 and an extra condition added
358: IS

Line 418: INSERT INTO qp_list_headers_all_b

414: l_new_orig_system_hrd_Ref := QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id);
415:
416: --Discount Header Information
417:
418: INSERT INTO qp_list_headers_all_b
419: (
420: list_header_id,
421: creation_date,
422: created_by,

Line 625: FROM QP_LIST_HEADERS_ALL_B

621:
622: SELECT ACTIVE_FLAG, LIST_TYPE_CODE
623: INTO l_active_flag, l_list_type_code
624: --fix for bug 4673872
625: FROM QP_LIST_HEADERS_ALL_B
626: WHERE LIST_HEADER_ID = l_new_discount_header_id;
627:
628: EXCEPTION
629: WHEN OTHERS THEN

Line 1584: From qp_list_headers_all_b a

1580: WHERE (q.list_header_id = p_from_list_header_id AND
1581: q.qualifier_attribute <> p_attribute AND --Added for 2200425
1582: Exists (Select Null
1583: --fix for bug 4673872
1584: From qp_list_headers_all_b a
1585: Where a.list_header_id = p_from_list_header_id
1586: And a.list_type_code = 'PRL'
1587: )
1588: )

Line 1594: EXISTS (select null from qp_list_headers_all_b a --Added for 2200425

1590: (q.qualifier_context = p_context AND
1591: q.qualifier_attribute = p_attribute AND
1592: q.qualifier_attr_value = TO_CHAR(p_from_list_header_id) AND
1593: --fix for bug 4673872
1594: EXISTS (select null from qp_list_headers_all_b a --Added for 2200425
1595: where a.list_header_id =q.list_header_id
1596: And a.list_type_code = 'PRL')
1597: /* and --Commented out for 2200425
1598: Exists (Select Null

Line 1671: INSERT INTO qp_list_headers_all_b

1667: FROM dual;
1668:
1669: -- Insert Price List Header information
1670:
1671: INSERT INTO qp_list_headers_all_b
1672: (
1673: list_header_id,
1674: creation_date,
1675: created_by,

Line 1793: FROM qp_list_headers_all_b

1789: --,to_char(list_header_id) --7309992
1790: ,to_char(l_new_list_header_id) --bug#12423441
1791:
1792: --fix for bug 4673872
1793: FROM qp_list_headers_all_b
1794: WHERE list_header_id = p_from_list_header_id;
1795:
1796: -- Object Security - sfiresto
1797:

Line 1801: FROM qp_list_headers_all_b

1797:
1798: SELECT list_type_code,pte_code,source_system_code
1799: INTO v_list_type_code,v_pte_code,v_source_system_code
1800: --fix for bug 4673872
1801: FROM qp_list_headers_all_b
1802: WHERE list_header_id = p_from_list_header_id;
1803:
1804: IF v_list_type_code = 'AGR' THEN
1805: QP_security.create_default_grants( p_instance_type => QP_security.G_AGREEMENT_OBJECT,

Line 1891: FROM QP_LIST_HEADERS_ALL_B

1887:
1888: SELECT ACTIVE_FLAG, LIST_TYPE_CODE
1889: INTO l_active_flag, l_list_type_code
1890: --fix for bug 4673872
1891: FROM QP_LIST_HEADERS_ALL_B
1892: WHERE LIST_HEADER_ID = l_qp_qualifiers_rec.list_header_id;
1893:
1894: EXCEPTION
1895: WHEN OTHERS THEN