APPS.ASG_PUB_SEQUENCE_PKG dependencies on ASG_PUB_SEQUENCE

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

3:
4:
5: --
6: -- NAME
7: -- ASG_PUB_SEQUENCE
8: --
9: -- PURPOSE
10: --
11: -- HISTORY

Line 244: insert into ASG_PUB_SEQUENCE (

240: exception
241: when others then
242: l_b_schema := x_B_SCHEMA;
243: end;
244: insert into ASG_PUB_SEQUENCE (
245: SEQUENCE_ID,
246: SEQUENCE_NAME,
247: PUBLICATION_ID,
248: B_SCHEMA,

Line 313: update asg_pub_sequence set

309: when others then
310: l_b_schema := x_B_SCHEMA;
311: end;
312:
313: update asg_pub_sequence set
314: sequence_id = x_sequence_id,
315: sequence_name = x_sequence_name,
316: publication_id = x_publication_id,
317: b_schema = l_b_schema,

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: