APPS.AHL_MEL_CDL_ATA_SEQS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 48

    SELECT 'X'
    FROM
        ahl_mel_cdl_ata_sequences
    WHERE
        mel_cdl_ata_sequence_id = ata_seq_id;

Line: 60

    SELECT
        hdr.status_code
    FROM
        ahl_mel_cdl_ata_sequences ata,
        ahl_mel_cdl_headers hdr
    WHERE
        mel_cdl_ata_sequence_id = ata_seq_id
        AND ata.mel_cdl_header_id = hdr. mel_cdl_header_id;

Line: 104

    SELECT  ata_code
    FROM    ahl_mel_cdl_ata_sequences
    WHERE   mel_cdl_ata_sequence_id = p_ata_sequence_id;

Line: 116

    SELECT  'x'
    FROM    ahl_mel_cdl_ata_sequences
    WHERE   mel_cdl_header_id = p_mel_cdl_header_id AND
            ata_code = p_ata_code;

Line: 126

    SELECT  jtf_note_id, note_status
    FROM    jtf_notes_vl
    WHERE   source_object_id = p_ata_sequence_id AND
            source_object_code = 'AHL_MEL_CDL';

Line: 198

                    CAC_NOTES_PVT.delete_note
                    (
                        l_note_rec.jtf_note_id,
                        l_return_status,
                        l_msg_count,
                        l_msg_data
                    );

Line: 226

                DELETE FROM ahl_mel_cdl_relationships
                WHERE ata_sequence_id = p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id
                OR related_ata_sequence_id = p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id;

Line: 231

                DELETE FROM ahl_mel_cdl_mo_procedures
                WHERE ata_sequence_id = p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id;

Line: 235

                DELETE FROM ahl_mel_cdl_ata_sequences
                WHERE mel_cdl_ata_sequence_id = p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id;

Line: 244

                        'Deleted ATA sequence [ata_sequence_id='||p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id||'] and all its associations'
                    );

Line: 344

                UPDATE  ahl_mel_cdl_ata_sequences
                SET     OBJECT_VERSION_NUMBER   = p_x_ata_sequences_tbl(l_rec_idx).object_version_number,
                        LAST_UPDATE_DATE        = sysdate,
                        LAST_UPDATED_BY         = fnd_global.user_id,
                        LAST_UPDATE_LOGIN       = fnd_global.login_id,
                        REPAIR_CATEGORY_ID      = p_x_ata_sequences_tbl(l_rec_idx).repair_category_id,
                        INSTALLED_NUMBER        = p_x_ata_sequences_tbl(l_rec_idx).installed_number,
                        DISPATCH_NUMBER         = p_x_ata_sequences_tbl(l_rec_idx).dispatch_number,
                        ATTRIBUTE_CATEGORY      = p_x_ata_sequences_tbl(l_rec_idx).attribute_category,
                        ATTRIBUTE1              = p_x_ata_sequences_tbl(l_rec_idx).attribute1,
                        ATTRIBUTE2              = p_x_ata_sequences_tbl(l_rec_idx).attribute2,
                        ATTRIBUTE3              = p_x_ata_sequences_tbl(l_rec_idx).attribute3,
                        ATTRIBUTE4              = p_x_ata_sequences_tbl(l_rec_idx).attribute4,
                        ATTRIBUTE5              = p_x_ata_sequences_tbl(l_rec_idx).attribute5,
                        ATTRIBUTE6              = p_x_ata_sequences_tbl(l_rec_idx).attribute6,
                        ATTRIBUTE7              = p_x_ata_sequences_tbl(l_rec_idx).attribute7,
                        ATTRIBUTE8              = p_x_ata_sequences_tbl(l_rec_idx).attribute8,
                        ATTRIBUTE9              = p_x_ata_sequences_tbl(l_rec_idx).attribute9,
                        ATTRIBUTE10             = p_x_ata_sequences_tbl(l_rec_idx).attribute10,
                        ATTRIBUTE11             = p_x_ata_sequences_tbl(l_rec_idx).attribute11,
                        ATTRIBUTE12             = p_x_ata_sequences_tbl(l_rec_idx).attribute12,
                        ATTRIBUTE13             = p_x_ata_sequences_tbl(l_rec_idx).attribute13,
                        ATTRIBUTE14             = p_x_ata_sequences_tbl(l_rec_idx).attribute14,
                        ATTRIBUTE15             = p_x_ata_sequences_tbl(l_rec_idx).attribute15
                WHERE   MEL_CDL_ATA_SEQUENCE_ID = p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id;

