1 package PA_STATUS_COLUMN_SETUP_PKG as
2 /* $Header: PAREPSCS.pls 120.4 2005/08/19 16:50:33 mwasowic ship $ */
3 -- g_insertflag is used to indicate whether the system should upload data into
4 -- the PA_STATUS_COLUMN_SETUP table. Upload is yes when g_insertflag is true
5 -- and no if g_insertflag is false.
6 g_insertflag BOOLEAN := NULL;
7 procedure INSERT_ROW (
8 X_FOLDER_CODE in VARCHAR2,
9 X_COLUMN_ORDER in NUMBER,
10 X_FORMAT_CODE in VARCHAR2,
11 X_COLUMN_NAME in VARCHAR2,
12 X_CURRENCY_FORMAT_FLAG in VARCHAR2,
13 X_TOTAL_FLAG in VARCHAR2,
14 X_COLUMN_PROMPT in VARCHAR2,
15 X_CREATION_DATE in DATE,
16 X_CREATED_BY in NUMBER,
17 X_LAST_UPDATE_DATE in DATE,
18 X_LAST_UPDATED_BY in NUMBER,
19 X_LAST_UPDATE_LOGIN in NUMBER);
20 procedure TRANSLATE_ROW (
21 X_FOLDER_CODE in VARCHAR2,
22 X_COLUMN_ORDER in NUMBER,
23 X_FORMAT_CODE in VARCHAR2,
24 X_OWNER in VARCHAR2,
25 X_COLUMN_PROMPT in VARCHAR2);
26 procedure GET_INSERT_STATUS (
27 X_INSERTFLAG out NOCOPY BOOLEAN --File.Sql.39 bug 4440895
28 );
29 end PA_STATUS_COLUMN_SETUP_PKG;