APPS.AHL_MEL_CDL_HEADERS_PVT dependencies on AHL_MEL_CDL_RELATIONSHIPS

Line 791: DELETE FROM ahl_mel_cdl_relationships

787: END IF;
788:
789: -- 1. For all associated ATA sequences
790: -- 1b. Delete all inter-relationships with other 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

Line 1119: FROM ahl_mel_cdl_relationships

1115: attribute12,
1116: attribute13,
1117: attribute14,
1118: attribute15
1119: FROM ahl_mel_cdl_relationships
1120: WHERE ata_sequence_id = p_ata_sequence_id;
1121:
1122: BEGIN
1123: -- Standard start of API savepoint

Line 1545: INSERT INTO ahl_mel_cdl_relationships

1541: IF (l_old_new_ata_tbl(l_rel_ata_seq).old_object_id = l_ata_rel_rec.related_ata_sequence_id)
1542: THEN
1543: l_rel_ata_seq_id := l_old_new_ata_tbl(l_rel_ata_seq).new_object_id;
1544:
1545: INSERT INTO ahl_mel_cdl_relationships
1546: (
1547: MEL_CDL_RELATIONSHIP_ID,
1548: OBJECT_VERSION_NUMBER,
1549: LAST_UPDATE_DATE,

Line 1575: ahl_mel_cdl_relationships_s.nextval,

1571: ATTRIBUTE15
1572: )
1573: VALUES
1574: (
1575: ahl_mel_cdl_relationships_s.nextval,
1576: 1,
1577: sysdate,
1578: fnd_global.user_id,
1579: sysdate,