1 package JTF_AM_SCREEN_SETUPS_PKG AUTHID CURRENT_USER as
2 /* $Header: jtfamtss.pls 115.2 2002/12/03 21:02:02 sroychou ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_SCREEN_SETUP_ID in NUMBER,
6 X_ATTRIBUTE15 in VARCHAR2,
7 X_ATTRIBUTE_CATEGORY in VARCHAR2,
8 X_SECURITY_GROUP_ID in NUMBER,
9 X_ATTRIBUTE11 in VARCHAR2,
10 X_MODE_ASSIST in VARCHAR2,
11 X_MODE_UNASSIST in VARCHAR2,
12 X_CONTRACTS in VARCHAR2,
13 X_INSTALLED_BASE in VARCHAR2,
14 X_TERRITORY in VARCHAR2,
15 X_AVAILABILITY in VARCHAR2,
16 X_DOCUMENT_TYPE in VARCHAR2,
17 X_ATTRIBUTE7 in VARCHAR2,
18 X_ATTRIBUTE8 in VARCHAR2,
19 X_ATTRIBUTE9 in VARCHAR2,
20 X_ATTRIBUTE10 in VARCHAR2,
21 X_ATTRIBUTE12 in VARCHAR2,
22 X_ATTRIBUTE13 in VARCHAR2,
23 X_ATTRIBUTE14 in VARCHAR2,
24 X_WINDOW_WIDTH in NUMBER,
25 X_WINDOW_HEIGHT in NUMBER,
26 X_WINDOW_X_POSITION in NUMBER,
27 X_WINDOW_Y_POSITION in NUMBER,
28 X_DOC_DTLS_USER_VALUES in VARCHAR2,
29 X_SHOW_SELECTED_TIME in VARCHAR2,
30 X_OBJECT_VERSION_NUMBER in NUMBER,
31 X_USER_ID in NUMBER,
32 X_ATTRIBUTE1 in VARCHAR2,
33 X_ATTRIBUTE2 in VARCHAR2,
34 X_ATTRIBUTE3 in VARCHAR2,
35 X_ATTRIBUTE4 in VARCHAR2,
36 X_ATTRIBUTE5 in VARCHAR2,
37 X_ATTRIBUTE6 in VARCHAR2,
38 X_DOC_DETAILS in VARCHAR2,
39 X_PREFERENCE_NAME in VARCHAR2,
40 X_CREATION_DATE in DATE,
41 X_CREATED_BY in NUMBER,
42 X_LAST_UPDATE_DATE in DATE,
43 X_LAST_UPDATED_BY in NUMBER,
44 X_LAST_UPDATE_LOGIN in NUMBER);
45 procedure LOCK_ROW (
46 X_SCREEN_SETUP_ID in NUMBER,
47 X_ATTRIBUTE15 in VARCHAR2,
48 X_ATTRIBUTE_CATEGORY in VARCHAR2,
49 X_SECURITY_GROUP_ID in NUMBER,
50 X_ATTRIBUTE11 in VARCHAR2,
51 X_MODE_ASSIST in VARCHAR2,
52 X_MODE_UNASSIST in VARCHAR2,
53 X_CONTRACTS in VARCHAR2,
54 X_INSTALLED_BASE in VARCHAR2,
55 X_TERRITORY in VARCHAR2,
56 X_AVAILABILITY in VARCHAR2,
57 X_DOCUMENT_TYPE in VARCHAR2,
58 X_ATTRIBUTE7 in VARCHAR2,
59 X_ATTRIBUTE8 in VARCHAR2,
60 X_ATTRIBUTE9 in VARCHAR2,
61 X_ATTRIBUTE10 in VARCHAR2,
62 X_ATTRIBUTE12 in VARCHAR2,
63 X_ATTRIBUTE13 in VARCHAR2,
64 X_ATTRIBUTE14 in VARCHAR2,
65 X_WINDOW_WIDTH in NUMBER,
66 X_WINDOW_HEIGHT in NUMBER,
67 X_WINDOW_X_POSITION in NUMBER,
68 X_WINDOW_Y_POSITION in NUMBER,
69 X_DOC_DTLS_USER_VALUES in VARCHAR2,
70 X_SHOW_SELECTED_TIME in VARCHAR2,
71 X_OBJECT_VERSION_NUMBER in NUMBER,
72 X_USER_ID in NUMBER,
73 X_ATTRIBUTE1 in VARCHAR2,
74 X_ATTRIBUTE2 in VARCHAR2,
75 X_ATTRIBUTE3 in VARCHAR2,
76 X_ATTRIBUTE4 in VARCHAR2,
77 X_ATTRIBUTE5 in VARCHAR2,
78 X_ATTRIBUTE6 in VARCHAR2,
79 X_DOC_DETAILS in VARCHAR2,
80 X_PREFERENCE_NAME in VARCHAR2
81 );
82 procedure UPDATE_ROW (
83 X_SCREEN_SETUP_ID in NUMBER,
84 X_ATTRIBUTE15 in VARCHAR2,
85 X_ATTRIBUTE_CATEGORY in VARCHAR2,
86 X_SECURITY_GROUP_ID in NUMBER,
87 X_ATTRIBUTE11 in VARCHAR2,
88 X_MODE_ASSIST in VARCHAR2,
89 X_MODE_UNASSIST in VARCHAR2,
90 X_CONTRACTS in VARCHAR2,
91 X_INSTALLED_BASE in VARCHAR2,
92 X_TERRITORY in VARCHAR2,
93 X_AVAILABILITY in VARCHAR2,
94 X_DOCUMENT_TYPE in VARCHAR2,
95 X_ATTRIBUTE7 in VARCHAR2,
96 X_ATTRIBUTE8 in VARCHAR2,
97 X_ATTRIBUTE9 in VARCHAR2,
98 X_ATTRIBUTE10 in VARCHAR2,
99 X_ATTRIBUTE12 in VARCHAR2,
100 X_ATTRIBUTE13 in VARCHAR2,
101 X_ATTRIBUTE14 in VARCHAR2,
102 X_WINDOW_WIDTH in NUMBER,
103 X_WINDOW_HEIGHT in NUMBER,
104 X_WINDOW_X_POSITION in NUMBER,
105 X_WINDOW_Y_POSITION in NUMBER,
106 X_DOC_DTLS_USER_VALUES in VARCHAR2,
107 X_SHOW_SELECTED_TIME in VARCHAR2,
108 X_OBJECT_VERSION_NUMBER in NUMBER,
109 X_USER_ID in NUMBER,
110 X_ATTRIBUTE1 in VARCHAR2,
111 X_ATTRIBUTE2 in VARCHAR2,
112 X_ATTRIBUTE3 in VARCHAR2,
113 X_ATTRIBUTE4 in VARCHAR2,
114 X_ATTRIBUTE5 in VARCHAR2,
115 X_ATTRIBUTE6 in VARCHAR2,
116 X_DOC_DETAILS in VARCHAR2,
117 X_PREFERENCE_NAME in VARCHAR2,
118 X_LAST_UPDATE_DATE in DATE,
119 X_LAST_UPDATED_BY in NUMBER,
120 X_LAST_UPDATE_LOGIN in NUMBER
121 );
122 procedure DELETE_ROW (
123 X_SCREEN_SETUP_ID in NUMBER
124 );
125 procedure ADD_LANGUAGE;
126 procedure LOAD_ROW (
127 X_OWNER in VARCHAR2,
128 X_SCREEN_SETUP_ID in NUMBER,
129 X_MODE_ASSIST in VARCHAR2,
130 X_MODE_UNASSIST in VARCHAR2,
131 X_CONTRACTS in VARCHAR2,
132 X_INSTALLED_BASE in VARCHAR2,
133 X_TERRITORY in VARCHAR2,
134 X_AVAILABILITY in VARCHAR2,
135 X_DOCUMENT_TYPE in VARCHAR2,
136 X_WINDOW_WIDTH in NUMBER,
137 X_WINDOW_HEIGHT in NUMBER,
138 X_WINDOW_X_POSITION in NUMBER,
139 X_WINDOW_Y_POSITION in NUMBER,
140 X_DOC_DTLS_USER_VALUES in VARCHAR2,
141 X_SHOW_SELECTED_TIME in VARCHAR2,
142 X_OBJECT_VERSION_NUMBER in NUMBER,
143 X_USER_ID in NUMBER,
144 X_DOC_DETAILS in VARCHAR2,
145 X_ATTRIBUTE1 in VARCHAR2,
146 X_ATTRIBUTE2 in VARCHAR2,
147 X_ATTRIBUTE3 in VARCHAR2,
148 X_ATTRIBUTE4 in VARCHAR2,
149 X_ATTRIBUTE5 in VARCHAR2,
150 X_ATTRIBUTE6 in VARCHAR2,
151 X_ATTRIBUTE7 in VARCHAR2,
152 X_ATTRIBUTE8 in VARCHAR2,
153 X_ATTRIBUTE9 in VARCHAR2,
154 X_ATTRIBUTE10 in VARCHAR2,
155 X_ATTRIBUTE11 in VARCHAR2,
156 X_ATTRIBUTE12 in VARCHAR2,
157 X_ATTRIBUTE13 in VARCHAR2,
158 X_ATTRIBUTE14 in VARCHAR2,
159 X_ATTRIBUTE15 in VARCHAR2,
160 X_ATTRIBUTE_CATEGORY in VARCHAR2,
161 X_SECURITY_GROUP_ID in NUMBER,
162 X_PREFERENCE_NAME in VARCHAR2);
163
164 Procedure TRANSLATE_ROW
165 (X_screen_setup_id in number,
166 X_preference_name in varchar2,
167 x_Last_update_date in date,
168 x_last_updated_by in number,
169 x_last_update_login in number);
170
171 end JTF_AM_SCREEN_SETUPS_PKG;