DBA Data[Home] [Help]

APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_LIST_HEADERS_ALL_B

Line 1840: UPDATE QP_LIST_HEADERS_ALL_B

1836: p_instance_pk1 => p_MODIFIER_LIST_rec.list_header_id) <> 'F' then
1837:
1838: --for moac changes QP_LIST_HEADERS_B to all_b to enable updates to ML with orig_org_id
1839: --that do not belong to the responsibility when the user has update privilges
1840: UPDATE QP_LIST_HEADERS_ALL_B
1841: SET ATTRIBUTE1 = p_MODIFIER_LIST_rec.attribute1
1842: , ATTRIBUTE10 = p_MODIFIER_LIST_rec.attribute10
1843: , ATTRIBUTE11 = p_MODIFIER_LIST_rec.attribute11
1844: , ATTRIBUTE12 = p_MODIFIER_LIST_rec.attribute12

Line 2608: FROM QP_LIST_HEADERS_ALL_B

2604: --added for MOAC
2605: , l_MODIFIER_LIST_rec.org_id
2606: --for moac changes QP_LIST_HEADERS_B to all_b to enable locks/updates to ML with orig_org_id
2607: --that do not belong to the responsibility when the user has update privilges
2608: FROM QP_LIST_HEADERS_ALL_B
2609: WHERE LIST_HEADER_ID = p_MODIFIER_LIST_rec.list_header_id
2610: FOR UPDATE NOWAIT;
2611:
2612: SELECT NAME