[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT gp.start_date
,gp.end_date
FROM gl_periods gp
WHERE gp.period_name = p_current_planning_period
AND gp.period_set_name = p_period_set_name
AND gp.period_type = decode(P_time_phase_code,'G',p_accounted_period_type,'P',P_pa_period_type)
AND gp.adjustment_period_flag = 'N';
SELECT gp.end_date
,gp.period_name
FROM gl_periods gp
WHERE p_planning_end_date BETWEEN gp.start_date AND gp.end_date
AND gp.period_set_name = p_period_set_name
AND gp.period_type = decode(P_time_phase_code,'G',p_accounted_period_type,'P',P_pa_period_type)
AND gp.adjustment_period_flag = 'N';
SELECT gp.start_date
,gp.period_name
FROM gl_periods gp
WHERE p_planning_start_date BETWEEN gp.start_date AND gp.end_date
AND gp.period_set_name = p_period_set_name
AND gp.period_type = decode(P_time_phase_code,'G',p_accounted_period_type,'P',P_pa_period_type)
AND gp.adjustment_period_flag = 'N';
SELECT min(from_anchor_start) from_anchor_start_min
FROM pa_period_mask_details
WHERE from_anchor_start NOT IN (-99999,99999)
AND period_mask_id = p_period_mask_id;
SELECT max(from_anchor_end) from_anchor_end_max
FROM pa_period_mask_details
WHERE from_anchor_end NOT IN (-99999,99999)
AND period_mask_id = p_period_mask_id;
SELECT gsb.period_set_name
,gsb.accounted_period_type
,pbv.current_planning_period
,pbv.period_mask_id
,pia.pa_period_type
,decode(pbv.version_type,
'COST',ppfo.cost_time_phased_code,
'REVENUE',ppfo.revenue_time_phased_code,
ppfo.all_time_phased_code) time_phase_code
FROM gl_sets_of_books gsb
,pa_implementations_all pia
,pa_projects_all ppa
,pa_budget_versions pbv
,pa_proj_fp_options ppfo
WHERE ppa.project_id = pbv.project_id
AND pbv.budget_version_id = ppfo.fin_plan_version_id
AND ppa.org_id = pia.org_id
AND gsb.set_of_books_id = pia.set_of_books_id
AND pbv.budget_version_id = p_budget_version_id;
SELECT planning_start_date,
planning_end_date
FROM pa_resource_assignments
WHERE resource_assignment_id = p_resource_assignment_id;
SELECT *
FROM gl_periods gp
WHERE gp.period_set_name = l_period_set_name
AND gp.period_type = decode(l_time_phase_code,'G',l_accounted_period_type,
'P',l_pa_period_type)
AND gp.start_date <= l_cpp_start_date
AND gp.adjustment_period_flag = 'N'
--AND nvl(l_plan_start_date,gp.start_date) between gp.start_date and gp.end_date
--AND gp.end_date >= nvl(l_plan_start_date, gp.end_date)
-- Bug Fix 3475010. Additional PP masks are getting created.
-- Modified the following where condition as we are trying to compare
-- Period's start with plan start date instead of the plan's start date's
-- period's start date.
-- Need to compare the like wise things.
-- AND l_cpp_start_date between l_plan_start_date and l_plan_end_date
-- AND l_cpp_start_date between g_plan_period_start_date and g_plan_period_end_datE
ORDER BY gp.start_date DESC;
SELECT *
FROM gl_periods gp
WHERE gp.period_set_name = l_period_set_name
AND gp.period_type = decode(l_time_phase_code,'G',l_accounted_period_type,
'P',l_pa_period_type)
AND gp.start_date > l_cpp_start_date
AND gp.adjustment_period_flag = 'N'
-- Bug Fix 3475010. Additional PP masks are getting created.
-- Modified the following where condition as we are trying to compare
-- Period's start with plan end date instead of the plan's end date's
-- period's end date.
-- Need to compare the like wise things.
-- AND gp.start_date <= nvl(l_plan_end_date, gp.start_date)
-- AND gp.start_date <= nvl(g_plan_period_end_date, gp.start_date)
ORDER BY gp.start_date;
SELECT meaning
FROM pa_lookups
WHERE lookup_type = l_lookup_type
AND lookup_code = l_prec ;
SELECT meaning
FROM pa_lookups
WHERE lookup_type = l_lookup_type
AND lookup_code = l_succ ;
SELECT meaning
FROM pa_lookups
WHERE lookup_type = l_lookup_type
AND lookup_code = l_to ;
THEN periods_tab.DELETE;
SELECT from_anchor_start
,from_anchor_end
FROM pa_period_mask_details
WHERE from_anchor_position = p_from_anchor_position
AND period_mask_id = g_period_mask_id;
SELECT from_anchor_start
,from_anchor_end
FROM pa_period_mask_details
WHERE from_anchor_position = p_from_anchor_position
AND period_mask_id = g_period_mask_id;
SELECT from_anchor_start
,from_anchor_end
FROM pa_period_mask_details
WHERE from_anchor_position = p_from_anchor_position
AND period_mask_id = g_period_mask_id;
SELECT from_anchor_start
,from_anchor_end
FROM pa_period_mask_details
WHERE from_anchor_position = p_from_anchor_position
AND period_mask_id = g_period_mask_id;
/* The update_current_pp is called from the Edit Plan Lines Page to update
the current planning period in the pa_budget_versions table and pa_proj_fp_options
table.
*/
-- Bug Fix 3975683
-- Added record version numbers which will be used
-- to see if the record is already is updates or not
-- and update the version number as well.
PROCEDURE update_current_pp (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_bud_rec_ver_num IN pa_budget_versions.record_version_number%TYPE,
p_fp_rec_ver_num IN pa_proj_fp_options.record_version_number%TYPE,
X_Return_Status OUT NOCOPY Varchar2,
X_Msg_Count OUT NOCOPY Number,
X_Msg_Data OUT NOCOPY Varchar2) IS
CURSOR get_version_type_csr(p_budget_version_id NUMBER) IS
SELECT version_type
FROM pa_budget_versions
WHERE budget_version_id = p_budget_version_id;
SELECT DISTINCT(period_name) into l_curr_plan_period FROM gl_periods where period_name=p_current_planning_period;
UPDATE pa_budget_versions
SET current_planning_period = p_current_planning_period,
record_version_number = record_version_number + 1
WHERE budget_version_id = p_budget_version_id
AND record_version_number = p_bud_rec_ver_num;
X_Msg_Data := 'PA_RECORD_ALREADY_UPDATED';
P_Msg_Name => 'PA_RECORD_ALREADY_UPDATED');
UPDATE pa_proj_fp_options
SET COST_CURRENT_PLANNING_PERIOD = p_current_planning_period,
record_version_number = record_version_number + 1
WHERE FIN_PLAN_VERSION_ID = p_budget_version_id
AND record_version_number = p_fp_rec_ver_num;
UPDATE pa_proj_fp_options
SET REV_CURRENT_PLANNING_PERIOD = p_current_planning_period,
record_version_number = record_version_number + 1
WHERE FIN_PLAN_VERSION_ID = p_budget_version_id
AND record_version_number = p_fp_rec_ver_num;
UPDATE pa_proj_fp_options
SET ALL_CURRENT_PLANNING_PERIOD = p_current_planning_period,
record_version_number = record_version_number + 1
WHERE FIN_PLAN_VERSION_ID = p_budget_version_id
AND record_version_number = p_fp_rec_ver_num;
X_Msg_Data := 'PA_RECORD_ALREADY_UPDATED';
P_Msg_Name => 'PA_RECORD_ALREADY_UPDATED');
END update_current_pp;