APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on AHL_MEL_CDL_RELATIONSHIPS

Line 226: DELETE FROM ahl_mel_cdl_relationships

222: END LOOP;
223: */
224:
225: -- Delete inter-relationships with other ATA sequences
226: DELETE FROM ahl_mel_cdl_relationships
227: WHERE ata_sequence_id = p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id
228: OR related_ata_sequence_id = p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id;
229:
230: -- Delete Inter-relationships associated with the ATA sequence

Line 1266: ahl_mel_cdl_relationships

1262: )
1263: IS
1264: SELECT 'x'
1265: FROM
1266: ahl_mel_cdl_relationships
1267: WHERE
1268: (ata_sequence_id = p_ata_seq_id
1269: AND related_ata_sequence_id = p_rel_ata_seq_id) OR
1270: (ata_sequence_id = p_rel_ata_seq_id

Line 1362: DELETE FROM ahl_mel_cdl_relationships

1358: -- For U/D, verify mel_cdl_mo_procedures_id + ovn is correct
1359: Check_Inter_Reln_Exists(p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id, p_x_ata_relations_tbl(l_rec_idx).object_version_number);
1360:
1361: -- Delete MandO procedures from the MO Procedure Table
1362: DELETE FROM ahl_mel_cdl_relationships
1363: WHERE mel_cdl_relationship_id = p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id;
1364:
1365: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1366: THEN

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

Line 1519: INSERT INTO ahl_mel_cdl_relationships

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
1520: (
1521: MEL_CDL_RELATIONSHIP_ID,
1522: OBJECT_VERSION_NUMBER,
1523: LAST_UPDATE_DATE,

Line 2113: FROM ahl_mel_cdl_relationships

2109:
2110: CURSOR check_exists
2111: IS
2112: SELECT object_version_number
2113: FROM ahl_mel_cdl_relationships
2114: WHERE mel_cdl_relationship_id = p_mel_cdl_relationship_id;
2115:
2116: l_ovn NUMBER;
2117: