APPS.OZF_FUND_APPROVAL_PVT SQL Statements

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

Line: 51

select org_id
from ozf_funds_all_b
where fund_id = p_id;

Line: 117

        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: 129

         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: 328

	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: 340

         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: 549

         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: 751

	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: 763

         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: 980

         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: 1211

         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: 1482

      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: 1532

   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: 1544

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

Line: 1551

      l_update_status           VARCHAR2 (12);

Line: 1569

          SELECT fund_type from ozf_funds_all_b where fund_id = l_fund_id;

Line: 1571

      SAVEPOINT update_parbudget_status ;

Line: 1573

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

Line: 1654

	OZF_DEBUG_PVT.DEBUG_MO('OZF_Fund_Approval_PVT update_parbudget_status before setting context : fund_id '||l_fund_id);

Line: 1656

         IF l_update_status IN ('APPROVED', 'REJECTED') AND
        (l_user_id IS NULL OR l_resp_id IS NULL OR l_appl_id IS NULL) THEN
        l_update_status := NULL;

Line: 1662

          ,aname    => 'UPDATE_GEN_STATUS'
          ,avalue   => l_update_status
        );

Line: 1680

           ,'update_parbudget_status'
           ,itemtype
           ,itemkey
           ,actid
           ,l_error_msg
        );

Line: 1688

     ELSIF l_update_status IN ('APPROVED', 'REJECTED') THEN
         --Bug 14725235
        FND_GLOBAL.apps_initialize( user_id           => l_user_id
                                  , resp_id           => l_resp_id
                                  , resp_appl_id      => l_appl_id
                                  --, security_group_id => l_security_group_id
                                  );

Line: 1702

	 OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','OZF_Fund_Approval_PVT update_parbudget_status l_fund_id : '||l_fund_id);

Line: 1704

	 OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','OZF_Fund_Approval_PVT update_parbudget_status l_org_id : '||l_org_id);

Line: 1708

	 OZF_DEBUG_PVT.DEBUG_MO('OZF_Fund_Approval_PVT update_parbudget_status after setting context : fund_id '||l_fund_id);

Line: 1710

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

Line: 1768

               ozf_utility_pvt.debug_message (   l_full_name || l_update_status);

Line: 1771

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

Line: 1803

            || l_update_status
         );

Line: 1806

         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: 1818

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

Line: 1862

      ROLLBACK TO update_parbudget_status ;

Line: 1878

   END update_parbudget_status;

Line: 1893

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

Line: 1900

      l_update_status           VARCHAR2 (12);

Line: 1932

            || l_update_status
         );

Line: 1935

         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: 2022

         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;