[Home] [Help]
PACKAGE: APPS.PA_FP_GEN_BUDGET_AMT_PUB
Source
1 PACKAGE PA_FP_GEN_BUDGET_AMT_PUB as
2 /* $Header: PAFPGAMS.pls 120.2 2005/07/15 10:57:09 appldev noship $ */
3
4 /**
5 * Wrapper API
6 *
7 * 23-MAY-05 dkuo Added parameters P_CHECK_SRC_ERRORS, X_WARNING_MESSAGE.
8 * Please check body of VALIDATE_SUPPORT_CASES in PAFPGAUB.pls
9 * for list of valid parameter values.
10 **/
11 PROCEDURE GENERATE_BUDGET_AMT_WRP
12 (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
13 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
14 P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
15 P_COMMIT_FLAG IN VARCHAR2 DEFAULT 'N',
16 P_INIT_MSG_FLAG IN VARCHAR2 DEFAULT 'Y',
17 P_CHECK_SRC_ERRORS_FLAG IN VARCHAR2 DEFAULT 'Y',
18 X_WARNING_MESSAGE OUT NOCOPY VARCHAR2,
19 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
20 X_MSG_COUNT OUT NOCOPY NUMBER,
21 X_MSG_DATA OUT NOCOPY VARCHAR2);
22
23
24 PROCEDURE GENERATE_BUDGET_AMT_RES_SCH
25 (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
26 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
27 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
28 P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
29 P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
30 P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
31 P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
32 P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
33 P_CALLED_MODE IN VARCHAR2 := 'SELF_SERVICE',
34 P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
35 P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
36 P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
37 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE DEFAULT NULL,
38 P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
39 PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
40 PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
41 P_COMMIT_FLAG IN VARCHAR2,
42 P_INIT_MSG_FLAG IN VARCHAR2,
43 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44 X_MSG_COUNT OUT NOCOPY NUMBER,
45 X_MSG_DATA OUT NOCOPY VARCHAR2);
46
47 PROCEDURE CREATE_RES_ASG
48 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
49 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
50 P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
51 P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
52 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
53 P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE DEFAULT NULL,
54 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55 X_MSG_COUNT OUT NOCOPY NUMBER,
56 X_MSG_DATA OUT NOCOPY VARCHAR2);
57
58 PROCEDURE UPDATE_RES_ASG
59 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
60 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
61 P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
62 P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
63 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
64 P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE DEFAULT NULL,
65 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
66 X_MSG_COUNT OUT NOCOPY NUMBER,
67 X_MSG_DATA OUT NOCOPY VARCHAR2);
68
69
70 PROCEDURE DEL_MANUAL_BDGT_LINES
71 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
72 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
73 PX_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
74 PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
75 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
76 X_MSG_COUNT OUT NOCOPY NUMBER,
77 X_MSG_DATA OUT NOCOPY VARCHAR2);
78
79 PROCEDURE UPDATE_INIT_AMOUNTS
80 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
81 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
82 P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
83 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
84 X_MSG_COUNT OUT NOCOPY NUMBER,
85 X_MSG_DATA OUT NOCOPY VARCHAR2);
86
87
88 PROCEDURE UPDATE_BV_FOR_GEN_DATE
89 (P_PROJECT_ID IN
90 PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
91 P_BUDGET_VERSION_ID IN
92 PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
93 P_ETC_START_DATE IN
94 PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE DEFAULT NULL,
95 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96 X_MSG_COUNT OUT NOCOPY NUMBER,
97 X_MSG_DATA OUT NOCOPY VARCHAR2);
98
99 PROCEDURE GET_GENERATED_RES_ASG
100 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
101 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
102 PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
103 P_CHK_DUPLICATE_FLAG IN VARCHAR2 := 'N',
104 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
105 X_MSG_COUNT OUT NOCOPY NUMBER,
106 X_MSG_DATA OUT NOCOPY VARCHAR2);
107
108 PROCEDURE INSERT_TXN_CURRENCY
109 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE DEFAULT NULL,
110 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
111 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS DEFAULT NULL,
112 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
113 X_MSG_COUNT OUT NOCOPY NUMBER,
114 X_MSG_DATA OUT NOCOPY VARCHAR2);
115
116 PROCEDURE RESET_COST_AMOUNTS
117 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
118 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
119 X_MSG_COUNT OUT NOCOPY NUMBER,
120 X_MSG_DATA OUT NOCOPY VARCHAR2);
121
122 PROCEDURE GEN_REV_BDGT_AMT_RES_SCH_WRP
123 (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
124 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
125 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
126 P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
127 P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
128 P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
129 P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
130 P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
131 P_CALLED_MODE IN VARCHAR2 := 'SELF_SERVICE',
132 P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
133 P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
134 P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
135 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE DEFAULT NULL,
136 P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
137 PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
138 PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
139 P_COMMIT_FLAG IN VARCHAR2,
140 P_INIT_MSG_FLAG IN VARCHAR2,
141 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
142 X_MSG_COUNT OUT NOCOPY NUMBER,
143 X_MSG_DATA OUT NOCOPY VARCHAR2);
144
145 PROCEDURE GEN_WP_REV_BDGT_AMT_WRP
146 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
147 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
148 P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE
149 default 'Budget',
150 P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE
151 default 'WORKPLAN_RESOURCES',
152 P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
153 P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE
154 default null,
155 P_RETAIN_MANUAL_FLAG IN VARCHAR2 default null,
156 P_CALLED_MODE IN VARCHAR2 default 'SELF_SERVICE',
157 P_INC_CHG_DOC_FLAG IN VARCHAR2 default 'N',
158 P_INC_BILL_EVENT_FLAG IN VARCHAR2 default 'N',
159 P_INC_OPEN_COMMIT_FLAG IN VARCHAR2 default 'N',
160 P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp
161 default PA_PLSQL_DATATYPES.EmptyIdTab,
162 P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
163 P_COMMIT_FLAG IN VARCHAR2 default 'N',
164 PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
165 PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
166 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
167 X_MSG_COUNT OUT NOCOPY NUMBER,
168 X_MSG_DATA OUT NOCOPY VARCHAR2);
169
170 END PA_FP_GEN_BUDGET_AMT_PUB;