DBA Data[Home] [Help]

APPS.JTF_TASK_WF_UTIL dependencies on FND_PROFILE

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

206:
207: l_group_rec c_group_members%ROWTYPE;
208: l_team_rec c_team_members%ROWTYPE;
209: l_role_name wf_roles.NAME%TYPE;
210: l_members VARCHAR2(80) := fnd_profile.VALUE('JTF_TASK_NOTIFY_MEMBERS');
211: BEGIN
212: l_role_name := NULL;
213:
214: IF p_resource_type_code = 'RS_EMPLOYEE' THEN

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

498: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
499: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
500: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
501: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
502: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
503: , x_return_status OUT NOCOPY VARCHAR2
504: , x_msg_count OUT NOCOPY NUMBER
505: , x_msg_data OUT NOCOPY VARCHAR2
506: ) IS

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

503: , x_return_status OUT NOCOPY VARCHAR2
504: , x_msg_count OUT NOCOPY NUMBER
505: , x_msg_data OUT NOCOPY VARCHAR2
506: ) IS
507: l_format_mask CONSTANT VARCHAR2(80) := fnd_profile.VALUE('ICX_DATE_FORMAT_MASK') || ' HH24:MI:SS';
508:
509: l_process jtf_task_types_b.workflow%TYPE;
510: l_itemtype VARCHAR2(8) := 'JTFTASK';
511: l_itemkey wf_item_activity_statuses.item_key%TYPE;