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.GMDRTGAP_WF_PKG dependencies on GMD_ROUTINGS_B

Line 4: p_Routing_id IN gmd_routings_b.Routing_id%TYPE,

1: PACKAGE BODY GMDRTGAP_wf_pkg AS
2: /* $Header: GMDRTGAB.pls 120.1 2011/03/22 18:32:26 rnalla ship $ */
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 GMDRTGAP_wf_pkg AS
2: /* $Header: GMDRTGAB.pls 120.1 2011/03/22 18:32:26 rnalla ship $ */
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: GMDRTGAB.pls 120.1 2011/03/22 18:32:26 rnalla ship $ */
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 167: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));

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

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

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

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

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

Line 213: UPDATE GMD_ROUTINGS_B

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

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

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

Line 264: UPDATE GMD_ROUTINGS_B

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

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

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

Line 290: UPDATE GMD_ROUTINGS_B

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

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

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

Line 307: UPDATE GMD_ROUTINGS_B

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