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 1272: ahl_mel_cdl_relationships

1268: )
1269: IS
1270: SELECT 'x'
1271: FROM
1272: ahl_mel_cdl_relationships
1273: WHERE
1274: (ata_sequence_id = p_ata_seq_id
1275: AND related_ata_sequence_id = p_rel_ata_seq_id) OR
1276: (ata_sequence_id = p_rel_ata_seq_id

Line 1368: DELETE FROM ahl_mel_cdl_relationships

1364: -- For U/D, verify mel_cdl_mo_procedures_id + ovn is correct
1365: 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);
1366:
1367: -- Delete MandO procedures from the MO Procedure Table
1368: DELETE FROM ahl_mel_cdl_relationships
1369: WHERE mel_cdl_relationship_id = p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id;
1370:
1371: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1372: THEN

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

Line 1525: INSERT INTO ahl_mel_cdl_relationships

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
1526: (
1527: MEL_CDL_RELATIONSHIP_ID,
1528: OBJECT_VERSION_NUMBER,
1529: LAST_UPDATE_DATE,

Line 2119: FROM ahl_mel_cdl_relationships

2115:
2116: CURSOR check_exists
2117: IS
2118: SELECT object_version_number
2119: FROM ahl_mel_cdl_relationships
2120: WHERE mel_cdl_relationship_id = p_mel_cdl_relationship_id;
2121:
2122: l_ovn NUMBER;
2123: