APPS.CSM_AD_SEARCH_REGION_VIEW_PKG dependencies on CSM_AD_SEARCH_REGION_VIEW

Line 1: PACKAGE BODY CSM_AD_SEARCH_REGION_VIEW_PKG as

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

Line 26: INSERT INTO CSM_AD_SEARCH_REGION_VIEW

22: IS
23:
24: BEGIN
25:
26: INSERT INTO CSM_AD_SEARCH_REGION_VIEW
27: (ID,
28: SEARCH_TYPE_ID,
29: LEVEL_ID,
30: LEVEL_VALUE,

Line 49: ( CSM_AD_SEARCH_REGION_VIEW_S.NEXTVAL,

45: DB_TYPE,
46: OPERATION
47: )
48: VALUES
49: ( CSM_AD_SEARCH_REGION_VIEW_S.NEXTVAL,
50: X_SEARCH_TYPE_ID,
51: X_LEVEL_ID,
52: X_LEVEL_VALUE,
53: X_NAME,

Line 95: UPDATE CSM_AD_SEARCH_REGION_VIEW

91:
92: BEGIN
93:
94:
95: UPDATE CSM_AD_SEARCH_REGION_VIEW
96: SET
97: NAME = X_NAME,
98: FIELD_TYPE = X_FIELD_TYPE,
99: BASE_VO = X_BASE_VO,

Line 141: FROM CSM_AD_SEARCH_REGION_VIEW

137: IS
138:
139: CURSOR c_exists IS
140: SELECT 1
141: FROM CSM_AD_SEARCH_REGION_VIEW
142: WHERE COLUMN_NAME =X_COLUMN_NAME
143: AND SEARCH_TYPE_ID=X_SEARCH_TYPE_ID;
144:
145:

Line 202: END CSM_AD_SEARCH_REGION_VIEW_PKG ;

198: END IF;
199:
200: END LOAD_ROW;
201:
202: END CSM_AD_SEARCH_REGION_VIEW_PKG ;