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.13 2011/12/22 07:24:16 hemasha 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 174: ,module => 'jtf.jtf_task_wf_util.get_party_details'

170: l_pLog := (fnd_log.level_statement >= fnd_log.g_current_runtime_level);
171: IF p_resource_type_code IN('RS_PARTNER', 'RS_PARTY') THEN
172: IF(l_debug = 'Y' AND l_pLog = TRUE) THEN
173: fnd_log.STRING(log_level => fnd_log.level_statement
174: ,module => 'jtf.jtf_task_wf_util.get_party_details'
175: ,message => 'entering into partner or party section');
176: END IF;
177: OPEN c_resource_party(p_resource_id);
178: FETCH c_resource_party INTO l_resource_party_rec;

Line 189: ,module => 'jtf.jtf_task_wf_util.get_party_details'

185: l_orig_system_id := l_resource_party_rec.source_id;
186: ELSIF p_resource_type_code = 'RS_SUPPLIER_CONTACT' THEN
187: IF(l_debug = 'Y' AND l_pLog = TRUE) THEN
188: fnd_log.STRING(log_level => fnd_log.level_statement
189: ,module => 'jtf.jtf_task_wf_util.get_party_details'
190: ,message => 'entering into supplier contact');
191: END IF;
192: -- supplier or party resource
193: OPEN c_resource_party(p_resource_id);

Line 209: ,module => 'jtf.jtf_task_wf_util.get_party_details'

205: l_orig_system_id := p_resource_id;
206: END IF;
207: IF(l_debug = 'Y' AND l_pLog = TRUE) THEN
208: fnd_log.STRING(log_level => fnd_log.level_statement
209: ,module => 'jtf.jtf_task_wf_util.get_party_details'
210: ,message => 'orig_system and orig_system_id '||l_orig_system||' '||l_orig_system_id);
211: END IF;
212: wf_directory.getusername(l_orig_system, l_orig_system_id, x_role_name, l_display_name);
213:

Line 661: jtf_task_wf_util.g_event := p_event;

657: l_itemtype := SUBSTR(l_wf_items, 1, INSTR(l_wf_items, ',') - 1);
658: l_process := SUBSTR(l_wf_items, INSTR(l_wf_items, ',') + 1);
659:
660: --- Set global attributes so we can use this data later
661: jtf_task_wf_util.g_event := p_event;
662: jtf_task_wf_util.g_task_id := p_task_id;
663: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
664: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
665: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;

Line 662: jtf_task_wf_util.g_task_id := p_task_id;

658: l_process := SUBSTR(l_wf_items, INSTR(l_wf_items, ',') + 1);
659:
660: --- Set global attributes so we can use this data later
661: jtf_task_wf_util.g_event := p_event;
662: jtf_task_wf_util.g_task_id := p_task_id;
663: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
664: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
665: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
666: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;

Line 663: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;

659:
660: --- Set global attributes so we can use this data later
661: jtf_task_wf_util.g_event := p_event;
662: jtf_task_wf_util.g_task_id := p_task_id;
663: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
664: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
665: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
666: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
667: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;

Line 664: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;

660: --- Set global attributes so we can use this data later
661: jtf_task_wf_util.g_event := p_event;
662: jtf_task_wf_util.g_task_id := p_task_id;
663: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
664: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
665: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
666: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
667: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
668: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;

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

661: jtf_task_wf_util.g_event := p_event;
662: jtf_task_wf_util.g_task_id := p_task_id;
663: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
664: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
665: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
666: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
667: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
668: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
669: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;

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

662: jtf_task_wf_util.g_task_id := p_task_id;
663: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
664: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
665: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
666: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
667: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
668: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
669: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;
670: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;

Line 667: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;

663: jtf_task_wf_util.g_old_owner_id := p_old_owner_id;
664: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
665: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
666: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
667: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
668: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
669: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;
670: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;
671:

Line 668: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;

664: jtf_task_wf_util.g_old_owner_code := p_old_owner_code;
665: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
666: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
667: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
668: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
669: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;
670: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;
671:
672: -- Get the Translated Text for 'Not Entered' from message dictionary

Line 669: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;

665: jtf_task_wf_util.g_owner_id := l_task_rec.owner_id;
666: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
667: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
668: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
669: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;
670: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;
671:
672: -- Get the Translated Text for 'Not Entered' from message dictionary
673: fnd_message.set_name('JTF', 'JTF_TASK_DATA_NOT_ENTERED');

Line 670: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;

666: jtf_task_wf_util.g_owner_type_code := l_task_rec.owner_type_code;
667: jtf_task_wf_util.g_old_assignee_id := p_old_assignee_id;
668: jtf_task_wf_util.g_old_assignee_code := p_old_assignee_code;
669: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;
670: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;
671:
672: -- Get the Translated Text for 'Not Entered' from message dictionary
673: fnd_message.set_name('JTF', 'JTF_TASK_DATA_NOT_ENTERED');
674: l_not_entered := fnd_message.get;

Line 847: jtf_task_wf_util.notiflist.DELETE;

