[Home] [Help]
PACKAGE BODY: APPS.CSM_AD_SEARCH_RESULT_VIEW_PKG
Source
1 PACKAGE BODY CSM_AD_SEARCH_RESULT_VIEW_PKG as
2 /* $Header: csmlaslb.pls 120.1 2008/02/20 11:38:38 trajasek noship $ */
3
4 PROCEDURE INSERT_ROW (
5 X_ID IN NUMBER,
6 X_SEARCH_TYPE_ID IN NUMBER,
7 X_LEVEL_ID IN NUMBER,
8 X_LEVEL_VALUE IN NUMBER,
9 X_HEADER IN VARCHAR2,
10 X_COLUMN_NAME IN VARCHAR2,
11 X_IS_MAIN IN VARCHAR2,
12 X_IS_LINK IN VARCHAR2,
13 X_DESTINATION IN VARCHAR2,
14 X_PARAMETERS IN VARCHAR2,
15 X_DISPLAY_SEQ IN NUMBER,
16 X_ORIGINAL_SEQ IN NUMBER,
17 X_IS_REMOVED IN VARCHAR2,
18 X_OWNER IN VARCHAR2
19 )
20
21 IS
22
23 BEGIN
24
25 INSERT INTO CSM_AD_SEARCH_RESULT_VIEW
26 (ID,
27 SEARCH_TYPE_ID,
28 LEVEL_ID,
29 LEVEL_VALUE,
30 HEADER,
31 COLUMN_NAME,
32 IS_MAIN,
33 IS_LINK,
34 DESTINATION,
35 PARAMETERS,
36 DISPLAY_SEQ,
37 ORIGINAL_SEQ,
38 IS_REMOVED,
39 CREATION_DATE,
40 CREATED_BY,
41 LAST_UPDATE_DATE,
42 LAST_UPDATED_BY
43 )
44 VALUES
45 ( X_ID, --CSM_AD_SEARCH_RESULT_VIEW_S.NEXTVAL,
46 X_SEARCH_TYPE_ID,
47 X_LEVEL_ID,
48 X_LEVEL_VALUE,
49 X_HEADER,
50 X_COLUMN_NAME,
51 X_IS_MAIN,
52 X_IS_LINK,
53 X_DESTINATION,
54 X_PARAMETERS,
55 X_DISPLAY_SEQ,
56 X_ORIGINAL_SEQ,
57 X_IS_REMOVED,
58 SYSDATE,
59 DECODE(X_OWNER,'SEED',1,0),
60 SYSDATE,
61 DECODE(X_OWNER,'SEED',1,0)
62 );
63 END INSERT_ROW;
64
65 PROCEDURE UPDATE_ROW (
66 X_ID IN NUMBER,
67 X_SEARCH_TYPE_ID IN NUMBER,
68 X_LEVEL_ID IN NUMBER,
69 X_LEVEL_VALUE IN NUMBER,
70 X_HEADER IN VARCHAR2,
71 X_COLUMN_NAME IN VARCHAR2,
72 X_IS_MAIN IN VARCHAR2,
73 X_IS_LINK IN VARCHAR2,
74 X_DESTINATION IN VARCHAR2,
75 X_PARAMETERS IN VARCHAR2,
76 X_DISPLAY_SEQ IN NUMBER,
77 X_ORIGINAL_SEQ IN NUMBER,
78 X_IS_REMOVED IN VARCHAR2,
79 X_OWNER IN VARCHAR2
80 )
81 IS
82
83 BEGIN
84
85
86 UPDATE CSM_AD_SEARCH_RESULT_VIEW
87 SET
88 HEADER = X_HEADER,
89 IS_MAIN = X_IS_MAIN,
90 IS_LINK = X_IS_LINK,
91 DESTINATION = X_DESTINATION,
92 PARAMETERS = X_PARAMETERS,
93 DISPLAY_SEQ = X_DISPLAY_SEQ,
94 ORIGINAL_SEQ = X_ORIGINAL_SEQ,
95 IS_REMOVED = X_IS_REMOVED,
96 LAST_UPDATE_DATE = SYSDATE,
97 LAST_UPDATED_BY = DECODE(X_OWNER,'SEED',1,0),
98 COLUMN_NAME = X_COLUMN_NAME ,
99 SEARCH_TYPE_ID = X_SEARCH_TYPE_ID
100 WHERE ID = X_ID;
101
102
103 END UPDATE_ROW;
104
105 PROCEDURE LOAD_ROW (
106 X_ID IN NUMBER,
107 X_SEARCH_TYPE_ID IN NUMBER,
108 X_LEVEL_ID IN NUMBER,
109 X_LEVEL_VALUE IN NUMBER,
110 X_HEADER IN VARCHAR2,
111 X_COLUMN_NAME IN VARCHAR2,
112 X_IS_MAIN IN VARCHAR2,
113 X_IS_LINK IN VARCHAR2,
114 X_DESTINATION IN VARCHAR2,
115 X_PARAMETERS IN VARCHAR2,
116 X_DISPLAY_SEQ IN NUMBER,
117 X_ORIGINAL_SEQ IN NUMBER,
118 X_IS_REMOVED IN VARCHAR2,
119 X_OWNER IN VARCHAR2
120 )
121
122
123 IS
124
125 CURSOR c_exists IS
126 SELECT 1
127 FROM CSM_AD_SEARCH_RESULT_VIEW
128 WHERE ID = X_ID;
129
130
131 l_exists NUMBER;
132
133 BEGIN
134
135
136
137 OPEN c_exists;
138 FETCH c_exists INTO l_exists;
139 CLOSE c_exists;
140
141
142
143 IF l_exists IS NULL THEN
144 INSERT_ROW (
145 X_ID,
146 X_SEARCH_TYPE_ID,
147 X_LEVEL_ID,
148 X_LEVEL_VALUE,
149 X_HEADER,
150 X_COLUMN_NAME,
151 X_IS_MAIN,
152 X_IS_LINK,
153 X_DESTINATION,
154 X_PARAMETERS,
155 X_DISPLAY_SEQ,
156 X_ORIGINAL_SEQ,
157 X_IS_REMOVED,
158 X_OWNER
159 );
160
161 ELSE
162
163 UPDATE_ROW (
164 X_ID,
165 X_SEARCH_TYPE_ID,
166 X_LEVEL_ID,
167 X_LEVEL_VALUE,
168 X_HEADER,
169 X_COLUMN_NAME,
170 X_IS_MAIN,
171 X_IS_LINK,
172 X_DESTINATION,
173 X_PARAMETERS,
174 X_DISPLAY_SEQ,
175 X_ORIGINAL_SEQ,
176 X_IS_REMOVED,
177 X_OWNER
178 );
179 END IF;
180
181 END LOAD_ROW;
182
183 END CSM_AD_SEARCH_RESULT_VIEW_PKG ;