APPS.AHL_MEL_CDL_HEADERS_PVT dependencies on AHL_MEL_CDL_ATA_SEQUENCES

Line 683: FROM ahl_mel_cdl_ata_sequences ata, jtf_notes_b note

679:
680: CURSOR get_all_ata_notes
681: IS
682: SELECT note.jtf_note_id
683: FROM ahl_mel_cdl_ata_sequences ata, jtf_notes_b note
684: WHERE ata.mel_cdl_header_id = p_mel_cdl_header_id AND
685: ata.mel_cdl_ata_sequence_id = note.source_object_id AND
686: note.source_object_code = 'AHL_MEL_CDL';
687:

Line 795: FROM ahl_mel_cdl_ata_sequences

791: DELETE FROM ahl_mel_cdl_relationships
792: WHERE ata_sequence_id IN
793: (
794: SELECT mel_cdl_ata_sequence_id
795: FROM ahl_mel_cdl_ata_sequences
796: WHERE mel_cdl_header_id = p_mel_cdl_header_id
797: );
798:
799: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 815: FROM ahl_mel_cdl_ata_sequences

811: DELETE FROM ahl_mel_cdl_mo_procedures
812: WHERE ata_sequence_id IN
813: (
814: SELECT mel_cdl_ata_sequence_id
815: FROM ahl_mel_cdl_ata_sequences
816: WHERE mel_cdl_header_id = p_mel_cdl_header_id
817: );
818:
819: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 830: DELETE FROM ahl_mel_cdl_ata_sequences

826: );
827: END IF;
828:
829: -- 2. Delete all ATA sequences
830: DELETE FROM ahl_mel_cdl_ata_sequences
831: WHERE mel_cdl_header_id = p_mel_cdl_header_id;
832:
833: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
834: THEN

Line 1018: FROM ahl_mel_cdl_ata_sequences

1014: attribute12,
1015: attribute13,
1016: attribute14,
1017: attribute15
1018: FROM ahl_mel_cdl_ata_sequences
1019: WHERE mel_cdl_header_id = p_mel_cdl_header_id;
1020:
1021: l_ata_rec_idx NUMBER := 0;
1022:

Line 1287: INSERT INTO ahl_mel_cdl_ata_sequences

1283: l_ata_rec_idx := l_ata_rec_idx + 1;
1284: l_old_new_ata_tbl(l_ata_rec_idx).old_object_id := l_ata_rec.mel_cdl_ata_sequence_id;
1285:
1286: -- Create new ATA sequence record into the database
1287: INSERT INTO ahl_mel_cdl_ata_sequences
1288: (
1289: MEL_CDL_ATA_SEQUENCE_ID,
1290: OBJECT_VERSION_NUMBER,
1291: LAST_UPDATE_DATE,

Line 1320: ahl_mel_cdl_ata_sequences_s.nextval,

1316: ATTRIBUTE15
1317: )
1318: VALUES
1319: (
1320: ahl_mel_cdl_ata_sequences_s.nextval,
1321: 1,
1322: sysdate,
1323: fnd_global.user_id,
1324: sysdate,