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,
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,
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,
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,
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;
179: END IF;
180:
181: END LOAD_ROW;
182:
183: END CSM_AD_SEARCH_RESULT_VIEW_PKG ;