APPS.QP_PRICE_LIST_UTIL dependencies on QP_LIST_HEADERS_B

Line 1374: --for moac changes QP_LIST_HEADERS_B to all_b to enable updates to PL with orig_org_id

1370: IF QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
1371: p_instance_type => QP_Security.G_PRICELIST_OBJECT,
1372: p_instance_pk1 => p_PRICE_LIST_rec.list_header_id) <> 'F' THEN
1373:
1374: --for moac changes QP_LIST_HEADERS_B to all_b to enable updates to PL with orig_org_id
1375: --that do not belong to the responsibility when the user has update privilges
1376: UPDATE QP_LIST_HEADERS_ALL_B
1377: SET ATTRIBUTE1 = p_PRICE_LIST_rec.attribute1
1378: , ATTRIBUTE10 = p_PRICE_LIST_rec.attribute10

Line 1494: INSERT INTO QP_LIST_HEADERS_B

1490:
1491: END IF;
1492: */
1493:
1494: INSERT INTO QP_LIST_HEADERS_B
1495: ( ATTRIBUTE1
1496: , ATTRIBUTE10
1497: , ATTRIBUTE11
1498: , ATTRIBUTE12

Line 1704: DELETE FROM QP_LIST_HEADERS_B

1700: raise no_data_found;
1701: end if;
1702: */
1703:
1704: DELETE FROM QP_LIST_HEADERS_B
1705: WHERE LIST_HEADER_ID = p_list_header_id;
1706:
1707:
1708:

Line 1838: FROM QP_LIST_HEADERS_B

1834: , l_PRICE_LIST_rec.sold_to_org_id
1835: , l_PRICE_LIST_rec.locked_from_list_header_id
1836: --added for MOAC
1837: , l_PRICE_LIST_rec.org_id
1838: FROM QP_LIST_HEADERS_B
1839: WHERE LIST_HEADER_ID = p_list_header_id
1840: ;
1841:
1842: SELECT NAME

Line 1997: --for moac changes QP_LIST_HEADERS_B to all_b to enable locks/updates to PL with orig_org_id

1993: , l_PRICE_LIST_rec.sold_to_org_id
1994: , l_PRICE_LIST_rec.locked_from_list_header_id
1995: --added for MOAC
1996: , l_PRICE_LIST_rec.org_id
1997: --for moac changes QP_LIST_HEADERS_B to all_b to enable locks/updates to PL with orig_org_id
1998: --that do not belong to the responsibility when the user has update privilges
1999: FROM QP_LIST_HEADERS_ALL_B
2000: WHERE LIST_HEADER_ID = p_PRICE_LIST_rec.list_header_id
2001: FOR UPDATE NOWAIT;

Line 2634: from qp_list_headers_b h

2630: IF p_LIST_HEADER_ID IS NULL THEN
2631: RETURN NULL;
2632: ELSE
2633: Select COUNT(*) into l_exist
2634: from qp_list_headers_b h
2635: where h.orig_system_header_ref=to_char(p_LIST_HEADER_ID);
2636:
2637: IF l_exist>0 THEN
2638: RETURN 'INT-D-'||TO_CHAR(p_LIST_HEADER_ID);