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_PROCESS_WO_PUB dependencies on EAM_PROCESS_SAFETY_PUB

Line 4018: l_eam_permit_tbl EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type;

4014: , p_debug_filename IN VARCHAR2 := 'EAM_WO_DEBUG.log'
4015: , p_debug_file_mode IN VARCHAR2 := 'w'
4016: ) IS
4017:
4018: l_eam_permit_tbl EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type;
4019: l_eam_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4020: l_eam_work_clearance_tbl EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ;
4021: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4022:

Line 4019: l_eam_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

4015: , p_debug_file_mode IN VARCHAR2 := 'w'
4016: ) IS
4017:
4018: l_eam_permit_tbl EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type;
4019: l_eam_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4020: l_eam_work_clearance_tbl EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ;
4021: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4022:
4023: BEGIN

Line 4020: l_eam_work_clearance_tbl EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ;

4016: ) IS
4017:
4018: l_eam_permit_tbl EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type;
4019: l_eam_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4020: l_eam_work_clearance_tbl EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ;
4021: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4022:
4023: BEGIN
4024:

Line 4021: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

4017:
4018: l_eam_permit_tbl EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type;
4019: l_eam_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4020: l_eam_work_clearance_tbl EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ;
4021: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4022:
4023: BEGIN
4024:
4025: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Start ====================='); END IF ;

Line 4224: , p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type

4220: , p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
4221: , p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
4222: , p_eam_op_comp_tbl IN EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
4223: , p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
4224: , p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type
4225: , p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
4226: , p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type
4227: , p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
4228: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

Line 4225: , p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

4221: , p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
4222: , p_eam_op_comp_tbl IN EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
4223: , p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
4224: , p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type
4225: , p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
4226: , p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type
4227: , p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
4228: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
4229: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type

Line 4226: , p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type

4222: , p_eam_op_comp_tbl IN EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
4223: , p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
4224: , p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type
4225: , p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
4226: , p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type
4227: , p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
4228: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
4229: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
4230: , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type

Line 4227: , p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

4223: , p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
4224: , p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type
4225: , p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
4226: , p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type
4227: , p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
4228: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
4229: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
4230: , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
4231: , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type

Line 4254: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

4250: , p_debug_file_mode IN VARCHAR2 := 'w'
4251: ) IS
4252:
4253: l_return_status VARCHAR2(1);
4254: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4255: l_second_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4256: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4257: lx_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4258: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

Line 4255: l_second_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

4251: ) IS
4252:
4253: l_return_status VARCHAR2(1);
4254: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4255: l_second_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4256: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4257: lx_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4258: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4259: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

Line 4256: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

4252:
4253: l_return_status VARCHAR2(1);
4254: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4255: l_second_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4256: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4257: lx_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4258: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4259: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4260: l_permit_wo_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;

Line 4257: lx_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

4253: l_return_status VARCHAR2(1);
4254: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4255: l_second_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4256: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4257: lx_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4258: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4259: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4260: l_permit_wo_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
4261: l_eam_work_clearance_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;

Line 4258: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

4254: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4255: l_second_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4256: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4257: lx_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4258: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4259: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4260: l_permit_wo_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
4261: l_eam_work_clearance_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
4262: l_clearance_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

Line 4259: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

4255: l_second_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4256: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4257: lx_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4258: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4259: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4260: l_permit_wo_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
4261: l_eam_work_clearance_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
4262: l_clearance_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4263: l_clearance_re_estabish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

Line 4260: l_permit_wo_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;

4256: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4257: lx_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4258: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4259: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4260: l_permit_wo_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
4261: l_eam_work_clearance_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
4262: l_clearance_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4263: l_clearance_re_estabish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4264: l_clearance_wo_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

Line 4261: l_eam_work_clearance_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;

4257: lx_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4258: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4259: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4260: l_permit_wo_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
4261: l_eam_work_clearance_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
4262: l_clearance_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4263: l_clearance_re_estabish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4264: l_clearance_wo_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4265: l_clearance_permit_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

Line 4262: l_clearance_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

4258: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4259: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4260: l_permit_wo_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
4261: l_eam_work_clearance_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
4262: l_clearance_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4263: l_clearance_re_estabish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4264: l_clearance_wo_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4265: l_clearance_permit_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4266: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

