APPS.JTF_TASK_WF_UTIL dependencies on FND_PROFILE

Line 166: l_debug VARCHAR2(1):= NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');

162: l_display_name VARCHAR2(100); -- check this declaration
163: l_orig_system wf_users.orig_system% TYPE;
164: l_orig_system_id wf_users.orig_system_id% TYPE;
165: l_resource_party_rec c_resource_party%ROWTYPE;
166: l_debug VARCHAR2(1):= NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
167: l_pLog BOOLEAN := FALSE;
168: BEGIN
169: x_role_name := NULL;
170: l_pLog := (fnd_log.level_statement >= fnd_log.g_current_runtime_level);

Line 243: l_members VARCHAR2(80) := fnd_profile.VALUE('JTF_TASK_NOTIFY_MEMBERS');

239:
240: l_group_rec c_group_members%ROWTYPE;
241: l_team_rec c_team_members%ROWTYPE;
242: l_role_name wf_roles.NAME%TYPE;
243: l_members VARCHAR2(80) := fnd_profile.VALUE('JTF_TASK_NOTIFY_MEMBERS');
244: BEGIN
245: l_role_name := NULL;
246:
247: IF p_resource_type_code = 'RS_EMPLOYEE' THEN

Line 535: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')

531: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
532: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
533: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
534: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
535: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
536: , x_return_status OUT NOCOPY VARCHAR2
537: , x_msg_count OUT NOCOPY NUMBER
538: , x_msg_data OUT NOCOPY VARCHAR2
539: ) IS

Line 540: l_format_mask CONSTANT VARCHAR2(80) := fnd_profile.VALUE('ICX_DATE_FORMAT_MASK') || ' HH24:MI:SS';

536: , x_return_status OUT NOCOPY VARCHAR2
537: , x_msg_count OUT NOCOPY NUMBER
538: , x_msg_data OUT NOCOPY VARCHAR2
539: ) IS
540: l_format_mask CONSTANT VARCHAR2(80) := fnd_profile.VALUE('ICX_DATE_FORMAT_MASK') || ' HH24:MI:SS';
541:
542: l_process jtf_task_types_b.workflow%TYPE;
543: l_itemtype VARCHAR2(8) := 'JTFTASK';
544: l_itemkey wf_item_activity_statuses.item_key%TYPE;