APPS.OZF_FUND_EXTENSION_PVT SQL Statements

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

Line: 36

        SELECT  full_name
        FROM ams_jtf_rs_emp_v
        WHERE resource_id = p_owner_id;

Line: 41

         SELECT ofr.owner_id, qp.description, ofr.status_code, ofr.budget_offer_yn
           FROM ozf_offers ofr, qp_list_headers qp
          WHERE ofr.qp_list_header_id = qp.list_header_id
            AND ofr.qp_list_header_id = p_object_id;

Line: 47

         SELECT owner_user_id, campaign_name, status_code
           FROM ams_campaigns_vl
          WHERE campaign_id = p_object_id;

Line: 52

         SELECT owner_user_id, schedule_name, status_code
           FROM ams_campaign_schedules_vl
          WHERE schedule_id = p_object_id;

Line: 57

         SELECT owner_user_id, event_header_name, system_status_code
           FROM ams_event_headers_vl
          WHERE event_header_id = p_object_id;

Line: 62

         SELECT owner_user_id, event_offer_name, system_status_code
           FROM ams_event_offers_vl
          WHERE event_offer_id = p_object_id;

Line: 67

         SELECT owner_user_id, deliverable_name, status_code
           FROM ams_deliverables_vl
          WHERE deliverable_id = p_object_id;

Line: 72

         SELECT owner, short_name, status_code
           FROM ozf_funds_all_vl
          WHERE fund_id = p_object_id;

Line: 200

    SELECT arc_act_budget_used_by, act_budget_used_by_id, status_code
    FROM   ozf_act_budgets
    WHERE  budget_source_type = 'FUND'
    AND    budget_source_id = p_object_id
    AND    transfer_type IN ('TRANSFER', 'REQUEST', 'UTILIZED');

Line: 207

    SELECT budget_source_type, budget_source_id, status_code
    FROM   ozf_act_budgets
    WHERE  arc_act_budget_used_by = 'FUND'
    AND    act_budget_used_by_id = p_object_id
    AND    transfer_type IN ('TRANSFER', 'REQUEST', 'UTILIZED');

Line: 214

    SELECT fund_id
    FROM   ozf_funds_all_b
    WHERE  parent_fund_id = p_object_id
    AND    fund_id = p_child_fund_id;

Line: 361

    SELECT fund_id, short_name, status_code, owner,
           decode(status_code, 'DRAFT', 'Y', 'REJECTED', 'Y', 'ARCHIVED', 'Y', 'N') deletable_flag
    FROM   ozf_funds_all_vl
    WHERE  parent_fund_id = p_object_id;

Line: 367

        SELECT  full_name
        FROM ams_jtf_rs_emp_v
        WHERE resource_id = p_owner_id;

Line: 482

PROCEDURE validate_delete_fund(
    p_api_version_number IN       NUMBER
  , p_init_msg_list      IN       VARCHAR2 := fnd_api.g_false
  , p_commit             IN       VARCHAR2 := fnd_api.g_false
  , p_object_id          IN       NUMBER
  , p_object_version_number IN    NUMBER
  , x_dependent_object_tbl  OUT NOCOPY   ams_utility_pvt.dependent_objects_tbl_type
  , 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) := 'validate_delete_fund';

Line: 503

    SELECT status_code
    FROM   ozf_funds_all_b
    WHERE  fund_id = p_object_id;

Line: 585

END validate_delete_fund;

Line: 625

 SELECT offer_id, object_version_number, offer_type
 FROM ozf_offers
 WHERE qp_list_header_id =  p_qp_list_header_id;

Line: 631

 SELECT plan_id
 FROM ozf_funds_all_b
 WHERE fund_id =  l_fund_id;

Line: 663

         l_offer_hdr_rec.offer_operation := 'UPDATE';

Line: 664

         l_offer_hdr_rec.modifier_operation := 'UPDATE';

Line: 727

