APPS.QA_PARENT_CHILD_COPY_PKG SQL Statements

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

Line: 18

        SELECT   qpr.plan_relationship_id, qpr.data_entry_mode, qpr.auto_row_count,
                 qpr.plan_relationship_type,
                 qpr.default_parent_spec, qpr.layout_mode
        FROM     qa_pc_plan_relationship qpr
        WHERE    qpr.parent_plan_id = parent_id
                 AND qpr.child_plan_id = child_id
        ORDER BY qpr.creation_date DESC;

Line: 45

      QA_SS_PARENT_CHILD_PKG.insert_plan_rel(
        p_parent_plan_id         => p_target_parent_plan_id,
        p_child_plan_id          => p_target_child_plan_id,
        p_plan_relationship_type => c1_rec.plan_relationship_type,
        p_data_entry_mode        => c1_rec.data_entry_mode,
        p_auto_row_count         => c1_rec.auto_row_count,
        p_default_parent_spec    => c1_rec.default_parent_spec,
        x_plan_relationship_id   => x_new_plan_relationship_id);

Line: 55

      QA_PC_PLAN_REL_PKG.Insert_Row(
                       X_Rowid                  => x_row_id,
                       X_Plan_Relationship_Id   => x_new_plan_relationship_id,
                       X_Parent_Plan_Id         => p_target_parent_plan_id,
                       X_Child_Plan_id          => p_target_child_plan_id,
                       X_Plan_Relationship_Type => c1_rec.plan_relationship_type,
                       X_Data_Entry_Mode        => c1_rec.data_entry_mode,
                       X_Layout_mode            => c1_rec.layout_mode,
                       X_Auto_Row_Count         => c1_rec.auto_row_count,
                       X_Default_Parent_Spec    => c1_rec.default_parent_spec,
                       X_Last_Update_Date       => SYSDATE,
                       X_Last_Updated_By        => fnd_global.user_id,
                       X_Creation_Date          => SYSDATE,
                       X_Created_By             => fnd_global.user_id,
                       X_Last_Update_Login      => fnd_global.user_id);

Line: 85

         SELECT parent_char_id, child_char_id, element_relationship_type,
                decode(link_flag,1,'Y','N') as vlink_flag
         FROM   qa_pc_element_relationship
         WHERE  plan_relationship_id = p_old_plan_relationship_id;

Line: 95

         QA_SS_PARENT_CHILD_PKG.insert_element_rel(
          p_plan_relationship_id      => p_new_plan_relationship_id,
          p_parent_char_id            => c1_rec.parent_char_id,
          p_child_char_id             => c1_rec.child_char_id,
          p_element_relationship_type => c1_rec.element_relationship_type,
          p_link_flag                 => c1_rec.vlink_flag,
          x_element_relationship_id   => l_new_element_relationship_id);

Line: 117

         SELECT char_id, operator, low_value, high_value
         FROM   qa_pc_criteria
         WHERE  plan_relationship_id = p_old_plan_relationship_id;

Line: 125

        QA_SS_PARENT_CHILD_PKG.insert_criteria_rel(
          p_plan_relationship_id => p_new_plan_relationship_id,
          p_char_id              => c1_rec.char_id,
          p_operator             => c1_rec.operator,
          p_low_value            => c1_rec.low_value,
          p_high_value           => c1_rec.high_value,
          x_criteria_id          => l_new_criteria_id);

Line: 246

         SELECT organization_code
         FROM mtl_parameters
         WHERE organization_id = p_orgid;

Line: 265

         SELECT DISTINCT fu.user_name FROM
       fnd_user fu
       WHERE
       fu.user_id = u_id;

Line: 508

         SELECT qpca.plan_char_action_id, qpca.alr_action_id, qpca.message
         FROM qa_plans qp, qa_plan_chars qpc, qa_plan_char_action_triggers qpcat, qa_plan_char_actions qpca
         WHERE qp.plan_id = qpc.plan_id AND qpc.char_id = qpcat.char_id AND qp.plan_id = qpcat.plan_id
         AND qpcat.plan_char_action_trigger_id = qpca.plan_char_action_trigger_id AND qp.plan_id=p_plan_id;

Line: 516

         SELECT body
         FROM alr_actions
         WHERE action_id = p_alract_id AND application_id = 250;

Line: 558

                  UPDATE ALR_ACTIONS SET BODY = l_body WHERE APPLICATION_ID=250 AND ACTION_ID = c1_rec.alr_action_id;

Line: 569

               UPDATE QA_PLAN_CHAR_ACTIONS SET MESSAGE = l_message WHERE PLAN_CHAR_ACTION_ID = c1_rec.plan_char_action_id;

Line: 654

         SELECT 1 FROM DUAL
         WHERE NOT EXISTS
            (SELECT 1 FROM qa_plans
             WHERE translate(substr(upper(name),1,25),' ''','__') =
             translate(substr(upper(p_plan_name),1,25),' ''','__'));

Line: 697

      select_string     VARCHAR2(4000);

Line: 698

      update_string     VARCHAR2(4000);

Line: 708

      select_string := 'select plan_id, effective_from, effective_to from qa_plans where plan_id in (';

Line: 711

            select_string := select_string || ':' || to_char(i) || ', ';

Line: 713

            select_string := select_string || ':' || to_char(i) || ')';

Line: 719

      dbms_sql.parse(c1, select_string, dbms_sql.native);

Line: 767

      update_string := 'UPDATE QA_PLANS SET effective_from = :1, effective_to = :2 WHERE plan_id = :3';

Line: 769

      dbms_sql.parse(c2, update_string, dbms_sql.native);

Line: 817

         SELECT child_plan_id
         FROM qa_pc_plan_relationship
         WHERE parent_plan_id = parent_id;

Line: 827

          SELECT qpc.char_id,qpc.result_column_name,qc.name
          FROM qa_plan_chars qpc,qa_chars qc, qa_char_indexes qci
          WHERE qpc.plan_id = p_plan_id
          AND qpc.char_id = qc.char_id
          AND qpc.char_id = qci.char_id
          AND qci.enabled_flag = 1;