Line: 376

                        'Updated ATA sequence [ata_sequence_id='||p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id||']'
                    );

Line: 390

                        JTF_NOTES_PUB.Update_Note
                        (
                            p_api_version               => 1.0,
                            p_init_msg_list             => FND_API.G_FALSE,
                            p_commit                    => FND_API.G_FALSE,
                            p_validation_level          => FND_API.G_VALID_LEVEL_FULL,
                            x_return_status             => l_return_status,
                            x_msg_count                 => l_msg_count,
                            x_msg_data                  => l_msg_data,
                            p_jtf_note_id               => l_note_rec.jtf_note_id,
                            p_entered_by                => fnd_global.user_id,
                            p_last_updated_by           => fnd_global.user_id,
                            p_last_update_date          => sysdate,
                            p_last_update_login         => fnd_global.login_id,
                            p_notes                     => substr(p_x_ata_sequences_tbl(l_rec_idx).remarks_note, 1, 2000),
                            p_notes_detail              => p_x_ata_sequences_tbl(l_rec_idx).remarks_note,
                            p_append_flag               => 'N',
                            p_note_status               => l_note_rec.note_status,
                            p_note_type                 => 'AHL_MEL_CDL',
                            p_jtf_note_contexts_tab     => l_note_contexts_tbl
                        );

Line: 435

                                'Updated Remarks Note [jtf_note_id='||l_note_rec.jtf_note_id||']'
                            );

Line: 461

                            p_last_updated_by           => fnd_global.user_id,
                            p_last_update_date          => sysdate,
                            p_created_by                => fnd_global.user_id,
                            p_creation_date             => sysdate,
                            p_last_update_login         => fnd_global.login_id,
                            p_attribute1                => null,
                            p_attribute2                => null,
                            p_attribute3                => null,
                            p_attribute4                => null,
                            p_attribute5                => null,
                            p_attribute6                => null,
                            p_attribute7                => null,
                            p_attribute8                => null,
                            p_attribute9                => null,
                            p_attribute10               => null,
                            p_attribute11               => null,
                            p_attribute12               => null,
                            p_attribute13               => null,
                            p_attribute14               => null,
                            p_attribute15               => null,
                            p_context                   => null,
                            p_note_type                 => 'AHL_MEL_CDL',
                            p_jtf_note_contexts_tab     => l_note_contexts_tbl
                        );

Line: 605

                    SELECT ahl_mel_cdl_ata_sequences_s.NEXTVAL INTO p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id FROM DUAL;

Line: 609

                INSERT INTO ahl_mel_cdl_ata_sequences
                (
                    MEL_CDL_ATA_SEQUENCE_ID,
                    OBJECT_VERSION_NUMBER,
                    LAST_UPDATE_DATE,
                    LAST_UPDATED_BY,
                    CREATION_DATE,
                    CREATED_BY,
                    LAST_UPDATE_LOGIN,
                    MEL_CDL_HEADER_ID,
                    REPAIR_CATEGORY_ID,
                    ATA_CODE,
                    INSTALLED_NUMBER,
                    DISPATCH_NUMBER,
                    ATTRIBUTE_CATEGORY,
                    ATTRIBUTE1,
                    ATTRIBUTE2,
                    ATTRIBUTE3,
                    ATTRIBUTE4,
                    ATTRIBUTE5,
                    ATTRIBUTE6,
                    ATTRIBUTE7,
                    ATTRIBUTE8,
                    ATTRIBUTE9,
                    ATTRIBUTE10,
                    ATTRIBUTE11,
                    ATTRIBUTE12,
                    ATTRIBUTE13,
                    ATTRIBUTE14,
                    ATTRIBUTE15
                )
                VALUES
                (
                    p_x_ata_sequences_tbl(l_rec_idx).MEL_CDL_ATA_SEQUENCE_ID,
                    p_x_ata_sequences_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
                    sysdate,
                    fnd_global.user_id,
                    sysdate,
                    fnd_global.user_id,
                    fnd_global.login_id,
                    p_x_ata_sequences_tbl(l_rec_idx).MEL_CDL_HEADER_ID,
                    p_x_ata_sequences_tbl(l_rec_idx).REPAIR_CATEGORY_ID,
                    p_x_ata_sequences_tbl(l_rec_idx).ATA_CODE,
                    p_x_ata_sequences_tbl(l_rec_idx).INSTALLED_NUMBER,
                    p_x_ata_sequences_tbl(l_rec_idx).DISPATCH_NUMBER,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE_CATEGORY,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE1,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE2,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE3,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE4,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE5,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE6,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE7,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE8,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE9,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE10,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE11,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE12,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE13,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE14,
                    p_x_ata_sequences_tbl(l_rec_idx).ATTRIBUTE15
                )
                RETURNING MEL_CDL_ATA_SEQUENCE_ID INTO p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id;

