1 PACKAGE pa_fp_txn_currencies_pub AUTHID CURRENT_USER AS
2 /* $Header: PAFPTXCS.pls 120.1 2005/08/19 16:30:43 mwasowic noship $ */
3
4
5 PROCEDURE Copy_Fp_Txn_Currencies (
6 p_source_fp_option_id IN NUMBER
7 ,p_target_fp_option_id IN NUMBER
8 ,p_target_fp_preference_code IN VARCHAR2
9 ,p_plan_in_multi_curr_flag IN VARCHAR2
10 ,p_approved_rev_plan_type_flag IN VARCHAR2 default null--For Bug 2998696
11 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
14
15 PROCEDURE Insert_Default_Currencies(
16 p_project_id IN NUMBER
17 ,p_fin_plan_type_id IN NUMBER
18 ,p_fin_plan_preference_code IN VARCHAR2
19 ,p_fin_plan_version_id IN NUMBER
20 ,p_project_currency_code IN VARCHAR2
21 ,p_projfunc_currency_code IN VARCHAR2
22 ,p_approved_rev_plan_type_flag IN VARCHAR2
23 ,p_target_fp_option_id IN NUMBER );
24
25 PROCEDURE Set_Default_Currencies(
26 p_target_fp_option_id IN NUMBER
27 ,p_target_preference_code IN VARCHAR2
28 ,p_approved_rev_plan_type_flag IN VARCHAR2
29 ,p_srce_all_default_curr_code IN VARCHAR2
30 ,p_srce_rev_default_curr_code IN VARCHAR2
31 ,p_srce_cost_default_curr_code IN VARCHAR2
32 ,p_project_currency_code IN VARCHAR2
33 ,p_projfunc_currency_code IN VARCHAR2 );
34
35 PROCEDURE enter_agreement_curr_for_ci
36 ( p_project_id IN pa_budget_versions.project_id%TYPE
37 ,p_fin_plan_version_id IN pa_budget_versions.budget_Version_id%TYPE
38 ,p_ci_id IN pa_budget_Versions.ci_id%TYPE
39 ,p_project_currency_code IN pa_projects.project_currency_code%TYPE
40 ,p_projfunc_currency_code IN pa_projects.projfunc_currency_code%TYPE
41 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
42 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
43 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
44
45 /* Added for bug #2632410. */
46 FUNCTION Insert_Only_Projfunc_Curr( p_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE
47 ,p_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE default null)--for bug 2998696
48 RETURN BOOLEAN;
49
50 END pa_fp_txn_currencies_pub;