eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_LIST_HEADERS_B

Line 1607: --for moac changes QP_LIST_HEADERS_B to all_b to enable updates to ML with orig_org_id

1603: if QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
1604: p_instance_type => QP_Security.G_MODIFIER_OBJECT,
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

Line 1814: INSERT INTO QP_LIST_HEADERS_B

1810: ,l_end_date_active_second
1811: );
1812: END IF;
1813:
1814: INSERT INTO QP_LIST_HEADERS_B
1815: ( ATTRIBUTE1
1816: , ATTRIBUTE10
1817: , ATTRIBUTE11
1818: , ATTRIBUTE12

Line 2070: DELETE FROM QP_LIST_HEADERS_B

2066:
2067: DELETE FROM QP_LIST_HEADERS_TL
2068: WHERE LIST_HEADER_ID = p_list_header_id;
2069:
2070: DELETE FROM QP_LIST_HEADERS_B
2071: WHERE LIST_HEADER_ID = p_list_header_id ;
2072:
2073: oe_debug_pub.add('END delete_row in QPXUMLHB');
2074: EXCEPTION

Line 2213: FROM QP_LIST_HEADERS_B

2209: , l_MODIFIER_LIST_rec.orig_system_header_ref
2210: , l_MODIFIER_LIST_rec.shareable_flag
2211: --added for MOAC
2212: , l_MODIFIER_LIST_rec.org_id
2213: FROM QP_LIST_HEADERS_B
2214: WHERE LIST_HEADER_ID = p_list_header_id
2215: ;
2216:
2217: SELECT NAME

Line 2375: --for moac changes QP_LIST_HEADERS_B to all_b to enable locks/updates to ML with orig_org_id

2371: , l_MODIFIER_LIST_rec.orig_system_header_ref
2372: , l_MODIFIER_LIST_rec.shareable_flag
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;