DBA Data[Home] [Help]

APPS.QP_PRICE_LIST_UTIL dependencies on QP_LIST_HEADERS_ALL_B

Line 1515: UPDATE QP_LIST_HEADERS_ALL_B

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
1518: , ATTRIBUTE11 = p_PRICE_LIST_rec.attribute11
1519: , ATTRIBUTE12 = p_PRICE_LIST_rec.attribute12

Line 2138: FROM QP_LIST_HEADERS_ALL_B

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;
2141:
2142: -- Row locked. Compare IN attributes to DB attributes.