DBA Data[Home] [Help]

APPS.QA_SS_PARENT_CHILD_PKG SQL Statements

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

Line: 38

      l_select_clause   VARCHAR2(10) := 'SELECT 1';
Line: 112

      l_query_clause := l_select_clause || l_from_clause || l_where_clause;
Line: 242

  PROCEDURE insert_plan_rel_chk(
                           p_parent_plan_id       IN NUMBER,
                           p_parent_plan_name     IN VARCHAR2,
                           p_child_plan_id        IN NUMBER,
                           p_child_plan_name      IN VARCHAR2,
                           p_data_entry_mode      IN NUMBER,
                           p_layout_mode          IN NUMBER,
                           p_num_auto_rows        IN NUMBER,
                           x_parent_plan_id       OUT NOCOPY NUMBER,
                           x_child_plan_id        OUT NOCOPY NUMBER,
                           x_status               OUT NOCOPY VARCHAR2)
  IS

  ret_status       VARCHAR2(1) := 'T';
Line: 268

     SELECT 1
     FROM   qa_pc_plan_relationship
     WHERE  parent_plan_id = c_parent_plan_id
     AND    child_plan_id = c_child_plan_id;
Line: 278

     l_error_array.delete;
Line: 282

        select qa_plans_api.plan_id(p_parent_plan_name) into result_num from dual;
Line: 293

        select qa_plans_api.plan_id(p_child_plan_name) into result_num from dual;
Line: 347

  END insert_plan_rel_chk;
Line: 349

  PROCEDURE update_plan_rel_chk(
                           p_parent_plan_id       IN NUMBER,
                           p_parent_plan_name     IN VARCHAR2,
                           p_child_plan_id        IN NUMBER,
                           p_child_plan_name      IN VARCHAR2,
                           p_data_entry_mode      IN NUMBER,
                           p_layout_mode          IN NUMBER,
                           p_num_auto_rows        IN NUMBER,
                           p_new_plan             IN VARCHAR2,
                           x_parent_plan_id       OUT NOCOPY NUMBER,
                           x_child_plan_id        OUT NOCOPY NUMBER,
                           x_status               OUT NOCOPY VARCHAR2)
  IS

  ret_status       VARCHAR2(1) := 'T';
Line: 377

     SELECT 1
     FROM   qa_pc_plan_relationship
     WHERE  parent_plan_id = c_parent_plan_id
     AND    child_plan_id = c_child_plan_id;
Line: 387

     l_error_array.delete;
Line: 391

        select qa_plans_api.plan_id(p_parent_plan_name) into result_num from dual;
Line: 402

        select qa_plans_api.plan_id(p_child_plan_name) into result_num from dual;
Line: 455

  END update_plan_rel_chk;
Line: 458

  PROCEDURE insert_plan_rel(p_parent_plan_id      NUMBER,
                            p_child_plan_id       NUMBER,
                            p_plan_relationship_type NUMBER,
                            p_data_entry_mode     NUMBER,
                            p_layout_mode         NUMBER,
                            p_auto_row_count      NUMBER,
                            p_default_parent_spec VARCHAR2,
                            p_last_updated_by     NUMBER := fnd_global.user_id,
                            p_created_by          NUMBER := fnd_global.user_id,
                            p_last_update_login   NUMBER := fnd_global.user_id,
                            x_plan_relationship_id IN OUT NOCOPY NUMBER)
      IS

  l_sysdate DATE;
Line: 477

      SELECT sysdate INTO l_sysdate
      FROM DUAL;
Line: 484

      QA_PC_PLAN_REL_PKG.Insert_Row(
                       X_Rowid => x_row_id,
                       X_Plan_Relationship_Id =>x_plan_relationship_id,
                       X_Parent_Plan_Id => p_parent_plan_id,
                       X_Child_Plan_id => p_child_plan_id,
                       X_Plan_Relationship_Type => p_plan_relationship_type,
                       X_Data_Entry_Mode => p_data_entry_mode,
                       X_Layout_Mode => p_layout_mode,
                       X_Auto_Row_Count => p_auto_row_count,
                       X_Default_Parent_Spec => l_default_parent_spec,
                       X_Last_Update_Date =>l_sysdate,
                       X_Last_Updated_By => p_last_updated_by,
                       X_Creation_Date  =>l_sysdate,
                       X_Created_By    => p_created_by,
                       X_Last_Update_Login => p_last_update_login);
Line: 525

  END insert_plan_rel;
Line: 528

  PROCEDURE insert_element_rel_chk(p_parent_char_id    NUMBER,
                                   p_child_char_id     NUMBER,
                                   p_relationship_type NUMBER,
                                   x_status            OUT NOCOPY VARCHAR2) IS

  l_error_array     ErrorTable;
Line: 541

    SELECT datatype
    FROM qa_chars
    WHERE char_id = c_char_id;
Line: 551

        l_error_array.delete;
Line: 613

  END insert_element_rel_chk;
Line: 615

  PROCEDURE insert_element_rel(
                p_plan_relationship_id        NUMBER,
                p_parent_char_id              NUMBER,
                p_child_char_id               NUMBER,
                p_element_relationship_type   NUMBER,
                p_link_flag                   VARCHAR2,
                p_last_updated_by             NUMBER  := fnd_global.user_id,
                p_created_by                  NUMBER  := fnd_global.user_id,
                p_last_update_login           NUMBER  := fnd_global.user_id,
                x_element_relationship_id OUT NOCOPY NUMBER) IS

  l_sysdate   DATE;
Line: 632

      SELECT sysdate INTO l_sysdate
      FROM DUAL;
Line: 641

      QA_PC_ELEMENT_REL_PKG.Insert_Row(
                       X_Rowid => l_row_id,
                       X_Element_Relationship_Id => x_element_relationship_id,
                       X_Plan_Relationship_Id =>p_plan_relationship_id,
                       X_Parent_Char_id => p_parent_char_id,
                       X_Child_Char_id  => p_child_char_id,
                       X_Element_Relationship_Type=>p_element_relationship_type,
                       X_Link_Flag=>l_link_flag,
                       X_Last_Update_Date=>l_sysdate,
                       X_Last_Updated_By => p_last_updated_by,
                       X_Creation_Date =>l_sysdate,
                       X_Created_By   => p_created_by,
                       X_Last_Update_Login => p_last_update_login);
Line: 655

  END insert_element_rel;
Line: 657

  PROCEDURE insert_criteria_rel(p_plan_relationship_id       NUMBER,
                p_char_id           NUMBER,
                p_operator          NUMBER,
                p_low_value         VARCHAR2,
--                p_low_value_id      NUMBER,
                p_high_value        VARCHAR2,
--                p_high_value_id     NUMBER,
                p_last_updated_by   NUMBER  := fnd_global.user_id,
                p_created_by        NUMBER  := fnd_global.user_id,
                p_last_update_login NUMBER  := fnd_global.user_id,
                x_criteria_id       OUT NOCOPY NUMBER) IS

  l_sysdate   DATE;
Line: 674

      SELECT sysdate INTO l_sysdate
      FROM DUAL;
Line: 677

      QA_PC_CRITERIA_PKG.Insert_Row(
                       X_Rowid => l_row_id,
                       X_Criteria_Id => x_criteria_id,
                       X_Plan_Relationship_Id =>p_plan_relationship_id,
                       X_Char_id => p_char_id,
                       X_Operator => p_operator,
                       X_Low_Value => p_low_value,
                       X_Low_Value_Id => null,
                       X_High_Value => p_high_value,
                       X_High_Value_Id => null,
                       X_Last_Update_Date=>l_sysdate,
                       X_Last_Updated_By => p_last_updated_by,
                       X_Creation_Date =>l_sysdate,
                       X_Created_By   => p_created_by,
                       X_Last_Update_Login => p_last_update_login);
Line: 693

  END insert_criteria_rel;
Line: 696

  PROCEDURE update_plan_rel(
                            -- p_rowid                  VARCHAR2,
                            p_plan_relationship_id   NUMBER,
                            p_parent_plan_id         NUMBER,
                            p_child_plan_id          NUMBER,
                            p_plan_relationship_type NUMBER,
                            p_data_entry_mode        NUMBER,
                            p_layout_mode            NUMBER,
                            p_auto_row_count         NUMBER,
                            p_default_parent_spec    VARCHAR2,
                            p_last_updated_by        NUMBER:=fnd_global.user_id,
                            p_created_by             NUMBER:=fnd_global.user_id,
                            p_last_update_login      NUMBER:=fnd_global.user_id
                           ) IS
  l_sysdate   DATE;
Line: 716

  select rowid
  from   qa_pc_plan_relationship
  where  plan_relationship_id = p_plan_relationship_id;
Line: 722

      SELECT sysdate INTO l_sysdate
      FROM DUAL;
Line: 733

      QA_PC_PLAN_REL_PKG.Update_Row(
                       X_Rowid                  => l_rowid,
                       X_Plan_Relationship_Id   => p_plan_relationship_id,
                       X_Parent_Plan_Id         => p_parent_plan_id,
                       X_Child_Plan_id          => p_child_plan_id,
                       X_Plan_Relationship_Type => p_plan_relationship_type,
                       X_Data_Entry_Mode        => p_data_entry_mode,
                       X_Layout_Mode            => p_layout_mode,
                       X_Auto_Row_Count         => p_auto_row_count,
                       X_Default_Parent_Spec    => l_default_parent_spec,
                       X_Last_Update_Date       => l_sysdate,
                       X_Last_Updated_By        => p_last_updated_by,
                       X_Creation_Date          => l_sysdate,
                       X_Created_By             => p_created_by,
                       X_Last_Update_Login      => p_last_update_login );
Line: 750

  END update_plan_rel;
Line: 752

  PROCEDURE update_element_rel(
                p_element_relationship_id     NUMBER,
                p_plan_relationship_id        NUMBER,
                p_parent_char_id              NUMBER,
                p_child_char_id               NUMBER,
                p_element_relationship_type   NUMBER,
                p_link_flag                   VARCHAR2,
                p_last_updated_by             NUMBER  := fnd_global.user_id,
                p_created_by                  NUMBER  := fnd_global.user_id,
                p_last_update_login           NUMBER  := fnd_global.user_id,
                p_row_id                      VARCHAR2) IS

  l_sysdate   DATE;
Line: 770

      SELECT sysdate INTO l_sysdate
      FROM DUAL;
Line: 779

      QA_PC_ELEMENT_REL_PKG.Update_Row(
                       X_Rowid => p_row_id,
                       X_Element_Relationship_Id => p_element_relationship_id,
                       X_Plan_Relationship_Id =>p_plan_relationship_id,
                       X_Parent_Char_id => p_parent_char_id,
                       X_Child_Char_id  => p_child_char_id,
                       X_Element_Relationship_Type=>p_element_relationship_type,
                       X_Link_Flag=>l_link_flag,
                       X_Last_Update_Date=>l_sysdate,
                       X_Last_Updated_By => p_last_updated_by,
                       X_Creation_Date =>l_sysdate,
                       X_Created_By   => p_created_by,
                       X_Last_Update_Login => p_last_update_login);
Line: 793

  END update_element_rel;
Line: 796

  PROCEDURE update_criteria_rel(
                p_rowid                VARCHAR2,
                p_plan_relationship_id NUMBER,
                p_char_id              NUMBER,
                p_operator             NUMBER,
                p_low_value            VARCHAR2,
                p_high_value           VARCHAR2,
                p_last_updated_by      NUMBER  := fnd_global.user_id,
                p_created_by           NUMBER  := fnd_global.user_id,
                p_last_update_login    NUMBER  := fnd_global.user_id,
                p_criteria_id          NUMBER) IS

  l_sysdate   DATE;
Line: 812

      SELECT sysdate INTO l_sysdate
      FROM DUAL;
Line: 815

      QA_PC_CRITERIA_PKG.Update_Row(
                       X_Rowid => p_rowid,
                       X_Criteria_Id => p_criteria_id,
                       X_Plan_Relationship_Id =>p_plan_relationship_id,
                       X_Char_id => p_char_id,
                       X_Operator => p_operator,
                       X_Low_Value => p_low_value,
                       X_Low_Value_Id => null,
                       X_High_Value => p_high_value,
                       X_High_Value_Id => null,
                       X_Last_Update_Date=>l_sysdate,
                       X_Last_Updated_By => p_last_updated_by,
                       X_Creation_Date =>l_sysdate,
                       X_Created_By   => p_created_by,
                       X_Last_Update_Login => p_last_update_login);
Line: 831

  END update_criteria_rel;
Line: 833

  PROCEDURE delete_element_rel(p_element_relationship_id NUMBER) IS

  BEGIN
      --QA_PC_CRITERIA_PKG.Delete_Row(X_Rowid => p_rowid);
Line: 837

    DELETE FROM QA_PC_ELEMENT_RELATIONSHIP
    WHERE element_relationship_id = p_element_relationship_id;
Line: 840

  END delete_element_rel;
Line: 843

  PROCEDURE delete_criteria(p_criteria_id NUMBER) IS

  BEGIN
      --QA_PC_CRITERIA_PKG.Delete_Row(X_Rowid => p_rowid);
Line: 847

    DELETE FROM QA_PC_CRITERIA
    WHERE criteria_id = p_criteria_id;
Line: 850

  END delete_criteria;
Line: 863

    SELECT 1
    FROM  qa_pc_plan_relationship
    WHERE parent_plan_id = c_child_plan_id;
Line: 938

        SelectFromClause VARCHAR2(20000);
Line: 945

        SelectFromClause :=
                qa_results_interface_pkg.get_plan_vqr_sql (p_plan_id);
Line: 962

        RETURN SelectFromClause || WhereClause;
Line: 974

        SelectFromClause VARCHAR2(20000);
Line: 978

        SelectFromClause :=
                qa_results_interface_pkg.get_plan_vqr_sql (p_child_plan_id);
Line: 983

                        || ' AND (COLLECTION_ID, OCCURRENCE) IN (SELECT CHILD_COLLECTION_ID, CHILD_OCCURRENCE FROM QA_PC_RESULTS_RELATIONSHIP WHERE PARENT_OCCURRENCE = ' || p_parent_occurrence || ' AND CHILD_PLAN_ID = ' || p_child_plan_id || ' ) ';
Line: 986

        RETURN SelectFromClause || WhereClause;
Line: 997

        SelectFromClause VARCHAR2(20000);
Line: 1001

        SelectFromClause :=
                qa_results_interface_pkg.get_plan_vqr_sql (p_parent_plan_id);
Line: 1010

        RETURN SelectFromClause || WhereClause;
Line: 1016

  PROCEDURE delete_plan_rel(p_plan_relationship_id NUMBER) IS

  BEGIN

    DELETE FROM QA_PC_PLAN_RELATIONSHIP
    WHERE plan_relationship_id = p_plan_relationship_id;
Line: 1023

    DELETE FROM QA_PC_ELEMENT_RELATIONSHIP
    WHERE plan_relationship_id = p_plan_relationship_id;
Line: 1026

    DELETE FROM QA_PC_CRITERIA
    WHERE plan_relationship_id = p_plan_relationship_id;
Line: 1029

  END delete_plan_rel;
Line: 1051

         select distinct qpr.parent_plan_id
         from qa_pc_plan_relationship qpr, qa_plans qp
         where qpr.parent_plan_id = qp.plan_id
         and qp.organization_id = p_org_id;