eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_WF_UTIL dependencies on JTF_TASK_WF_UTIL

Line 1: PACKAGE BODY jtf_task_wf_util AS

1: PACKAGE BODY jtf_task_wf_util AS
2: /* $Header: jtftkwub.pls 120.4.12010000.3 2008/11/18 10:51:56 rkamasam ship $ */
3: FUNCTION do_notification(p_task_id IN NUMBER)
4: RETURN BOOLEAN IS
5: CURSOR c_task_flag(b_task_id jtf_tasks_b.task_id%TYPE) IS

Line 133: l_index NUMBER := jtf_task_wf_util.notiflist.COUNT;

129: END IF;
130: END check_backcomp;
131:
132: PROCEDURE include_role(p_role_name IN VARCHAR2) IS
133: l_index NUMBER := jtf_task_wf_util.notiflist.COUNT;
134: l_search_index NUMBER;
135: l_role_name wf_roles.NAME%TYPE;
136: BEGIN
137: -- check to see if the role is already in the list

Line 141: FOR l_search_index IN jtf_task_wf_util.notiflist.FIRST .. jtf_task_wf_util.notiflist.LAST LOOP

137: -- check to see if the role is already in the list
138: l_role_name := p_role_name;
139:
140: IF l_index > 0 THEN
141: FOR l_search_index IN jtf_task_wf_util.notiflist.FIRST .. jtf_task_wf_util.notiflist.LAST LOOP
142: IF l_role_name = jtf_task_wf_util.notiflist(l_search_index).NAME THEN
143: l_role_name := NULL;
144: EXIT;
145: END IF;

Line 142: IF l_role_name = jtf_task_wf_util.notiflist(l_search_index).NAME THEN

138: l_role_name := p_role_name;
139:
140: IF l_index > 0 THEN
141: FOR l_search_index IN jtf_task_wf_util.notiflist.FIRST .. jtf_task_wf_util.notiflist.LAST LOOP
142: IF l_role_name = jtf_task_wf_util.notiflist(l_search_index).NAME THEN
143: l_role_name := NULL;
144: EXIT;
145: END IF;
146: END LOOP;

Line 151: jtf_task_wf_util.notiflist(l_index + 1).NAME := l_role_name;

147: END IF;
148:
149: IF l_role_name IS NOT NULL THEN
150: -- add the role to the list
151: jtf_task_wf_util.notiflist(l_index + 1).NAME := l_role_name;
152: END IF;
153: END include_role;
154:
155: PROCEDURE get_party_details(p_resource_id IN NUMBER, p_resource_type_code IN VARCHAR2, x_role_name OUT NOCOPY VARCHAR2) IS

Line 628: jtf_task_wf_util.g_event := p_event;

624: l_itemtype := SUBSTR(l_wf_items, 1, INSTR(l_wf_items, ',') - 1);
625: l_process := SUBSTR(l_wf_items, INSTR(l_wf_items, ',') + 1);
626:
627: --- Set global attributes so we can use this data later
628: jtf_task_wf_util.g_event := p_event;
629: jtf_task_wf_util.g_task_id := p_task_id;
630: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
631: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
632: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;

Line 629: jtf_task_wf_util.g_task_id := p_task_id;

625: l_process := SUBSTR(l_wf_items, INSTR(l_wf_items, ',') + 1);
626:
627: --- Set global attributes so we can use this data later
628: jtf_task_wf_util.g_event := p_event;
629: jtf_task_wf_util.g_task_id := p_task_id;
630: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
631: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
632: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
633: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;

Line 630: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;

626:
627: --- Set global attributes so we can use this data later
628: jtf_task_wf_util.g_event := p_event;
629: jtf_task_wf_util.g_task_id := p_task_id;
630: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
631: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
632: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
633: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
634: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;

Line 631: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;

627: --- Set global attributes so we can use this data later
628: jtf_task_wf_util.g_event := p_event;
629: jtf_task_wf_util.g_task_id := p_task_id;
630: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
631: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
632: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
633: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
634: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
635: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;

Line 632: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;

628: jtf_task_wf_util.g_event := p_event;
629: jtf_task_wf_util.g_task_id := p_task_id;
630: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
631: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
632: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
633: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
634: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
635: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
636: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;

Line 633: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;

629: jtf_task_wf_util.g_task_id := p_task_id;
630: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
631: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
632: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
633: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
634: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
635: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
636: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;
637: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;

Line 634: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;

630: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
631: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
632: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
633: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
634: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
635: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
636: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;
637: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;
638:

Line 635: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;

631: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
632: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
633: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
634: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
635: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
636: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;
637: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;
638:
639: -- Get the Translated Text for 'Not Entered' from message dictionary

Line 636: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;

632: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
633: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
634: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
635: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
636: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;
637: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;
638:
639: -- Get the Translated Text for 'Not Entered' from message dictionary
640: fnd_message.set_name('JTF', 'JTF_TASK_DATA_NOT_ENTERED');

Line 637: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;

