APPS.CSM_CUSTOMIZATION_VIEWS_PKG dependencies on CSM_CUSTOMIZATION_VIEWS

Line 1: PACKAGE BODY CSM_CUSTOMIZATION_VIEWS_PKG AS

1: PACKAGE BODY CSM_CUSTOMIZATION_VIEWS_PKG AS
2: /* $Header: csmlcvb.pls 120.2 2005/11/23 05:28:32 saradhak noship $ */
3:
4: PROCEDURE INSERT_ROW
5: (

Line 27: INSERT INTO CSM_CUSTOMIZATION_VIEWS

23: IS
24:
25: BEGIN
26: --Insert
27: INSERT INTO CSM_CUSTOMIZATION_VIEWS
28: (CUST_VIEW_ID,
29: PAGE_NAME,
30: REGION_NAME,
31: CUST_VIEW_KEY,

Line 48: VALUES(CSM_CUSTOMIZATION_VIEWS_S.NEXTVAL,

44: LAST_UPDATED_BY,
45: CREATION_DATE,
46: CREATED_BY,
47: LAST_UPDATE_DATE)
48: VALUES(CSM_CUSTOMIZATION_VIEWS_S.NEXTVAL,
49: X_PAGE_NAME,
50: X_REGION_NAME,
51: X_CUST_VIEW_KEY,
52: X_LEVEL_ID,

Line 94: UPDATE CSM_CUSTOMIZATION_VIEWS

90: IS
91:
92: BEGIN
93: --Update
94: UPDATE CSM_CUSTOMIZATION_VIEWS
95: SET MESSAGE_NAME = X_MESSAGE_NAME,
96: SELECT_STATEMENT = X_SELECT_STATEMENT,
97: WHERE_CONDITION = X_WHERE_CONDITION,
98: WHERE_CLAUSE = X_WHERE_CLAUSE,

Line 138: FROM CSM_CUSTOMIZATION_VIEWS CCV

134:
135:
136: CURSOR c_view_exists(b_page_name VARCHAR2,b_region_name VARCHAR2,b_cust_view_key VARCHAR2,b_level_id NUMBER,b_level_value NUMBER) IS
137: SELECT 1
138: FROM CSM_CUSTOMIZATION_VIEWS CCV
139: WHERE CCV.PAGE_NAME = b_page_name
140: AND CCV.REGION_NAME = b_region_name
141: AND CCV.CUST_VIEW_KEY = b_cust_view_key
142: AND CCV.LEVEL_ID = b_level_id