[Home] [Help]
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
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