APPS.GMI_WF_LOT_RETEST dependencies on WF_ITEM

Line 15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';

11: p_created_by IN ic_lots_mst.created_by%TYPE
12: )
13:
14: IS
15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';
16:
17: /* since two WF processes exist with the GMWLOTEX WF Item,
18: prefix ITEMKEY with 'RT' to differentiate the Retest Process */
19: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := 'RT' || TO_CHAR(p_lot_id) ;

Line 17: /* since two WF processes exist with the GMWLOTEX WF Item,

13:
14: IS
15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';
16:
17: /* since two WF processes exist with the GMWLOTEX WF Item,
18: prefix ITEMKEY with 'RT' to differentiate the Retest Process */
19: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := 'RT' || TO_CHAR(p_lot_id) ;
20:
21: /* number of days before lot retest date to send WF notification

Line 19: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := 'RT' || TO_CHAR(p_lot_id) ;

15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';
16:
17: /* since two WF processes exist with the GMWLOTEX WF Item,
18: prefix ITEMKEY with 'RT' to differentiate the Retest Process */
19: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := 'RT' || TO_CHAR(p_lot_id) ;
20:
21: /* number of days before lot retest date to send WF notification
22: value is fetched from table gmwlotrt_ctl
23: if not found in gmwlotrt_ctl, default is 7 days */

Line 45: l_role_name sy_wf_item_roles.retest_role_name%TYPE ;

41: c_item_id ic_item_mst.item_id%TYPE;
42: l_performer_name FND_USER.USER_NAME%TYPE ;
43: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
44:
45: l_role_name sy_wf_item_roles.retest_role_name%TYPE ;
46: l_role_display_name sy_wf_item_roles.retest_role_display_name%TYPE ;
47:
48: l_WorkflowProcess VARCHAR2(30) := 'LOT_RETEST_PROC';
49:

Line 46: l_role_display_name sy_wf_item_roles.retest_role_display_name%TYPE ;

42: l_performer_name FND_USER.USER_NAME%TYPE ;
43: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
44:
45: l_role_name sy_wf_item_roles.retest_role_name%TYPE ;
46: l_role_display_name sy_wf_item_roles.retest_role_display_name%TYPE ;
47:
48: l_WorkflowProcess VARCHAR2(30) := 'LOT_RETEST_PROC';
49:
50: l_errname VARCHAR2(30);

Line 57: wf_item_already_exists EXCEPTION ;

53: l_errstack VARCHAR2(32000);
54: l_sqlcode NUMBER ;
55:
56:
57: wf_item_already_exists EXCEPTION ;
58: --BEGIN BUG#2134597 PR
59: l_status VARCHAR2 (8);
60: l_result VARCHAR2 (30);
61: --END BUG#2134597

Line 64: FROM sy_wf_item_roles

60: l_result VARCHAR2 (30);
61: --END BUG#2134597
62: CURSOR c_whse_item_role(c_whse_item_id NUMBER) is
63: ( SELECT retest_role_name,retest_role_display_name,NVL(lot_retest_note,0)
64: FROM sy_wf_item_roles
65: WHERE whse_item_id = c_whse_item_id);
66: CURSOR c_item_role(c_item_id NUMBER) is
67: ( SELECT retest_role_name,retest_role_display_name,NVL(lot_retest_note,0)
68: FROM sy_wf_item_roles

Line 68: FROM sy_wf_item_roles

64: FROM sy_wf_item_roles
65: WHERE whse_item_id = c_whse_item_id);
66: CURSOR c_item_role(c_item_id NUMBER) is
67: ( SELECT retest_role_name,retest_role_display_name,NVL(lot_retest_note,0)
68: FROM sy_wf_item_roles
69: WHERE item_id = c_item_id);
70:
71: CURSOR c_whse_item(c_item_id NUMBER) is
72: ( SELECT whse_item_id

Line 94: IF (wf_item.item_exist (l_itemtype, l_itemkey)) THEN

90: /*BEGIN BUG#2134597 Praveen Reddy*/
91: /*Check if the workflow data exists and remove the same for the itemtype and itemkey
92: combination */
93: BEGIN
94: IF (wf_item.item_exist (l_itemtype, l_itemkey)) THEN
95: /* Check the status of the root activity */
96: wf_item_activity_status.root_status (l_itemtype, l_itemkey, l_status, l_result);
97: /* If it is not completed then abort the process */
98: IF (l_status <> 'COMPLETE')THEN

Line 96: wf_item_activity_status.root_status (l_itemtype, l_itemkey, l_status, l_result);

92: combination */
93: BEGIN
94: IF (wf_item.item_exist (l_itemtype, l_itemkey)) THEN
95: /* Check the status of the root activity */
96: wf_item_activity_status.root_status (l_itemtype, l_itemkey, l_status, l_result);
97: /* If it is not completed then abort the process */
98: IF (l_status <> 'COMPLETE')THEN
99: wf_engine.abortprocess (itemtype=> l_itemtype, itemkey=> l_itemkey, process=> l_workflowprocess);
100: END IF;

Line 117: RAISE wf_item_already_exists ;

113: itemkey => l_itemkey,
114: process => l_WorkflowProcess);
115: EXCEPTION
116: WHEN DUP_VAL_ON_INDEX THEN
117: RAISE wf_item_already_exists ;
118: END ;
119:
120: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
121:

Line 278: WHEN wf_item_already_exists THEN

274:
275:
276: EXCEPTION
277:
278: WHEN wf_item_already_exists THEN
279: null;
280:
281: WHEN OTHERS THEN
282: