APPS.EAM_CLEARANCE_UTILITY_PVT dependencies on EAM_WORK_CLEARANCES

Line 137: FROM EAM_WORK_CLEARANCES ewc

133: ,l_work_clearance_header_rec.ATTRIBUTE28
134: ,l_work_clearance_header_rec.ATTRIBUTE30
135:
136:
137: FROM EAM_WORK_CLEARANCES ewc
138: WHERE ewc.WORK_CLEARANCE_ID = p_work_clearance_id
139: AND ewc.organization_id = p_organization_id;
140:
141: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

Line 172: INSERT INTO EAM_WORK_CLEARANCES(

168:
169: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing clearance rec for ' || p_work_clearance_header_rec.WORK_CLEARANCE_NAME); END IF;
170:
171:
172: INSERT INTO EAM_WORK_CLEARANCES(
173: WORK_CLEARANCE_ID
174: ,WORK_CLEARANCE_NAME
175: ,LAST_ISOLATION_ID
176: ,DESCRIPTION

Line 302: UPDATE EAM_WORK_CLEARANCES

298: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Permit rec for ' || p_work_clearance_header_rec.WORK_CLEARANCE_NAME); END IF;
299:
300: --Note : double check which of these columns are updeatable.
301:
302: UPDATE EAM_WORK_CLEARANCES
303: SET WORK_CLEARANCE_NAME = p_work_clearance_header_rec.WORK_CLEARANCE_NAME
304: ,DESCRIPTION =p_work_clearance_header_rec.DESCRIPTION
305: ,LAST_ISOLATION_ID =p_work_clearance_header_rec.ISOLATION_ID
306: ,PENDING_FLAG =p_work_clearance_header_rec.PENDING_FLAG

Line 453: UPDATE EAM_WORK_CLEARANCES

449: -- Update status in clearance table
450: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Update status in clearance table'); END IF;
451: BEGIN
452:
453: UPDATE EAM_WORK_CLEARANCES
454: SET STATUS_TYPE = l_to_status_type
455: WHERE ORGANIZATION_ID = l_organization_id
456: AND WORK_CLEARANCE_ID = l_clearance_id;
457: