130: l_err_msg varchar2(2000);
131: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
132: l_status_error EXCEPTION;
133:
134: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
135: l_old_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
136: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
137: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
138: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
131: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
132: l_status_error EXCEPTION;
133:
134: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
135: l_old_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
136: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
137: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
138: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
139: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
132: l_status_error EXCEPTION;
133:
134: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
135: l_old_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
136: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
137: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
138: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
139: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
140:
133:
134: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
135: l_old_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
136: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
137: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
138: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
139: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
140:
141: l_output_dir VARCHAR2(512);
134: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
135: l_old_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
136: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
137: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
138: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
139: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
140:
141: l_output_dir VARCHAR2(512);
142: l_return_status VARCHAR2(1);
135: l_old_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
136: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
137: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
138: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
139: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
140:
141: l_output_dir VARCHAR2(512);
142: l_return_status VARCHAR2(1);
143: l_msg_count NUMBER;
249: l_err_msg varchar2(2000);
250: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
251: l_status_error EXCEPTION;
252:
253: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
254: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
255: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
256: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
257: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
250: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
251: l_status_error EXCEPTION;
252:
253: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
254: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
255: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
256: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
257: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
258:
251: l_status_error EXCEPTION;
252:
253: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
254: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
255: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
256: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
257: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
258:
259: l_output_dir VARCHAR2(512);
252:
253: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
254: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
255: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
256: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
257: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
258:
259: l_output_dir VARCHAR2(512);
260: l_return_status VARCHAR2(1);
253: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
254: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
255: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
256: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
257: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
258:
259: l_output_dir VARCHAR2(512);
260: l_return_status VARCHAR2(1);
261: l_msg_count NUMBER;
544: the work isolation release
545: *********************************************************************/
546:
547: PROCEDURE Is_Approval_Required_Released
548: ( p_old_isolation_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
549: , p_new_isolation_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
550: , x_approval_required OUT NOCOPY BOOLEAN
551: , x_workflow_name OUT NOCOPY VARCHAR2
552: , x_workflow_process OUT NOCOPY VARCHAR2
545: *********************************************************************/
546:
547: PROCEDURE Is_Approval_Required_Released
548: ( p_old_isolation_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
549: , p_new_isolation_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
550: , x_approval_required OUT NOCOPY BOOLEAN
551: , x_workflow_name OUT NOCOPY VARCHAR2
552: , x_workflow_process OUT NOCOPY VARCHAR2
553: )IS