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.GMDRTLAP_WF_PKG dependencies on GMD_ROUTINGS

Line 4: p_Routing_id IN gmd_routings_b.Routing_id%TYPE,

1: PACKAGE BODY GMDRTLAP_wf_pkg AS
2: /* $Header: GMDRTLAB.pls 120.0 2005/05/25 19:49:39 appldev noship $ */
3: PROCEDURE wf_init (
4: p_Routing_id IN gmd_routings_b.Routing_id%TYPE,
5: p_Routing_no IN gmd_routings_b.Routing_no%TYPE,
6: p_Routing_vers IN gmd_routings_b.Routing_vers%TYPE,
7: p_start_status IN gmd_routings_b.Routing_status%TYPE,
8: p_target_status IN gmd_routings_b.Routing_status%TYPE,

Line 5: p_Routing_no IN gmd_routings_b.Routing_no%TYPE,

1: PACKAGE BODY GMDRTLAP_wf_pkg AS
2: /* $Header: GMDRTLAB.pls 120.0 2005/05/25 19:49:39 appldev noship $ */
3: PROCEDURE wf_init (
4: p_Routing_id IN gmd_routings_b.Routing_id%TYPE,
5: p_Routing_no IN gmd_routings_b.Routing_no%TYPE,
6: p_Routing_vers IN gmd_routings_b.Routing_vers%TYPE,
7: p_start_status IN gmd_routings_b.Routing_status%TYPE,
8: p_target_status IN gmd_routings_b.Routing_status%TYPE,
9: p_requester IN gmd_routings_b.LAST_UPDATED_BY%TYPE,

Line 6: p_Routing_vers IN gmd_routings_b.Routing_vers%TYPE,

2: /* $Header: GMDRTLAB.pls 120.0 2005/05/25 19:49:39 appldev noship $ */
3: PROCEDURE wf_init (
4: p_Routing_id IN gmd_routings_b.Routing_id%TYPE,
5: p_Routing_no IN gmd_routings_b.Routing_no%TYPE,
6: p_Routing_vers IN gmd_routings_b.Routing_vers%TYPE,
7: p_start_status IN gmd_routings_b.Routing_status%TYPE,
8: p_target_status IN gmd_routings_b.Routing_status%TYPE,
9: p_requester IN gmd_routings_b.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN gmd_routings_b.LAST_UPDATE_DATE%TYPE

Line 7: p_start_status IN gmd_routings_b.Routing_status%TYPE,

3: PROCEDURE wf_init (
4: p_Routing_id IN gmd_routings_b.Routing_id%TYPE,
5: p_Routing_no IN gmd_routings_b.Routing_no%TYPE,
6: p_Routing_vers IN gmd_routings_b.Routing_vers%TYPE,
7: p_start_status IN gmd_routings_b.Routing_status%TYPE,
8: p_target_status IN gmd_routings_b.Routing_status%TYPE,
9: p_requester IN gmd_routings_b.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN gmd_routings_b.LAST_UPDATE_DATE%TYPE
11: )

Line 8: p_target_status IN gmd_routings_b.Routing_status%TYPE,

4: p_Routing_id IN gmd_routings_b.Routing_id%TYPE,
5: p_Routing_no IN gmd_routings_b.Routing_no%TYPE,
6: p_Routing_vers IN gmd_routings_b.Routing_vers%TYPE,
7: p_start_status IN gmd_routings_b.Routing_status%TYPE,
8: p_target_status IN gmd_routings_b.Routing_status%TYPE,
9: p_requester IN gmd_routings_b.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN gmd_routings_b.LAST_UPDATE_DATE%TYPE
11: )
12: IS

Line 9: p_requester IN gmd_routings_b.LAST_UPDATED_BY%TYPE,

5: p_Routing_no IN gmd_routings_b.Routing_no%TYPE,
6: p_Routing_vers IN gmd_routings_b.Routing_vers%TYPE,
7: p_start_status IN gmd_routings_b.Routing_status%TYPE,
8: p_target_status IN gmd_routings_b.Routing_status%TYPE,
9: p_requester IN gmd_routings_b.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN gmd_routings_b.LAST_UPDATE_DATE%TYPE
11: )
12: IS
13: /* procedure to initialize and run Workflow */

Line 10: p_last_update_date IN gmd_routings_b.LAST_UPDATE_DATE%TYPE

6: p_Routing_vers IN gmd_routings_b.Routing_vers%TYPE,
7: p_start_status IN gmd_routings_b.Routing_status%TYPE,
8: p_target_status IN gmd_routings_b.Routing_status%TYPE,
9: p_requester IN gmd_routings_b.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN gmd_routings_b.LAST_UPDATE_DATE%TYPE
11: )
12: IS
13: /* procedure to initialize and run Workflow */
14:

Line 22: l_routing_desc GMD_ROUTINGS.ROUTING_DESC%TYPE;

18: l_performer_name FND_USER.USER_NAME%TYPE ;
19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
20:
21: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
22: l_routing_desc GMD_ROUTINGS.ROUTING_DESC%TYPE;
23: l_owner_id GMD_ROUTINGS.OWNER_ID%TYPE;
24: l_routing_class GMD_ROUTINGS.ROUTING_CLASS%TYPE;
25: l_routing_qty GMD_ROUTINGS.ROUTING_QTY%TYPE;
26: l_item_um GMD_ROUTINGS.ROUTING_UOM%TYPE;

Line 23: l_owner_id GMD_ROUTINGS.OWNER_ID%TYPE;

19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
20:
21: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
22: l_routing_desc GMD_ROUTINGS.ROUTING_DESC%TYPE;
23: l_owner_id GMD_ROUTINGS.OWNER_ID%TYPE;
24: l_routing_class GMD_ROUTINGS.ROUTING_CLASS%TYPE;
25: l_routing_qty GMD_ROUTINGS.ROUTING_QTY%TYPE;
26: l_item_um GMD_ROUTINGS.ROUTING_UOM%TYPE;
27: l_effective_start_date GMD_ROUTINGS.EFFECTIVE_START_DATE%TYPE;

Line 24: l_routing_class GMD_ROUTINGS.ROUTING_CLASS%TYPE;

20:
21: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
22: l_routing_desc GMD_ROUTINGS.ROUTING_DESC%TYPE;
23: l_owner_id GMD_ROUTINGS.OWNER_ID%TYPE;
24: l_routing_class GMD_ROUTINGS.ROUTING_CLASS%TYPE;
25: l_routing_qty GMD_ROUTINGS.ROUTING_QTY%TYPE;
26: l_item_um GMD_ROUTINGS.ROUTING_UOM%TYPE;
27: l_effective_start_date GMD_ROUTINGS.EFFECTIVE_START_DATE%TYPE;
28: l_effective_end_date GMD_ROUTINGS.EFFECTIVE_END_DATE%TYPE;

Line 25: l_routing_qty GMD_ROUTINGS.ROUTING_QTY%TYPE;

21: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
22: l_routing_desc GMD_ROUTINGS.ROUTING_DESC%TYPE;
23: l_owner_id GMD_ROUTINGS.OWNER_ID%TYPE;
24: l_routing_class GMD_ROUTINGS.ROUTING_CLASS%TYPE;
25: l_routing_qty GMD_ROUTINGS.ROUTING_QTY%TYPE;
26: l_item_um GMD_ROUTINGS.ROUTING_UOM%TYPE;
27: l_effective_start_date GMD_ROUTINGS.EFFECTIVE_START_DATE%TYPE;
28: l_effective_end_date GMD_ROUTINGS.EFFECTIVE_END_DATE%TYPE;
29: /* Mercy Thomas Bug 3173515 End of the changes */

Line 26: l_item_um GMD_ROUTINGS.ROUTING_UOM%TYPE;

22: l_routing_desc GMD_ROUTINGS.ROUTING_DESC%TYPE;
23: l_owner_id GMD_ROUTINGS.OWNER_ID%TYPE;
24: l_routing_class GMD_ROUTINGS.ROUTING_CLASS%TYPE;
25: l_routing_qty GMD_ROUTINGS.ROUTING_QTY%TYPE;
26: l_item_um GMD_ROUTINGS.ROUTING_UOM%TYPE;
27: l_effective_start_date GMD_ROUTINGS.EFFECTIVE_START_DATE%TYPE;
28: l_effective_end_date GMD_ROUTINGS.EFFECTIVE_END_DATE%TYPE;
29: /* Mercy Thomas Bug 3173515 End of the changes */
30:

Line 27: l_effective_start_date GMD_ROUTINGS.EFFECTIVE_START_DATE%TYPE;

23: l_owner_id GMD_ROUTINGS.OWNER_ID%TYPE;
24: l_routing_class GMD_ROUTINGS.ROUTING_CLASS%TYPE;
25: l_routing_qty GMD_ROUTINGS.ROUTING_QTY%TYPE;
26: l_item_um GMD_ROUTINGS.ROUTING_UOM%TYPE;
27: l_effective_start_date GMD_ROUTINGS.EFFECTIVE_START_DATE%TYPE;
28: l_effective_end_date GMD_ROUTINGS.EFFECTIVE_END_DATE%TYPE;
29: /* Mercy Thomas Bug 3173515 End of the changes */
30:
31: /* make sure that process runs with background engine

Line 28: l_effective_end_date GMD_ROUTINGS.EFFECTIVE_END_DATE%TYPE;

24: l_routing_class GMD_ROUTINGS.ROUTING_CLASS%TYPE;
25: l_routing_qty GMD_ROUTINGS.ROUTING_QTY%TYPE;
26: l_item_um GMD_ROUTINGS.ROUTING_UOM%TYPE;
27: l_effective_start_date GMD_ROUTINGS.EFFECTIVE_START_DATE%TYPE;
28: l_effective_end_date GMD_ROUTINGS.EFFECTIVE_END_DATE%TYPE;
29: /* Mercy Thomas Bug 3173515 End of the changes */
30:
31: /* make sure that process runs with background engine
32: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)

Line 98: FROM GMD_ROUTINGS

94:
95: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
96: SELECT ROUTING_DESC, OWNER_ID, ROUTING_CLASS, ROUTING_QTY, ROUTING_UOM, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
97: INTO l_routing_desc, l_owner_id, l_routing_class, l_routing_qty, l_item_um, l_effective_start_date, l_effective_end_date
98: FROM GMD_ROUTINGS
99: WHERE ROUTING_ID = P_ROUTING_ID;
100:
101: SELECT USER_NAME , DESCRIPTION
102: INTO l_performer_name ,l_performer_display_name

Line 166: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_ROUTING_ID'));

162: IS
163: /* procedure to Check Approval is required or not if required find the approver and send the notification to
164: approver */
165:
166: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_ROUTING_ID'));
167: p_data_string VARCHAR2(2000);
168: p_wf_data_string VARCHAR2(2000);
169: p_lab_wf_item_type VARCHAR2(8) := 'GMDRTLAP'; -- Recipe Lab use Approval Workflow Inernal Name
170: P_lab_Process_name VARCHAR2(32) := 'GMDRTLAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name

Line 172: P_table_name VARCHAR2(32) := 'GMD_ROUTINGS_B'; -- Key Table

168: p_wf_data_string VARCHAR2(2000);
169: p_lab_wf_item_type VARCHAR2(8) := 'GMDRTLAP'; -- Recipe Lab use Approval Workflow Inernal Name
170: P_lab_Process_name VARCHAR2(32) := 'GMDRTLAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name
171: P_lab_activity_name VARCHAR2(80) := 'GMDRTLAP_NOTI_REQUEST';
172: P_table_name VARCHAR2(32) := 'GMD_ROUTINGS_B'; -- Key Table
173: P_where_clause VARCHAR2(100):= ' gmd_routings_b.ROUTING_ID='||l_ROUTING_ID; -- Where clause to be appended
174: p_role GMA_ACTDATA_WF.ROLE%TYPE;
175: l_data_string VARCHAR2(2000);
176: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');

