APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_PROJECTS_ALL

Line 176: p_target_project_id IN pa_projects_all.project_id%TYPE,

172: ,p_plan_version_id IN NUMBER ) RETURN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
173:
174: FUNCTION GET_DEFAULT_FP_OPTIONS(
175: p_fin_plan_preference_code IN VARCHAR2,
176: p_target_project_id IN pa_projects_all.project_id%TYPE,
177: p_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE ) RETURN FP_COLS;
178:
179: FUNCTION GET_FP_PROJ_MC_OPTIONS (p_proj_fp_options_id IN NUMBER) Return FP_MC_COLS;
180:

Line 192: p_target_project_id IN pa_projects_all.project_id%TYPE,

188: 23-JAN-2004 rravipat FP M Dev effort Bug 3354518 (IDC)
189: Initial Creation
190: =====================================================================================*/
191: FUNCTION Gen_Src_Plan_Version_Id(
192: p_target_project_id IN pa_projects_all.project_id%TYPE,
193: p_target_version_type IN pa_budget_versions.version_type%TYPE,
194: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
195: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
196: RETURN pa_budget_versions.budget_version_id%TYPE;

Line 207: p_target_project_id IN pa_projects_all.project_id%TYPE,

203: Initial Creation
204: =====================================================================================*/
205:
206: FUNCTION Gen_Src_WP_Version_Id(
207: p_target_project_id IN pa_projects_all.project_id%TYPE,
208: p_gen_src_wp_ver_code IN pa_proj_fp_options.gen_src_cost_wp_ver_code%TYPE)
209: RETURN pa_budget_versions.budget_version_id%TYPE;
210:
211: /*==================================================================================

Line 220: p_project_id IN pa_projects_all.project_id%TYPE

216: 06-Apr-2005 prachand Created as a part of WebAdi changes.
217: Initial Creation
218: ===================================================================================*/
219: PROCEDURE Create_amt_types (
220: p_project_id IN pa_projects_all.project_id%TYPE
221: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
222: ,p_plan_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
223: ,p_cost_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
224: ,p_revenue_layout_code IN pa_proj_fp_options.revenue_layout_code%TYPE

Line 240: p_source_project_id IN pa_projects_all.project_id%TYPE

236: Initial Creation
237: ===================================================================================*/
238:
239: PROCEDURE copy_amt_types (
240: p_source_project_id IN pa_projects_all.project_id%TYPE
241: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
242: ,p_target_project_id IN pa_projects_all.project_id%TYPE
243: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
244: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 242: ,p_target_project_id IN pa_projects_all.project_id%TYPE

238:
239: PROCEDURE copy_amt_types (
240: p_source_project_id IN pa_projects_all.project_id%TYPE
241: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
242: ,p_target_project_id IN pa_projects_all.project_id%TYPE
243: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
244: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
245: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
246: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 259: p_project_id IN pa_projects_all.project_id%TYPE

255: ===================================================================================*/
256:
257:
258: PROCEDURE update_amt_types (
259: p_project_id IN pa_projects_all.project_id%TYPE
260: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
261: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
262: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
263: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type