APPS.QP_PRICE_LIST_UTIL dependencies on QP_LIST_HEADERS_B

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

1509: IF QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
1510: p_instance_type => QP_Security.G_PRICELIST_OBJECT,
1511: p_instance_pk1 => p_PRICE_LIST_rec.list_header_id) <> 'F' THEN
1512:
1513: --for moac changes QP_LIST_HEADERS_B to all_b to enable updates to PL with orig_org_id
1514: --that do not belong to the responsibility when the user has update privilges
1515: UPDATE QP_LIST_HEADERS_ALL_B
1516: SET ATTRIBUTE1 = p_PRICE_LIST_rec.attribute1
1517: , ATTRIBUTE10 = p_PRICE_LIST_rec.attribute10

Line 1633: INSERT INTO QP_LIST_HEADERS_B

1629:
1630: END IF;
1631: */
1632:
1633: INSERT INTO QP_LIST_HEADERS_B
1634: ( ATTRIBUTE1
1635: , ATTRIBUTE10
1636: , ATTRIBUTE11
1637: , ATTRIBUTE12

Line 1843: DELETE FROM QP_LIST_HEADERS_B

1839: raise no_data_found;
1840: end if;
1841: */
1842:
1843: DELETE FROM QP_LIST_HEADERS_B
1844: WHERE LIST_HEADER_ID = p_list_header_id;
1845:
1846:
1847:

Line 1977: FROM QP_LIST_HEADERS_B

1973: , l_PRICE_LIST_rec.sold_to_org_id
1974: , l_PRICE_LIST_rec.locked_from_list_header_id
1975: --added for MOAC
1976: , l_PRICE_LIST_rec.org_id
1977: FROM QP_LIST_HEADERS_B
1978: WHERE LIST_HEADER_ID = p_list_header_id
1979: ;
1980:
1981: SELECT NAME

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

2132: , l_PRICE_LIST_rec.sold_to_org_id
2133: , l_PRICE_LIST_rec.locked_from_list_header_id
2134: --added for MOAC
2135: , l_PRICE_LIST_rec.org_id
2136: --for moac changes QP_LIST_HEADERS_B to all_b to enable locks/updates to PL with orig_org_id
2137: --that do not belong to the responsibility when the user has update privilges
2138: FROM QP_LIST_HEADERS_ALL_B
2139: WHERE LIST_HEADER_ID = p_PRICE_LIST_rec.list_header_id
2140: FOR UPDATE NOWAIT;

Line 2824: from qp_list_headers_b h

2820: IF p_LIST_HEADER_ID IS NULL THEN
2821: RETURN NULL;
2822: ELSE
2823: Select COUNT(*) into l_exist
2824: from qp_list_headers_b h
2825: where h.orig_system_header_ref=to_char(p_LIST_HEADER_ID);
2826:
2827: IF l_exist>0 THEN
2828: RETURN 'INT-D-'||TO_CHAR(p_LIST_HEADER_ID);