APPS.GMI_WF_LOT_EXPIRY dependencies on SY_WF_ITEM_ROLES

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 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