APPS.FND_DICTIONARY_PKG dependencies on FND_SEQUENCES

Line 465: -- Add a new sequence into FND_SEQUENCES. This is only called after checking

461: end InsertForeignKey;
462:
463: --
464: -- InsertSequence (PRIVATE))
465: -- Add a new sequence into FND_SEQUENCES. This is only called after checking
466: -- there is no such sequence exists in UploadSequence().
467: --
468: procedure InsertSequence (
469: x_application_id in number,

Line 486: insert into FND_SEQUENCES (

482: x_last_updated_by in number,
483: x_last_update_login in number
484: ) is
485: begin
486: insert into FND_SEQUENCES (
487: APPLICATION_ID,
488: SEQUENCE_ID,
489: SEQUENCE_NAME,
490: START_VALUE,

Line 505: FND_SEQUENCES_S.NEXTVAL,

501: CREATION_DATE,
502: CREATED_BY)
503: values (
504: x_application_id,
505: FND_SEQUENCES_S.NEXTVAL,
506: x_sequence_name,
507: x_start_value,
508: x_description,
509: x_increment_by,

Line 1460: -- Remove sequence from FND_SEQUENCES table.

1456: end RemoveForeignKey;
1457:
1458: --
1459: -- RemoveSequence (PUBLIC)
1460: -- Remove sequence from FND_SEQUENCES table.
1461: --
1462: procedure RemoveSequence(
1463: x_application_short_name in varchar2,
1464: x_sequence_name in varchar2) is

Line 1482: delete from fnd_sequences

1478: app_exception.raise_exception;
1479: return;
1480: end;
1481:
1482: delete from fnd_sequences
1483: where application_id = appl_id
1484: and sequence_name = upper(x_sequence_name);
1485: if (SQL%ROWCOUNT = 0) then
1486: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

Line 1487: fnd_message.set_token('TABLE', 'FND_SEQUENCES');

1483: where application_id = appl_id
1484: and sequence_name = upper(x_sequence_name);
1485: if (SQL%ROWCOUNT = 0) then
1486: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1487: fnd_message.set_token('TABLE', 'FND_SEQUENCES');
1488: fnd_message.set_token('COLUMN', 'SEQUENCE_NAME');
1489: fnd_message.set_token('VALUE', x_sequence_name);
1490: app_exception.raise_exception;
1491: return;

Line 3308: from FND_SEQUENCES

3304:
3305: begin
3306: select LAST_UPDATED_BY, LAST_UPDATE_DATE
3307: into db_luby, db_ludate
3308: from FND_SEQUENCES
3309: where APPLICATION_ID = appl_id
3310: and SEQUENCE_NAME = x_sequence_name;
3311:
3312: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 3317: update FND_SEQUENCES set

3313: db_ludate, X_CUSTOM_MODE)) then
3314:
3315:
3316: -- Check if this is a new table or old table
3317: update FND_SEQUENCES set
3318: START_VALUE = x_start_value,
3319: DESCRIPTION = x_description,
3320: INCREMENT_BY = x_increment_by,
3321: MIN_VALUE = x_min_value,