DBA Data[Home] [Help]

APPS.EAM_WORKPERMIT_WORKFLOW_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 134: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

130: l_err_msg varchar2(2000);
131: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
132: l_status_error EXCEPTION;
133:
134: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
135: l_old_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
136: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
137: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

Line 135: l_old_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

131: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
132: l_status_error EXCEPTION;
133:
134: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
135: l_old_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
136: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
137: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
139:

Line 136: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

132: l_status_error EXCEPTION;
133:
134: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
135: l_old_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
136: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
137: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
139:
140: l_output_dir VARCHAR2(512);

Line 137: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

133:
134: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
135: l_old_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
136: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
137: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
139:
140: l_output_dir VARCHAR2(512);
141: l_return_status VARCHAR2(1);

Line 138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

134: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
135: l_old_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
136: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
137: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
138: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
139:
140: l_output_dir VARCHAR2(512);
141: l_return_status VARCHAR2(1);
142: l_msg_count NUMBER;

Line 252: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

248: l_err_msg varchar2(2000);
249: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
250: l_status_error EXCEPTION;
251:
252: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
253: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
254: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
255: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
256:

Line 253: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

249: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
250: l_status_error EXCEPTION;
251:
252: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
253: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
254: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
255: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
256:
257: l_output_dir VARCHAR2(512);

Line 254: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

250: l_status_error EXCEPTION;
251:
252: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
253: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
254: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
255: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
256:
257: l_output_dir VARCHAR2(512);
258: l_return_status VARCHAR2(1);

Line 255: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

251:
252: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
253: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
254: l_permit_wo_association_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
255: l_permit_clearance_asso_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
256:
257: l_output_dir VARCHAR2(512);
258: l_return_status VARCHAR2(1);
259: l_msg_count NUMBER;

Line 545: ( p_old_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

541: the work permit release
542: *********************************************************************/
543:
544: PROCEDURE Is_Approval_Required_Released
545: ( p_old_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
546: , p_new_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
547: , x_approval_required OUT NOCOPY BOOLEAN
548: , x_workflow_name OUT NOCOPY VARCHAR2
549: , x_workflow_process OUT NOCOPY VARCHAR2

Line 546: , p_new_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

542: *********************************************************************/
543:
544: PROCEDURE Is_Approval_Required_Released
545: ( p_old_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
546: , p_new_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
547: , x_approval_required OUT NOCOPY BOOLEAN
548: , x_workflow_name OUT NOCOPY VARCHAR2
549: , x_workflow_process OUT NOCOPY VARCHAR2
550: )IS