PROCEDURE delete_fund_schema(
    p_api_version_number IN       NUMBER
  , p_object_id          IN       NUMBER
  , p_object_version_number IN    NUMBER
  , p_top_del_budget_id  IN       NUMBER
  , 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_fund_schema';

Line: 746

    SELECT fund_id, object_version_number
    FROM   ozf_funds_all_b
    WHERE  parent_fund_id = p_object_id;

Line: 751

    SELECT fund_id
         , owner
         , short_name
         , parent_fund_id
         , -rollup_original_budget
         , -rollup_transfered_in_amt
         , -rollup_transfered_out_amt
         , -rollup_holdback_amt
         , -rollup_planned_amt
         , -rollup_committed_amt
         , -rollup_utilized_amt      -- yzhao: 12/02/2003 11.5.10 added
         , -rollup_earned_amt
         , -rollup_paid_amt
         , -rollup_recal_committed
         , status_code
         , fund_type

    FROM   ozf_funds_all_vl
    WHERE  fund_id = p_object_id
    AND    object_version_number = p_object_version_number;

Line: 774

    SELECT utilization_id
    FROM   ozf_funds_utilized_all_b
    WHERE  fund_id = p_object_id
    OR     (object_id = p_object_id  AND  object_type = 'FUND')
    OR     (component_id = p_object_id  AND component_type = 'FUND');*/

Line: 781

    SELECT activity_metric_id
      from ozf_act_metrics_all
     where act_metric_used_by_id = p_object_id
       and arc_act_metric_used_by = 'FUND';

Line: 787

    SELECT activity_access_id
         , object_version_number
    FROM   ams_act_access
    WHERE  act_access_to_object_id = p_object_id
    AND    arc_act_access_to_object = 'FUND';

Line: 795

    SELECT 1
    FROM ozf_funds_utilized_all_b
    WHERE fund_id = p_object_id and rownum = 1;

Line: 816

       delete_fund_schema(p_api_version_number    => p_api_version_number
                 , p_object_id             => child_rec.fund_id
                 , p_object_version_number => child_rec.object_version_number
                 , p_top_del_budget_id     => p_top_del_budget_id
                 , x_return_status         => l_return_status
                 , x_msg_count             => x_msg_count
                 , x_msg_data              => x_msg_data
                 );

Line: 859

      ozf_funds_pvt.update_rollup_amount(
             p_api_version      => p_api_version_number
            ,p_init_msg_list    => fnd_api.g_false
            ,p_commit           => fnd_api.g_false
            ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
            ,x_return_status    => l_return_status
            ,x_msg_count        => x_msg_count
            ,x_msg_data         => x_msg_data
            ,p_fund_rec         => l_fund_rec
            );

Line: 890

      ozf_funds_pvt.update_funds_access(
             p_api_version      => p_api_version_number
            ,p_init_msg_list    => fnd_api.g_false
            ,p_commit           => fnd_api.g_false
            ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
            ,x_return_status    => l_return_status
            ,x_msg_count        => x_msg_count
            ,x_msg_data         => x_msg_data
            ,p_fund_rec         => l_fund_rec
            ,p_mode             => 'DELETE'
            );

Line: 921

   END IF;  -- update ancestor

Line: 949

         DELETE FROM OZF_ACT_METRIC_FACTS_ALL
          WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id
           AND ARC_ACT_METRIC_USED_BY = 'FUND';

Line: 953

         DELETE FROM  ozf_act_metric_form_ent
          WHERE formula_id IN ( SELECT FORMULA_ID
                                  FROM OZF_ACT_METRIC_FORMULAS
                                 WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id);

Line: 958

         DELETE FROM  ozf_act_metric_formulas
          WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id;

Line: 961

         DELETE from ozf_act_metrics_all
          WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id;

Line: 966

     DELETE FROM ozf_act_budgets
     WHERE  (budget_source_type = 'FUND'
     AND     budget_source_id = p_object_id
     OR      arc_act_budget_used_by = 'FUND'
     AND     act_budget_used_by_id = p_object_id
            )
     AND    transfer_type IN ('TRANSFER', 'REQUEST', 'UTILIZATION', 'RESERVE');

Line: 988

     DELETE FROM ams_act_products
     WHERE  arc_act_product_used_by = 'FUND'
     AND    act_product_used_by_id = p_object_id;

Line: 1006

     DELETE FROM ams_act_market_segments
     WHERE  arc_act_market_segment_used_by = 'FUND'
     AND    act_market_segment_used_by_id = p_object_id;

Line: 1026

        DELETE FROM ozf_funds_utilized_all_b
        WHERE  utilization_id = util_rec.utilization_id;

Line: 1028

        DELETE FROM ozf_funds_utilized_all_tl
        WHERE  utilization_id = util_rec.utilization_id;

Line: 1041

      ams_access_pvt.delete_access(
                  p_api_version      => p_api_version_number
                 ,p_init_msg_list    => fnd_api.g_false
                 ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
                 ,x_return_status    => l_return_status
                 ,x_msg_count        => x_msg_count
                 ,x_msg_data         => x_msg_data
                 ,p_commit           => fnd_api.g_false
                 ,p_access_id        => fund_access_rec.activity_access_id
                 ,p_object_version   => fund_access_rec.object_version_number);

Line: 1070

   DELETE FROM ozf_funds_all_b
   WHERE  fund_id = p_object_id
   AND    object_version_number = p_object_version_number;

Line: 1087

   DELETE FROM ozf_funds_all_tl
   WHERE  fund_id = p_object_id;

Line: 1115

END delete_fund_schema;

Line: 1131

PROCEDURE delete_fund(
    p_api_version_number IN       NUMBER
  , p_init_msg_list      IN       VARCHAR2 := fnd_api.g_false
  , p_commit             IN       VARCHAR2 := fnd_api.g_false
  , p_object_id          IN       NUMBER
  , p_object_version_number IN    NUMBER
  , 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_fund';

Line: 1148

  delete_fund_schema(
      p_api_version_number    => p_api_version_number
    , p_object_id             => p_object_id
    , p_object_version_number => p_object_version_number
    , p_top_del_budget_id     => p_object_id
    , x_return_status         => x_return_status
    , x_msg_count             => x_msg_count
    , x_msg_data              => x_msg_data
  );

Line: 1173

END delete_fund;