633: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
634: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
635: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
636: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;
637: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;
638:
639: -- Get the Translated Text for 'Not Entered' from message dictionary
640: fnd_message.set_name('JTF', 'JTF_TASK_DATA_NOT_ENTERED');
641: l_not_entered := fnd_message.get;

Line 813: jtf_task_wf_util.notiflist.DELETE;

809: l_act_end_change_text := l_act_end_change_text || ' (' || l_old_date || ')';
810: END IF;
811: END IF;
812:
813: jtf_task_wf_util.notiflist.DELETE;
814:
815: -- Abort the previous WF if the parameter is set
816: IF p_abort_workflow = 'Y' AND l_task_rec.workflow_process_id IS NOT NULL THEN
817: abort_previous_wf(p_task_id => p_task_id, p_workflow_process_id => l_task_rec.workflow_process_id);

Line 1062: l_role := jtf_task_wf_util.notiflist(l_counter).NAME;

1058: l_role wf_roles.NAME%TYPE;
1059: BEGIN
1060: IF funcmode = 'RUN' THEN
1061: l_counter := wf_engine.getitemattrnumber(itemtype => itemtype, itemkey => itemkey, aname => 'LIST_COUNTER');
1062: l_role := jtf_task_wf_util.notiflist(l_counter).NAME;
1063:
1064: IF l_role IS NOT NULL THEN
1065: set_text_attr(p_itemtype => itemtype, p_itemkey => itemkey, p_attr_name => 'MESSAGE_RECIPIENT'
1066: , p_attr_value => l_role);

Line 1109: p_event => jtf_task_wf_util.g_event

1105: -------------------------------------------------------------------------
1106: -- Set the Notification List
1107: -------------------------------------------------------------------------
1108: list_notify_roles(
1109: p_event => jtf_task_wf_util.g_event
1110: , p_task_id => jtf_task_wf_util.g_task_id
1111: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1112: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1113: , p_new_owner_id => jtf_task_wf_util.g_owner_id

Line 1110: , p_task_id => jtf_task_wf_util.g_task_id

1106: -- Set the Notification List
1107: -------------------------------------------------------------------------
1108: list_notify_roles(
1109: p_event => jtf_task_wf_util.g_event
1110: , p_task_id => jtf_task_wf_util.g_task_id
1111: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1112: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1113: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1114: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code

Line 1111: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id

1107: -------------------------------------------------------------------------
1108: list_notify_roles(
1109: p_event => jtf_task_wf_util.g_event
1110: , p_task_id => jtf_task_wf_util.g_task_id
1111: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1112: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1113: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1114: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1115: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id

Line 1112: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code

1108: list_notify_roles(
1109: p_event => jtf_task_wf_util.g_event
1110: , p_task_id => jtf_task_wf_util.g_task_id
1111: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1112: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1113: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1114: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1115: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1116: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code

Line 1113: , p_new_owner_id => jtf_task_wf_util.g_owner_id

1109: p_event => jtf_task_wf_util.g_event
1110: , p_task_id => jtf_task_wf_util.g_task_id
1111: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1112: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1113: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1114: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1115: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1116: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1117: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id

Line 1114: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code

1110: , p_task_id => jtf_task_wf_util.g_task_id
1111: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1112: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1113: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1114: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1115: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1116: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1117: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1118: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code

Line 1115: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id

1111: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1112: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1113: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1114: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1115: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1116: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1117: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1118: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code
1119: );

Line 1116: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code

1112: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1113: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1114: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1115: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1116: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1117: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1118: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code
1119: );
1120:

Line 1117: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id

1113: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1114: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1115: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1116: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1117: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1118: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code
1119: );
1120:
1121: IF jtf_task_wf_util.notiflist.COUNT > 0 THEN

Line 1118: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code

1114: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1115: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1116: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1117: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1118: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code
1119: );
1120:
1121: IF jtf_task_wf_util.notiflist.COUNT > 0 THEN
1122: -------------------------------------------------------------------------

Line 1121: IF jtf_task_wf_util.notiflist.COUNT > 0 THEN

1117: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1118: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code
1119: );
1120:
1121: IF jtf_task_wf_util.notiflist.COUNT > 0 THEN
1122: -------------------------------------------------------------------------
1123: -- Set the process counters
1124: -------------------------------------------------------------------------
1125: l_counter := jtf_task_wf_util.notiflist.COUNT;

Line 1125: l_counter := jtf_task_wf_util.notiflist.COUNT;

1121: IF jtf_task_wf_util.notiflist.COUNT > 0 THEN
1122: -------------------------------------------------------------------------
1123: -- Set the process counters
1124: -------------------------------------------------------------------------
1125: l_counter := jtf_task_wf_util.notiflist.COUNT;
1126: set_num_attr(
1127: p_itemtype => itemtype
1128: , p_itemkey => itemkey
1129: , p_attr_name => 'LIST_COUNTER'

Line 1160: END jtf_task_wf_util;

1156: WHEN OTHERS THEN
1157: wf_core.CONTEXT(g_pkg_name, 'Set_Notif_List', itemtype, itemkey, TO_CHAR(actid), funcmode);
1158: RAISE;
1159: END set_notif_list;
1160: END jtf_task_wf_util;