APPS.CSM_AD_SIMPLE_SEARCH_VIEW_PKG dependencies on CSM_AD_SIMPLE_SEARCH_VIEW

Line 1: PACKAGE BODY CSM_AD_SIMPLE_SEARCH_VIEW_PKG as

1: PACKAGE BODY CSM_AD_SIMPLE_SEARCH_VIEW_PKG as
2: /* $Header: csmlassb.pls 120.0 2008/01/25 19:16:41 trajasek noship $ */
3: PROCEDURE INSERT_ROW (
4: X_SEARCH_TYPE_ID IN NUMBER,
5: X_LEVEL_ID IN NUMBER,

Line 21: INSERT INTO CSM_AD_SIMPLE_SEARCH_VIEW

17: IS
18:
19: BEGIN
20:
21: INSERT INTO CSM_AD_SIMPLE_SEARCH_VIEW
22: (ID,
23: SEARCH_TYPE_ID,
24: LEVEL_ID,
25: LEVEL_VALUE,

Line 39: ( CSM_AD_SIMPLE_SEARCH_VIEW_S.NEXTVAL,

35: CREATED_BY,
36: LAST_UPDATE_DATE,
37: LAST_UPDATED_BY)
38: VALUES
39: ( CSM_AD_SIMPLE_SEARCH_VIEW_S.NEXTVAL,
40: X_SEARCH_TYPE_ID,
41: X_LEVEL_ID,
42: X_LEVEL_VALUE,
43: X_NAME,

Line 82: UPDATE CSM_AD_SIMPLE_SEARCH_VIEW

78:
79: BEGIN
80:
81:
82: UPDATE CSM_AD_SIMPLE_SEARCH_VIEW
83: SET
84: NAME = X_NAME,
85: DISPLAY_SEQ = X_DISPLAY_SEQ,
86: ORIGINAL_SEQ = X_ORIGINAL_SEQ,

Line 119: FROM CSM_AD_SIMPLE_SEARCH_VIEW

115: IS
116:
117: CURSOR c_exists IS
118: SELECT 1
119: FROM CSM_AD_SIMPLE_SEARCH_VIEW
120: WHERE COLUMN_NAME =X_COLUMN_NAME
121: AND SEARCH_TYPE_ID=X_SEARCH_TYPE_ID;
122:
123:

Line 173: END CSM_AD_SIMPLE_SEARCH_VIEW_PKG ;

169: END IF;
170:
171: END LOAD_ROW;
172:
173: END CSM_AD_SIMPLE_SEARCH_VIEW_PKG ;