eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_CLEARANCE_WORKFLOW_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 134: l_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_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_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
135: l_old_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
136: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
137: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

Line 135: l_old_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;

131: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
132: l_status_error EXCEPTION;
133:
134: l_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
135: l_old_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
136: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
137: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
139: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

Line 136: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;

132: l_status_error EXCEPTION;
133:
134: l_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
135: l_old_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
136: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
137: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
139: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
140: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

Line 137: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

133:
134: l_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
135: l_old_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
136: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
137: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
139: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
140: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
141:

Line 138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

134: l_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
135: l_old_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
136: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
137: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
139: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
140: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
141:
142: l_output_dir VARCHAR2(512);

Line 139: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

135: l_old_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
136: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
137: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
139: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
140: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
141:
142: l_output_dir VARCHAR2(512);
143: l_return_status VARCHAR2(1);

Line 140: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

136: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
137: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
139: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
140: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
141:
142: l_output_dir VARCHAR2(512);
143: l_return_status VARCHAR2(1);
144: l_msg_count NUMBER;

Line 255: l_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;

251: l_err_msg varchar2(2000);
252: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
253: l_status_error EXCEPTION;
254:
255: l_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
256: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
257: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
258: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
259: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

Line 256: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;

252: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
253: l_status_error EXCEPTION;
254:
255: l_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
256: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
257: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
258: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
259: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
260: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

Line 257: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

253: l_status_error EXCEPTION;
254:
255: l_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
256: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
257: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
258: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
259: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
260: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
261:

Line 258: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

254:
255: l_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
256: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
257: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
258: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
259: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
260: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
261:
262: l_output_dir VARCHAR2(512);

Line 259: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

255: l_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
256: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
257: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
258: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
259: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
260: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
261:
262: l_output_dir VARCHAR2(512);
263: l_return_status VARCHAR2(1);

Line 260: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

256: lx_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
257: l_clearance_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
258: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
259: l_clearance_establishment_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
260: l_clearance_re_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
261:
262: l_output_dir VARCHAR2(512);
263: l_return_status VARCHAR2(1);
264: l_msg_count NUMBER;

Line 552: ( p_old_clearance_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type

548: the work clearance release
549: *********************************************************************/
550:
551: PROCEDURE Is_Approval_Required_Released
552: ( p_old_clearance_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
553: , p_new_clearance_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
554: , x_approval_required OUT NOCOPY BOOLEAN
555: , x_workflow_name OUT NOCOPY VARCHAR2
556: , x_workflow_process OUT NOCOPY VARCHAR2

Line 553: , p_new_clearance_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type

549: *********************************************************************/
550:
551: PROCEDURE Is_Approval_Required_Released
552: ( p_old_clearance_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
553: , p_new_clearance_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
554: , x_approval_required OUT NOCOPY BOOLEAN
555: , x_workflow_name OUT NOCOPY VARCHAR2
556: , x_workflow_process OUT NOCOPY VARCHAR2
557: )IS