APPS.GMI_WF_LOT_EXPIRY dependencies on WF_ITEM

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

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

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

14: IS
15:
16: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';
17:
18: /* since two WF processes exist with the GMWLOTEX WF Item,
19: prefix ITEMKEY with 'EX' to differentiate the Expiry Process */
20: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := 'EX' || TO_CHAR(p_lot_id) ;
21:
22: l_expiry_interval NUMBER(3) ;

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

16: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';
17:
18: /* since two WF processes exist with the GMWLOTEX WF Item,
19: prefix ITEMKEY with 'EX' to differentiate the Expiry Process */
20: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := 'EX' || TO_CHAR(p_lot_id) ;
21:
22: l_expiry_interval NUMBER(3) ;
23: l_expiry_interval_from_tab NUMBER(3);
24: l_default_expiry_interval NUMBER(3) :=7;

Line 49: l_role_name sy_wf_item_roles.expiry_role_name%TYPE ;

45: l_sqlcode NUMBER ;
46: l_performer_name WF_ROLES.NAME%TYPE ;
47: l_performer_display_name WF_ROLES.DISPLAY_NAME%TYPE ;
48:
49: l_role_name sy_wf_item_roles.expiry_role_name%TYPE ;
50: l_role_display_name sy_wf_item_roles.expiry_role_display_name%TYPE ;
51:
52: l_WorkflowProcess VARCHAR2(30) := 'LOT_EXPIRY_PROC';
53:

Line 50: l_role_display_name sy_wf_item_roles.expiry_role_display_name%TYPE ;

46: l_performer_name WF_ROLES.NAME%TYPE ;
47: l_performer_display_name WF_ROLES.DISPLAY_NAME%TYPE ;
48:
49: l_role_name sy_wf_item_roles.expiry_role_name%TYPE ;
50: l_role_display_name sy_wf_item_roles.expiry_role_display_name%TYPE ;
51:
52: l_WorkflowProcess VARCHAR2(30) := 'LOT_EXPIRY_PROC';
53:
54: wf_item_already_exists EXCEPTION ;

Line 54: wf_item_already_exists EXCEPTION ;

50: l_role_display_name sy_wf_item_roles.expiry_role_display_name%TYPE ;
51:
52: l_WorkflowProcess VARCHAR2(30) := 'LOT_EXPIRY_PROC';
53:
54: wf_item_already_exists EXCEPTION ;
55: --BEGIN BUG#2134597 PR
56: l_status VARCHAR2 (8);
57: l_result VARCHAR2 (30);
58: --END BUG#2134597

Line 61: FROM sy_wf_item_roles

57: l_result VARCHAR2 (30);
58: --END BUG#2134597
59: CURSOR c_whse_item_role(c_whse_item_id NUMBER) is
60: ( SELECT expiry_role_name,expiry_role_display_name,NVL(lot_expiry_note,0)
61: FROM sy_wf_item_roles
62: WHERE whse_item_id = c_whse_item_id);
63: CURSOR c_item_role(c_item_id NUMBER) is
64: ( SELECT expiry_role_name,expiry_role_display_name,NVL(lot_expiry_note,0)
65: FROM sy_wf_item_roles

Line 65: FROM sy_wf_item_roles

61: FROM sy_wf_item_roles
62: WHERE whse_item_id = c_whse_item_id);
63: CURSOR c_item_role(c_item_id NUMBER) is
64: ( SELECT expiry_role_name,expiry_role_display_name,NVL(lot_expiry_note,0)
65: FROM sy_wf_item_roles
66: WHERE item_id = c_item_id);
67:
68: CURSOR c_whse_item(c_item_id NUMBER) is
69: ( SELECT whse_item_id

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

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

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

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

Line 115: RAISE wf_item_already_exists ;

111: /* create the process */
112: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype, itemkey => l_itemkey, process => l_WorkflowProcess) ;
113: EXCEPTION
114: WHEN DUP_VAL_ON_INDEX THEN
115: RAISE wf_item_already_exists ;
116: END ;
117:
118: /* make sure that process runs with background engine */
119: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

Line 276: WHEN wf_item_already_exists THEN

272: itemkey => l_itemkey);
273:
274: EXCEPTION
275:
276: WHEN wf_item_already_exists THEN
277: Null;
278: WHEN OTHERS THEN
279:
280: WF_CORE.CONTEXT ('gm_wf_lot_expiry',

Line 350: /* save inventory quantities in WF item attributes */

346: ELSE
347: p_resultout := 'COMPLETE:INVEXIST';
348: END IF ;
349:
350: /* save inventory quantities in WF item attributes */
351: WF_ENGINE.SETITEMATTRNUMBER (itemtype => p_itemtype,
352: itemkey => p_itemkey,
353: aname => 'QUANTITY',
354: avalue => l_sum_loct_onhand) ;