APPS.OTA_INITIALIZATION_WF dependencies on FND_PROFILE

Line 1109: l_notify_days_before number(9) := fnd_profile.value('OTA_INST_REMIND_NTF_DAYS');

1105: p_event_id in ota_events.event_id%type default null)
1106: is
1107: l_proc varchar2(72) := g_package||'Initialize_auto_wf';
1108:
1109: l_notify_days_before number(9) := fnd_profile.value('OTA_INST_REMIND_NTF_DAYS');
1110:
1111: --get all classes begining today
1112:
1113: cursor get_all_class_info

Line 1311: l_creator_username varchar2(80):= fnd_profile.value('USERNAME');

1307: is
1308:
1309: l_proc varchar2(72) := g_package||'set_wf_item_attr';
1310:
1311: l_creator_username varchar2(80):= fnd_profile.value('USERNAME');
1312: l_creator_user_Id number := fnd_profile.value('USER_ID');
1313: l_creator_full_name per_all_people_f.full_name%TYPE;
1314:
1315: l_current_username varchar2(80);

Line 1312: l_creator_user_Id number := fnd_profile.value('USER_ID');

1308:
1309: l_proc varchar2(72) := g_package||'set_wf_item_attr';
1310:
1311: l_creator_username varchar2(80):= fnd_profile.value('USERNAME');
1312: l_creator_user_Id number := fnd_profile.value('USER_ID');
1313: l_creator_full_name per_all_people_f.full_name%TYPE;
1314:
1315: l_current_username varchar2(80);
1316: