APPS.FND_SEQNUM dependencies on FND_DOC_SEQUENCE_USERS

Line 247: from fnd_doc_sequence_users su)

243: select seq.doc_Sequence_id
244: from fnd_document_sequences seq
245: where seq.doc_sequence_id not in
246: (select su.doc_Sequence_id
247: from fnd_doc_sequence_users su)
248: and seq.type='G';
249: seqid number;
250: result number;
251: begin

Line 278: /* This function creates a row in the fnd_doc_sequence_users

274: app_exception.raise_exception;
275:
276: end create_gapless_sequences;
277:
278: /* This function creates a row in the fnd_doc_sequence_users
279: * to keep track of the sequence value of a gapless sequence.
280: * This is called when a sequence is assigned to a document in
281: * Assign Document Sequence form (FNDSNASQ).
282: *

Line 283: * Bug 494345: FND_DOC_SEQUENCE_USERS should only record one sequence

279: * to keep track of the sequence value of a gapless sequence.
280: * This is called when a sequence is assigned to a document in
281: * Assign Document Sequence form (FNDSNASQ).
282: *
283: * Bug 494345: FND_DOC_SEQUENCE_USERS should only record one sequence
284: * per entry, instead of one assignment per entry. Therefore,
285: * the sequence_assignment_id in this table is not really used
286: * in determining the sequence next value. The assignment_id
287: * of the first assignment that uses that particular sequence

Line 294: insert into fnd_doc_sequence_users

290: function create_gapless_sequence (seqid in number) return number
291: is
292: begin
293:
294: insert into fnd_doc_sequence_users
295: (doc_sequence_id,
296: doc_sequence_assignment_id,
297: user_id,
298: nextval,

Line 338: fnd_message.set_token('SQLSTMT', 'insert into fnd_doc_sequence_users ...', FALSE);

334: fnd_message.set_token('ERRNO', sqlcode, FALSE);
335: fnd_message.set_token('ROUTINE', 'create_gapless_sequence( '|| seqid || ' )', FALSE);
336: fnd_message.set_token('REASON', sqlerrm, FALSE);
337: fnd_message.set_token('ERRFILE', 'AFSQNUMB.pls', FALSE);
338: fnd_message.set_token('SQLSTMT', 'insert into fnd_doc_sequence_users ...', FALSE);
339: app_exception.raise_exception;
340: return(0);
341:
342: end create_gapless_sequence;

Line 358: update fnd_doc_sequence_users

354: seqid in number) return number
355: is
356: v_nextVal number;
357: begin
358: update fnd_doc_sequence_users
359: set nextval = nextval + 1
360: where user_id = fds_user_id and doc_sequence_id = seqid;
361:
362: select distinct nextval-1

Line 364: from fnd_doc_sequence_users

360: where user_id = fds_user_id and doc_sequence_id = seqid;
361:
362: select distinct nextval-1
363: into v_nextVal
364: from fnd_doc_sequence_users
365: where doc_sequence_id = seqid and user_id = fds_user_id;
366:
367: return(v_nextVal);
368:

Line 372: fnd_message.set_token( 'TABLENAME', 'FND_DOC_SEQUENCE_USERS' ,FALSE);

368:
369: exception
370: when no_data_found then
371: fnd_message.set_name( 'FND','SQL-ERROR SELECTING' );
372: fnd_message.set_token( 'TABLENAME', 'FND_DOC_SEQUENCE_USERS' ,FALSE);
373: app_exception.raise_exception;
374: return(0);
375:
376: when others then

Line 382: fnd_message.set_token( 'SQLSTMT', 'update fnd_doc_sequence_users ... nextval', FALSE );

378: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );
379: fnd_message.set_token( 'ROUTINE', 'get_next_user_sequence', FALSE );
380: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
381: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
382: fnd_message.set_token( 'SQLSTMT', 'update fnd_doc_sequence_users ... nextval', FALSE );
383: app_exception.raise_exception;
384: return(0);
385: end get_next_user_sequence;
386:

Line 1097: from FND_DOC_SEQUENCE_USERS where DOC_SEQUENCE_ID = v_docSeqId;

1093:
1094: IF v_type = 'G' THEN
1095: begin /* Create Gapless check block */
1096: select count( DOC_SEQUENCE_ID ) into v_numRows
1097: from FND_DOC_SEQUENCE_USERS where DOC_SEQUENCE_ID = v_docSeqId;
1098: IF v_numRows = 0 THEN
1099: v_numRows := FND_SEQNUM.create_gapless_sequence( v_docSeqId );
1100: IF v_numRows <> 1 THEN
1101: return( FND_SEQNUM.ORAFAIL );

Line 1111: fnd_message.set_token( 'SQLSTMT', 'select count(DOC_SEQUENCE_ID) from FND_DOC_SEQUENCE_USERS', FALSE );

1107: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );
1108: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
1109: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
1110: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
1111: fnd_message.set_token( 'SQLSTMT', 'select count(DOC_SEQUENCE_ID) from FND_DOC_SEQUENCE_USERS', FALSE );
1112: app_exception.raise_exception;
1113: return( FND_SEQNUM.ORAFAIL );
1114: end; /* Gapless check block */
1115: END IF;