1: package body IMC_THREE_SIXTY_QUERY_PKG as
2: /* $Header: ARHTSDVB.pls 120.3 2005/08/30 00:41:22 rnalluri noship $ */
3:
4: procedure INSERT_ROW (
5: X_QUERY_ID in out NOCOPY NUMBER,
478: END;
479:
480: L_OBJECT_VERSION_NUMBER := NVL(X_OBJECT_VERSION_NUMBER, 1) + 1;
481:
482: IMC_THREE_SIXTY_QUERY_PKG.UPDATE_ROW (
483: X_QUERY_ID => X_QUERY_ID,
484: X_APPLICATION_ID => X_APPLICATION_ID,
485: X_QUERY_TYPE_FLAG => X_QUERY_TYPE_FLAG,
486: X_PRODUCT_QUERY1 => X_PRODUCT_QUERY1,
506:
507: exception
508: when NO_DATA_FOUND then
509:
510: IMC_THREE_SIXTY_QUERY_PKG.INSERT_ROW (
511: X_QUERY_ID => L_QUERY_ID,
512: X_APPLICATION_ID => X_APPLICATION_ID,
513: X_QUERY_TYPE_FLAG => X_QUERY_TYPE_FLAG,
514: X_PRODUCT_QUERY1 => X_PRODUCT_QUERY1,
538: <
539: null;
540: end LOAD_ROW;
541:
542: end IMC_THREE_SIXTY_QUERY_PKG;