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
50: INTO P_TRACE_ID
51: FROM
52: DUAL;
53: GMI_LOT_TRACE_PKG.EXP_LOT(P_ITEM_ID
49: GMI_LOT_TRACE_ID_S.NEXTVAL
50: INTO P_TRACE_ID
51: FROM
52: DUAL;
53: GMI_LOT_TRACE_PKG.EXP_LOT(P_ITEM_ID
54: ,P_LOT_ID
55: ,1
56: ,COMP_NO
57: ,P_VIEW_BY
61: END AFTERPFORM;
62:
63: FUNCTION AFTERREPORT RETURN BOOLEAN IS
64: BEGIN
65: DELETE FROM GMI_LOT_TRACE
66: WHERE LOT_TRACE_ID = P_TRACE_ID;
67: COMMIT;
68: --GGM_TRACE.SET_TRACE_OFF;
69: /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;