DBA Data[Home] [Help]

APPS.ENG_NIR_UTIL_PKG dependencies on EGO_PEOPLE_V

Line 138: SELECT PERSON_ID into l_party_id FROM EGO_PEOPLE_V WHERE USER_ID = p_wf_user_id;

134: BEGIN
135:
136: x_nir_cancel_status := 'TRUE';
137: -- First check whether user has edit privilege on this change or not.
138: SELECT PERSON_ID into l_party_id FROM EGO_PEOPLE_V WHERE USER_ID = p_wf_user_id;
139: /*
140: IF p_check_security = TRUE THEN
141: l_chk_fn_ret_val := EGO_DATA_SECURITY.check_function
142: (

Line 302: SELECT PERSON_ID into l_party_id FROM EGO_PEOPLE_V WHERE USER_ID = p_wf_user_id;

298: l_cancel_comments VARCHAR2(32767);
299:
300: BEGIN
301: -- p_check_security := TRUE;
302: SELECT PERSON_ID into l_party_id FROM EGO_PEOPLE_V WHERE USER_ID = p_wf_user_id;
303:
304: -- Query all the NIRs for this Item in this Organization and Cancel them.
305: FOR nirs IN c_nirs_for_this_item
306: LOOP