APPS.AMW_DELETE_OBJECT_PVT SQL Statements

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

Line: 21

  G_VARCHAR_VARRAY('select risk_id from amw_risk_associations where risk_id = :1','Y')
 ,G_VARCHAR_VARRAY('select object_type from amw_control_associations where ( object_type = ''RISK'' and pk2 =:1 ) or (object_type = ''RISK_ORG'' and pk3 =:1) ','Y')
);

Line: 28

  G_VARCHAR_VARRAY('select control_id from amw_control_associations where control_id = :1','Y')
 ,G_VARCHAR_VARRAY('select object_type from amw_ap_associations where ( object_type = ''CTRL'' and pk1 =:1 ) or (object_type = ''CTRL_ORG'' and pk3 =:1) ','Y')
);

Line: 35

  G_VARCHAR_VARRAY(  'SELECT control_id '
                   ||' FROM amw_control_associations WHERE control_id IN ( '
                   ||'      SELECT pk1 '
                   ||'      FROM amw_ap_associations '
                   ||'      WHERE audit_procedure_id = :1 '
                   ||'      AND object_type = ''CTRL'' '
                   ||'      UNION '
                   ||'      SELECT pk2 '
                   ||'      FROM amw_ap_associations '
                   ||'      WHERE object_type =''ENTITY_AP'' '
                   ||'      AND  audit_procedure_id = :1 '
                   ||'      AND deletion_date IS NULL '
                   ||'      UNION '
                   ||'      SELECT pk3 '
                   ||'      FROM amw_ap_associations '
                   ||'      WHERE object_type =''PROJECT'' '
                   ||'      AND  audit_procedure_id = :1 '
                   ||'      AND deletion_date IS NULL '
                   ||'      UNION '
                   ||'      SELECT pk3 '
                   ||'      FROM amw_ap_associations '
                   ||'      WHERE object_type in (''CTRL_ORG'',''CTRL_FINCERT'',''BUSIPROC_CERTIFICATION'') '
                   ||'      AND  audit_procedure_id = :1 ) ','Y')
);

Line: 77

PROCEDURE Delete_Objects(
    errbuf                       OUT  NOCOPY VARCHAR2,
    retcode                      OUT  NOCOPY VARCHAR2,
    p_object_type_and_id1         IN   VARCHAR2 := NULL,
    p_object_type_and_id2         IN   VARCHAR2 := NULL,
    p_object_type_and_id3         IN   VARCHAR2 := NULL,
    p_object_type_and_id4         IN   VARCHAR2 := NULL
)
IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Objects';

Line: 111

        Delete_Object(p_object_type => l_object_type1, p_object_id => l_object_id1);

Line: 119

        Delete_Object(p_object_type => l_object_type2, p_object_id => l_object_id2);

Line: 127

        Delete_Object(p_object_type => l_object_type3, p_object_id => l_object_id3);

Line: 135

        Delete_Object(p_object_type => l_object_type4, p_object_id => l_object_id4);

Line: 139

End Delete_Objects;

Line: 152

PROCEDURE Delete_Object(
    p_object_type                IN   VARCHAR2,
    p_object_id                  IN   NUMBER
)
IS
  l_Is_Object_In_Use VARCHAR2(1);

Line: 168

        Delete_Risk(p_risk_id => p_object_id);

Line: 170

        FND_FILE.put_line(fnd_file.log, 'Cannot Delete Risk : risk_id = '||p_object_id);

Line: 178

        Delete_Ctrl(p_ctrl_id => p_object_id);

Line: 180

        FND_FILE.put_line(fnd_file.log, 'Cannot Delete Control : control_id = '||p_object_id);

Line: 188

        Delete_Ap(p_ap_id => p_object_id);

Line: 190

        FND_FILE.put_line(fnd_file.log, 'Cannot Delete Audit Procedure : audit_procedure_id = '||p_object_id);

Line: 196

END Delete_Object;

Line: 208

PROCEDURE Delete_Risk(
    p_risk_id                  IN   NUMBER
)
IS
-- find the list of risk_rev_id by specified risk_id
l_risk_rev_id_list G_NUMBER_TABLE;

Line: 217

    SELECT risk_rev_id
    BULK COLLECT INTO l_risk_rev_id_list
    FROM AMW_RISKS_B
    WHERE risk_id = p_risk_id;

Line: 224

      DELETE FROM AMW_RISK_TYPE WHERE risk_rev_id = l_risk_rev_id_list(i);

Line: 227

    DELETE FROM AMW_RISK_EXT_B WHERE risk_id = p_risk_id;

