1: PACKAGE BODY ASG_PUB_SEQUENCE_PKG as
2: /* $Header: asgpseqb.pls 120.2 2006/02/02 15:48:55 rsripada noship $ */
3:
4:
5: --
358: if (p_owner = 'SEED' ) then
359: l_user_id := 1;
360: end if;
361:
362: asg_pub_sequence_pkg.UPDATE_ROW (
363: x_SEQUENCE_ID => x_SEQUENCE_ID,
364: x_SEQUENCE_NAME => x_SEQUENCE_NAME,
365: x_PUBLICATION_ID => x_PUBLICATION_ID,
366: x_B_SCHEMA => x_B_SCHEMA,
377: x_LAST_UPDATED_BY => l_USER_ID);
378:
379: EXCEPTION
380: when no_DATA_FOUND THEN
381: asg_pub_sequence_pkg.insert_row (
382: x_SEQUENCE_ID => x_SEQUENCE_ID,
383: x_SEQUENCE_NAME => x_SEQUENCE_NAME,
384: x_PUBLICATION_ID => x_PUBLICATION_ID,
385: x_B_SCHEMA => x_B_SCHEMA,
396: x_LAST_UPDATED_BY => l_USER_ID);
397:
398: END LOAD_ROW;
399:
400: END ASG_PUB_SEQUENCE_PKG;
401: