1: package body IMC_THREE_SIXTY_PARAMS_PKG as
2: /* $Header: ARHTSPMB.pls 120.0 2005/05/25 22:00:22 achung noship $ */
3:
4: procedure INSERT_ROW (
5: X_QUERY_ID in NUMBER,
172: dbms_output.put_line('In begin of load_row : ssm_query_id is ' ||to_char(X_SSM_QUERY_ID));
173:
174: L_OBJECT_VERSION_NUMBER := NVL(X_OBJECT_VERSION_NUMBER, 1) + 1;
175:
176: IMC_THREE_SIXTY_PARAMS_PKG.UPDATE_ROW (
177: X_QUERY_ID => X_QUERY_ID,
178: X_APPLICATION_ID => X_APPLICATION_ID,
179: X_SSM_QUERY_ID => X_SSM_QUERY_ID,
180: X_PARAM_POSITION => X_PARAM_POSITION,
186:
187: exception
188: when NO_DATA_FOUND then
189:
190: IMC_THREE_SIXTY_PARAMS_PKG.INSERT_ROW (
191: X_QUERY_ID => L_QUERY_ID,
192: X_APPLICATION_ID => X_APPLICATION_ID,
193: X_SSM_QUERY_ID => X_SSM_QUERY_ID,
194: X_PARAM_POSITION => X_PARAM_POSITION,
202:
203: end ;
204: end LOAD_ROW;
205:
206: end IMC_THREE_SIXTY_PARAMS_PKG;