DBA Data[Home] [Help]

APPS.IMC_THREE_SIXTY_SSM_QUERY_PKG dependencies on IMC_THREE_SIXTY_SSM_QUERY_PKG

Line 1: package body IMC_THREE_SIXTY_SSM_QUERY_PKG as

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,

Line 161: IMC_THREE_SIXTY_SSM_QUERY_PKG.UPDATE_ROW (

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,

Line 173: IMC_THREE_SIXTY_SSM_QUERY_PKG.INSERT_ROW (

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,

Line 187: end IMC_THREE_SIXTY_SSM_QUERY_PKG;

183:
184: end ;
185: end LOAD_ROW;
186:
187: end IMC_THREE_SIXTY_SSM_QUERY_PKG;