eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_REFRESH_ELEMENTS_PUB dependencies on PA_BUDGET_VERSIONS

Line 63: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

59: request id , processing code and a flag which indicates whether the record
60: requires a planning elements refresh or not. */
61:
62: PROCEDURE get_refresh_plan_ele_dtls(
63: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
64: DEFAULT NULL,
65: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
66: DEFAULT NULL,
67: x_request_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 85: p_request_id IN pa_budget_versions.request_id%TYPE,

81: records ) in both budget versions and proj fp options table.
82: */
83: PROCEDURE set_process_flag_opt(
84: p_project_id IN pa_projects_all.project_id%TYPE,
85: p_request_id IN pa_budget_versions.request_id%TYPE,
86: p_process_code IN pa_budget_versions.plan_processing_code%TYPE,
87: p_refresh_required_flag IN VARCHAR2,
88: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
89: DEFAULT NULL,

Line 86: p_process_code IN pa_budget_versions.plan_processing_code%TYPE,

82: */
83: PROCEDURE set_process_flag_opt(
84: p_project_id IN pa_projects_all.project_id%TYPE,
85: p_request_id IN pa_budget_versions.request_id%TYPE,
86: p_process_code IN pa_budget_versions.plan_processing_code%TYPE,
87: p_refresh_required_flag IN VARCHAR2,
88: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
89: DEFAULT NULL,
90: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

Line 90: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

86: p_process_code IN pa_budget_versions.plan_processing_code%TYPE,
87: p_refresh_required_flag IN VARCHAR2,
88: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
89: DEFAULT NULL,
90: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
91: DEFAULT NULL,
92: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
93: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
94: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 108: p_request_id IN pa_budget_versions.request_id%TYPE,

104: */
105:
106: PROCEDURE set_process_flag_proj(
107: p_project_id IN pa_projects_all.project_id%TYPE,
108: p_request_id IN pa_budget_versions.request_id%TYPE,
109: p_process_code IN pa_budget_versions.plan_processing_code%TYPE,
110: p_refresh_required_flag IN VARCHAR2,
111: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
112: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 109: p_process_code IN pa_budget_versions.plan_processing_code%TYPE,

105:
106: PROCEDURE set_process_flag_proj(
107: p_project_id IN pa_projects_all.project_id%TYPE,
108: p_request_id IN pa_budget_versions.request_id%TYPE,
109: p_process_code IN pa_budget_versions.plan_processing_code%TYPE,
110: p_refresh_required_flag IN VARCHAR2,
111: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
112: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
113: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 120: p_request_id IN pa_budget_versions.request_id%TYPE,

116: END set_process_flag_proj;
117:
118: PROCEDURE refresh_planning_elements(
119: p_project_id IN pa_projects_all.project_id%TYPE,
120: p_request_id IN pa_budget_versions.request_id%TYPE,
121: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
122: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
123: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
124: l_impacted_tasks_rec PA_FP_ELEMENTS_PUB.l_wbs_refresh_tasks_tbl_typ;

Line 185: pa_budget_versions bv

181: plan_processing_code = 'WUP'
182: UNION ALL
183: SELECT proj_fp_options_id proj_fp_options_id, 'BV' l_tname FROM
184: pa_proj_fp_options opt,
185: pa_budget_versions bv
186: WHERE
187: opt.project_id = p_project_id AND
188: opt.fin_plan_option_level_code = 'PLAN_VERSION' AND
189: bv.budget_version_id = opt.fin_plan_version_id AND

Line 215: pa_budget_versions bv

211: NVL(process_update_wbs_flag,'N') = 'Y'
212: UNION ALL
213: SELECT proj_fp_options_id proj_fp_options_id, 'BV' l_tname FROM
214: pa_proj_fp_options opt,
215: pa_budget_versions bv
216: WHERE
217: opt.project_id = p_project_id AND
218: opt.fin_plan_option_level_code = 'PLAN_VERSION' AND
219: bv.locked_by_person_id IS NULL AND /* Bug 3091568 */