[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT project_id
FROM pa_projects_all
WHERE project_id = p_project_id;
SELECT
page_type_code
, page_id
, approval_required
, reporting_cycle_id
, report_offset_days
, reminder_days
, reminder_days_type
, initial_progress_status
, final_progress_status
, rollup_progress_status
, report_type_id
, approver_source_id
, approver_source_type
, effective_from
, effective_to
, object_page_layout_id
, pers_function_name
FROM pa_object_page_layouts
WHERE object_type = p_object_type
AND object_id = p_object_id_from;
SELECT
placeholder_reg_code
, replacement_reg_code
FROM pa_object_regions
where object_type = p_object_type
and object_id = p_object_id_from;
-- This call is made to simulate the same effect as user is trying to update the reporting cycle and
-- PA_PROGRESS_REPORT_PVT.define_progress_report_setup is getting called
IF obj_page_layout_rec.page_type_code = 'PPR' AND obj_page_layout_rec.reporting_cycle_id IS NOT NULL THEN
-- Note that in p_object_type intentionally null is passed instead of actual object type,
-- so that it does not return the From Project's next reporting date but the actual next
-- reporting date for the To project
PA_PROGRESS_REPORT_UTILS.GET_REPORT_START_END_DATES(
p_Object_Type => null ,
p_Object_Id => p_object_id_from ,
p_report_type_id => obj_page_layout_rec.report_type_id ,
p_Reporting_Cycle_Id => obj_page_layout_rec.reporting_cycle_id ,
p_Reporting_Offset_Days => obj_page_layout_rec.report_offset_days ,
p_Publish_Report => 'N' ,
p_report_effective_from => obj_page_layout_rec.effective_from ,
x_Report_Start_Date => l_rep_start_date ,
x_Report_End_Date => l_next_reporting_date
);
select start_date into v_proj_start_date from pa_projects_all where project_id=P_object_id_to; /* Bug8732869 */
PA_PROGRESS_REPORT_PKG.INSERT_OBJECT_PAGE_LAYOUT_ROW (
P_OBJECT_ID => p_object_id_to ,
P_OBJECT_TYPE => p_object_type ,
P_PAGE_ID => obj_page_layout_rec.page_id ,
P_PAGE_TYPE_CODE => obj_page_layout_rec.page_type_code ,
P_APPROVAL_REQUIRED => obj_page_layout_rec.approval_required ,
P_REPORTING_CYCLE_ID => obj_page_layout_rec.reporting_cycle_id ,
P_REPORTING_OFFSET_DAYS => obj_page_layout_rec.report_offset_days ,
P_NEXT_REPORTING_DATE => l_next_reporting_date , -- to_date(null), Bug 3026572
P_REMINDER_DAYS => obj_page_layout_rec.reminder_days ,
P_REMINDER_DAYS_TYPE => obj_page_layout_rec.REMINDER_DAYS_TYPE ,
P_INITIAL_PROGRESS_STATUS => obj_page_layout_rec.INITIAL_PROGRESS_STATUS ,
P_FINAL_PROGRESS_STATUS => obj_page_layout_rec.FINAL_PROGRESS_STATUS ,
P_ROLLUP_PROGRESS_STATUS => obj_page_layout_rec.ROLLUP_PROGRESS_STATUS ,
P_REPORT_TYPE_ID => obj_page_layout_rec.report_type_id ,
P_APPROVER_SOURCE_ID => obj_page_layout_rec.approver_source_id ,
P_APPROVER_SOURCE_TYPE => obj_page_layout_rec.approver_source_type ,
P_EFFECTIVE_FROM => nvl(v_proj_start_date, obj_page_layout_rec.effective_from) , /* Bug8732869 */
P_EFFECTIVE_TO => obj_page_layout_rec.effective_to ,
--P_FUNCTION_NAME => obj_page_layout_rec.effective_to , Bug 3665562 Incorrect value passed.
P_FUNCTION_NAME => obj_page_layout_rec.pers_function_name , -- Pass the correct value.
X_OBJECT_PAGE_LAYOUT_ID => l_object_page_layout_id ,
X_RETURN_STATUS => x_return_status ,
X_MSG_COUNT => x_msg_count ,
X_MSG_DATA => x_msg_data
);
PA_OBJECT_REGIONS_PKG.INSERT_ROW (
P_OBJECT_ID => p_object_id_to ,
P_OBJECT_TYPE => p_object_type ,
P_PLACEHOLDER_REG_CODE => obj_regions_rec.PLACEHOLDER_REG_CODE ,
P_REPLACEMENT_REG_CODE => obj_regions_rec.REPLACEMENT_REG_CODE ,
P_CREATION_DATE => sysdate ,
P_CREATED_BY => fnd_global.user_id ,
P_LAST_UPDATE_DATE => sysdate ,
P_LAST_UPDATED_BY => fnd_global.user_id ,
P_LAST_UPDATE_LOGIN => fnd_global.user_id
);
SELECT replacement_reg_code
FROM pa_object_regions
WHERE object_type = p_object_type
AND object_id = P_object_id
--AND placeholder_reg_code = 'PA_PROJECT_INFO'; --Bug 3745737
SELECT region_code
FROM ak_regions_vl
WHERE name = p_region_name
AND region_application_id = p_application_id;
SELECT region_code
FROM ak_regions_vl
WHERE name = p_region_source_name
AND region_application_id = p_application_id;
SELECT
descriptive_flex_context_code
FROM fnd_descr_flex_contexts_vl
WHERE application_id = p_application_id
AND descriptive_flexfield_name = p_flex_name
AND descriptive_flex_context_name = p_region_source_name;
SELECT ppl.page_id FROM
pa_page_layouts ppl, pa_page_layout_regions pplr
WHERE ppl.page_id = pplr.page_id
AND ppl.page_type_code = p_page_type_code
AND pplr.region_source_type = p_region_source_type
AND pplr.region_source_code = p_region_source_code;
SELECT descriptive_flex_context_name
FROM fnd_descr_flex_contexts_vl
WHERE descriptive_flexfield_name = 'PA_STATUS_REPORT_DESC_FLEX'
AND descriptive_flex_context_code = p_context_code
AND application_id = fnd_global.resp_appl_id; /* Added for for Bug 2634995 */
SELECT page_id
INTO x_pagelayout_id
FROM pa_page_layouts
WHERE page_id = x_pagelayout_id;
SELECT page_id
INTO x_pagelayout_id
FROM pa_page_layouts
WHERE page_name = p_pagelayout_name
AND page_type_code = p_pagetype_code;
SELECT page_id
INTO x_pagelayout_id
FROM pa_page_layouts
WHERE page_name = p_pagelayout_name
AND page_type_code = p_pagetype_code;
SELECT 'X'
FROM pa_object_page_layouts
WHERE page_id = p_page_id;
Select 'X'
FROM pa_report_types
WHERE page_id = p_page_id;
SELECT page_type_code
FROM pa_page_layouts
WHERE page_id = p_page_id;
SELECT 'X'
FROM fnd_profile_options po,
fnd_profile_option_values pov
WHERE po.application_id = 275
AND po.profile_option_name = 'PA_TEAM_HOME_PAGELAYOUT'
AND po.profile_option_id = pov.profile_option_id
AND pov.application_id = 275
AND to_number(pov.profile_option_value) = p_page_id;
Select page_id
From pa_page_layouts
Where page_type_code = v_page_type_code
And pers_function_name = v_function_name;
DELETE FROM PA_PAGE_LAYOUTS_TMP;
INSERT INTO PA_PAGE_LAYOUTS_TMP VALUES(p_page_type_code_tbl(i),p_function_name_tbl(i));