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.PA_TEAM_TEMPLATES_PVT dependencies on WF_ENGINE

Line 43: l_save_threshold := wf_engine.threshold;

39: --initialize return status to Success
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:
42: -- Setting thresold value to run the process in background
43: l_save_threshold := wf_engine.threshold;
44:
45: IF wf_engine.threshold < 0 THEN
46: wf_engine.threshold := l_save_threshold;
47: END IF;

Line 45: IF wf_engine.threshold < 0 THEN

41:
42: -- Setting thresold value to run the process in background
43: l_save_threshold := wf_engine.threshold;
44:
45: IF wf_engine.threshold < 0 THEN
46: wf_engine.threshold := l_save_threshold;
47: END IF;
48: wf_engine.threshold := -1;
49:

Line 46: wf_engine.threshold := l_save_threshold;

42: -- Setting thresold value to run the process in background
43: l_save_threshold := wf_engine.threshold;
44:
45: IF wf_engine.threshold < 0 THEN
46: wf_engine.threshold := l_save_threshold;
47: END IF;
48: wf_engine.threshold := -1;
49:
50: FOR l_index IN p_team_template_id_tbl.FIRST..p_team_template_id_tbl.LAST LOOP

Line 48: wf_engine.threshold := -1;

44:
45: IF wf_engine.threshold < 0 THEN
46: wf_engine.threshold := l_save_threshold;
47: END IF;
48: wf_engine.threshold := -1;
49:
50: FOR l_index IN p_team_template_id_tbl.FIRST..p_team_template_id_tbl.LAST LOOP
51:
52: SELECT pa_apply_team_template_wf_s.nextval

Line 60: WF_ENGINE.CreateProcess( itemtype => l_item_type,

56: --get the item key --- **USE SEQUENCE**
57: l_item_key := p_team_template_id_tbl(l_index).team_template_id||'-'||l_nextval;
58:
59: -- Creating the work flow process
60: WF_ENGINE.CreateProcess( itemtype => l_item_type,
61: itemkey => l_item_key,
62: process => 'PA_APPLY_TEAM_TEMPLATE') ;
63:
64: -- Setting the attribute value for team template id

Line 65: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,

61: itemkey => l_item_key,
62: process => 'PA_APPLY_TEAM_TEMPLATE') ;
63:
64: -- Setting the attribute value for team template id
65: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,
66: itemkey => l_item_key,
67: aname => 'TEAM_TEMPLATE_ID',
68: avalue => p_team_template_id_tbl(l_index).team_template_id);
69:

Line 71: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,

67: aname => 'TEAM_TEMPLATE_ID',
68: avalue => p_team_template_id_tbl(l_index).team_template_id);
69:
70: -- Setting the attribute value for project id
71: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,
72: itemkey => l_item_key,
73: aname => 'PROJECT_ID',
74: avalue => p_project_id);
75:

Line 77: WF_ENGINE.SetItemAttrDate( itemtype => l_item_type,

73: aname => 'PROJECT_ID',
74: avalue => p_project_id);
75:
76: -- Setting the attribute value for project start date
77: WF_ENGINE.SetItemAttrDate( itemtype => l_item_type,
78: itemkey => l_item_key,
79: aname => 'PROJECT_START_DATE',
80: avalue => p_project_start_date);
81:

Line 83: WF_ENGINE.SetItemAttrDate( itemtype => l_item_type,

79: aname => 'PROJECT_START_DATE',
80: avalue => p_project_start_date);
81:
82: -- Setting the attribute value for team start date
83: WF_ENGINE.SetItemAttrDate( itemtype => l_item_type,
84: itemkey => l_item_key,
85: aname => 'TEAM_START_DATE',
86: avalue => p_team_start_date);
87:

Line 89: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,

85: aname => 'TEAM_START_DATE',
86: avalue => p_team_start_date);
87:
88: -- Setting the attribute value for use project location
89: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,
90: itemkey => l_item_key,
91: aname => 'USE_PROJECT_LOCATION',
92: avalue => p_use_project_location);
93:

Line 95: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,

91: aname => 'USE_PROJECT_LOCATION',
92: avalue => p_use_project_location);
93:
94: -- Setting the attribute value for project location id
95: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,
96: itemkey => l_item_key,
97: aname => 'PROJECT_LOCATION_ID',
98: avalue => p_project_location_id);
99:

Line 101: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,

97: aname => 'PROJECT_LOCATION_ID',
98: avalue => p_project_location_id);
99:
100: -- Setting the attribute value for use project calendar
101: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,
102: itemkey => l_item_key,
103: aname => 'USE_PROJECT_CALENDAR',
104: avalue => p_use_project_calendar);
105:

Line 107: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,

103: aname => 'USE_PROJECT_CALENDAR',
104: avalue => p_use_project_calendar);
105:
106: -- Setting the attribute value for project calendar id
107: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,
108: itemkey => l_item_key,
109: aname => 'PROJECT_CALENDAR_ID',
110: avalue => p_project_calendar_id);
111:

Line 113: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,

109: aname => 'PROJECT_CALENDAR_ID',
110: avalue => p_project_calendar_id);
111:
112: -- Setting the attribute value for project calendar id
113: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,
114: itemkey => l_item_key,
115: aname => 'APPLIER_USER_NAME',
116: avalue => FND_GLOBAL.user_name);
117:

Line 121: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type

117:
118: ---- Code added for bug 3919767 for setting the context values for running WF process
119:
120:
121: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type
122: , itemkey => l_item_key
123: , aname => 'USER_ID'
124: , avalue => FND_GLOBAL.USER_ID);
125:

Line 126: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type

122: , itemkey => l_item_key
123: , aname => 'USER_ID'
124: , avalue => FND_GLOBAL.USER_ID);
125:
126: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type
127: , itemkey => l_item_key
128: , aname => 'RESPONSIBILITY_ID'
129: , avalue => FND_GLOBAL.RESP_ID);
130:

Line 131: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type

127: , itemkey => l_item_key
128: , aname => 'RESPONSIBILITY_ID'
129: , avalue => FND_GLOBAL.RESP_ID);
130:
131: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type
132: , itemkey => l_item_key
133: , aname => 'APPLICATION_ID'
134: , avalue => FND_GLOBAL.RESP_APPL_ID);
135:

Line 143: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,

139: OPEN get_project_name_and_number;
140: FETCH get_project_name_and_number INTO l_project_name, l_project_number;
141: CLOSE get_project_name_and_number;
142:
143: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,
144: itemkey => l_item_key,
145: aname => 'PROJECT_NAME',
146: avalue => l_project_name);
147:

Line 148: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,

144: itemkey => l_item_key,
145: aname => 'PROJECT_NAME',
146: avalue => l_project_name);
147:
148: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,
149: itemkey => l_item_key,
150: aname => 'PROJECT_NUMBER',
151: avalue => l_project_number);
152:

Line 158: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,

154: OPEN get_team_template_name(p_team_template_id_tbl(l_index).team_template_id);
155: FETCH get_team_template_name INTO l_team_template_name;
156: CLOSE get_team_template_name;
157:
158: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,
159: itemkey => l_item_key,
160: aname => 'TEAM_TEMPLATE_NAME',
161: avalue => l_team_template_name);
162:

Line 164: WF_ENGINE.StartProcess( itemtype => l_item_type,

160: aname => 'TEAM_TEMPLATE_NAME',
161: avalue => l_team_template_name);
162:
163: -- start the workflow process
164: WF_ENGINE.StartProcess( itemtype => l_item_type,
165: itemkey => l_item_key);
166:
167:
168: UPDATE pa_team_templates

Line 175: wf_engine.threshold := l_save_threshold;

171:
172: END LOOP;
173:
174: --Setting the original value
175: wf_engine.threshold := l_save_threshold;
176:
177: EXCEPTION
178: WHEN OTHERS THEN
179:

Line 181: wf_engine.threshold := l_save_threshold;

177: EXCEPTION
178: WHEN OTHERS THEN
179:
180: --Setting the original value
181: wf_engine.threshold := l_save_threshold;
182:
183: -- Set the excetption Message and the stack
184: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'
185: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line 231: l_team_template_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,

227:
228: --set the check ID flag to 'N'
229: PA_STARTUP.G_Check_ID_Flag := 'N';
230:
231: l_team_template_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,
232: itemkey => p_item_key,
233: aname => 'TEAM_TEMPLATE_ID');
234: --set the team template id token global variable so that the template
235: --name will show up in the error message.

Line 238: l_project_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,

234: --set the team template id token global variable so that the template
235: --name will show up in the error message.
236: PA_ASSIGNMENT_UTILS.g_team_template_id := l_team_template_id;
237:
238: l_project_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,
239: itemkey => p_item_key,
240: aname => 'PROJECT_ID');
241:
242: l_project_start_date := WF_ENGINE.GetItemAttrDate (itemtype => p_item_type,

Line 242: l_project_start_date := WF_ENGINE.GetItemAttrDate (itemtype => p_item_type,

238: l_project_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,
239: itemkey => p_item_key,
240: aname => 'PROJECT_ID');
241:
242: l_project_start_date := WF_ENGINE.GetItemAttrDate (itemtype => p_item_type,
243: itemkey => p_item_key,
244: aname => 'PROJECT_START_DATE');
245:
246: l_team_start_date := WF_ENGINE.GetItemAttrDate (itemtype => p_item_type,

Line 246: l_team_start_date := WF_ENGINE.GetItemAttrDate (itemtype => p_item_type,

242: l_project_start_date := WF_ENGINE.GetItemAttrDate (itemtype => p_item_type,
243: itemkey => p_item_key,
244: aname => 'PROJECT_START_DATE');
245:
246: l_team_start_date := WF_ENGINE.GetItemAttrDate (itemtype => p_item_type,
247: itemkey => p_item_key,
248: aname => 'TEAM_START_DATE');
249:
250: l_use_project_location := WF_ENGINE.GetItemAttrText (itemtype => p_item_type,

Line 250: l_use_project_location := WF_ENGINE.GetItemAttrText (itemtype => p_item_type,

246: l_team_start_date := WF_ENGINE.GetItemAttrDate (itemtype => p_item_type,
247: itemkey => p_item_key,
248: aname => 'TEAM_START_DATE');
249:
250: l_use_project_location := WF_ENGINE.GetItemAttrText (itemtype => p_item_type,
251: itemkey => p_item_key,
252: aname => 'USE_PROJECT_LOCATION');
253:
254: l_project_location_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,

Line 254: l_project_location_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,

250: l_use_project_location := WF_ENGINE.GetItemAttrText (itemtype => p_item_type,
251: itemkey => p_item_key,
252: aname => 'USE_PROJECT_LOCATION');
253:
254: l_project_location_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,
255: itemkey => p_item_key,
256: aname => 'PROJECT_LOCATION_ID');
257:
258: l_use_project_calendar := WF_ENGINE.GetItemAttrText (itemtype => p_item_type,

Line 258: l_use_project_calendar := WF_ENGINE.GetItemAttrText (itemtype => p_item_type,

254: l_project_location_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,
255: itemkey => p_item_key,
256: aname => 'PROJECT_LOCATION_ID');
257:
258: l_use_project_calendar := WF_ENGINE.GetItemAttrText (itemtype => p_item_type,
259: itemkey => p_item_key,
260: aname => 'USE_PROJECT_CALENDAR');
261:
262: l_project_calendar_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,

Line 262: l_project_calendar_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,

258: l_use_project_calendar := WF_ENGINE.GetItemAttrText (itemtype => p_item_type,
259: itemkey => p_item_key,
260: aname => 'USE_PROJECT_CALENDAR');
261:
262: l_project_calendar_id := WF_ENGINE.GetItemAttrNumber (itemtype => p_item_type,
263: itemkey => p_item_key,
264: aname => 'PROJECT_CALENDAR_ID');
265: /*
266: dbms_output.put_line('l_team_template_id = '||l_team_template_id);

Line 295: WF_ENGINE.SetItemAttrText( itemtype => p_item_type

291: ,p_msg_index => l_count
292: ,p_data => l_msg_data
293: ,p_msg_index_out => l_msg_index_out);
294:
295: WF_ENGINE.SetItemAttrText( itemtype => p_item_type
296: , itemkey => p_item_key
297: , aname => 'ERROR_MESSAGE_'||l_count
298: , avalue => l_count||'. '||l_msg_data);
299: