APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_PROJECTS_ALL

Line 170: p_target_project_id IN pa_projects_all.project_id%TYPE,

166: ,p_plan_version_id IN NUMBER ) RETURN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
167:
168: FUNCTION GET_DEFAULT_FP_OPTIONS(
169: p_fin_plan_preference_code IN VARCHAR2,
170: p_target_project_id IN pa_projects_all.project_id%TYPE,
171: p_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE ) RETURN FP_COLS;
172:
173: FUNCTION GET_FP_PROJ_MC_OPTIONS (p_proj_fp_options_id IN NUMBER) Return FP_MC_COLS;
174:

Line 186: p_target_project_id IN pa_projects_all.project_id%TYPE,

182: 23-JAN-2004 rravipat FP M Dev effort Bug 3354518 (IDC)
183: Initial Creation
184: =====================================================================================*/
185: FUNCTION Gen_Src_Plan_Version_Id(
186: p_target_project_id IN pa_projects_all.project_id%TYPE,
187: p_target_version_type IN pa_budget_versions.version_type%TYPE,
188: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
189: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
190: RETURN pa_budget_versions.budget_version_id%TYPE;

Line 201: p_target_project_id IN pa_projects_all.project_id%TYPE,

197: Initial Creation
198: =====================================================================================*/
199:
200: FUNCTION Gen_Src_WP_Version_Id(
201: p_target_project_id IN pa_projects_all.project_id%TYPE,
202: p_gen_src_wp_ver_code IN pa_proj_fp_options.gen_src_cost_wp_ver_code%TYPE)
203: RETURN pa_budget_versions.budget_version_id%TYPE;
204:
205: /*==================================================================================

Line 214: p_project_id IN pa_projects_all.project_id%TYPE

210: 06-Apr-2005 prachand Created as a part of WebAdi changes.
211: Initial Creation
212: ===================================================================================*/
213: PROCEDURE Create_amt_types (
214: p_project_id IN pa_projects_all.project_id%TYPE
215: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
216: ,p_plan_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
217: ,p_cost_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
218: ,p_revenue_layout_code IN pa_proj_fp_options.revenue_layout_code%TYPE

Line 234: p_source_project_id IN pa_projects_all.project_id%TYPE

230: Initial Creation
231: ===================================================================================*/
232:
233: PROCEDURE copy_amt_types (
234: p_source_project_id IN pa_projects_all.project_id%TYPE
235: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
236: ,p_target_project_id IN pa_projects_all.project_id%TYPE
237: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
238: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 236: ,p_target_project_id IN pa_projects_all.project_id%TYPE

232:
233: PROCEDURE copy_amt_types (
234: p_source_project_id IN pa_projects_all.project_id%TYPE
235: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
236: ,p_target_project_id IN pa_projects_all.project_id%TYPE
237: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
238: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
239: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
240: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 253: p_project_id IN pa_projects_all.project_id%TYPE

249: ===================================================================================*/
250:
251:
252: PROCEDURE update_amt_types (
253: p_project_id IN pa_projects_all.project_id%TYPE
254: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
255: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
256: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
257: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type