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

Line 116: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

112: ( p_bo_identifier IN VARCHAR2 := 'EAM'
113: , p_api_version_number IN NUMBER := 1.0
114: , p_init_msg_list IN BOOLEAN := FALSE
115: , p_commit IN VARCHAR2
116: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
117: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
118: , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
119: , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
120: , x_return_status OUT NOCOPY VARCHAR2

Line 117: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

113: , p_api_version_number IN NUMBER := 1.0
114: , p_init_msg_list IN BOOLEAN := FALSE
115: , p_commit IN VARCHAR2
116: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
117: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
118: , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
119: , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
120: , x_return_status OUT NOCOPY VARCHAR2
121: , x_msg_count OUT NOCOPY NUMBER

Line 118: , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

114: , p_init_msg_list IN BOOLEAN := FALSE
115: , p_commit IN VARCHAR2
116: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
117: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
118: , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
119: , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
120: , x_return_status OUT NOCOPY VARCHAR2
121: , x_msg_count OUT NOCOPY NUMBER
122: , p_debug IN VARCHAR2

Line 119: , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

115: , p_commit IN VARCHAR2
116: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
117: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
118: , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
119: , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
120: , x_return_status OUT NOCOPY VARCHAR2
121: , x_msg_count OUT NOCOPY NUMBER
122: , p_debug IN VARCHAR2
123: , p_output_dir IN VARCHAR2

Line 134: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

130:
131: l_return_status VARCHAR2(1);
132: l_msg_count NUMBER;
133: l_msg_data VARCHAR2(240);
134: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
135: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
136: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
137: l_permit_id NUMBER;
138:

Line 135: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

131: l_return_status VARCHAR2(1);
132: l_msg_count NUMBER;
133: l_msg_data VARCHAR2(240);
134: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
135: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
136: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
137: l_permit_id NUMBER;
138:
139: /* Error Handling Variables */

Line 136: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;

132: l_msg_count NUMBER;
133: l_msg_data VARCHAR2(240);
134: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
135: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
136: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
137: l_permit_id NUMBER;
138:
139: /* Error Handling Variables */
140: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type ;

Line 279: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

275: (
276: p_validation_level IN NUMBER
277: , p_work_permit_id IN NUMBER :=NULL
278: , p_organization_id IN NUMBER :=NULL
279: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
280: , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
281: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
282: , x_return_status OUT NOCOPY VARCHAR2
283: )IS

Line 280: , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

276: p_validation_level IN NUMBER
277: , p_work_permit_id IN NUMBER :=NULL
278: , p_organization_id IN NUMBER :=NULL
279: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
280: , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
281: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
282: , x_return_status OUT NOCOPY VARCHAR2
283: )IS
284:

Line 295: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type :=p_work_permit_header_rec;

291:
292: l_permit_id NUMBER := p_work_permit_header_rec.PERMIT_ID;
293: l_workflow_enabled VARCHAR2(1);
294:
295: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type :=p_work_permit_header_rec;
296: l_old_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
297: l_out_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
298:
299:

Line 296: l_old_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

292: l_permit_id NUMBER := p_work_permit_header_rec.PERMIT_ID;
293: l_workflow_enabled VARCHAR2(1);
294:
295: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type :=p_work_permit_header_rec;
296: l_old_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
297: l_out_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
298:
299:
300: l_maintenance_object_source NUMBER :=1; -- To check if work flow is enabled

Line 297: l_out_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

293: l_workflow_enabled VARCHAR2(1);
294:
295: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type :=p_work_permit_header_rec;
296: l_old_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
297: l_out_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
298:
299:
300: l_maintenance_object_source NUMBER :=1; -- To check if work flow is enabled
301: l_status_pending_event VARCHAR2(100) := 'oracle.apps.eam.permit.status.change.pending';

Line 651: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type

647:
648: /*PROCEDURE PERMIT_WORK_ORDER_ASSOCIATION
649: ( p_validation_level IN NUMBER
650: , p_organization_id IN NUMBER
651: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
652: , p_work_permit_id IN NUMBER
653: , x_permit_wo_association_tbl OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
654: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
655: , x_return_status OUT NOCOPY VARCHAR2

Line 653: , x_permit_wo_association_tbl OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type

649: ( p_validation_level IN NUMBER
650: , p_organization_id IN NUMBER
651: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
652: , p_work_permit_id IN NUMBER
653: , x_permit_wo_association_tbl OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
654: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
655: , x_return_status OUT NOCOPY VARCHAR2
656: )IS
657: CURSOR C IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

Line 662: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_wp_association_rec_type;

658: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
659: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
660: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
661: l_return_status VARCHAR2(1);
662: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_wp_association_rec_type;
663: l_permit_status NUMBER;
664: l_wo_status NUMBER;
665: l_safety_assoc_id NUMBER;
666:

Line 841: , p_eam_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

837:
838: PROCEDURE RAISE_WORKFLOW_EVENTS
839: ( p_api_version IN NUMBER
840: , p_validation_level IN NUMBER
841: , p_eam_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
842: , p_old_eam_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
843: , p_approval_required IN BOOLEAN
844: , p_new_system_status IN NUMBER
845: , p_workflow_name IN VARCHAR2

Line 842: , p_old_eam_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

838: PROCEDURE RAISE_WORKFLOW_EVENTS
839: ( p_api_version IN NUMBER
840: , p_validation_level IN NUMBER
841: , p_eam_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
842: , p_old_eam_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
843: , p_approval_required IN BOOLEAN
844: , p_new_system_status IN NUMBER
845: , p_workflow_name IN VARCHAR2
846: , p_workflow_process IN VARCHAR2

Line 970: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

966: l_org_id NUMBER :=p_org_id;
967: -- l_permit_name_char VARCHAR2(240);
968: l_permit_name NUMBER;
969:
970: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
971: l_out_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
972:
973: /* Error Handling Variables */
974: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ;

Line 971: l_out_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

967: -- l_permit_name_char VARCHAR2(240);
968: l_permit_name NUMBER;
969:
970: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
971: l_out_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
972:
973: /* Error Handling Variables */
974: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ;
975: l_error_level NUMBER :=EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL;