[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
FROM DUAL
WHERE EXISTS( SELECT 1
FROM ams_act_products
WHERE act_product_used_by_id = p_fund_id AND arc_act_product_used_by = 'FUND');
SELECT original_budget,
transfered_in_amt,
transfered_out_amt,
currency_code_tc
FROM ozf_funds_all_vl
WHERE fund_id = p_parent_id;
SELECT fund_type
FROM ozf_funds_all_vl
WHERE fund_id = p_parent_id;
SELECT fund_type
FROM ozf_funds_all_vl
WHERE fund_id = p_parent_id;
SELECT status_code, fund_type
FROM ozf_funds_all_vl
WHERE fund_id = p_parent_id;
SELECT start_date_active,
end_date_active
FROM ozf_funds_all_vl
WHERE fund_id = p_parent_id;
SELECT currency_code_tc
FROM ozf_funds_all_vl
WHERE fund_id = p_parent_id;
SELECT short_name AS short_name,
original_budget AS original_budget,
currency_code_tc AS currency_code
FROM ozf_funds_all_vl
WHERE parent_fund_id = p_fund_id;
SELECT fund_type
FROM ozf_funds_all_vl
WHERE fund_id = p_fund_id;
SELECT short_name AS short_name,
start_date_active AS start_date,
end_date_active AS end_date,
fund_type AS fund_type
FROM ozf_funds_all_vl
WHERE parent_fund_id = p_fund_id;
SELECT short_name AS short_name,
fund_type AS fund_type
FROM ozf_funds_all_vl
WHERE parent_fund_id = p_fund_id;
SELECT short_name AS short_name,
currency_code_tc AS fund_curr,
fund_type AS fund_type
FROM ozf_funds_all_vl
WHERE parent_fund_id = p_fund_id;
SELECT 1
FROM DUAL
WHERE EXISTS( SELECT 1
FROM gl_periods_v
WHERE period_set_name = p_fund_calendar);
SELECT start_date,
end_date
FROM gl_periods_v
WHERE period_set_name = p_fund_calendar AND period_name = p_start_period_name;
SELECT start_date,
end_date
FROM gl_periods_v
WHERE period_set_name = p_fund_calendar AND period_name = p_end_period_name;
SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD
WHERE NAME = p_start_period_name
UNION ALL
SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_QTR
WHERE NAME = p_start_period_name
UNION ALL
SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR
WHERE NAME = p_start_period_name;
SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD
WHERE NAME = p_end_period_name
UNION ALL
SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_QTR
WHERE NAME = p_end_period_name
UNION ALL
SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR
WHERE NAME = p_end_period_name;
SELECT NAME, START_DATE, END_DATE
FROM
(SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD
UNION ALL
SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_QTR
UNION ALL
SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR
)
WHERE NAME = p_start_period_name;
SELECT NAME, START_DATE, END_DATE
FROM
(SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD
UNION ALL
SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_QTR
UNION ALL
SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR
)
WHERE NAME = p_end_period_name;
SELECT offer_id,
object_version_number
FROM ozf_offers
WHERE qp_list_header_id = p_list_header_id;
SELECT status_code
FROM ozf_funds_all_b
WHERE fund_id = cv_fund_id;
ELSIF p_mode In ( 'UPDATE' ,'ACTIVE') THEN
/* yzhao: 07/23/2001 create actbudget after updating offer modifiers
so product eligibility check succeeds */ -- 10/11/2002
/* fix bug 3464511 - duplicate REQUEST records in ozf_act_budgets whenever updating active accrual budget
IF p_fund_rec.status_code = 'ACTIVE' THEN
*/
IF p_fund_rec.status_code in ('ACTIVE','ON_HOLD') AND p_mode ='ACTIVE' THEN
IF G_DEBUG THEN
ozf_utility_pvt.debug_message(l_full_name ||
': begin create act budgets ');
ELSIF p_mode = 'UPDATE' THEN
-- 10/16/2001 mpande for updation of accrual offer
OPEN c_actbudget_id( l_upd_offer_hdr_rec.qp_list_header_id, p_fund_rec.fund_id) ;
UPDATE ozf_act_budgets
SET approved_amount = NVL(p_fund_rec.accrual_cap,0),
approved_original_amount = NVL(p_fund_rec.accrual_cap,0)
WHERE activity_budget_Id = l_Act_budget_id;
l_offer_hdr_rec.offer_operation := 'UPDATE';
l_offer_hdr_rec.offer_operation := 'UPDATE';
l_offer_hdr_rec.modifier_operation := 'UPDATE';
-- In case of Update, for any Update in Accrual Budget, the Offer OU was changing to Default OU.
-- Changed the code to not pass any value for offer's org id .
-- Fix for Bug #14736414
-- Global flag for an offer is checkedd against the profile global flag
IF p_mode = 'CREATE' THEN
IF NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') <> 'OFF' THEN
-- QP_SECURITY_PROFILE IS ON.
IF(p_fund_rec.org_id IS NULL OR p_fund_rec.org_id = FND_API.G_MISS_NUM) THEN
-- DEFAULT OU IS NULL
IF (NVL(fnd_profile.value('OZF_GLOBAL_FLAG'), 'N') = 'N') THEN
OZF_Utility_PVT.Error_Message('OZF_ORG_ID_OR_GFLAG_REQD');
ELSIF p_mode = 'UPDATE' THEN
OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'ozf_fundrules_pvt','Update mode = p_fund_rec.org_id'|| p_fund_rec.org_id);
/* yzhao: 08/09/2005 for fully accrual budget PENDING => DRAFT, call update_offer_status not process_modifier
otherwise fully accrual budget can not be reverted to DRAFT from PENDING
since process_modifer checks ams_status_order_rules, and PENDING => DRAFT not allowed for offer
AND p_fund_rec.status_code in('ACTIVE','ON_HOLD','REJECTED') THEN
*/
ozf_offer_pvt.update_offer_status
(
p_commit => fnd_api.g_false,
x_return_status=> l_return_status,
x_msg_count=> x_msg_count,
x_msg_data=> x_msg_data,
p_modifier_list_rec => l_offer_hdr_rec
);
ozf_utility_pvt.debug_message('OZF_OFFR_UPDATE_SATAUS FAIL');
UPDATE ozf_offers
SET status_code = 'PENDING',
user_status_id = l_offer_hdr_rec.user_status_id,
object_version_number = object_version_number + 1
WHERE offer_id = l_ozf_offer_id;
ozf_utility_pvt.debug_message('In update 1');
UPDATE ozf_funds_all_b
SET plan_id = l_qp_list_header_id,
plan_type = 'OFFR'
WHERE fund_id = p_fund_rec.fund_id;
ELSIF p_mode = 'UPDATE' THEN
l_qp_list_header_id := p_fund_rec.plan_id;
END IF; -- end of p_mode = CREATE/UPDATE
': end update offer advanced option ');
': begin update offer advanced option ');
SELECT (NVL(original_budget, 0) + NVL(transfered_in_amt,0) - NVL(transfered_out_amt, 0))
, NVL(recal_committed, 0),
NVL(utilized_amt, 0), NVL(earned_amt, 0), NVL(paid_amt, 0), fund_type -- yzhao: 11.5.10 added utilized_amt
FROM ozf_funds_all_b
WHERE fund_id = p_fund_id;
PROCEDURE update_fund_status(
p_fund_rec IN ozf_funds_pvt.fund_rec_type,
x_new_status_code OUT NOCOPY VARCHAR2,
x_new_status_id OUT NOCOPY NUMBER,
x_submit_budget_approval OUT NOCOPY VARCHAR2,
x_submit_child_approval OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_api_version IN NUMBER) IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'Update_fund_status';
SELECT status_code,
user_status_id,
owner,
fund_type,
plan_id
FROM ozf_funds_all_b
WHERE fund_id = p_fund_rec.fund_id;
SELECT owner
FROM ozf_funds_all_b
WHERE fund_id = p_parent_fund_id;
SAVEPOINT update_fund_status;
ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_UPDATE');
ozf_utility_pvt.error_message('OZF_FUND_BAN_UPDATE');
SELECT 1
FROM qp_list_lines
WHERE list_header_id = (SELECT plan_id FROM ozf_funds_all_b WHERE fund_id = p_fund_rec.fund_id);
'fund no update except owner');
ROLLBACK TO update_fund_status;
ROLLBACK TO update_fund_status;
ROLLBACK TO update_fund_status;
END update_fund_status;