259:
260: CURSOR c_func_exists IS
261: SELECT 'Y'
262: FROM fnd_responsibility r, fnd_compiled_menu_functions m, fnd_form_functions f
263: WHERE r.responsibility_id = fnd_global.resp_id
264: AND r.application_id=fnd_global.resp_appl_id
265: AND r.menu_id = m.menu_id
266: AND m.function_id = f.function_id
267: AND f.function_name = v_import_func;
260: CURSOR c_func_exists IS
261: SELECT 'Y'
262: FROM fnd_responsibility r, fnd_compiled_menu_functions m, fnd_form_functions f
263: WHERE r.responsibility_id = fnd_global.resp_id
264: AND r.application_id=fnd_global.resp_appl_id
265: AND r.menu_id = m.menu_id
266: AND m.function_id = f.function_id
267: AND f.function_name = v_import_func;
268:
268:
269: CURSOR c_func_excluded IS
270: SELECT 'Y'
271: FROM fnd_resp_functions rf, fnd_form_functions f
272: WHERE rf.application_id = fnd_global.resp_appl_id
273: AND rf.responsibility_id = fnd_global.resp_appl_id
274: AND rf.rule_type = 'F'
275: AND rf.action_id = f.function_id
276: AND f.function_name = v_import_func;
269: CURSOR c_func_excluded IS
270: SELECT 'Y'
271: FROM fnd_resp_functions rf, fnd_form_functions f
272: WHERE rf.application_id = fnd_global.resp_appl_id
273: AND rf.responsibility_id = fnd_global.resp_appl_id
274: AND rf.rule_type = 'F'
275: AND rf.action_id = f.function_id
276: AND f.function_name = v_import_func;
277:
834:
835: x_return_status VARCHAR2(30);
836:
837: BEGIN
838: --fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
839: --fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841:
842: -- use party_id as entered_by_id in AMW_CONSTRAINTS_B
835: x_return_status VARCHAR2(30);
836:
837: BEGIN
838: --fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
839: --fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841:
842: -- use party_id as entered_by_id in AMW_CONSTRAINTS_B
843: l_entered_by_id := Get_Party_Id(p_user_id);