34: FETCH GET_ITEM_DATA
35: INTO P_ITEM_ID,P_LOT_ID;
36: CLOSE GET_ITEM_DATA;
37: IF P_VIEW_BY = 1 THEN
38: P_REP_TITLE := FND_MESSAGE.GET_STRING('GMI'
39: ,'GMI_LOT_SOURCE');
40: P_LOT_COMP_TITLE := FND_MESSAGE.GET_STRING('GMI'
41: ,'GMI_LOT_INGD') ;
42: ELSE
36: CLOSE GET_ITEM_DATA;
37: IF P_VIEW_BY = 1 THEN
38: P_REP_TITLE := FND_MESSAGE.GET_STRING('GMI'
39: ,'GMI_LOT_SOURCE');
40: P_LOT_COMP_TITLE := FND_MESSAGE.GET_STRING('GMI'
41: ,'GMI_LOT_INGD') ;
42: ELSE
43: P_REP_TITLE := FND_MESSAGE.GET_STRING('GMI'
44: ,'GMI_LOT_WHERE_USED');
39: ,'GMI_LOT_SOURCE');
40: P_LOT_COMP_TITLE := FND_MESSAGE.GET_STRING('GMI'
41: ,'GMI_LOT_INGD') ;
42: ELSE
43: P_REP_TITLE := FND_MESSAGE.GET_STRING('GMI'
44: ,'GMI_LOT_WHERE_USED');
45: P_LOT_COMP_TITLE := FND_MESSAGE.GET_STRING('GMI'
46: ,'GMI_LOT_BYPRDS') ;
47: END IF;
41: ,'GMI_LOT_INGD') ;
42: ELSE
43: P_REP_TITLE := FND_MESSAGE.GET_STRING('GMI'
44: ,'GMI_LOT_WHERE_USED');
45: P_LOT_COMP_TITLE := FND_MESSAGE.GET_STRING('GMI'
46: ,'GMI_LOT_BYPRDS') ;
47: END IF;
48: SELECT
49: GMI_LOT_TRACE_ID_S.NEXTVAL