[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;