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.

[Home] [Help]

APPS.GMDFMGAP_WF_PKG dependencies on FM_FORM_MST

Line 4: p_formula_id IN FM_FORM_MST_B.formula_id%TYPE,

1: PACKAGE BODY GMDFMGAP_wf_pkg AS
2: /* $Header: GMDFMGAB.pls 120.1 2006/08/08 11:25:08 kmotupal noship $ */
3: PROCEDURE wf_init (
4: p_formula_id IN FM_FORM_MST_B.formula_id%TYPE,
5: p_formula_no IN FM_FORM_MST_B.formula_no%TYPE,
6: p_formula_vers IN FM_FORM_MST_B.formula_vers%TYPE,
7: p_start_status IN FM_FORM_MST_B.formula_status%TYPE,
8: p_target_status IN FM_FORM_MST_B.formula_status%TYPE,

Line 5: p_formula_no IN FM_FORM_MST_B.formula_no%TYPE,

1: PACKAGE BODY GMDFMGAP_wf_pkg AS
2: /* $Header: GMDFMGAB.pls 120.1 2006/08/08 11:25:08 kmotupal noship $ */
3: PROCEDURE wf_init (
4: p_formula_id IN FM_FORM_MST_B.formula_id%TYPE,
5: p_formula_no IN FM_FORM_MST_B.formula_no%TYPE,
6: p_formula_vers IN FM_FORM_MST_B.formula_vers%TYPE,
7: p_start_status IN FM_FORM_MST_B.formula_status%TYPE,
8: p_target_status IN FM_FORM_MST_B.formula_status%TYPE,
9: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,

Line 6: p_formula_vers IN FM_FORM_MST_B.formula_vers%TYPE,

2: /* $Header: GMDFMGAB.pls 120.1 2006/08/08 11:25:08 kmotupal noship $ */
3: PROCEDURE wf_init (
4: p_formula_id IN FM_FORM_MST_B.formula_id%TYPE,
5: p_formula_no IN FM_FORM_MST_B.formula_no%TYPE,
6: p_formula_vers IN FM_FORM_MST_B.formula_vers%TYPE,
7: p_start_status IN FM_FORM_MST_B.formula_status%TYPE,
8: p_target_status IN FM_FORM_MST_B.formula_status%TYPE,
9: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE

Line 7: p_start_status IN FM_FORM_MST_B.formula_status%TYPE,

3: PROCEDURE wf_init (
4: p_formula_id IN FM_FORM_MST_B.formula_id%TYPE,
5: p_formula_no IN FM_FORM_MST_B.formula_no%TYPE,
6: p_formula_vers IN FM_FORM_MST_B.formula_vers%TYPE,
7: p_start_status IN FM_FORM_MST_B.formula_status%TYPE,
8: p_target_status IN FM_FORM_MST_B.formula_status%TYPE,
9: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE
11: )

Line 8: p_target_status IN FM_FORM_MST_B.formula_status%TYPE,

4: p_formula_id IN FM_FORM_MST_B.formula_id%TYPE,
5: p_formula_no IN FM_FORM_MST_B.formula_no%TYPE,
6: p_formula_vers IN FM_FORM_MST_B.formula_vers%TYPE,
7: p_start_status IN FM_FORM_MST_B.formula_status%TYPE,
8: p_target_status IN FM_FORM_MST_B.formula_status%TYPE,
9: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE
11: )
12: IS

Line 9: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,

5: p_formula_no IN FM_FORM_MST_B.formula_no%TYPE,
6: p_formula_vers IN FM_FORM_MST_B.formula_vers%TYPE,
7: p_start_status IN FM_FORM_MST_B.formula_status%TYPE,
8: p_target_status IN FM_FORM_MST_B.formula_status%TYPE,
9: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE
11: )
12: IS
13: /* procedure to initialize and run Workflow */

Line 10: p_last_update_date IN FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE

6: p_formula_vers IN FM_FORM_MST_B.formula_vers%TYPE,
7: p_start_status IN FM_FORM_MST_B.formula_status%TYPE,
8: p_target_status IN FM_FORM_MST_B.formula_status%TYPE,
9: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE
11: )
12: IS
13: /* procedure to initialize and run Workflow */
14:

