APPS.OZF_QUOTA_ALLOCATIONS_PVT SQL Statements

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

Line: 25

SELECT 'Y' from dual
WHERE exists(SELECT 1 FROM ozf_funds_all_b WHERE parent_fund_id IS NOT NULL AND fund_id = p_quota_id)
AND NOT EXISTS(select 1 FROM ozf_funds_all_b WHERE parent_fund_id = p_quota_id);

Line: 29

CURSOR c_acct_Spread_OR_Selection(p_quota_start_date DATE) IS
SELECT decode(greatest(p_quota_start_date, sysdate), sysdate,'SPR','SEL')
FROM dual;

Line: 34

SELECT start_date_active
FROM ozf_funds_all_b
WHERE fund_id = p_quota_id;

Line: 54

  open c_acct_Spread_OR_Selection(l_quota_start_date);

Line: 55

     fetch c_acct_Spread_OR_Selection into l_acct_icon;

Line: 56

  close c_acct_Spread_OR_Selection;

Line: 72

SELECT 'Y' from dual
WHERE exists(SELECT 1 FROM ozf_funds_all_b WHERE parent_fund_id IS NOT NULL AND fund_id = p_quota_id)
AND NOT EXISTS(select 1 FROM ozf_funds_all_b WHERE parent_fund_id = p_quota_id);

Line: 77

SELECT TARGET Unallocated_Fund
FROM OZF_ACCOUNT_ALLOCATIONS
WHERE ALLOCATION_FOR = 'FUND'
AND ALLOCATION_FOR_ID = p_quota_id
AND PARENT_PARTY_ID = -9999;

Line: 84

SELECT	((NVL(FF.ORIGINAL_BUDGET,0) + NVL(FF.TRANSFERED_IN_AMT,0)) - NVL(FF.TRANSFERED_OUT_AMT,0)) UNALLOCATED_AMT
FROM OZF_FUNDS_ALL_VL FF
WHERE FF.FUND_ID = p_quota_id;

Line: 113

SELECT NAME FROM  ozf_thresholds_all_vl  WHERE threshold_id = p_id;

Line: 142

SELECT activity_metric_fact_id , activity_metric_id FROM ozf_act_metric_facts_all
WHERE activity_metric_id =  p_alloc_id;

Line: 297

PROCEDURE update_fund_with_extra_fields(
                              p_api_version         IN     NUMBER    DEFAULT 1.0
                            , p_init_msg_list       IN     VARCHAR2  DEFAULT FND_API.G_FALSE
                            , p_commit              IN     VARCHAR2  DEFAULT FND_API.G_FALSE
                            , p_validation_level    IN     NUMBER    DEFAULT FND_API.g_valid_level_full
                            , p_alloc_id            IN     NUMBER
                            , x_return_status      OUT NOCOPY      VARCHAR2
                            , x_msg_count          OUT NOCOPY      NUMBER
                            , x_msg_data           OUT NOCOPY      VARCHAR2
                            )
IS
l_api_version    CONSTANT NUMBER       := 1.0;

Line: 311

SELECT activity_metric_fact_id ,  act_metric_used_by_id FROM ozf_act_metric_facts_all
WHERE activity_metric_id =  p_alloc_id;

Line: 317

SELECT start_period_name, end_period_name, product_spread_time_id FROM ozf_act_metrics_all
WHERE activity_metric_id = p_alloc_id;

Line: 325

  SAVEPOINT update_fund_sp;

Line: 334

    UPDATE ozf_funds_all_b
    SET start_period_name = l_start_period_name,
	end_period_name = l_end_period_name,
	product_spread_time_id = l_spread_time_id
    WHERE fund_id = l_fact_id.act_metric_used_by_id;

Line: 344

    ROLLBACK TO update_fund_sp;

Line: 353

END update_fund_with_extra_fields;

Line: 371

SELECT activity_metric_fact_id ,  act_metric_used_by_id FROM ozf_act_metric_facts_all
WHERE activity_metric_id =  p_alloc_id;

Line: 378

SELECT 'Y' from dual
WHERE exists(
	SELECT 1 FROM ozf_funds_all_b
	WHERE parent_fund_id IS NOT NULL
	AND fund_id = p_quota_id)
AND NOT EXISTS(
	select 1 FROM ozf_funds_all_b
	WHERE parent_fund_id = p_quota_id);

Line: 476

SELECT activity_metric_fact_id , activity_metric_id FROM ozf_act_metric_facts_all
WHERE activity_metric_id = p_alloc_id;

Line: 480

SELECT status_code,object_version_number FROM ozf_act_metrics_all
    WHERE activity_metric_id = p_alloc_id;

Line: 533

ozf_utility_pvt.debug_message('@Calling Update Fund With Time Spread');

Line: 535

update_fund_with_extra_fields(
                            p_api_version         => p_api_version
                            , p_init_msg_list       => p_init_msg_list
                            , p_commit              => p_commit
                            , p_validation_level    => p_validation_level
                            , p_alloc_id            => p_alloc_id
                            , x_return_status       => x_return_status
                            , x_msg_count           => x_msg_count
                            , x_msg_data            => x_msg_data
                            ); -- dont update directly instead call budget api

Line: 551

ozf_utility_pvt.debug_message('@Done Calling Update Fund With Time Spread: Return :'||x_return_status);

Line: 643

select activity_metric_id
from ozf_act_metrics_all
where arc_act_metric_used_by = 'FUND'
and act_metric_used_by_id = p_quota_id;

Line: 649

select act_metric_used_by_id
from ozf_act_metric_facts_all
where arc_act_metric_used_by = 'FUND'
and activity_metric_id = p_alloc_id;

Line: 655

SELECT user_status_id
FROM ams_user_statuses_vl
WHERE system_status_type = 'OZF_FUND_STATUS'
AND system_status_code = 'CANCELLED';

Line: 669

update ozf_act_metrics_all
set status_code = 'CANCELLED'
where arc_act_metric_used_by = 'FUND'
and act_metric_used_by_id = p_quota_id;

Line: 682

update ozf_act_metric_facts_all
set status_code = 'CANCELLED'
where arc_act_metric_used_by = 'FUND'
and activity_metric_id = l_alloc_id.activity_metric_id;

Line: 694

update ozf_funds_all_b
set status_code = 'CANCELLED',
user_status_id = l_user_status_id
where fund_id in
(
select act_metric_used_by_id from ozf_act_metric_facts_all
where arc_act_metric_used_by = 'FUND'
and activity_metric_id = l_alloc_id.activity_metric_id
);