DBA Data[Home] [Help]

APPS.QP_PRICE_LIST_UTIL dependencies on QP_LIST_HEADERS_ALL_B

Line 1376: UPDATE QP_LIST_HEADERS_ALL_B

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

Line 1999: FROM QP_LIST_HEADERS_ALL_B

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