Line 21: l_formula_desc FM_FORM_MST.FORMULA_DESC1%TYPE;

17: l_runform VARCHAR2(100);
18: l_performer_name FND_USER.USER_NAME%TYPE ;
19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
20: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
21: l_formula_desc FM_FORM_MST.FORMULA_DESC1%TYPE;
22: l_owner_id FM_FORM_MST.OWNER_ID%TYPE;
23: l_formula_class FM_FORM_MST.FORMULA_CLASS%TYPE;
24: l_scale_type VARCHAR2(10);
25: /* Mercy Thomas Bug 3173515 End of the changes */

Line 22: l_owner_id FM_FORM_MST.OWNER_ID%TYPE;

18: l_performer_name FND_USER.USER_NAME%TYPE ;
19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
20: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
21: l_formula_desc FM_FORM_MST.FORMULA_DESC1%TYPE;
22: l_owner_id FM_FORM_MST.OWNER_ID%TYPE;
23: l_formula_class FM_FORM_MST.FORMULA_CLASS%TYPE;
24: l_scale_type VARCHAR2(10);
25: /* Mercy Thomas Bug 3173515 End of the changes */
26:

Line 23: l_formula_class FM_FORM_MST.FORMULA_CLASS%TYPE;

19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
20: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
21: l_formula_desc FM_FORM_MST.FORMULA_DESC1%TYPE;
22: l_owner_id FM_FORM_MST.OWNER_ID%TYPE;
23: l_formula_class FM_FORM_MST.FORMULA_CLASS%TYPE;
24: l_scale_type VARCHAR2(10);
25: /* Mercy Thomas Bug 3173515 End of the changes */
26:
27: /* make sure that process runs with background engine

Line 94: FROM FM_FORM_MST

90:
91: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
92: SELECT FORMULA_DESC1, OWNER_ID, FORMULA_CLASS, DECODE(SCALE_TYPE, 1, 'Yes', 0, 'No')
93: INTO l_formula_desc, l_owner_id, l_formula_class, l_scale_type
94: FROM FM_FORM_MST
95: WHERE FORMULA_ID = P_FORMULA_ID;
96:
97: SELECT USER_NAME , DESCRIPTION
98: INTO l_performer_name ,l_performer_display_name

Line 157: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));

153: IS
154: /* procedure to Check Approval is required or not if required find the approver and send the notification to
155: approver */
156:
157: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
158: p_data_string VARCHAR2(2000);
159: p_lab_wf_item_type VARCHAR2(8) := 'GMDFMGAP'; -- Recipe Lab use Approval Workflow Inernal Name
160: P_lab_Process_name VARCHAR2(32) := 'GMDFMGAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name
161: P_lab_activity_name VARCHAR2(80) := 'GMDFMGAP_NOTI_REQUEST';

Line 162: P_table_name VARCHAR2(32) := 'FM_FORM_MST_B'; -- Key Table

158: p_data_string VARCHAR2(2000);
159: p_lab_wf_item_type VARCHAR2(8) := 'GMDFMGAP'; -- Recipe Lab use Approval Workflow Inernal Name
160: P_lab_Process_name VARCHAR2(32) := 'GMDFMGAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name
161: P_lab_activity_name VARCHAR2(80) := 'GMDFMGAP_NOTI_REQUEST';
162: P_table_name VARCHAR2(32) := 'FM_FORM_MST_B'; -- Key Table
163: P_where_clause VARCHAR2(100):= ' FM_FORM_MST_B.FORMULA_ID='||l_FORMULA_ID; -- Where clause to be appended
164: p_role GMA_ACTDATA_WF.ROLE%TYPE;
165: l_data_string VARCHAR2(2000);
166: p_wf_data_string VARCHAR2(2000);

