APPS.EAM_PERMIT_UTILITY_PVT dependencies on EAM_WORK_PERMITS

Line 118: FROM EAM_WORK_PERMITS ewp

114: ,l_work_permit_header_rec.APPROVED_BY
115: ,l_work_permit_header_rec.CREATION_DATE
116: ,l_work_permit_header_rec.CREATED_BY
117:
118: FROM EAM_WORK_PERMITS ewp
119: WHERE ewp.permit_id = p_work_permit_id
120: AND ewp.organization_id = p_organization_id;
121:
122: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

Line 151: INSERT INTO EAM_WORK_PERMITS(

147:
148: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Permit rec for ' || p_work_permit_header_rec.PERMIT_NAME); END IF;
149:
150:
151: INSERT INTO EAM_WORK_PERMITS(
152: PERMIT_ID
153: ,PERMIT_NAME
154: ,DESCRIPTION
155: ,ORGANIZATION_ID

Line 275: UPDATE EAM_WORK_PERMITS

271:
272: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Permit rec for ' || p_work_permit_header_rec.PERMIT_NAME); END IF;
273:
274:
275: UPDATE EAM_WORK_PERMITS
276: SET
277: PERMIT_NAME =p_work_permit_header_rec.PERMIT_NAME -- incase of copy permit
278: ,PERMIT_TYPE =p_work_permit_header_rec.PERMIT_TYPE -- incase of copy permit
279: ,DESCRIPTION =p_work_permit_header_rec.DESCRIPTION

Line 425: UPDATE EAM_WORK_PERMITS

421: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Update status in permits table'); END IF;
422:
423: BEGIN
424:
425: UPDATE EAM_WORK_PERMITS
426: SET STATUS_TYPE = l_to_status_type
427: WHERE ORGANIZATION_ID = l_organization_id
428: AND permit_id = l_permit_id;
429: