[Home] [Help]
PACKAGE: APPS.PA_FP_REFRESH_ELEMENTS_PUB
Source
1 PACKAGE pa_fp_refresh_elements_pub AS
2 /* $Header: PAFPPERS.pls 120.1 2005/08/19 16:28:03 mwasowic noship $ */
3 PROCEDURE get_refresh_plan_ele_dtls(
4 p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5 DEFAULT NULL,
6 p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
7 DEFAULT NULL,
8 x_request_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
9 x_process_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
10 x_refresh_required_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
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
16 PROCEDURE set_process_flag_opt(
17 p_project_id IN pa_projects_all.project_id%TYPE,
18 p_request_id IN pa_budget_versions.request_id%TYPE,
19 p_process_code IN pa_budget_versions.plan_processing_code%TYPE,
20 p_refresh_required_flag IN VARCHAR2,
21 p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
22 DEFAULT NULL,
23 p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
24 DEFAULT NULL,
25 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
26 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
27 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
28
29 PROCEDURE set_process_flag_proj(
30 p_project_id IN pa_projects_all.project_id%TYPE,
31 p_request_id IN pa_budget_versions.request_id%TYPE,
32 p_process_code IN pa_budget_versions.plan_processing_code%TYPE,
33 p_refresh_required_flag IN VARCHAR2,
34 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
35 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
36 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
37
38 PROCEDURE refresh_planning_elements(
39 p_project_id IN pa_projects_all.project_id%TYPE,
40 p_request_id IN pa_budget_versions.request_id%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 PROCEDURE update_process_status_auto( p_fp_opt_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
46 p_return_status IN VARCHAR2,
47 p_project_id IN NUMBER,
48 p_request_id IN NUMBER,
49 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
50 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
51 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
52
53 PROCEDURE update_process_status( p_fp_opt_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
54 p_return_status IN VARCHAR2,
55 p_project_id IN NUMBER,
56 p_request_id IN NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
59 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
60
61 PROCEDURE fp_write_log_ss_or_conc(
62 p_calling_context IN VARCHAR2,
63 p_msg IN VARCHAR2,
64 p_log_level IN NUMBER,
65 p_module IN VARCHAR2 );
66
67 END pa_fp_refresh_elements_pub;