APPS.GMI_WF_LOT_RETEST dependencies on SY_WF_ITEM_ROLES

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