25: ( p_bo_identifier IN VARCHAR2 := 'EAM'
26: , p_api_version_number IN NUMBER := 1.0
27: , p_init_msg_list IN BOOLEAN := FALSE
28: , p_commit IN VARCHAR2 := 'N'
29: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
30: , p_clearance_establishment_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
31: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
32: , p_clearance_workorder_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
33: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
26: , p_api_version_number IN NUMBER := 1.0
27: , p_init_msg_list IN BOOLEAN := FALSE
28: , p_commit IN VARCHAR2 := 'N'
29: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
30: , p_clearance_establishment_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
31: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
32: , p_clearance_workorder_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
33: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
34: , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
27: , p_init_msg_list IN BOOLEAN := FALSE
28: , p_commit IN VARCHAR2 := 'N'
29: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
30: , p_clearance_establishment_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
31: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
32: , p_clearance_workorder_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
33: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
34: , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
35: , x_return_status OUT NOCOPY VARCHAR2
28: , p_commit IN VARCHAR2 := 'N'
29: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
30: , p_clearance_establishment_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
31: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
32: , p_clearance_workorder_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
33: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
34: , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
35: , x_return_status OUT NOCOPY VARCHAR2
36: , x_msg_count OUT NOCOPY NUMBER
29: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
30: , p_clearance_establishment_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
31: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
32: , p_clearance_workorder_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
33: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
34: , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
35: , x_return_status OUT NOCOPY VARCHAR2
36: , x_msg_count OUT NOCOPY NUMBER
37: , p_debug IN VARCHAR2 := 'N'
30: , p_clearance_establishment_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
31: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
32: , p_clearance_workorder_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
33: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
34: , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
35: , x_return_status OUT NOCOPY VARCHAR2
36: , x_msg_count OUT NOCOPY NUMBER
37: , p_debug IN VARCHAR2 := 'N'
38: , p_output_dir IN VARCHAR2 := NULL
48: PROCEDURE WORK_CLEARANCE
49: ( p_validation_level IN NUMBER
50: , p_work_clearance_id IN NUMBER
51: , p_organization_id IN NUMBER
52: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
53: , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
54: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
55: , x_return_status OUT NOCOPY VARCHAR2
56: );
49: ( p_validation_level IN NUMBER
50: , p_work_clearance_id IN NUMBER
51: , p_organization_id IN NUMBER
52: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
53: , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
54: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
55: , x_return_status OUT NOCOPY VARCHAR2
56: );
57:
62: *********************************************************************/
63: PROCEDURE RAISE_WORKFLOW_EVENTS
64: ( p_api_version IN NUMBER
65: , p_validation_level IN NUMBER
66: , p_eam_wc_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
67: , p_old_eam_wc_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
68: , p_approval_required IN BOOLEAN
69: , p_new_system_status IN NUMBER
70: , p_workflow_name IN VARCHAR2
63: PROCEDURE RAISE_WORKFLOW_EVENTS
64: ( p_api_version IN NUMBER
65: , p_validation_level IN NUMBER
66: , p_eam_wc_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
67: , p_old_eam_wc_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
68: , p_approval_required IN BOOLEAN
69: , p_new_system_status IN NUMBER
70: , p_workflow_name IN VARCHAR2
71: , p_workflow_process IN VARCHAR2