APPS.OZF_FUND_APPROVAL_PVT SQL Statements

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

Line: 81

        select b.fund_number , t.short_name , b.currency_code_tc , b.start_date_active , res.RESOURCE_NAME ,
	b.fund_type
	from ozf_funds_all_b b ,
	     ozf_funds_all_tl t ,
	     jtf_rs_resource_extns_tl res
	where b.fund_id = p_fund_id
	  and b.fund_id = t.fund_id
	  and res.resource_id = b.owner
	  and userenv ( 'LANG' ) =  t.language
	  and  t.language  = res.language;

Line: 93

         SELECT fund_number, short_name, currency_code_tc, start_date_active,
                owner_full_name,fund_type
           FROM ozf_fund_details_v
          WHERE fund_id = p_fund_id;

Line: 292

	select b.fund_number , t.short_name , b.currency_code_tc , b.start_date_active , res.RESOURCE_NAME ,
	b.fund_type
	from ozf_funds_all_b b ,
	     ozf_funds_all_tl t ,
	     jtf_rs_resource_extns_tl res
	where b.fund_id = p_fund_id
	  and b.fund_id = t.fund_id
	  and res.resource_id = b.owner
	  and userenv ( 'LANG' ) =  t.language
	  and  t.language  = res.language;

Line: 304

         SELECT fund_number, short_name, currency_code_tc, start_date_active,
                owner_full_name, fund_type  -- ,original_budget   01/28/2003 yzhao: requested amount is not original_budget
           FROM ozf_fund_details_v
          WHERE fund_id = p_fund_id;

Line: 513

         SELECT fund_number, short_name, currency_code_tc, start_date_active, fund_type
           FROM ozf_funds_all_vl
          WHERE fund_id = p_fund_id;

Line: 715

	select b.fund_number , t.short_name , b.currency_code_tc , b.start_date_active , res.RESOURCE_NAME ,
	b.fund_type
	from ozf_funds_all_b b ,
	     ozf_funds_all_tl t ,
	     jtf_rs_resource_extns_tl res
	where b.fund_id = p_fund_id
	  and b.fund_id = t.fund_id
	  and res.resource_id = b.owner
	  and userenv ( 'LANG' ) =  t.language
	  and  t.language  = res.language;

Line: 727

         SELECT fund_number, short_name, currency_code_tc, start_date_active,
                owner_full_name, fund_type
           FROM ozf_fund_details_v
          WHERE fund_id = p_fund_id;

Line: 944

         SELECT fund_number, short_name, currency_code_tc, start_date_active, fund_type
           FROM ozf_funds_all_vl
          WHERE fund_id = p_fund_id;

Line: 1175

         SELECT short_name, custom_setup_id, original_budget, org_id, to_char(category_id),
                start_date_active, end_date_active, owner, currency_code_tc, business_unit_id,
                fund_number, fund_type
           FROM ozf_funds_all_vl
          WHERE fund_id = p_act_id;

Line: 1446

      SELECT b.text_value, b.number_value
        FROM wf_routing_rules a, wf_routing_rule_attributes b
       WHERE a.rule_id = b.rule_id
         AND a.role = p_approver_name
         AND TRUNC(sysdate) BETWEEN TRUNC(NVL(begin_date, sysdate -1)) AND
             TRUNC(NVL(end_date,sysdate+1))
         AND a.message_name = 'AMS_APPROVAL_REQUIRED_OZF'
         AND b.name = 'AMS_AMOUNT';

Line: 1496

   PROCEDURE update_parbudget_status (
      itemtype    IN       VARCHAR2,
      itemkey     IN       VARCHAR2,
      actid       IN       NUMBER,
      funcmode    IN       VARCHAR2,
      resultout   OUT NOCOPY      VARCHAR2
   ) IS
      l_status_code             VARCHAR2 (30);

Line: 1508

      l_api_name       CONSTANT VARCHAR2 (30)               := 'Update_ParBudget_Status';

Line: 1515

      l_update_status           VARCHAR2 (12);

Line: 1532

          SELECT fund_type from ozf_funds_all_b where fund_id = l_fund_id;

Line: 1534

      SAVEPOINT update_parbudget_status ;

Line: 1536

         l_update_status            :=
               wf_engine.getitemattrtext (
                  itemtype=> itemtype,
                  itemkey=> itemkey,
                  aname => 'UPDATE_GEN_STATUS'
               );

Line: 1604

         IF l_update_status = 'APPROVED' THEN
            l_next_status_id           :=
                  wf_engine.getitemattrnumber (
                     itemtype=> itemtype,
                     itemkey=> itemkey,
                     aname => 'AMS_NEW_STAT_ID'
                  );

Line: 1662

               ozf_utility_pvt.debug_message (   l_full_name || l_update_status);

Line: 1665

         ELSIF l_update_status = 'REJECTED' THEN
            l_next_status_id           :=
                  wf_engine.getitemattrnumber (
                     itemtype=> itemtype,
                     itemkey=> itemkey,
                     aname => 'AMS_REJECT_STAT_ID'
                  );

Line: 1697

            || l_update_status
         );

Line: 1700

         ozf_funds_pvt.update_fund (
            p_api_version=> l_api_version,
            p_init_msg_list=> fnd_api.g_false,
            p_validation_level => l_validation_level,
            x_return_status=> l_return_status,
            x_msg_count=> l_msg_count,
            x_msg_data=> l_msg_data,
            p_fund_rec=> l_fund_rec,
            p_mode=> g_fund_mode
         );

Line: 1712

               ozf_utility_pvt.debug_message(l_full_name || ' failed to update fund to status ' || l_status_code);

Line: 1756

      ROLLBACK TO update_parbudget_status ;

Line: 1772

   END update_parbudget_status;

Line: 1787

      l_api_name       CONSTANT VARCHAR2 (30)               := 'Update_ParBudget_Status';

Line: 1794

      l_update_status           VARCHAR2 (12);

Line: 1826

            || l_update_status
         );

Line: 1829

         ozf_funds_pvt.update_fund (
            p_api_version=> l_api_version,
            p_init_msg_list=> fnd_api.g_false,
            x_return_status=> l_return_status,
            x_msg_count=> l_msg_count,
            x_msg_data=> l_msg_data,
            p_fund_rec=> l_fund_rec,
            p_mode=> g_fund_mode
         );

Line: 1916

         SELECT ozf2.owner, ozf1.owner
           FROM ozf_funds_all_b ozf2, ozf_funds_all_b ozf1
          WHERE ozf2.fund_id = ozf1.parent_fund_id
            AND ozf1.fund_id = p_fund_id;