APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on DUAL

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

601: -- Default attributes for create
602: p_x_ata_sequences_tbl(l_rec_idx).object_version_number := 1;
603: IF (p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id IS NULL)
604: THEN
605: SELECT ahl_mel_cdl_ata_sequences_s.NEXTVAL INTO p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id FROM DUAL;
606: END IF;
607:
608: -- Insert record into backend
609: INSERT INTO ahl_mel_cdl_ata_sequences

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

1055: END IF;
1056:
1057: -- Check if the MO Procedure is already associated to the Ata Sequence
1058: BEGIN
1059: SELECT 'X' INTO l_dummy_varchar FROM DUAL WHERE NOT EXISTS
1060: (SELECT 'x'
1061: FROM
1062: ahl_mel_cdl_mo_procedures
1063: WHERE

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

1082: -- Default attributes for create
1083: p_x_mo_procedures_tbl(l_rec_idx).object_version_number := 1;
1084: IF (p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id IS NULL)
1085: THEN
1086: SELECT ahl_mel_cdl_mo_procedures_s.NEXTVAL INTO p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id FROM DUAL;
1087: END IF;
1088:
1089:
1090: -- Insert record into backend

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

1511: -- Default attributes for create
1512: p_x_ata_relations_tbl(l_rec_idx).object_version_number := 1;
1513: IF (p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id IS NULL)
1514: THEN
1515: SELECT ahl_mel_cdl_relationships_s.NEXTVAL INTO p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id FROM DUAL;
1516: END IF;
1517:
1518: -- Insert record into backend
1519: INSERT INTO ahl_mel_cdl_relationships