APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on DUAL

Line 611: SELECT ahl_mel_cdl_ata_sequences_s.NEXTVAL INTO p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id FROM DUAL;

607: -- Default attributes for create
608: p_x_ata_sequences_tbl(l_rec_idx).object_version_number := 1;
609: IF (p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id IS NULL)
610: THEN
611: SELECT ahl_mel_cdl_ata_sequences_s.NEXTVAL INTO p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id FROM DUAL;
612: END IF;
613:
614: -- Insert record into backend
615: INSERT INTO ahl_mel_cdl_ata_sequences

Line 1065: SELECT 'X' INTO l_dummy_varchar FROM DUAL WHERE NOT EXISTS

1061: END IF;
1062:
1063: -- Check if the MO Procedure is already associated to the Ata Sequence
1064: BEGIN
1065: SELECT 'X' INTO l_dummy_varchar FROM DUAL WHERE NOT EXISTS
1066: (SELECT 'x'
1067: FROM
1068: ahl_mel_cdl_mo_procedures
1069: WHERE

Line 1092: SELECT ahl_mel_cdl_mo_procedures_s.NEXTVAL INTO p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id FROM DUAL;

1088: -- Default attributes for create
1089: p_x_mo_procedures_tbl(l_rec_idx).object_version_number := 1;
1090: IF (p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id IS NULL)
1091: THEN
1092: SELECT ahl_mel_cdl_mo_procedures_s.NEXTVAL INTO p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id FROM DUAL;
1093: END IF;
1094:
1095:
1096: -- Insert record into backend

Line 1521: SELECT ahl_mel_cdl_relationships_s.NEXTVAL INTO p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id FROM DUAL;

1517: -- Default attributes for create
1518: p_x_ata_relations_tbl(l_rec_idx).object_version_number := 1;
1519: IF (p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id IS NULL)
1520: THEN
1521: SELECT ahl_mel_cdl_relationships_s.NEXTVAL INTO p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id FROM DUAL;
1522: END IF;
1523:
1524: -- Insert record into backend
1525: INSERT INTO ahl_mel_cdl_relationships