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

Line 7: -- ASG_PUB_SEQUENCE

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

Line 94: v_seq_statement := 'SELECT SEQUENCE_NAME FROM ASG_PUB_SEQUENCE ' ||

90: v_max_users := getNEXT_VALUE;
91: v_start_mobile := to_number(x_start_mobile);
92:
93: --Get the Sequence Name for ServiceL
94: v_seq_statement := 'SELECT SEQUENCE_NAME FROM ASG_PUB_SEQUENCE ' ||
95: 'WHERE PUBLICATION_ID IN (''SERVICEL'',''JTM'' ) ' ||
96: 'AND B_TABLE = :1 ' ||
97: 'AND B_COLUMN = :2 ' ;
98:

Line 276: insert into ASG_PUB_SEQUENCE (

272: exception
273: when others then
274: l_b_schema := x_B_SCHEMA;
275: end;
276: insert into ASG_PUB_SEQUENCE (
277: SEQUENCE_ID,
278: SEQUENCE_NAME,
279: PUBLICATION_ID,
280: B_SCHEMA,

Line 345: update asg_pub_sequence set

341: when others then
342: l_b_schema := x_B_SCHEMA;
343: end;
344:
345: update asg_pub_sequence set
346: sequence_id = x_sequence_id,
347: sequence_name = x_sequence_name,
348: publication_id = x_publication_id,
349: b_schema = l_b_schema,

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: