[Home] [Help]
23: ***********************************************************************/
24: PROCEDURE QUERY_ROW(
25: p_isolation_id IN NUMBER ,
26: p_organization_id IN NUMBER ,
27: x_isolation_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type ,
28: x_Return_status OUT NOCOPY VARCHAR2 )
29: IS
30: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
31: BEGIN
26: p_organization_id IN NUMBER ,
27: x_isolation_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type ,
28: x_Return_status OUT NOCOPY VARCHAR2 )
29: IS
30: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
31: BEGIN
32: SELECT iso.ISOLATION_ID ,
33: iso.ISOLATION_NAME ,
34: iso.ISOLATION_TYPE ,
137: * Procedure : INSERT_ROW
138: * Purpose : Procedure will perfrom an insert into the table
139: *********************************************************************/
140: PROCEDURE INSERT_ROW(
141: p_isolation_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type ,
142: x_return_Status OUT NOCOPY VARCHAR2 )
143: IS
144: BEGIN
145: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
259: * Purpose : Procedure will perform an update on the table
260: *********************************************************************/
261: PROCEDURE UPDATE_ROW
262: (
263: p_isolation_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type ,
264: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
265: x_return_Status OUT NOCOPY VARCHAR2
266: )
267: IS
323: * Purpose : This is the only procedure that the user will have
324: access to when he/she needs to perform any kind of writes to the table.
325: *********************************************************************/
326: PROCEDURE PERFORM_WRITES(
327: p_isolation_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type ,
328: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
329: x_return_Status OUT NOCOPY VARCHAR2 )
330: IS
331: l_msg_data VARCHAR2(240);