APPS.GMI_WF_LOT_RETEST dependencies on IC_ITEM_MST

Line 35: l_item_no ic_item_mst.item_no%TYPE ;

31:
32: l_retest_notify_date DATE ;
33: l_wf_start_date DATE ;
34:
35: l_item_no ic_item_mst.item_no%TYPE ;
36: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
37: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
38: l_item_um ic_item_mst.item_um%TYPE ;
39: l_item_um2 ic_item_mst.item_um2%TYPE ;

Line 36: l_item_desc1 ic_item_mst.item_desc1%TYPE ;

32: l_retest_notify_date DATE ;
33: l_wf_start_date DATE ;
34:
35: l_item_no ic_item_mst.item_no%TYPE ;
36: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
37: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
38: l_item_um ic_item_mst.item_um%TYPE ;
39: l_item_um2 ic_item_mst.item_um2%TYPE ;
40: c_whse_item_id ic_item_mst.whse_item_id%TYPE;

Line 37: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;

33: l_wf_start_date DATE ;
34:
35: l_item_no ic_item_mst.item_no%TYPE ;
36: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
37: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
38: l_item_um ic_item_mst.item_um%TYPE ;
39: l_item_um2 ic_item_mst.item_um2%TYPE ;
40: c_whse_item_id ic_item_mst.whse_item_id%TYPE;
41: c_item_id ic_item_mst.item_id%TYPE;

Line 38: l_item_um ic_item_mst.item_um%TYPE ;

34:
35: l_item_no ic_item_mst.item_no%TYPE ;
36: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
37: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
38: l_item_um ic_item_mst.item_um%TYPE ;
39: l_item_um2 ic_item_mst.item_um2%TYPE ;
40: c_whse_item_id ic_item_mst.whse_item_id%TYPE;
41: c_item_id ic_item_mst.item_id%TYPE;
42: l_performer_name FND_USER.USER_NAME%TYPE ;

Line 39: l_item_um2 ic_item_mst.item_um2%TYPE ;

35: l_item_no ic_item_mst.item_no%TYPE ;
36: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
37: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
38: l_item_um ic_item_mst.item_um%TYPE ;
39: l_item_um2 ic_item_mst.item_um2%TYPE ;
40: c_whse_item_id ic_item_mst.whse_item_id%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 ;

Line 40: c_whse_item_id ic_item_mst.whse_item_id%TYPE;

36: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
37: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
38: l_item_um ic_item_mst.item_um%TYPE ;
39: l_item_um2 ic_item_mst.item_um2%TYPE ;
40: c_whse_item_id ic_item_mst.whse_item_id%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:

Line 41: c_item_id ic_item_mst.item_id%TYPE;

37: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
38: l_item_um ic_item_mst.item_um%TYPE ;
39: l_item_um2 ic_item_mst.item_um2%TYPE ;
40: c_whse_item_id ic_item_mst.whse_item_id%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 ;

Line 73: FROM ic_item_mst

69: WHERE item_id = c_item_id);
70:
71: CURSOR c_whse_item(c_item_id NUMBER) is
72: ( SELECT whse_item_id
73: FROM ic_item_mst
74: WHERE item_id = c_item_id);
75: BEGIN
76: SELECT sysdate
77: INTO l_wf_start_date

Line 87: FROM ic_item_mst

83: WHERE USER_ID = p_created_by ;
84:
85: SELECT item_no , item_desc1 ,item_um ,item_um2 , dualum_ind
86: INTO l_item_no ,l_item_desc1 ,l_item_um ,l_item_um2 ,l_dualum_ind
87: FROM ic_item_mst
88: WHERE item_id = p_item_id ;
89:
90: /*BEGIN BUG#2134597 Praveen Reddy*/
91: /*Check if the workflow data exists and remove the same for the itemtype and itemkey