PACKAGE: APPS.ITA_SETUP_PARAMETERS_PKG

Source

1 package ITA_SETUP_PARAMETERS_PKG as
2 /* $Header: itastprs.pls 120.3 2005/09/22 15:24:02 cpetriuc noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_PARAMETER_CODE in VARCHAR2,
6   X_SELECT_CLAUSE in VARCHAR2,
7   X_FROM_CLAUSE in VARCHAR2,
8   X_WHERE_CLAUSE in VARCHAR2,
9   X_END_DATE in DATE,
10   X_MIGRATED_FLAG in VARCHAR2,
11   X_OBJECT_VERSION_NUMBER in NUMBER,
12   X_FK_COLUMN_ID in NUMBER,
13   X_CONTEXT_SEQUENCE_NUM in NUMBER,
14   X_AUDIT_ENABLED_FLAG in VARCHAR2,
15   X_FK_TABLE_ID in NUMBER,
16   X_FK_TABLE_APP_ID in NUMBER,
17   X_SETUP_GROUP_CODE in VARCHAR2,
18   X_COLUMN_ID in NUMBER,
19   X_CONTEXT_PREDICATE_FLAG in VARCHAR2,
20   X_PARAMETER_NAME in VARCHAR2,
21   X_CREATION_DATE in DATE,
22   X_CREATED_BY in NUMBER,
23   X_LAST_UPDATE_DATE in DATE,
24   X_LAST_UPDATED_BY in NUMBER,
25   X_LAST_UPDATE_LOGIN in NUMBER,
26   X_COLUMN_REFERENCE1  in VARCHAR2,
27   X_COLUMN_REFERENCE2  in VARCHAR2
28 );
29 procedure LOCK_ROW (
30   X_PARAMETER_CODE in VARCHAR2,
31   X_SELECT_CLAUSE in VARCHAR2,
32   X_FROM_CLAUSE in VARCHAR2,
33   X_WHERE_CLAUSE in VARCHAR2,
34   X_END_DATE in DATE,
35   X_MIGRATED_FLAG in VARCHAR2,
36   X_OBJECT_VERSION_NUMBER in NUMBER,
37   X_FK_COLUMN_ID in NUMBER,
38   X_CONTEXT_SEQUENCE_NUM in NUMBER,
39   X_AUDIT_ENABLED_FLAG in VARCHAR2,
40   X_FK_TABLE_ID in NUMBER,
41   X_FK_TABLE_APP_ID in NUMBER,
42   X_SETUP_GROUP_CODE in VARCHAR2,
43   X_COLUMN_ID in NUMBER,
44   X_CONTEXT_PREDICATE_FLAG in VARCHAR2,
45   X_PARAMETER_NAME in VARCHAR2,
46   X_COLUMN_REFERENCE1  in VARCHAR2,
47   X_COLUMN_REFERENCE2  in VARCHAR2
48 );
49 procedure UPDATE_ROW (
50   X_PARAMETER_CODE in VARCHAR2,
51   X_SELECT_CLAUSE in VARCHAR2,
52   X_FROM_CLAUSE in VARCHAR2,
53   X_WHERE_CLAUSE in VARCHAR2,
54   X_END_DATE in DATE,
55   X_MIGRATED_FLAG in VARCHAR2,
56   X_OBJECT_VERSION_NUMBER in NUMBER,
57   X_FK_COLUMN_ID in NUMBER,
58   X_CONTEXT_SEQUENCE_NUM in NUMBER,
59   X_AUDIT_ENABLED_FLAG in VARCHAR2,
60   X_FK_TABLE_ID in NUMBER,
61   X_FK_TABLE_APP_ID in NUMBER,
62   X_SETUP_GROUP_CODE in VARCHAR2,
63   X_COLUMN_ID in NUMBER,
64   X_CONTEXT_PREDICATE_FLAG in VARCHAR2,
65   X_PARAMETER_NAME in VARCHAR2,
66   X_LAST_UPDATE_DATE in DATE,
67   X_LAST_UPDATED_BY in NUMBER,
68   X_LAST_UPDATE_LOGIN in NUMBER,
69   X_COLUMN_REFERENCE1  in VARCHAR2,
70   X_COLUMN_REFERENCE2  in VARCHAR2
71 );
72 procedure DELETE_ROW (
73   X_PARAMETER_CODE in VARCHAR2
74 );
75 procedure ADD_LANGUAGE;
76 
77 procedure LOAD_ROW (
78   X_PARAMETER_CODE in VARCHAR2,
79   X_SELECT_CLAUSE in VARCHAR2,
80   X_FROM_CLAUSE in VARCHAR2,
81   X_WHERE_CLAUSE in VARCHAR2,
82   X_END_DATE in DATE,
83   X_MIGRATED_FLAG in VARCHAR2,
84   X_OBJECT_VERSION_NUMBER in NUMBER,
85   X_CONTEXT_SEQUENCE_NUM in NUMBER,
86   X_AUDIT_ENABLED_FLAG in VARCHAR2,
87   X_SETUP_GROUP_CODE in VARCHAR2,
88   X_COLUMN_NAME in VARCHAR2,
89   X_CONTEXT_PREDICATE_FLAG in VARCHAR2,
90   X_PARAMETER_NAME in VARCHAR2,
91   X_LAST_UPDATE_DATE in VARCHAR2,
92   X_OWNER in VARCHAR2,
93   X_CUSTOM_MODE IN VARCHAR2,
94   X_COLUMN_REFERENCE1  in VARCHAR2,
95   X_COLUMN_REFERENCE2  in VARCHAR2);
96 
97 procedure TRANSLATE_ROW (
98   X_PARAMETER_CODE in VARCHAR2,
99   X_SELECT_CLAUSE in VARCHAR2,
100   X_FROM_CLAUSE in VARCHAR2,
101   X_WHERE_CLAUSE in VARCHAR2,
102   X_END_DATE in DATE,
103   X_MIGRATED_FLAG in VARCHAR2,
104   X_OBJECT_VERSION_NUMBER in NUMBER,
105   X_CONTEXT_SEQUENCE_NUM in NUMBER,
106   X_AUDIT_ENABLED_FLAG in VARCHAR2,
107   X_SETUP_GROUP_CODE in VARCHAR2,
108   X_COLUMN_NAME in VARCHAR2,
109   X_CONTEXT_PREDICATE_FLAG in VARCHAR2,
110   X_PARAMETER_NAME in VARCHAR2,
111   X_LAST_UPDATE_DATE in VARCHAR2,
112   X_OWNER in VARCHAR2,
113   X_CUSTOM_MODE IN VARCHAR2,
114   X_COLUMN_REFERENCE1  in VARCHAR2,
115   X_COLUMN_REFERENCE2  in VARCHAR2);
116 
117 end ITA_SETUP_PARAMETERS_PKG;