Line 4263: l_clearance_re_estabish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

4259: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
4260: l_permit_wo_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
4261: l_eam_work_clearance_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
4262: l_clearance_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4263: l_clearance_re_estabish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4264: l_clearance_wo_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4265: l_clearance_permit_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4266: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4267: l_wip_entity_id NUMBER;

Line 4264: l_clearance_wo_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

4260: l_permit_wo_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
4261: l_eam_work_clearance_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
4262: l_clearance_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4263: l_clearance_re_estabish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4264: l_clearance_wo_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4265: l_clearance_permit_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4266: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4267: l_wip_entity_id NUMBER;
4268: l_permit_id NUMBER;

Line 4265: l_clearance_permit_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

4261: l_eam_work_clearance_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
4262: l_clearance_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4263: l_clearance_re_estabish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4264: l_clearance_wo_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4265: l_clearance_permit_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4266: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4267: l_wip_entity_id NUMBER;
4268: l_permit_id NUMBER;
4269: l_clearance_id NUMBER;

Line 4266: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

4262: l_clearance_establish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4263: l_clearance_re_estabish_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
4264: l_clearance_wo_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4265: l_clearance_permit_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4266: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4267: l_wip_entity_id NUMBER;
4268: l_permit_id NUMBER;
4269: l_clearance_id NUMBER;
4270: l_organization_id NUMBER;

Line 4462: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT Permit name: '||l_work_permit_header_rec.permit_name);

4458:
4459: */
4460:
4461: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4462: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT Permit name: '||l_work_permit_header_rec.permit_name);
4463: END IF ;
4464:
4465: EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT(
4466: p_bo_identifier => p_bo_identifier

Line 4465: EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT(

4461: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4462: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT Permit name: '||l_work_permit_header_rec.permit_name);
4463: END IF ;
4464:
4465: EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT(
4466: p_bo_identifier => p_bo_identifier
4467: , p_api_version_number => p_api_version_number
4468: , p_init_msg_list => TRUE
4469: , p_commit => p_commit

Line 4525: EAM_PROCESS_SAFETY_PUB.PERMIT_WORK_ORDER_ASSOCIATION(

4521: END IF;
4522: END LOOP; --ASSOCIATION LOOP
4523:
4524:
4525: EAM_PROCESS_SAFETY_PUB.PERMIT_WORK_ORDER_ASSOCIATION(
4526: p_init_msg_list => TRUE
4527: , p_permit_wo_association_tbl => l_second_permit_wo_assoc_tbl
4528: , p_debug => p_debug
4529: , p_output_dir => p_output_dir

Line 4551: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE Clearance name: '||l_eam_work_clearance_rec.WORK_CLEARANCE_NAME);

4547:
4548: l_eam_work_clearance_rec := p_eam_work_clearance_tbl(i);
4549:
4550: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4551: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE Clearance name: '||l_eam_work_clearance_rec.WORK_CLEARANCE_NAME);
4552: END IF ;
4553: EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE(
4554: p_init_msg_list => TRUE
4555: , p_work_clearance_header_rec => l_eam_work_clearance_rec

Line 4553: EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE(

4549:
4550: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4551: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE Clearance name: '||l_eam_work_clearance_rec.WORK_CLEARANCE_NAME);
4552: END IF ;
4553: EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE(
4554: p_init_msg_list => TRUE
4555: , p_work_clearance_header_rec => l_eam_work_clearance_rec
4556: , p_clearance_establish_tbl => l_clearance_establish_tbl
4557: , p_clearance_re_estabish_tbl => l_clearance_re_estabish_tbl

Line 4586: EAM_PROCESS_SAFETY_PUB.CLEARANCE_WO_ASSOCIATION(

4582: FOR i in p_eam_wc_wo_assoc_tbl.FIRST .. p_eam_wc_wo_assoc_tbl.LAST LOOP
4583:
4584: l_eam_wc_wo_assoc_tbl(i).TARGET_REF_ID:= l_wip_entity_id;
4585:
4586: EAM_PROCESS_SAFETY_PUB.CLEARANCE_WO_ASSOCIATION(
4587: p_init_msg_list => TRUE
4588: , p_clearance_wo_asso_tbl => l_eam_wc_wo_assoc_tbl
4589: , p_debug => p_debug
4590: , p_output_dir => p_output_dir