Line 173: P_where_clause VARCHAR2(100):= ' gmd_routings_b.ROUTING_ID='||l_ROUTING_ID; -- Where clause to be appended

169: p_lab_wf_item_type VARCHAR2(8) := 'GMDRTLAP'; -- Recipe Lab use Approval Workflow Inernal Name
170: P_lab_Process_name VARCHAR2(32) := 'GMDRTLAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name
171: P_lab_activity_name VARCHAR2(80) := 'GMDRTLAP_NOTI_REQUEST';
172: P_table_name VARCHAR2(32) := 'GMD_ROUTINGS_B'; -- Key Table
173: P_where_clause VARCHAR2(100):= ' gmd_routings_b.ROUTING_ID='||l_ROUTING_ID; -- Where clause to be appended
174: p_role GMA_ACTDATA_WF.ROLE%TYPE;
175: l_data_string VARCHAR2(2000);
176: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
177: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

Line 212: UPDATE GMD_ROUTINGS_B

208:
209: p_resultout:='COMPLETE:Y';
210: ELSE
211: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_TARGET_STATUS');
212: UPDATE GMD_ROUTINGS_B
213: SET ROUTING_STATUS = l_target_status
214: WHERE ROUTING_ID = l_Routing_id;
215: p_resultout:='COMPLETE:N';
216: END IF;

Line 259: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_ROUTING_ID'));

255: p_actid IN NUMBER,
256: p_funcmode IN VARCHAR2,
257: p_resultout OUT NOCOPY VARCHAR2) IS
258: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
259: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_ROUTING_ID'));
260: BEGIN
261: IF (p_funcmode = 'RUN') THEN
262: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_TARGET_STATUS');
263: UPDATE GMD_ROUTINGS_B

Line 263: UPDATE GMD_ROUTINGS_B

259: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_ROUTING_ID'));
260: BEGIN
261: IF (p_funcmode = 'RUN') THEN
262: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_TARGET_STATUS');
263: UPDATE GMD_ROUTINGS_B
264: SET ROUTING_STATUS = l_target_status
265: WHERE ROUTING_ID = l_Routing_id;
266: END IF;
267:

Line 279: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_ROUTING_ID'));

275: p_resultout OUT NOCOPY VARCHAR2) IS
276: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
277: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
278: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
279: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_ROUTING_ID'));
280: BEGIN
281: IF (p_funcmode = 'RUN') THEN
282: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_START_STATUS');
283: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_TARGET_STATUS');

Line 289: UPDATE GMD_ROUTINGS_B

285: FROM GMD_STATUS_NEXT
286: WHERE current_status = l_start_status
287: AND target_status = l_target_status
288: AND pending_status IS NOT NULL;
289: UPDATE GMD_ROUTINGS_B
290: SET ROUTING_STATUS = l_rework_status
291: WHERE ROUTING_ID = l_Routing_id;
292: END IF;
293: END REQ_REJECTED;

Line 301: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_ROUTING_ID'));

297: p_itemkey IN VARCHAR2,
298: p_actid IN NUMBER,
299: p_funcmode IN VARCHAR2,
300: p_resultout OUT NOCOPY VARCHAR2) IS
301: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_ROUTING_ID'));
302: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
303: BEGIN
304: IF (p_funcmode = 'RUN') THEN
305: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_START_STATUS');

Line 306: UPDATE GMD_ROUTINGS_B

302: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
303: BEGIN
304: IF (p_funcmode = 'RUN') THEN
305: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTLAP_START_STATUS');
306: UPDATE GMD_ROUTINGS_B
307: SET ROUTING_STATUS = l_start_status
308: WHERE ROUTING_ID = l_Routing_id;
309: END IF;
310: END NO_RESPONSE;