APPS.QP_COPY_MODIFIERS_PVT dependencies on QP_LIST_HEADERS_ALL_B

Line 204: SELECT GSA_INDICATOR INTO l_gsa_indicator FROM QP_LIST_HEADERS_ALL_B

200:
201: l_qp_status := QP_UTIL.GET_QP_STATUS;
202:
203: --fix for bug 4673872
204: SELECT GSA_INDICATOR INTO l_gsa_indicator FROM QP_LIST_HEADERS_ALL_B
205: WHERE list_header_id=p_new_list_header_id;
206:
207: IF (fnd_profile.value('QP_ALLOW_DUPLICATE_MODIFIERS') <> 'Y'
208: AND (l_qp_status = 'S' OR l_gsa_indicator = 'Y')) THEN

Line 348: FROM qp_list_headers_ALL_b

344: AND a.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
345: AND a.list_header_id IN
346: (SELECT list_header_id
347: --fix for bug 4673872
348: FROM qp_list_headers_ALL_b
349: WHERE list_type_code = 'DLT');
350: */
351: CURSOR qp_from_discounts_cur(p_from_list_header_id NUMBER)
352: IS

Line 355: FROM qp_list_headers_ALL_b

351: CURSOR qp_from_discounts_cur(p_from_list_header_id NUMBER)
352: IS
353: SELECT list_header_id
354: --fix for bug 4673872
355: FROM qp_list_headers_ALL_b
356: WHERE list_header_id = p_from_list_header_id
357: AND list_type_code in ('DLT','DEL','CHARGES','PRO','SLT');
358:
359: CURSOR qp_qualifiers_cur(p_from_discount_header_id NUMBER)

Line 418: INSERT INTO qp_list_headers_all_b

414: --Discount Header Information
415:
416: --if fnd_profile.value('QP_ATTRIBUTE_MANAGER_INSTALLED') = 'Y' then
417: if QP_UTIL.Attrmgr_Installed = 'Y' then
418: INSERT INTO qp_list_headers_all_b
419: (
420: list_header_id,
421: creation_date,
422: created_by,

Line 545: FROM qp_list_headers_ALL_b

541: p_org_id
542: --ENH Upgrade BOAPI for orig_sys...ref RAVI
543: --,nvl(ORIG_SYSTEM_HEADER_REF,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id))
544: --fix for bug 4673872
545: FROM qp_list_headers_ALL_b
546: WHERE list_header_id = qp_from_discounts_rec.list_header_id;
547: else
548: INSERT INTO qp_list_headers_all_b
549: (

Line 548: INSERT INTO qp_list_headers_all_b

544: --fix for bug 4673872
545: FROM qp_list_headers_ALL_b
546: WHERE list_header_id = qp_from_discounts_rec.list_header_id;
547: else
548: INSERT INTO qp_list_headers_all_b
549: (
550: list_header_id,
551: creation_date,
552: created_by,

Line 673: FROM qp_list_headers_ALL_b

669: p_org_id
670: --ENH Upgrade BOAPI for orig_sys...ref RAVI
671: --,nvl(ORIG_SYSTEM_HEADER_REF,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id))
672: --fix for bug 4673872
673: FROM qp_list_headers_ALL_b
674: WHERE list_header_id = qp_from_discounts_rec.list_header_id;
675: end if;
676: --
677: SELECT version_no

Line 751: FROM QP_LIST_HEADERS_ALL_B

747:
748: SELECT ACTIVE_FLAG, LIST_TYPE_CODE
749: INTO l_active_flag, l_list_type_code
750: --fix for bug 4673872
751: FROM QP_LIST_HEADERS_ALL_B
752: WHERE LIST_HEADER_ID = l_new_discount_header_id;
753:
754: EXCEPTION
755: WHEN OTHERS THEN

Line 1161: FROM QP_LIST_HEADERS_ALL_B

1157:
1158: SELECT ACTIVE_FLAG, LIST_TYPE_CODE
1159: INTO l_active_flag, l_list_type_code
1160: --fix for bug 4673872
1161: FROM QP_LIST_HEADERS_ALL_B
1162: WHERE LIST_HEADER_ID = l_new_discount_header_id;
1163:
1164: EXCEPTION
1165: WHEN OTHERS THEN