DBA Data[Home] [Help]

APPS.EAM_PROCESS_CLEARANCE_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 29: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type

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

Line 30: , p_clearance_establishment_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_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

Line 31: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_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

Line 32: , p_clearance_workorder_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

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

Line 33: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

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'

Line 34: , x_work_clearance_header_rec OUT NOCOPY 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'
38: , p_output_dir IN VARCHAR2 := NULL

Line 52: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type

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

Line 53: , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type

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:

Line 66: , p_eam_wc_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type

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

Line 67: , p_old_eam_wc_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type

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