APPS.MRP_CREATE_SCHEDULE_ISO dependencies on FND_PROFILE

Line 4: l_debug varchar2(30) := FND_PROFILE.Value('MRP_DEBUG');

1: PACKAGE BODY MRP_CREATE_SCHEDULE_ISO AS
2: /* $Header: MRPCISOB.pls 120.18 2012/05/18 21:34:17 pstrnad ship $ */
3:
4: l_debug varchar2(30) := FND_PROFILE.Value('MRP_DEBUG');
5:
6:
7: /********************************************************
8: PROCEDURE : log_message

Line 112: FROM fnd_profile_options opt,

108: CURSOR c_security (l_org_id number,
109: l_user_id number,
110: l_appl_id number) IS
111: SELECT level_id, level_value
112: FROM fnd_profile_options opt,
113: fnd_profile_option_values opt_vals,
114: fnd_user_resp_groups user_resp
115: WHERE opt.profile_option_name = 'ORG_ID'
116: AND opt.profile_option_id = opt_vals.profile_option_id

Line 113: fnd_profile_option_values opt_vals,

109: l_user_id number,
110: l_appl_id number) IS
111: SELECT level_id, level_value
112: FROM fnd_profile_options opt,
113: fnd_profile_option_values opt_vals,
114: fnd_user_resp_groups user_resp
115: WHERE opt.profile_option_name = 'ORG_ID'
116: AND opt.profile_option_id = opt_vals.profile_option_id
117: AND opt_vals.profile_option_value = to_char(l_org_id)