DBA Data[Home] [Help]

APPS.EAM_ISOLATION_WORKFLOW_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 134: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;

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;

Line 135: l_old_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_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;

Line 136: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_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:

Line 137: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

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);

Line 138: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

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);

Line 139: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_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);
143: l_msg_count NUMBER;

Line 253: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;

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;

Line 254: lx_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_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:

Line 255: l_iso_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_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:
259: l_output_dir VARCHAR2(512);

Line 256: l_iso_reestablishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

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);

Line 257: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

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;

Line 548: ( p_old_isolation_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type

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

Line 549: , p_new_isolation_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type

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