Line 163: P_where_clause VARCHAR2(100):= ' FM_FORM_MST_B.FORMULA_ID='||l_FORMULA_ID; -- Where clause to be appended

159: p_lab_wf_item_type VARCHAR2(8) := 'GMDFMGAP'; -- Recipe Lab use Approval Workflow Inernal Name
160: P_lab_Process_name VARCHAR2(32) := 'GMDFMGAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name
161: P_lab_activity_name VARCHAR2(80) := 'GMDFMGAP_NOTI_REQUEST';
162: P_table_name VARCHAR2(32) := 'FM_FORM_MST_B'; -- Key Table
163: P_where_clause VARCHAR2(100):= ' FM_FORM_MST_B.FORMULA_ID='||l_FORMULA_ID; -- Where clause to be appended
164: p_role GMA_ACTDATA_WF.ROLE%TYPE;
165: l_data_string VARCHAR2(2000);
166: p_wf_data_string VARCHAR2(2000);
167: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');

Line 204: UPDATE FM_FORM_MST_B

200:
201: p_resultout:='COMPLETE:Y';
202: ELSE
203: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');
204: UPDATE FM_FORM_MST_B
205: SET FORMULA_STATUS = l_target_status
206: WHERE FORMULA_ID = l_formula_id;
207: p_resultout:='COMPLETE:N';
208: END IF;

Line 261: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));

257: p_funcmode IN VARCHAR2,
258: p_resultout OUT NOCOPY VARCHAR2) IS
259:
260: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
261: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
262:
263: /* added variables for recipe generation */
264: l_return_status VARCHAR2(1);
265: x_recipe_no VARCHAR2(32);

Line 278: FROM fm_form_mst_b

274: WHERE formula_id = V_formula_id);
275:
276: CURSOR c_get_orgn (V_formula_id NUMBER) IS
277: SELECT owner_organization_id
278: FROM fm_form_mst_b
279: WHERE formula_id = V_formula_id;
280:
281: /* Bug 3748697 - Recipe should only be created for automatic */
282: /* or optional setup */

Line 300: UPDATE FM_FORM_MST_B

296: l_creation_type NUMBER(5);
297: BEGIN
298: IF (p_funcmode = 'RUN') THEN
299: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');
300: UPDATE FM_FORM_MST_B
301: SET FORMULA_STATUS = l_target_status
302: WHERE FORMULA_ID = l_formula_id;
303:
304: /* Bug 3748697 - Thomas Daniel */

Line 339: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));

335: p_resultout OUT NOCOPY VARCHAR2) IS
336: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
337: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
338: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
339: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
340: BEGIN
341: IF (p_funcmode = 'RUN') THEN
342: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');
343: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');

Line 349: UPDATE FM_FORM_MST_B

345: FROM GMD_STATUS_NEXT
346: WHERE current_status = l_start_status
347: AND target_status = l_target_status
348: AND pending_status IS NOT NULL;
349: UPDATE FM_FORM_MST_B
350: SET FORMULA_STATUS = l_rework_status
351: WHERE FORMULA_ID = l_formula_id;
352: END IF;
353: END REQ_REJECTED;

Line 361: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));

357: p_itemkey IN VARCHAR2,
358: p_actid IN NUMBER,
359: p_funcmode IN VARCHAR2,
360: p_resultout OUT NOCOPY VARCHAR2) IS
361: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
362: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
363: BEGIN
364: IF (p_funcmode = 'RUN') THEN
365: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');

Line 366: UPDATE FM_FORM_MST_B

362: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
363: BEGIN
364: IF (p_funcmode = 'RUN') THEN
365: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');
366: UPDATE FM_FORM_MST_B
367: SET FORMULA_STATUS = l_start_status
368: WHERE FORMULA_ID = l_formula_id;
369: END IF;
370: END NO_RESPONSE;