APPS.CSM_AD_SEARCH_TITLE_VIEW_PKG dependencies on CSM_AD_SEARCH_TITLE_VIEW

Line 1: PACKAGE BODY CSM_AD_SEARCH_TITLE_VIEW_PKG as

1: PACKAGE BODY CSM_AD_SEARCH_TITLE_VIEW_PKG as
2: /* $Header: csmlastb.pls 120.1 2008/02/07 09:15:18 trajasek noship $ */
3: PROCEDURE INSERT_ROW (
4: X_SEARCH_TYPE IN VARCHAR2,
5: X_LEVEL_ID IN NUMBER,

Line 16: INSERT INTO CSM_AD_SEARCH_TITLE_VIEW

12: IS
13:
14: BEGIN
15:
16: INSERT INTO CSM_AD_SEARCH_TITLE_VIEW
17: (ID,
18: SEARCH_TYPE,
19: LEVEL_ID,
20: LEVEL_VALUE,

Line 29: ( CSM_AD_SEARCH_TITLE_VIEW_S.NEXTVAL,

25: LAST_UPDATE_DATE,
26: LAST_UPDATED_BY,
27: SEARCH_TYPE_ID)
28: VALUES
29: ( CSM_AD_SEARCH_TITLE_VIEW_S.NEXTVAL,
30: X_SEARCH_TYPE,
31: X_LEVEL_ID,
32: X_LEVEL_VALUE,
33: X_SEARCH_TITLE,

Line 61: UPDATE CSM_AD_SEARCH_TITLE_VIEW

57:
58: BEGIN
59:
60:
61: UPDATE CSM_AD_SEARCH_TITLE_VIEW
62: SET
63: SEARCH_TITLE = X_SEARCH_TITLE,
64: VO_NAME = X_VO_NAME,
65: SEARCH_TYPE_ID = X_SEARCH_TYPE_ID,

Line 87: FROM CSM_AD_SEARCH_TITLE_VIEW

83: IS
84:
85: CURSOR c_exists IS
86: SELECT 1
87: FROM CSM_AD_SEARCH_TITLE_VIEW
88: WHERE SEARCH_TYPE=X_SEARCH_TYPE;
89:
90: l_exists NUMBER;
91:

Line 128: END CSM_AD_SEARCH_TITLE_VIEW_PKG ;

124: END IF;
125:
126: END LOAD_ROW;
127:
128: END CSM_AD_SEARCH_TITLE_VIEW_PKG ;