1 PACKAGE AMW_IMPORT_STMNTS_ACCS_PKG AUTHID CURRENT_USER AS
2 /* $Header: amwacims.pls 120.0.12000000.1 2007/01/16 20:37:12 appldev ship $ */
3
4 -- ===============================================================
5 -- Start of Comments
6 -- Package name
7 -- AMW_IMPORT_STMNTS_ACCS_PKG
8 -- Purpose
9 -- Contains the PL/Sql Procedures that suppots the import
10 -- of Financial Statements,Financial Items and Accounts
11 -- History
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17 PROCEDURE import_accounts(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2) ;
18
19 PROCEDURE import_statements(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2, P_RUN_ID in NUMBER) ;
20
21 PROCEDURE get_stmnts_from_oracle_apps(P_RUN_ID in NUMBER) ;
22 PROCEDURE end_date_stmnts_after_import(P_RUNID NUMBER, P_STATEMENT_GROUP_ID NUMBER);
23
24 PROCEDURE get_stmnts_accs_oracle_apps(P_RUN_ID in NUMBER, P_STATEMENT_GROUP_ID in NUMBER);
25 PROCEDURE get_stmnts_from_external_apps(P_RUN_ID in NUMBER) ;
26
27 PROCEDURE get_acc_from_oracle_apps;
28 PROCEDURE get_acc_from_external_apps;
29 PROCEDURE get_acc_name_from_oracle_apps(p_group_id in number, p_flex_value_id in number);
30 Function check_acc_profiles_has_value return boolean ;
31 Function check_stmnt_profiles_has_value return boolean ;
32 Function check_key_accounts_exists return boolean ;
33 Function check_account_value_set return boolean ;
34
35
36 PROCEDURE INSERT_ROW (
37 X_ACCOUNT_GROUP_ID in out NOCOPY NUMBER,
38 X_NATURAL_ACCOUNT_ID in NUMBER,
39 X_NATURAL_ACCOUNT_VALUE in VARCHAR2,
40 X_END_DATE in DATE,
41 X_LAST_UPDATE_DATE in DATE,
42 X_LAST_UPDATED_BY in NUMBER,
43 X_LAST_UPDATE_LOGIN in NUMBER,
44 X_CREATION_DATE IN DATE,
45 X_CREATED_BY in NUMBER,
46 X_ATTRIBUTE_CATEGORY in VARCHAR2,
47 X_ATTRIBUTE1 in VARCHAR2,
48 X_ATTRIBUTE2 in VARCHAR2,
49 X_ATTRIBUTE3 in VARCHAR2,
50 X_ATTRIBUTE4 in VARCHAR2,
51 X_ATTRIBUTE5 in VARCHAR2,
52 X_ATTRIBUTE6 in VARCHAR2,
53 X_ATTRIBUTE7 in VARCHAR2,
54 X_ATTRIBUTE8 in VARCHAR2,
55 X_ATTRIBUTE9 in VARCHAR2,
56 X_ATTRIBUTE10 in VARCHAR2,
57 X_ATTRIBUTE11 in VARCHAR2,
58 X_ATTRIBUTE12 in VARCHAR2,
59 X_ATTRIBUTE13 in VARCHAR2,
60 X_ATTRIBUTE14 in VARCHAR2,
61 X_ATTRIBUTE15 in VARCHAR2,
62 X_PARENT_NATURAL_ACCOUNT_ID in NUMBER);
63
64 procedure INSERT_ROW_TL (
65 X_ACCOUNT_GROUP_ID in out NOCOPY NUMBER,
66 X_NATURAL_ACCOUNT_ID in NUMBER,
67 X_NAME in VARCHAR2,
68 X_LANGUAGE in VARCHAR2,
69 X_SOURCE_LANGUAGE in VARCHAR2,
70 -- X_OBJECT_TYPE VARCHAR2,
71 X_SECURITY_GROUP_ID in NUMBER,
72 X_OBJECT_VERSION_NUMBER in NUMBER,
73 X_ORIG_SYSTEM_REFERENCE in VARCHAR2,
74 X_LAST_UPDATE_DATE in DATE,
75 X_LAST_UPDATED_BY in NUMBER,
76 X_LAST_UPDATE_LOGIN in NUMBER,
77 X_CREATION_DATE DATE,
78 X_CREATED_BY in NUMBER
79 ) ;
80
81
82 procedure INSERT_STMNT_ROW (
83 X_STATEMENT_GROUP_ID in NUMBER,
84 X_FINANCIAL_STATEMENT_ID in NUMBER,
85 X_END_DATE in DATE,
86 X_LAST_UPDATE_DATE in DATE,
87 X_LAST_UPDATED_BY in NUMBER,
88 X_LAST_UPDATE_LOGIN in NUMBER,
89 X_CREATION_DATE in DATE,
90 X_CREATED_BY in NUMBER,
91 X_ATTRIBUTE_CATEGORY in VARCHAR2,
92 X_ATTRIBUTE1 in VARCHAR2,
93 X_ATTRIBUTE2 in VARCHAR2,
94 X_ATTRIBUTE3 in VARCHAR2,
95 X_ATTRIBUTE4 in VARCHAR2,
96 X_ATTRIBUTE5 in VARCHAR2,
97 X_ATTRIBUTE6 in VARCHAR2,
98 X_ATTRIBUTE7 in VARCHAR2,
99 X_ATTRIBUTE8 in VARCHAR2,
100 X_ATTRIBUTE9 in VARCHAR2,
101 X_ATTRIBUTE10 in VARCHAR2,
102 X_ATTRIBUTE11 in VARCHAR2,
103 X_ATTRIBUTE12 in VARCHAR2,
104 X_ATTRIBUTE13 in VARCHAR2,
105 X_ATTRIBUTE14 in VARCHAR2,
106 X_ATTRIBUTE15 in VARCHAR2,
107 X_SECURITY_GROUP_ID in NUMBER,
108 X_OBJECT_VERSION_NUMBER in NUMBER);
109
110 procedure INSERT_STMNT_ROW_TL (
111 X_STATEMENT_GROUP_ID in NUMBER,
112 X_FINANCIAL_STATEMENT_ID in NUMBER,
113 X_NAME in VARCHAR2,
114 X_LANGUAGE in VARCHAR2,
115 X_SOURCE_LANGUAGE in VARCHAR2,
116 X_SECURITY_GROUP_ID in NUMBER,
117 X_OBJECT_VERSION_NUMBER in NUMBER,
118 X_ORIG_SYSTEM_REFERENCE in VARCHAR2,
119 X_LAST_UPDATE_DATE in DATE,
120 X_LAST_UPDATED_BY in NUMBER,
121 X_LAST_UPDATE_LOGIN in NUMBER,
122 X_CREATION_DATE DATE,
123 X_CREATED_BY in NUMBER
124 ) ;
125
126 procedure INSERT_FINITEM_ROW (
127 X_STATEMENT_GROUP_ID in NUMBER,
128 X_FINANCIAL_STATEMENT_ID in NUMBER,
129 X_FINANCIAL_ITEM_ID IN NUMBER,
130 X_PARENT_FINANCIAL_ITEM_ID IN NUMBER,
131 X_SEQUENCE_NUMBER in NUMBER,
132 X_LAST_UPDATE_DATE in DATE,
133 X_LAST_UPDATED_BY in NUMBER,
134 X_LAST_UPDATE_LOGIN in NUMBER,
135 X_CREATION_DATE in DATE,
136 X_CREATED_BY in NUMBER,
137 X_ATTRIBUTE_CATEGORY in VARCHAR2,
138 X_ATTRIBUTE1 in VARCHAR2,
139 X_ATTRIBUTE2 in VARCHAR2,
140 X_ATTRIBUTE3 in VARCHAR2,
141 X_ATTRIBUTE4 in VARCHAR2,
142 X_ATTRIBUTE5 in VARCHAR2,
143 X_ATTRIBUTE6 in VARCHAR2,
144 X_ATTRIBUTE7 in VARCHAR2,
145 X_ATTRIBUTE8 in VARCHAR2,
146 X_ATTRIBUTE9 in VARCHAR2,
147 X_ATTRIBUTE10 in VARCHAR2,
148 X_ATTRIBUTE11 in VARCHAR2,
149 X_ATTRIBUTE12 in VARCHAR2,
150 X_ATTRIBUTE13 in VARCHAR2,
151 X_ATTRIBUTE14 in VARCHAR2,
152 X_ATTRIBUTE15 in VARCHAR2,
153 X_SECURITY_GROUP_ID in NUMBER,
154 X_OBJECT_VERSION_NUMBER in NUMBER);
155
156
157 procedure INSERT_FINITEM_ROW_TL (
158 X_STATEMENT_GROUP_ID in NUMBER,
159 X_FINANCIAL_STATEMENT_ID in NUMBER,
160 X_FINANCIAL_ITEM_ID IN NUMBER,
161 X_NAME in VARCHAR2,
162 X_LANGUAGE in VARCHAR2,
163 X_SOURCE_LANGUAGE in VARCHAR2,
164 X_SECURITY_GROUP_ID in NUMBER,
165 X_OBJECT_VERSION_NUMBER in NUMBER,
166 X_ORIG_SYSTEM_REFERENCE in VARCHAR2,
167 X_LAST_UPDATE_DATE in DATE,
168 X_LAST_UPDATED_BY in NUMBER,
169 X_LAST_UPDATE_LOGIN in NUMBER,
170 X_CREATION_DATE DATE,
171 X_CREATED_BY in NUMBER);
172
173 procedure INSERT_FINITEM_ACC_MAP (
174 X_STATEMENT_GROUP_ID in NUMBER,
175 X_ACCOUNT_GROUP_ID in NUMBER,
176 X_FINANCIAL_STATEMENT_ID in NUMBER,
177 X_FINANCIAL_ITEM_ID IN NUMBER,
178 X_NATURAL_ACCOUNT_ID in NUMBER,
179 X_LAST_UPDATE_DATE in DATE,
180 X_LAST_UPDATED_BY in NUMBER,
181 X_LAST_UPDATE_LOGIN in NUMBER,
182 X_CREATION_DATE in DATE,
183 X_CREATED_BY in NUMBER,
184 X_ATTRIBUTE_CATEGORY in VARCHAR2,
185 X_ATTRIBUTE1 in VARCHAR2,
186 X_ATTRIBUTE2 in VARCHAR2,
187 X_ATTRIBUTE3 in VARCHAR2,
188 X_ATTRIBUTE4 in VARCHAR2,
189 X_ATTRIBUTE5 in VARCHAR2,
190 X_ATTRIBUTE6 in VARCHAR2,
191 X_ATTRIBUTE7 in VARCHAR2,
192 X_ATTRIBUTE8 in VARCHAR2,
193 X_ATTRIBUTE9 in VARCHAR2,
194 X_ATTRIBUTE10 in VARCHAR2,
195 X_ATTRIBUTE11 in VARCHAR2,
196 X_ATTRIBUTE12 in VARCHAR2,
197 X_ATTRIBUTE13 in VARCHAR2,
198 X_ATTRIBUTE14 in VARCHAR2,
199 X_ATTRIBUTE15 in VARCHAR2,
200 X_SECURITY_GROUP_ID in NUMBER,
201 X_OBJECT_VERSION_NUMBER in NUMBER);
202
203 procedure flatten_accounts ( x_group_id in number );
204 procedure flatten_items ( x_group_id in number );
205
206 END AMW_IMPORT_STMNTS_ACCS_PKG;