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.3 2011/03/25 06:28:02 saradhak ship $ */
3:
4:
5: --

Line 394: asg_pub_sequence_pkg.UPDATE_ROW (

390: if (p_owner = 'SEED' ) then
391: l_user_id := 1;
392: end if;
393:
394: asg_pub_sequence_pkg.UPDATE_ROW (
395: x_SEQUENCE_ID => x_SEQUENCE_ID,
396: x_SEQUENCE_NAME => x_SEQUENCE_NAME,
397: x_PUBLICATION_ID => x_PUBLICATION_ID,
398: x_B_SCHEMA => x_B_SCHEMA,

Line 413: asg_pub_sequence_pkg.insert_row (

409: x_LAST_UPDATED_BY => l_USER_ID);
410:
411: EXCEPTION
412: when no_DATA_FOUND THEN
413: asg_pub_sequence_pkg.insert_row (
414: x_SEQUENCE_ID => x_SEQUENCE_ID,
415: x_SEQUENCE_NAME => x_SEQUENCE_NAME,
416: x_PUBLICATION_ID => x_PUBLICATION_ID,
417: x_B_SCHEMA => x_B_SCHEMA,

Line 432: END ASG_PUB_SEQUENCE_PKG;

428: x_LAST_UPDATED_BY => l_USER_ID);
429:
430: END LOAD_ROW;
431:
432: END ASG_PUB_SEQUENCE_PKG;
433: