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.GMDRPLAP_WF_PKG dependencies on GMD_RECIPES

Line 4: p_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE,

1: PACKAGE BODY GMDRPLAP_wf_pkg AS
2: /* $Header: GMDRPLAB.pls 120.0 2005/05/26 00:59:17 appldev noship $ */
3: PROCEDURE wf_init (
4: p_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE,
5: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
6: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
7: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
8: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,

Line 5: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,

1: PACKAGE BODY GMDRPLAP_wf_pkg AS
2: /* $Header: GMDRPLAB.pls 120.0 2005/05/26 00:59:17 appldev noship $ */
3: PROCEDURE wf_init (
4: p_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE,
5: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
6: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
7: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
8: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,

Line 6: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,

2: /* $Header: GMDRPLAB.pls 120.0 2005/05/26 00:59:17 appldev noship $ */
3: PROCEDURE wf_init (
4: p_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE,
5: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
6: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
7: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
8: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE

Line 7: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,

3: PROCEDURE wf_init (
4: p_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE,
5: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
6: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
7: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
8: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE
11: )

Line 8: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,

4: p_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE,
5: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
6: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
7: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
8: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE
11: )
12: IS

Line 9: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,

5: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
6: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
7: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
8: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE
11: )
12: IS
13: /* procedure to initialize and run Workflow */

Line 10: p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE

6: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
7: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
8: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE
11: )
12: IS
13: /* procedure to initialize and run Workflow */
14:

Line 24: l_recipe_description GMD_RECIPES.RECIPE_DESCRIPTION%TYPE;

20:
21: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
22:
23: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
24: l_recipe_description GMD_RECIPES.RECIPE_DESCRIPTION%TYPE;
25: l_owner_id GMD_RECIPES.OWNER_ID%TYPE;
26: l_creation_orgn_code ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
27: l_creation_orgn_id GMD_RECIPES.creation_organization_id%TYPE;
28: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;

Line 25: l_owner_id GMD_RECIPES.OWNER_ID%TYPE;

21: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
22:
23: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
24: l_recipe_description GMD_RECIPES.RECIPE_DESCRIPTION%TYPE;
25: l_owner_id GMD_RECIPES.OWNER_ID%TYPE;
26: l_creation_orgn_code ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
27: l_creation_orgn_id GMD_RECIPES.creation_organization_id%TYPE;
28: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
29: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;

Line 27: l_creation_orgn_id GMD_RECIPES.creation_organization_id%TYPE;

23: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
24: l_recipe_description GMD_RECIPES.RECIPE_DESCRIPTION%TYPE;
25: l_owner_id GMD_RECIPES.OWNER_ID%TYPE;
26: l_creation_orgn_code ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
27: l_creation_orgn_id GMD_RECIPES.creation_organization_id%TYPE;
28: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
29: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
30: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
31: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;

Line 100: FROM GMD_RECIPES A, GMD_ROUTINGS B, FM_FORM_MST C

96:
97: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
98: SELECT A.RECIPE_DESCRIPTION, A.OWNER_ID, A.CREATION_ORGANIZATION_ID, C.FORMULA_NO, C.FORMULA_VERS, B.ROUTING_NO, B.ROUTING_VERS
99: INTO l_recipe_description, l_owner_id, l_creation_orgn_id, l_formula_no, l_formula_vers, l_routing_no, l_routing_vers
100: FROM GMD_RECIPES A, GMD_ROUTINGS B, FM_FORM_MST C
101: WHERE A.RECIPE_ID = P_RECIPE_ID
102: AND A.ROUTING_ID = B.ROUTING_ID (+)
103: AND A.FORMULA_ID = C.FORMULA_ID;
104:

Line 176: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_RECIPE_ID'));

172: IS
173: /* procedure to Check Approval is required or not if required find the approver and send the notification to
174: approver */
175:
176: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_RECIPE_ID'));
177: p_data_string VARCHAR2(2000);
178: p_wf_data_string VARCHAR2(2000);
179: p_lab_wf_item_type VARCHAR2(8) := 'GMDRPLAP'; -- Recipe Lab use Approval Workflow Inernal Name
180: P_lab_Process_name VARCHAR2(32) := 'GMDRPLAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name

Line 182: P_table_name VARCHAR2(32) := 'GMD_RECIPES_B'; -- Key Table

