[Home] [Help]
PACKAGE: APPS.PA_PLAN_MATRIX
Source
1 PACKAGE Pa_Plan_Matrix AS
2 /* $Header: PARPLMXS.pls 120.1 2005/08/19 16:58:12 mwasowic noship $ */
3 TYPE amount_type_record IS RECORD( amount_type_code varchar2(30),
4 amount_subtype_code varchar2(30),
5 amount_type_id number(15),
6 amount_subtype_id number(15));
7
8 TYPE amount_type_tabtyp IS TABLE OF AMOUNT_TYPE_RECORD INDEX BY BINARY_INTEGER;
9
10 PROCEDURE Maintain_Plan_Matrix
11 (
12 p_amount_type_tab IN pa_plan_matrix.amount_type_tabtyp,
13 p_period_profile_id IN NUMBER,
14 p_prior_period_flag IN VARCHAR2,
15 p_commit_Flag IN VARCHAR2 DEFAULT 'N',
16 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
17 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
18 x_msg_data OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
19 p_budget_version_id IN NUMBER,
20 p_project_id IN NUMBER,
21 p_debug_mode IN VARCHAR2 DEFAULT 'N',
22 p_add_msg_in_stack IN VARCHAR2 DEFAULT 'N',
23 p_calling_module IN VARCHAR2 DEFAULT 'ORG_FORECAST'
24 );
25
26 PROCEDURE Get_Period_Info
27 (
28 p_bucketing_period_code IN VARCHAR2,
29 p_st_dt_4_st_pd IN DATE,
30 p_st_dt_4_end_pd IN DATE,
31 p_plan_period_type IN VARCHAR2,
32 p_project_id IN NUMBER,
33 p_budget_version_id IN NUMBER,
34 p_resource_assignment_id IN NUMBER,
35 p_transaction_currency_code IN VARCHAR2,
36 x_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
37 x_end_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
38 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
39 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
41 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
42 );
43
44 PROCEDURE Populate_Budget_Lines
45 (
46 p_bucketing_period_code IN VARCHAR2,
47 p_st_dt_4_st_pd IN DATE,
48 p_st_dt_4_end_pd IN DATE,
49 p_plan_period_type IN VARCHAR2,
50 p_project_id IN NUMBER,
51 p_budget_version_id IN NUMBER,
52 p_project_currency_code IN VARCHAR2,
53 p_projfunc_currency_code IN VARCHAR2,
54 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
55 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
56 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57 );
58
59 END Pa_Plan_Matrix;