DBA Data[Home] [Help]

APPS.EAM_PERMIT_VALIDATE_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 10: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,

6: * Procedure : Check_Existence
7: * Purpose : Procedure will query the old work permit record and return it in old record variables.
8: *********************************************************************/
9: PROCEDURE CHECK_EXISTENCE(
10: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
11: x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
12: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
13: x_return_Status OUT NOCOPY VARCHAR2 )
14: IS

Line 11: x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,

7: * Purpose : Procedure will query the old work permit record and return it in old record variables.
8: *********************************************************************/
9: PROCEDURE CHECK_EXISTENCE(
10: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
11: x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
12: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
13: x_return_Status OUT NOCOPY VARCHAR2 )
14: IS
15: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

Line 19: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

15: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
16: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
17: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
18: l_return_status VARCHAR2(1);
19: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
20:
21: BEGIN
22: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Permit'); END IF;
23: EAM_PERMIT_UTILITY_PVT.QUERY_ROW (

Line 80: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,

76: * Procedure: Check_Attributes
77: * Purpose: Check_Attributes procedure will validate every Revised item attribute in its entirely.
78: *********************************************************************/
79: PROCEDURE CHECK_ATTRIBUTES(
80: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
81: p_old_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
82: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
83: x_return_Status OUT NOCOPY VARCHAR2 )
84: IS

Line 81: p_old_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,

77: * Purpose: Check_Attributes procedure will validate every Revised item attribute in its entirely.
78: *********************************************************************/
79: PROCEDURE CHECK_ATTRIBUTES(
80: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
81: p_old_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
82: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
83: x_return_Status OUT NOCOPY VARCHAR2 )
84: IS
85: l_err_text VARCHAR2(2000) := NULL;

Line 417: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,

413: * Procedure : Check_Required
414: * Purpose : Check_Required procedure will check the existence of mandatory attributes.
415: *********************************************************************/
416: PROCEDURE CHECK_REQUIRED(
417: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
418: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
419: x_return_Status OUT NOCOPY VARCHAR2 )
420: IS
421: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;