APPS.AMW_ASSESSMENTS_PVT SQL Statements

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

Line: 25

PROCEDURE Delete_Procedure_Related(
    p_assess_procedure_id        IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2   := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2   := FND_API.G_FALSE,
    p_validate_only              IN   VARCHAR2   := FND_API.G_FALSE,
    x_return_status              OUT  NOCOPY VARCHAR2,
    x_msg_count                  OUT  NOCOPY NUMBER,
    x_msg_data                   OUT  NOCOPY VARCHAR2
) IS

L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Procedure_Related';

Line: 41

    SAVEPOINT Delete_Procedure_Related;

Line: 47

    delete from AMW_ASSESS_PROCEDURE_STEPS_TL
    where ASSESS_PROCEDURE_STEP_ID IN (
        select ASSESS_PROCEDURE_STEP_ID
        from AMW_ASSESS_PROCEDURE_STEPS_B
        where ASSESS_PROCEDURE_ID = p_assess_procedure_id
    );

Line: 54

    delete from AMW_ASSESS_PROCEDURE_STEPS_B
    where ASSESS_PROCEDURE_ID = p_assess_procedure_id;

Line: 57

    delete from AMW_ASSESS_PROCEDURES_TL
    where ASSESS_PROCEDURE_ID = p_assess_procedure_id;

Line: 60

    delete from AMW_ASSESS_PROCEDURES_B
    where ASSESS_PROCEDURE_ID = p_assess_procedure_id;

Line: 68

              ROLLBACK TO Delete_Procedure_Related;

Line: 76

              ROLLBACK TO Delete_Procedure_Related;

Line: 81

                               p_procedure_name =>    'Delete_Procedure_Related',
                               p_error_text     =>     SUBSTRB(SQLERRM,1,240));

Line: 87

END Delete_Procedure_Related;

Line: 99

PROCEDURE Delete_Assessment_Related(
    p_assessment_id              IN  NUMBER,
    p_init_msg_list              IN  VARCHAR2   := FND_API.G_FALSE,
    p_commit                     IN  VARCHAR2   := FND_API.G_FALSE,
    p_validate_only              IN  VARCHAR2   := FND_API.G_FALSE,
    x_return_status              OUT  NOCOPY VARCHAR2,
    x_msg_count                  OUT  NOCOPY NUMBER,
    x_msg_data                   OUT  NOCOPY VARCHAR2
) IS

L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Procedure_Related';

Line: 115

    SAVEPOINT Delete_Procedure_Related;

Line: 122

    DELETE FROM AMW_ASSESS_PROCEDURE_ASSOCS WHERE OBJECT_TYPE='ASSESSMENT' AND PK1=p_assessment_id;

Line: 125

    DELETE FROM AMW_ASSESSMENT_CONTEXTS WHERE ASSESSMENT_ID = p_assessment_id;

Line: 128

    DELETE FROM AMW_SURVEY_ASSOCS WHERE OBJECT_TYPE='ASSESSMENT' AND OBJECT_ID=p_assessment_id;

Line: 131

    DELETE FROM AMW_ASSESSMENT_COMPONENTS WHERE OBJECT_TYPE='ASSESSMENT' AND OBJECT_ID=p_assessment_id;

Line: 134

    FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments('AMW_ASSESSMENT',
                                                   p_assessment_id,
                                                   null,
                                                   null,
                                                   null,
                                                   null,
                                                   'N',
                                                   null);

Line: 147

              ROLLBACK TO Delete_Assessment_Related;

Line: 155

              ROLLBACK TO Delete_Assessment_Related;

Line: 160

                               p_procedure_name =>    'Delete_Assessment_Related',
                               p_error_text     =>     SUBSTRB(SQLERRM,1,240));

Line: 166

END Delete_Assessment_Related;