DBA Data[Home] [Help]

APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_LIST_HEADERS_ALL_B

Line 1609: UPDATE QP_LIST_HEADERS_ALL_B

1605: p_instance_pk1 => p_MODIFIER_LIST_rec.list_header_id) <> 'F' then
1606:
1607: --for moac changes QP_LIST_HEADERS_B to all_b to enable updates to ML with orig_org_id
1608: --that do not belong to the responsibility when the user has update privilges
1609: UPDATE QP_LIST_HEADERS_ALL_B
1610: SET ATTRIBUTE1 = p_MODIFIER_LIST_rec.attribute1
1611: , ATTRIBUTE10 = p_MODIFIER_LIST_rec.attribute10
1612: , ATTRIBUTE11 = p_MODIFIER_LIST_rec.attribute11
1613: , ATTRIBUTE12 = p_MODIFIER_LIST_rec.attribute12

Line 2377: FROM QP_LIST_HEADERS_ALL_B

2373: --added for MOAC
2374: , l_MODIFIER_LIST_rec.org_id
2375: --for moac changes QP_LIST_HEADERS_B to all_b to enable locks/updates to ML with orig_org_id
2376: --that do not belong to the responsibility when the user has update privilges
2377: FROM QP_LIST_HEADERS_ALL_B
2378: WHERE LIST_HEADER_ID = p_MODIFIER_LIST_rec.list_header_id
2379: FOR UPDATE NOWAIT;
2380:
2381: SELECT NAME