843: l_act_end_change_text := l_act_end_change_text || ' (' || l_old_date || ')';
844: END IF;
845: END IF;
846:
847: jtf_task_wf_util.notiflist.DELETE;
848:
849: -- Abort the previous WF if the parameter is set
850: IF p_abort_workflow = 'Y' AND l_task_rec.workflow_process_id IS NOT NULL THEN
851: abort_previous_wf(p_task_id => p_task_id, p_workflow_process_id => l_task_rec.workflow_process_id);

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

1092: l_role wf_roles.NAME%TYPE;
1093: BEGIN
1094: IF funcmode = 'RUN' THEN
1095: l_counter := wf_engine.getitemattrnumber(itemtype => itemtype, itemkey => itemkey, aname => 'LIST_COUNTER');
1096: l_role := jtf_task_wf_util.notiflist(l_counter).NAME;
1097:
1098: IF l_role IS NOT NULL THEN
1099: set_text_attr(p_itemtype => itemtype, p_itemkey => itemkey, p_attr_name => 'MESSAGE_RECIPIENT'
1100: , p_attr_value => l_role);

Line 1143: p_event => jtf_task_wf_util.g_event

1139: -------------------------------------------------------------------------
1140: -- Set the Notification List
1141: -------------------------------------------------------------------------
1142: list_notify_roles(
1143: p_event => jtf_task_wf_util.g_event
1144: , p_task_id => jtf_task_wf_util.g_task_id
1145: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1146: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1147: , p_new_owner_id => jtf_task_wf_util.g_owner_id

Line 1144: , p_task_id => jtf_task_wf_util.g_task_id

1140: -- Set the Notification List
1141: -------------------------------------------------------------------------
1142: list_notify_roles(
1143: p_event => jtf_task_wf_util.g_event
1144: , p_task_id => jtf_task_wf_util.g_task_id
1145: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1146: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1147: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1148: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code

Line 1145: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id

1141: -------------------------------------------------------------------------
1142: list_notify_roles(
1143: p_event => jtf_task_wf_util.g_event
1144: , p_task_id => jtf_task_wf_util.g_task_id
1145: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1146: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1147: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1148: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1149: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id

Line 1146: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code

1142: list_notify_roles(
1143: p_event => jtf_task_wf_util.g_event
1144: , p_task_id => jtf_task_wf_util.g_task_id
1145: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1146: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1147: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1148: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1149: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1150: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code

Line 1147: , p_new_owner_id => jtf_task_wf_util.g_owner_id

1143: p_event => jtf_task_wf_util.g_event
1144: , p_task_id => jtf_task_wf_util.g_task_id
1145: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1146: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1147: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1148: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1149: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1150: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1151: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id

Line 1148: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code

1144: , p_task_id => jtf_task_wf_util.g_task_id
1145: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1146: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1147: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1148: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1149: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1150: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1151: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1152: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code

Line 1149: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id

1145: , p_old_owner_id => jtf_task_wf_util.g_old_owner_id
1146: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1147: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1148: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1149: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1150: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1151: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1152: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code
1153: );

Line 1150: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code

1146: , p_old_owner_code => jtf_task_wf_util.g_old_owner_code
1147: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1148: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1149: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1150: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1151: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1152: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code
1153: );
1154:

Line 1151: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id

1147: , p_new_owner_id => jtf_task_wf_util.g_owner_id
1148: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1149: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1150: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1151: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1152: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code
1153: );
1154:
1155: IF jtf_task_wf_util.notiflist.COUNT > 0 THEN

Line 1152: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code

1148: , p_new_owner_code => jtf_task_wf_util.g_owner_type_code
1149: , p_old_assignee_id => jtf_task_wf_util.g_old_assignee_id
1150: , p_old_assignee_code => jtf_task_wf_util.g_old_assignee_code
1151: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1152: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code
1153: );
1154:
1155: IF jtf_task_wf_util.notiflist.COUNT > 0 THEN
1156: -------------------------------------------------------------------------

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

1151: , p_new_assignee_id => jtf_task_wf_util.g_new_assignee_id
1152: , p_new_assignee_code => jtf_task_wf_util.g_new_assignee_code
1153: );
1154:
1155: IF jtf_task_wf_util.notiflist.COUNT > 0 THEN
1156: -------------------------------------------------------------------------
1157: -- Set the process counters
1158: -------------------------------------------------------------------------
1159: l_counter := jtf_task_wf_util.notiflist.COUNT;

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

1155: IF jtf_task_wf_util.notiflist.COUNT > 0 THEN
1156: -------------------------------------------------------------------------
1157: -- Set the process counters
1158: -------------------------------------------------------------------------
1159: l_counter := jtf_task_wf_util.notiflist.COUNT;
1160: set_num_attr(
1161: p_itemtype => itemtype
1162: , p_itemkey => itemkey
1163: , p_attr_name => 'LIST_COUNTER'

Line 1194: END jtf_task_wf_util;

1190: WHEN OTHERS THEN
1191: wf_core.CONTEXT(g_pkg_name, 'Set_Notif_List', itemtype, itemkey, TO_CHAR(actid), funcmode);
1192: RAISE;
1193: END set_notif_list;
1194: END jtf_task_wf_util;