DBA Data[Home] [Help]

PACKAGE: APPS.PA_FP_CI_INCLUDE_PKG

Source


1 PACKAGE pa_fp_ci_include_pkg as
2 /* $Header: PAFPINCS.pls 120.1 2005/08/19 16:26:54 mwasowic noship $ */
3 
4 --Copy exception
5 RAISE_COPY_CI_ERROR   EXCEPTION;
6 PRAGMA EXCEPTION_INIT(RAISE_COPY_CI_ERROR, -503);
7 
8 
9  PROCEDURE FP_CI_COPY_CONTROL_ITEMS
10  (
11    p_project_id			IN pa_budget_versions.project_id%TYPE,
12    p_source_ci_id_tbl		IN PA_PLSQL_DATATYPES.IdTabTyp,
13    p_target_ci_id		IN pa_budget_versions.ci_id%TYPE,
14    p_merge_unmerge_mode		IN VARCHAR2 DEFAULT 'MERGE',
15    p_commit_flag		IN VARCHAR2 DEFAULT 'N',
16    p_init_msg_list		IN VARCHAR2 DEFAULT 'N',
17    p_calling_context		IN VARCHAR2 DEFAULT 'COPY',
18    x_warning_flag		OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
19    x_msg_data          		OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
20    x_msg_count         		OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
21    x_return_status     		OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22  );
23 
24 /*=============================================================================
25  This api is called to create financial realted impacts in pa_ci_impacts during
26  change document inclusion or change document copy.
27 
28  02-Jul-2004   rravipat  Bug 3677924
29                          Initial Creation
30 ==============================================================================*/
31 
32 PROCEDURE populate_ci_fin_impact_records(
33           p_project_id           IN   pa_projects_all.project_id%TYPE
34           ,p_source_ci_id        IN   pa_budget_versions.ci_id%TYPE
35           ,p_target_ci_id        IN   pa_budget_versions.ci_id%TYPE
36           ,p_calling_context     IN   VARCHAR2
37           ,x_return_status       OUT  NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
38           ,x_msg_count           OUT  NOCOPY NUMBER --File.Sql.39 bug 4440895
39           ,x_msg_data            OUT  NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
40 
41 end pa_fp_ci_include_pkg;