1: package body IMC_THREE_SIXTY_SSM_QUERY_PKG as
2: /* $Header: ARHTSSQB.pls 120.0 2005/05/25 22:00:28 achung noship $ */
3:
4: procedure INSERT_ROW (
5: X_SSM_QUERY_ID in out NOCOPY NUMBER,
157: end if;
158:
159: L_OBJECT_VERSION_NUMBER := NVL(X_OBJECT_VERSION_NUMBER, 1) + 1;
160:
161: IMC_THREE_SIXTY_SSM_QUERY_PKG.UPDATE_ROW (
162: X_SSM_QUERY_ID => X_SSM_QUERY_ID,
163: X_APPLICATION_ID => X_APPLICATION_ID,
164: X_SSM_QUERY_STRING => X_SSM_QUERY_STRING,
165: X_LAST_UPDATE_DATE => sysdate,
169:
170: exception
171: when NO_DATA_FOUND then
172:
173: IMC_THREE_SIXTY_SSM_QUERY_PKG.INSERT_ROW (
174: X_SSM_QUERY_ID => L_SSM_QUERY_ID,
175: X_APPLICATION_ID => X_APPLICATION_ID,
176: X_SSM_QUERY_STRING => X_SSM_QUERY_STRING,
177: X_CREATION_DATE => sysdate,
183:
184: end ;
185: end LOAD_ROW;
186:
187: end IMC_THREE_SIXTY_SSM_QUERY_PKG;