APPS.EAM_PROCESS_PERMIT_PVT dependencies on DUAL

Line 285: CURSOR C IS SELECT EAM_WORK_PERMIT_S.NEXTVAL FROM SYS.DUAL;

281: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
282: , x_return_status OUT NOCOPY VARCHAR2
283: )IS
284:
285: CURSOR C IS SELECT EAM_WORK_PERMIT_S.NEXTVAL FROM SYS.DUAL;
286:
287: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
288: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
289: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 657: CURSOR C IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

653: , x_permit_wo_association_tbl OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
654: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
655: , x_return_status OUT NOCOPY VARCHAR2
656: )IS
657: CURSOR C IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;
658: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
659: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
660: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
661: l_return_status VARCHAR2(1);

Line 870: FROM DUAL;

866: IF( p_approval_required AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE')) THEN
867:
868: SELECT EAM_SAFETYWORKFLOW_EVENT_S.NEXTVAL
869: INTO l_wf_event_seq
870: FROM DUAL;
871:
872: l_parameter_list := wf_parameter_list_t();
873: l_event_name := l_status_pending_event;
874:

Line 959: CURSOR C IS SELECT EAM_PERMIT_NAME_S.NEXTVAL FROM SYS.DUAL;

955: , x_return_status OUT NOCOPY VARCHAR2
956: , x_msg_count OUT NOCOPY NUMBER
957:
958: )IS
959: CURSOR C IS SELECT EAM_PERMIT_NAME_S.NEXTVAL FROM SYS.DUAL;
960: l_api_name CONSTANT VARCHAR2(30) := G_PKG_NAME;
961: l_validation_level NUMBER := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
962:
963: l_return_status VARCHAR2(1);