DBA Data[Home] [Help]

APPS.ASG_PUB_SEQUENCE_PKG dependencies on ASG_PUB_SEQUENCE_PKG

Line 1: PACKAGE BODY ASG_PUB_SEQUENCE_PKG as

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: --

Line 362: asg_pub_sequence_pkg.UPDATE_ROW (

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,

Line 381: asg_pub_sequence_pkg.insert_row (

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,

Line 400: END ASG_PUB_SEQUENCE_PKG;

396: x_LAST_UPDATED_BY => l_USER_ID);
397:
398: END LOAD_ROW;
399:
400: END ASG_PUB_SEQUENCE_PKG;
401: