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 1838: --for moac changes QP_LIST_HEADERS_B to all_b to enable updates to ML with orig_org_id

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

Line 2045: INSERT INTO QP_LIST_HEADERS_B

2041: ,l_end_date_active_second
2042: );
2043: END IF;
2044:
2045: INSERT INTO QP_LIST_HEADERS_B
2046: ( ATTRIBUTE1
2047: , ATTRIBUTE10
2048: , ATTRIBUTE11
2049: , ATTRIBUTE12

Line 2301: DELETE FROM QP_LIST_HEADERS_B

2297:
2298: DELETE FROM QP_LIST_HEADERS_TL
2299: WHERE LIST_HEADER_ID = p_list_header_id;
2300:
2301: DELETE FROM QP_LIST_HEADERS_B
2302: WHERE LIST_HEADER_ID = p_list_header_id ;
2303:
2304: oe_debug_pub.add('END delete_row in QPXUMLHB');
2305: EXCEPTION

Line 2444: FROM QP_LIST_HEADERS_B

2440: , l_MODIFIER_LIST_rec.orig_system_header_ref
2441: , l_MODIFIER_LIST_rec.shareable_flag
2442: --added for MOAC
2443: , l_MODIFIER_LIST_rec.org_id
2444: FROM QP_LIST_HEADERS_B
2445: WHERE LIST_HEADER_ID = p_list_header_id
2446: ;
2447:
2448: SELECT NAME

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

2602: , l_MODIFIER_LIST_rec.orig_system_header_ref
2603: , l_MODIFIER_LIST_rec.shareable_flag
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;