APPS.AHL_MEL_CDL_HEADERS_PVT dependencies on AHL_MEL_CDL_MO_PROCEDURES

Line 811: DELETE FROM ahl_mel_cdl_mo_procedures

807: END IF;
808:
809: -- 1. For all associated ATA sequences
810: -- 1c. Delete all MO procedures associated
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

Line 1090: FROM ahl_mel_cdl_mo_procedures mo, ahl_mr_headers_app_v mrh

1086: mo.attribute12,
1087: mo.attribute13,
1088: mo.attribute14,
1089: mo.attribute15
1090: FROM ahl_mel_cdl_mo_procedures mo, ahl_mr_headers_app_v mrh
1091: WHERE mo.mr_header_id = mrh.mr_header_id and
1092: mrh.mr_status_code = 'COMPLETE' and
1093: trunc(sysdate) between trunc(mrh.effective_from) and trunc(nvl(effective_to, sysdate + 1)) and
1094: mo.ata_sequence_id = p_ata_sequence_id;

Line 1451: INSERT INTO ahl_mel_cdl_mo_procedures

1447:
1448: -- Create revisions of all MO procedure associations to ATA sequences
1449: FOR l_mo_proc_rec IN get_mo_proc_details(l_old_new_ata_tbl(l_ata_rec_idx).old_object_id)
1450: LOOP
1451: INSERT INTO ahl_mel_cdl_mo_procedures
1452: (
1453: MEL_CDL_MO_PROCEDURE_ID,
1454: OBJECT_VERSION_NUMBER,
1455: LAST_UPDATE_DATE,

Line 1481: ahl_mel_cdl_mo_procedures_s.nextval,

1477: ATTRIBUTE15
1478: )
1479: VALUES
1480: (
1481: ahl_mel_cdl_mo_procedures_s.nextval,
1482: 1,
1483: sysdate,
1484: fnd_global.user_id,
1485: sysdate,