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.GMDRVLAP_WF_PKG dependencies on GMD_RECIPE_VALIDITY_RULES

Line 4: p_recipe_validity_rule_id IN GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE,

1: PACKAGE BODY GMDRVLAP_wf_pkg AS
2: /* $Header: GMDRVLAB.pls 120.1 2006/06/06 06:24:21 kmotupal noship $ */
3: PROCEDURE wf_init (
4: p_recipe_validity_rule_id IN GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE,
5: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
6: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
7: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,

Line 5: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,

1: PACKAGE BODY GMDRVLAP_wf_pkg AS
2: /* $Header: GMDRVLAB.pls 120.1 2006/06/06 06:24:21 kmotupal noship $ */
3: PROCEDURE wf_init (
4: p_recipe_validity_rule_id IN GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE,
5: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
6: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
7: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
9: p_last_update_date IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE

Line 6: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,

2: /* $Header: GMDRVLAB.pls 120.1 2006/06/06 06:24:21 kmotupal noship $ */
3: PROCEDURE wf_init (
4: p_recipe_validity_rule_id IN GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE,
5: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
6: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
7: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
9: p_last_update_date IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE
10: )

Line 7: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,

3: PROCEDURE wf_init (
4: p_recipe_validity_rule_id IN GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE,
5: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
6: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
7: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
9: p_last_update_date IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE
10: )
11: IS

Line 8: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,

4: p_recipe_validity_rule_id IN GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE,
5: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
6: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
7: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
9: p_last_update_date IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE
10: )
11: IS
12: /* procedure to initialize and run Workflow */

Line 9: p_last_update_date IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE

5: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
6: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
7: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
9: p_last_update_date IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE
10: )
11: IS
12: /* procedure to initialize and run Workflow */
13:

Line 25: l_orgn_id GMD_RECIPE_VALIDITY_RULES.organization_id%TYPE;

21: l_recipe_vers GMD_RECIPES.RECIPE_VERSION%TYPE;
22: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
23: l_recipe_use VARCHAR2(80);
24: --Krishna NPD-Conv, Created l_orgn_id, l_item_id. Modified l_orgn_code, l_item_no.
25: l_orgn_id GMD_RECIPE_VALIDITY_RULES.organization_id%TYPE;
26: l_orgn_code ORG_ORGANIZATION_DEFINITIONS.organization_code%TYPE;
27: l_item_id GMD_RECIPE_VALIDITY_RULES.INVENTORY_ITEM_ID%TYPE;
28: l_item_no MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
29: l_preference GMD_RECIPE_VALIDITY_RULES.PREFERENCE%TYPE;

Line 27: l_item_id GMD_RECIPE_VALIDITY_RULES.INVENTORY_ITEM_ID%TYPE;

23: l_recipe_use VARCHAR2(80);
24: --Krishna NPD-Conv, Created l_orgn_id, l_item_id. Modified l_orgn_code, l_item_no.
25: l_orgn_id GMD_RECIPE_VALIDITY_RULES.organization_id%TYPE;
26: l_orgn_code ORG_ORGANIZATION_DEFINITIONS.organization_code%TYPE;
27: l_item_id GMD_RECIPE_VALIDITY_RULES.INVENTORY_ITEM_ID%TYPE;
28: l_item_no MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
29: l_preference GMD_RECIPE_VALIDITY_RULES.PREFERENCE%TYPE;
30: l_std_qty VARCHAR2(80);
31: l_min_qty VARCHAR2(80);

Line 29: l_preference GMD_RECIPE_VALIDITY_RULES.PREFERENCE%TYPE;

25: l_orgn_id GMD_RECIPE_VALIDITY_RULES.organization_id%TYPE;
26: l_orgn_code ORG_ORGANIZATION_DEFINITIONS.organization_code%TYPE;
27: l_item_id GMD_RECIPE_VALIDITY_RULES.INVENTORY_ITEM_ID%TYPE;
28: l_item_no MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
29: l_preference GMD_RECIPE_VALIDITY_RULES.PREFERENCE%TYPE;
30: l_std_qty VARCHAR2(80);
31: l_min_qty VARCHAR2(80);
32: l_max_qty VARCHAR2(80);
33: l_effective_start_date GMD_RECIPE_VALIDITY_RULES.START_DATE%TYPE;

Line 33: l_effective_start_date GMD_RECIPE_VALIDITY_RULES.START_DATE%TYPE;

29: l_preference GMD_RECIPE_VALIDITY_RULES.PREFERENCE%TYPE;
30: l_std_qty VARCHAR2(80);
31: l_min_qty VARCHAR2(80);
32: l_max_qty VARCHAR2(80);
33: l_effective_start_date GMD_RECIPE_VALIDITY_RULES.START_DATE%TYPE;
34: l_effective_end_date GMD_RECIPE_VALIDITY_RULES.END_DATE%TYPE;
35: /* Mercy Thomas Bug 3173515 End of the changes */
36:
37: /* make sure that process runs with background engine

Line 34: l_effective_end_date GMD_RECIPE_VALIDITY_RULES.END_DATE%TYPE;

30: l_std_qty VARCHAR2(80);
31: l_min_qty VARCHAR2(80);
32: l_max_qty VARCHAR2(80);
33: l_effective_start_date GMD_RECIPE_VALIDITY_RULES.START_DATE%TYPE;
34: l_effective_end_date GMD_RECIPE_VALIDITY_RULES.END_DATE%TYPE;
35: /* Mercy Thomas Bug 3173515 End of the changes */
36:
37: /* make sure that process runs with background engine
38: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)

Line 113: FROM GMD_RECIPE_VALIDITY_RULES A, MTL_SYSTEM_ITEMS_KFV B

109: SELECT A.ORGANIZATION_ID,
110: DECODE(A.RECIPE_USE, 0, 'Production', 1, 'Planning', 2, 'Costing', 3, 'Regulatory', 4, 'Technical'),
111: B.CONCATENATED_SEGMENTS, A.PREFERENCE, A.STD_QTY || ' ' || A.DETAIL_UOM, A.MIN_QTY || ' ' || A.DETAIL_UOM, A.MAX_QTY || ' ' || A.DETAIL_UOM, A.START_DATE, A.END_DATE
112: INTO l_orgn_id, l_recipe_use, l_item_no, l_preference, l_std_qty, l_min_qty, l_max_qty, l_effective_start_date, l_effective_end_date
113: FROM GMD_RECIPE_VALIDITY_RULES A, MTL_SYSTEM_ITEMS_KFV B
114: WHERE A.RECIPE_VALIDITY_RULE_ID = P_RECIPE_VALIDITY_RULE_ID
115: AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
116: AND A.organization_id = B.organization_id;
117:

Line 191: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;

187: IS
188: /* procedure to Check Approval is required or not if required find the approver and send the notification to
189: approver */
190:
191: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
192: p_data_string VARCHAR2(2000);
193: p_wf_data_string VARCHAR2(2000);
194: p_lab_wf_item_type VARCHAR2(8) := 'GMDRVLAP'; -- Recipe Lab use Approval Workflow Inernal Name
195: P_lab_Process_name VARCHAR2(32) := 'GMDRVLAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name

Line 197: P_table_name VARCHAR2(32) := 'GMD_RECIPE_VALIDITY_RULES'; -- Key Table

193: p_wf_data_string VARCHAR2(2000);
194: p_lab_wf_item_type VARCHAR2(8) := 'GMDRVLAP'; -- Recipe Lab use Approval Workflow Inernal Name
195: P_lab_Process_name VARCHAR2(32) := 'GMDRVLAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name
196: P_lab_activity_name VARCHAR2(80) := 'GMDRVLAP_NOTI_REQUEST';
197: P_table_name VARCHAR2(32) := 'GMD_RECIPE_VALIDITY_RULES'; -- Key Table
198: P_where_clause VARCHAR2(100); -- Where clause to be appended
199: p_role GMA_ACTDATA_WF.ROLE%TYPE;
200: l_data_string VARCHAR2(2000);
201: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');

Line 239: UPDATE GMD_RECIPE_VALIDITY_RULES

235:
236: p_resultout:='COMPLETE:Y';
237: ELSE
238: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');
239: UPDATE GMD_RECIPE_VALIDITY_RULES
240: SET VALIDITY_RULE_STATUS = l_target_status
241: WHERE RECIPE_VALIDITY_RULE_ID = l_recipe_validity_rule_id;
242: p_resultout:='COMPLETE:N';
243: END IF;

Line 286: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;

282: p_actid IN NUMBER,
283: p_funcmode IN VARCHAR2,
284: p_resultout OUT NOCOPY VARCHAR2) IS
285: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
286: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
287: BEGIN
288: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
289: IF (p_funcmode = 'RUN') THEN
290: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');

Line 291: UPDATE GMD_RECIPE_VALIDITY_RULES

287: BEGIN
288: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
289: IF (p_funcmode = 'RUN') THEN
290: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');
291: UPDATE GMD_RECIPE_VALIDITY_RULES
292: SET VALIDITY_RULE_STATUS = l_target_status
293: WHERE RECIPE_VALIDITY_RULE_ID = l_recipe_validity_rule_id;
294: END IF;
295: END REQ_APPROVED;

Line 306: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;

302: p_resultout OUT NOCOPY VARCHAR2) IS
303: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
304: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
305: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
306: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
307: BEGIN
308: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
309: IF (p_funcmode = 'RUN') THEN
310: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_START_STATUS');

Line 317: UPDATE GMD_RECIPE_VALIDITY_RULES

313: FROM GMD_STATUS_NEXT
314: WHERE current_status = l_start_status
315: AND target_status = l_target_status
316: AND pending_status IS NOT NULL;
317: UPDATE GMD_RECIPE_VALIDITY_RULES
318: SET VALIDITY_RULE_STATUS = l_rework_status
319: WHERE RECIPE_VALIDITY_RULE_ID = l_recipe_validity_rule_id;
320: END IF;
321: END REQ_REJECTED;

Line 329: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;

325: p_itemkey IN VARCHAR2,
326: p_actid IN NUMBER,
327: p_funcmode IN VARCHAR2,
328: p_resultout OUT NOCOPY VARCHAR2) IS
329: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
330: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
331: BEGIN
332: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
333: IF (p_funcmode = 'RUN') THEN

Line 335: UPDATE GMD_RECIPE_VALIDITY_RULES

331: BEGIN
332: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
333: IF (p_funcmode = 'RUN') THEN
334: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_START_STATUS');
335: UPDATE GMD_RECIPE_VALIDITY_RULES
336: SET VALIDITY_RULE_STATUS = l_start_status
337: WHERE RECIPE_VALIDITY_RULE_ID = l_recipe_validity_rule_id;
338: END IF;
339: END NO_RESPONSE;