DBA Data[Home] [Help]

APPS.EAM_PERMIT_UTILITY_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 16: , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

12: ***********************************************************************/
13: PROCEDURE QUERY_ROW
14: ( p_work_permit_id IN NUMBER
15: , p_organization_id IN NUMBER
16: , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
17: , x_Return_status OUT NOCOPY VARCHAR2
18: ) IS
19:
20: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

Line 20: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

16: , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
17: , x_Return_status OUT NOCOPY VARCHAR2
18: ) IS
19:
20: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
21: BEGIN
22:
23:
24: SELECT

Line 141: (p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

137: * Procedure : INSERT_ROW
138: * Purpose : Procedure will perfrom an insert into the table
139: *********************************************************************/
140: PROCEDURE INSERT_ROW
141: (p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
142: , x_return_Status OUT NOCOPY VARCHAR2
143: )
144: IS
145:

Line 265: ( p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

261: * Purpose : Procedure will perform an update on the table
262: *********************************************************************/
263:
264: PROCEDURE UPDATE_ROW
265: ( p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
266: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
267: , x_return_Status OUT NOCOPY VARCHAR2
268: ) IS
269:

Line 336: ( p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

332: access to when he/she needs to perform any kind of writes to the table.
333: *********************************************************************/
334:
335: PROCEDURE PERFORM_WRITES
336: ( p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
337: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
338: , x_return_Status OUT NOCOPY VARCHAR2
339: )IS
340: l_msg_data VARCHAR2(240);