DBA Data[Home] [Help]

APPS.AMW_LOAD_CONSTRAINT_DATA dependencies on FND_GLOBAL

Line 263: WHERE r.responsibility_id = fnd_global.resp_id

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;

Line 264: AND r.application_id=fnd_global.resp_appl_id

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:

Line 272: WHERE rf.application_id = fnd_global.resp_appl_id

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;

Line 273: AND rf.responsibility_id = fnd_global.resp_appl_id

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:

Line 838: --fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);

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

Line 839: --fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);

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);