178: p_wf_data_string VARCHAR2(2000);
179: p_lab_wf_item_type VARCHAR2(8) := 'GMDRPLAP'; -- Recipe Lab use Approval Workflow Inernal Name
180: P_lab_Process_name VARCHAR2(32) := 'GMDRPLAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name
181: P_lab_activity_name VARCHAR2(80) := 'GMDRPLAP_NOTI_REQUEST';
182: P_table_name VARCHAR2(32) := 'GMD_RECIPES_B'; -- Key Table
183: P_where_clause VARCHAR2(100):= ' GMD_RECIPES_B.RECIPE_ID='||l_RECIPE_ID; -- Where clause to be appended
184: p_role GMA_ACTDATA_WF.ROLE%TYPE;
185: l_data_string VARCHAR2(2000);
186: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');

Line 183: P_where_clause VARCHAR2(100):= ' GMD_RECIPES_B.RECIPE_ID='||l_RECIPE_ID; -- Where clause to be appended

179: p_lab_wf_item_type VARCHAR2(8) := 'GMDRPLAP'; -- Recipe Lab use Approval Workflow Inernal Name
180: P_lab_Process_name VARCHAR2(32) := 'GMDRPLAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name
181: P_lab_activity_name VARCHAR2(80) := 'GMDRPLAP_NOTI_REQUEST';
182: P_table_name VARCHAR2(32) := 'GMD_RECIPES_B'; -- Key Table
183: P_where_clause VARCHAR2(100):= ' GMD_RECIPES_B.RECIPE_ID='||l_RECIPE_ID; -- Where clause to be appended
184: p_role GMA_ACTDATA_WF.ROLE%TYPE;
185: l_data_string VARCHAR2(2000);
186: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
187: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

Line 223: UPDATE GMD_RECIPES_B

219:
220: p_resultout:='COMPLETE:Y';
221: ELSE
222: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_TARGET_STATUS');
223: UPDATE GMD_RECIPES_B
224: SET RECIPE_STATUS = l_target_status
225: WHERE RECIPE_ID = l_recipe_id;
226: p_resultout:='COMPLETE:N';
227: END IF;

Line 276: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_RECIPE_ID'));

272: p_actid IN NUMBER,
273: p_funcmode IN VARCHAR2,
274: p_resultout OUT NOCOPY VARCHAR2) IS
275: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
276: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_RECIPE_ID'));
277: /* added variables for recipe generation for B3604554 */
278: l_return_status VARCHAR2(1);
279: l_formula_id NUMBER(10);
280: x_end_status VARCHAR2(32);

Line 286: FROM gmd_recipes_b r, fm_form_mst_b f

282: l_recipe_use VARCHAR2(1);
283:
284: CURSOR c_get_details IS
285: SELECT r.owner_organization_id, r.formula_id, r.recipe_no, r.recipe_version, f.formula_status
286: FROM gmd_recipes_b r, fm_form_mst_b f
287: WHERE r.recipe_id = l_recipe_id
288: AND r.formula_id = f.formula_id;
289: LocalDetailsRecord c_get_details%ROWTYPE;
290:

Line 302: UPDATE GMD_RECIPES_B

298: BEGIN
299:
300: IF (p_funcmode = 'RUN') THEN
301: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_TARGET_STATUS');
302: UPDATE GMD_RECIPES_B
303: SET RECIPE_STATUS = l_target_status
304: WHERE RECIPE_ID = l_recipe_id;
305:
306: OPEN c_get_details;

Line 343: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_RECIPE_ID'));

339: p_resultout OUT NOCOPY VARCHAR2) IS
340: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
341: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
342: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
343: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_RECIPE_ID'));
344: BEGIN
345: IF (p_funcmode = 'RUN') THEN
346: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_START_STATUS');
347: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_TARGET_STATUS');

Line 353: UPDATE GMD_RECIPES_B

349: FROM GMD_STATUS_NEXT
350: WHERE current_status = l_start_status
351: AND target_status = l_target_status
352: AND pending_status IS NOT NULL;
353: UPDATE GMD_RECIPES_B
354: SET RECIPE_STATUS = l_rework_status
355: WHERE RECIPE_ID = l_recipe_id;
356: END IF;
357: END REQ_REJECTED;

Line 365: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_RECIPE_ID'));

361: p_itemkey IN VARCHAR2,
362: p_actid IN NUMBER,
363: p_funcmode IN VARCHAR2,
364: p_resultout OUT NOCOPY VARCHAR2) IS
365: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_RECIPE_ID'));
366: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
367: BEGIN
368: IF (p_funcmode = 'RUN') THEN
369: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_START_STATUS');

Line 370: UPDATE GMD_RECIPES_B

366: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
367: BEGIN
368: IF (p_funcmode = 'RUN') THEN
369: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_START_STATUS');
370: UPDATE GMD_RECIPES_B
371: SET RECIPE_STATUS = l_start_status
372: WHERE RECIPE_ID = l_recipe_id;
373: END IF;
374: END NO_RESPONSE;