Line: 707

                        p_last_updated_by           => fnd_global.user_id,
                        p_last_update_date          => sysdate,
                        p_created_by                => fnd_global.user_id,
                        p_creation_date             => sysdate,
                        p_last_update_login         => fnd_global.login_id,
                        p_attribute1                => null,
                        p_attribute2                => null,
                        p_attribute3                => null,
                        p_attribute4                => null,
                        p_attribute5                => null,
                        p_attribute6                => null,
                        p_attribute7                => null,
                        p_attribute8                => null,
                        p_attribute9                => null,
                        p_attribute10               => null,
                        p_attribute11               => null,
                        p_attribute12               => null,
                        p_attribute13               => null,
                        p_attribute14               => null,
                        p_attribute15               => null,
                        p_context                   => null,
                        p_note_type                 => 'AHL_MEL_CDL',
                        p_jtf_note_contexts_tab     => l_note_contexts_tbl
                    );

Line: 865

        SELECT 'x'
        FROM
            ahl_mr_headers_b
        WHERE
            mr_header_id  = mr_header_id
            and upper(program_type_code) = upper('MO_PROC');

Line: 881

        SELECT mr_status_code
        FROM
            ahl_mr_headers_b
        WHERE
            mr_header_id  = mr_header_id
            --and upper(program_type_code) = upper('MO_PROC')
            and upper(mr_status_code) = upper('COMPLETE')
			and TRUNC(SYSDATE) between TRUNC(NVL(EFFECTIVE_FROM, SYSDATE)) and TRUNC(NVL(EFFECTIVE_TO, SYSDATE));

Line: 898

        SELECT mr_header_id
        FROM
            ahl_mr_headers_b
        WHERE
            upper(TITLE) = upper(mr_title)
            and version_number = mr_version
            and TRUNC(SYSDATE) between TRUNC(NVL(EFFECTIVE_FROM, SYSDATE)) and TRUNC(NVL(EFFECTIVE_TO, SYSDATE));

Line: 971

                DELETE FROM ahl_mel_cdl_mo_procedures
                WHERE mel_cdl_mo_procedure_id = p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id;

Line: 1059

                    SELECT 'X'  INTO l_dummy_varchar FROM DUAL WHERE NOT EXISTS
                    (SELECT 'x'
                    FROM
                        ahl_mel_cdl_mo_procedures
                    WHERE
                        ata_sequence_id = p_x_mo_procedures_tbl(l_rec_idx).ata_sequence_id
                        AND mr_header_id = p_x_mo_procedures_tbl(l_rec_idx).mr_header_id);

Line: 1086

                    SELECT ahl_mel_cdl_mo_procedures_s.NEXTVAL INTO p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id FROM DUAL;

Line: 1091

                INSERT INTO ahl_mel_cdl_mo_procedures
                (
                    MEL_CDL_MO_PROCEDURE_ID,
                    OBJECT_VERSION_NUMBER,
                    LAST_UPDATE_DATE,
                    LAST_UPDATED_BY,
                    CREATION_DATE,
                    CREATED_BY,
                    LAST_UPDATE_LOGIN,
                    ATA_SEQUENCE_ID,
                    MR_HEADER_ID,
                    ATTRIBUTE_CATEGORY,
                    ATTRIBUTE1,
                    ATTRIBUTE2,
                    ATTRIBUTE3,
                    ATTRIBUTE4,
                    ATTRIBUTE5,
                    ATTRIBUTE6,
                    ATTRIBUTE7,
                    ATTRIBUTE8,
                    ATTRIBUTE9,
                    ATTRIBUTE10,
                    ATTRIBUTE11,
                    ATTRIBUTE12,
                    ATTRIBUTE13,
                    ATTRIBUTE14,
                    ATTRIBUTE15
                )
                VALUES
                (
                    p_x_mo_procedures_tbl(l_rec_idx).MEL_CDL_MO_PROCEDURE_ID,
                    p_x_mo_procedures_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
                    sysdate,
                    fnd_global.user_id,
                    sysdate,
                    fnd_global.user_id,
                    fnd_global.login_id,
                    p_x_mo_procedures_tbl(l_rec_idx).ATA_SEQUENCE_ID,
                    p_x_mo_procedures_tbl(l_rec_idx).MR_HEADER_ID,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE_CATEGORY,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE1,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE2,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE3,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE4,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE5,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE6,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE7,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE8,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE9,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE10,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE11,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE12,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE13,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE14,
                    p_x_mo_procedures_tbl(l_rec_idx).ATTRIBUTE15
                )
                RETURNING MEL_CDL_MO_PROCEDURE_ID INTO p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id;

Line: 1264

        SELECT 'x'
        FROM
            ahl_mel_cdl_relationships
        WHERE
            (ata_sequence_id = p_ata_seq_id
            AND related_ata_sequence_id = p_rel_ata_seq_id) OR
            (ata_sequence_id = p_rel_ata_seq_id
            AND related_ata_sequence_id = p_ata_seq_id);

Line: 1281

        SELECT  'x'
        FROM
            ahl_mel_cdl_ata_sequences_v a,
            ahl_mel_cdl_ata_sequences_v b
        WHERE
            a.mel_cdl_ata_sequence_id= p_ata_seq_id
            AND b.mel_cdl_ata_sequence_id = p_rel_ata_seq_id
            AND a.mel_cdl_header_id = b.mel_cdl_header_id;

Line: 1362

                DELETE FROM ahl_mel_cdl_relationships
                WHERE mel_cdl_relationship_id = p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id;

Line: 1371

                    'Deleted Relationship'|| p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id
                    );

Line: 1451

                SELECT ata_meaning  INTO l_ata_mng
                FROM
                    ahl_mel_cdl_ata_sequences_v
                WHERE
                    mel_cdl_ata_sequence_id = p_x_ata_relations_tbl(l_rec_idx).ata_sequence_id;

Line: 1458

                SELECT ata_meaning  INTO l_reln_ata_mng
                FROM
                    ahl_mel_cdl_ata_sequences_v
                WHERE
                    mel_cdl_ata_sequence_id = p_x_ata_relations_tbl(l_rec_idx).related_ata_sequence_id;

Line: 1515

                    SELECT ahl_mel_cdl_relationships_s.NEXTVAL INTO p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id FROM DUAL;

Line: 1519

                INSERT INTO ahl_mel_cdl_relationships
                (
                    MEL_CDL_RELATIONSHIP_ID,
                    OBJECT_VERSION_NUMBER,
                    LAST_UPDATE_DATE,
                    LAST_UPDATED_BY,
                    CREATION_DATE,
                    CREATED_BY,
                    LAST_UPDATE_LOGIN,
                    ATA_SEQUENCE_ID,
                    RELATED_ATA_SEQUENCE_ID,
                    ATTRIBUTE_CATEGORY,
                    ATTRIBUTE1,
                    ATTRIBUTE2,
                    ATTRIBUTE3,
                    ATTRIBUTE4,
                    ATTRIBUTE5,
                    ATTRIBUTE6,
                    ATTRIBUTE7,
                    ATTRIBUTE8,
                    ATTRIBUTE9,
                    ATTRIBUTE10,
                    ATTRIBUTE11,
                    ATTRIBUTE12,
                    ATTRIBUTE13,
                    ATTRIBUTE14,
                    ATTRIBUTE15
                )
                VALUES
                (
                    p_x_ata_relations_tbl(l_rec_idx).MEL_CDL_RELATIONSHIP_ID,
                    p_x_ata_relations_tbl(l_rec_idx).OBJECT_VERSION_NUMBER,
                    sysdate,
                    fnd_global.user_id,
                    sysdate,
                    fnd_global.user_id,
                    fnd_global.login_id,
                    p_x_ata_relations_tbl(l_rec_idx).ATA_SEQUENCE_ID,
                    p_x_ata_relations_tbl(l_rec_idx).RELATED_ATA_SEQUENCE_ID,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE_CATEGORY,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE1,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE2,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE3,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE4,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE5,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE6,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE7,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE8,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE9,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE10,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE11,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE12,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE13,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE14,
                    p_x_ata_relations_tbl(l_rec_idx).ATTRIBUTE15
                )
                RETURNING MEL_CDL_RELATIONSHIP_ID INTO p_x_ata_relations_tbl(l_rec_idx).mel_cdl_relationship_id;

Line: 1696

        SELECT  ata_sequence_id
        FROM    ahl_mel_cdl_mo_procedures
        WHERE   mr_header_id = p_mr_header_id;

Line: 1744

            INSERT INTO ahl_mel_cdl_mo_procedures
            (
                MEL_CDL_MO_PROCEDURE_ID,
                OBJECT_VERSION_NUMBER,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY,
                CREATION_DATE,
                CREATED_BY,
                LAST_UPDATE_LOGIN,
                ATA_SEQUENCE_ID,
                MR_HEADER_ID,
                ATTRIBUTE_CATEGORY,
                ATTRIBUTE1,
                ATTRIBUTE2,
                ATTRIBUTE3,
                ATTRIBUTE4,
                ATTRIBUTE5,
                ATTRIBUTE6,
                ATTRIBUTE7,
                ATTRIBUTE8,
                ATTRIBUTE9,
                ATTRIBUTE10,
                ATTRIBUTE11,
                ATTRIBUTE12,
                ATTRIBUTE13,
                ATTRIBUTE14,
                ATTRIBUTE15
            )
            VALUES
            (
                ahl_mel_cdl_mo_procedures_s.nextval,
                1,
                sysdate,
                fnd_global.user_id,
                sysdate,
                fnd_global.user_id,
                fnd_global.login_id,
                l_ata_seq_id,
                p_new_mr_header_id,
                null,
                null,
                null,
                null,
                null,
                null,
                null,
                null,
                null,
                null,
                null,
                null,
                null,
                null,
                null,
                null
            );

Line: 1889

    SELECT  object_version_number
    FROM    ahl_mel_cdl_ata_sequences
    WHERE   mel_cdl_ata_sequence_id = p_ata_sequence_id;

Line: 1932

    SELECT  'x'
    FROM    ahl_repair_categories
    WHERE   repair_category_id = p_repcat_id;

Line: 1941

    SELECT  repcat.repair_category_id
    FROM    cs_incident_urgencies_vl urg, ahl_repair_categories repcat
    WHERE   upper(urg.name) = upper(p_repcat_name) AND
            urg.incident_urgency_id = repcat.sr_urgency_id;

Line: 2009

    SELECT  hdr.status_code, hdr.mel_cdl_header_id
    FROM    ahl_mel_cdl_headers hdr, ahl_mel_cdl_ata_sequences ata
    WHERE   hdr.mel_cdl_header_id = ata.mel_cdl_header_id AND
            ata.mel_cdl_ata_sequence_id = p_ata_sequence_id;

Line: 2016

    SELECT  status_code, mel_cdl_header_id
    FROM    ahl_mel_cdl_headers
    WHERE   mel_cdl_header_id = p_mel_cdl_header_id;

Line: 2049

        UPDATE  ahl_mel_cdl_headers
        SET     status_code = 'DRAFT'
        WHERE   mel_cdl_header_id = l_mel_cdl_header_id;

Line: 2069

    SELECT  object_version_number
    FROM    ahl_mel_cdl_mo_procedures
    WHERE   mel_cdl_mo_procedure_id = p_mo_procedure_id;

Line: 2112

        SELECT  object_version_number
        FROM ahl_mel_cdl_relationships
        WHERE mel_cdl_relationship_id = p_mel_cdl_relationship_id;