Line: 228

    DELETE FROM AMW_RISK_EXT_TL WHERE risk_id = p_risk_id;

Line: 231

    FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments('AMW_RISKS',
                                                   p_risk_id,
                                                   null,
                                                   null,
                                                   null,
                                                   null,
                                                   'N',
                                                   null);

Line: 242

      DELETE FROM AMW_RISKS_TL WHERE risk_rev_id = l_risk_rev_id_list(i);

Line: 244

    DELETE FROM AMW_RISKS_B WHERE risk_id = p_risk_id;

Line: 246

    FND_FILE.put_line(fnd_file.log, 'Delete Risk : risk_id = '||p_risk_id);

Line: 259

END Delete_Risk;

Line: 270

PROCEDURE Delete_Ctrl(
    p_ctrl_id                  IN   NUMBER
)
IS
-- find the list of control_rev_id by specified control_id
l_ctrl_rev_id_list G_NUMBER_TABLE;

Line: 279

    SELECT control_rev_id
    BULK COLLECT INTO l_ctrl_rev_id_list
    FROM AMW_CONTROLS_B
    WHERE control_id = p_ctrl_id;

Line: 286

      DELETE FROM AMW_CONTROL_OBJECTIVES WHERE control_rev_id = l_ctrl_rev_id_list(i);

Line: 290

      DELETE FROM AMW_CONTROL_ASSERTIONS WHERE control_rev_id = l_ctrl_rev_id_list(i);

Line: 294

      DELETE FROM AMW_CONTROL_PURPOSES WHERE control_rev_id = l_ctrl_rev_id_list(i);

Line: 298

      DELETE FROM AMW_ASSESSMENT_COMPONENTS WHERE OBJECT_TYPE='CONTROL' AND OBJECT_ID = l_ctrl_rev_id_list(i);

Line: 301

    DELETE FROM AMW_CTRL_EXT_B WHERE control_id = p_ctrl_id;

Line: 302

    DELETE FROM AMW_CTRL_EXT_TL WHERE control_id = p_ctrl_id;

Line: 305

    FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments('AMW_CONTROLS',
                                                   p_ctrl_id,
                                                   null,
                                                   null,
                                                   null,
                                                   null,
                                                   'N',
                                                   null);

Line: 315

      DELETE FROM AMW_CONTROLS_TL WHERE control_rev_id = l_ctrl_rev_id_list(i);

Line: 317

    DELETE FROM AMW_CONTROLS_B WHERE control_id = p_ctrl_id;

Line: 319

    FND_FILE.put_line(fnd_file.log, 'Delete Control : control_id = '||p_ctrl_id);

Line: 332

END Delete_Ctrl;

Line: 343

PROCEDURE Delete_Ap(
    p_ap_id                  IN   NUMBER
)
IS
-- find the list of audit_procedure_rev_id by specified audit_procedure_id
l_ap_rev_id_list G_NUMBER_TABLE;

Line: 352

    SELECT audit_procedure_rev_id
    BULK COLLECT INTO l_ap_rev_id_list
    FROM AMW_AUDIT_PROCEDURES_B
    WHERE audit_procedure_id = p_ap_id;

Line: 358

    DELETE FROM AMW_AP_STEPS_TL WHERE ap_step_id in (SELECT ap_step_id FROM amw_ap_steps_b WHERE audit_procedure_id = p_ap_id);

Line: 359

    DELETE FROM AMW_AP_STEPS_B WHERE audit_procedure_id = p_ap_id;

Line: 362

    DELETE FROM AMW_AP_TASKS WHERE audit_procedure_id = p_ap_id;

Line: 365

    DELETE FROM AMW_AP_EXT_B WHERE audit_procedure_id = p_ap_id;

Line: 366

    DELETE FROM AMW_AP_EXT_TL WHERE audit_procedure_id = p_ap_id;

Line: 369

    FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments('AMW_AUDIT_PRCD',
                                                   p_ap_id,
                                                   null,
                                                   null,
                                                   null,
                                                   null,
                                                   'N',
                                                   null);

Line: 380

      DELETE FROM AMW_AUDIT_PROCEDURES_TL WHERE audit_procedure_rev_id = l_ap_rev_id_list(i);

Line: 382

    DELETE FROM AMW_AUDIT_PROCEDURES_B WHERE audit_procedure_id = p_ap_id;

Line: 383

    DELETE FROM AMW_AP_ASSOCIATIONS WHERE audit_procedure_id = p_ap_id;

Line: 385

    FND_FILE.put_line(fnd_file.log, 'Delete Audit Procedure : audit_procedure_id = '||p_ap_id);

Line: 399

END Delete_Ap;