eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_SEQNUM dependencies on FND_DOCUMENT_SEQUENCES_S

Line 78: FROM FND_DOCUMENT_SEQUENCES SEQ,

74: SELECT SEQ.DB_SEQUENCE_NAME,
75: SEQ.DOC_SEQUENCE_ID,
76: SA.doc_sequence_assignment_id
77: INTO dbseqnm, dbseqid, seqassid
78: FROM FND_DOCUMENT_SEQUENCES SEQ,
79: FND_DOC_SEQUENCE_ASSIGNMENTS SA
80: WHERE SEQ.DOC_SEQUENCE_ID = SA.DOC_SEQUENCE_ID
81: AND SA.APPLICATION_ID = appid
82: AND SA.CATEGORY_CODE = cat_code

Line 148: FROM FND_DOCUMENT_SEQUENCES SEQ,

144:
145: begin
146:
147: SELECT SEQ.DB_SEQUENCE_NAME into dbseqnm
148: FROM FND_DOCUMENT_SEQUENCES SEQ,
149: FND_DOC_SEQUENCE_ASSIGNMENTS SA
150: WHERE SEQ.DOC_SEQUENCE_ID = SA.DOC_SEQUENCE_ID
151: AND SA.APPLICATION_ID = appid
152: AND SA.CATEGORY_CODE = cat_code

Line 206: FROM FND_DOCUMENT_SEQUENCES SEQ,

202:
203: begin
204:
205: SELECT SEQ.DB_SEQUENCE_NAME into dbseqnm
206: FROM FND_DOCUMENT_SEQUENCES SEQ,
207: FND_DOC_SEQUENCE_ASSIGNMENTS SA
208: WHERE SEQ.DOC_SEQUENCE_ID = SA.DOC_SEQUENCE_ID
209: AND SA.APPLICATION_ID = appid
210: AND SA.CATEGORY_CODE = cat_code

Line 244: from fnd_document_sequences seq

240: is
241: cursor c
242: is
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';

Line 320: from fnd_document_sequences seq,

316: depend on forms.
317: */
318: DECODE(seq.initial_value, NULL, 1, 0, 1, seq.initial_value),
319: sysdate, 0, sysdate, 0, 0
320: from fnd_document_sequences seq,
321: fnd_doc_sequence_assignments sa
322: where seq.doc_sequence_id = sa.doc_sequence_id
323: and sa.doc_sequence_id = seqid
324: and sa.doc_Sequence_assignment_id =

Line 400: is called before this call - FND_DOCUMENT_SEQUENCES_S.nextval has already been

396: new db_sequence_name and initial_value and create the DB Seq directly. The
397: only bad effect of calling from PRE-INSERT is that if something wierd happens
398: and the commit fails and AD_DDL does not the DB Seq has still been created,
399: this will not cause any functional problems since the call to create the name
400: is called before this call - FND_DOCUMENT_SEQUENCES_S.nextval has already been
401: fired and a duplicate name will not be generated - we do have an unused DB Seq
402: hanging around, but the odds of this happing are low since this the last thing
403: we do before the insert */
404: procedure create_db_seq ( db_seq_name in fnd_document_sequences.db_sequence_name%TYPE,

Line 530: from FND_DOCUMENT_SEQUENCES SEQ, FND_DOC_SEQUENCE_ASSIGNMENTS SA

526: into v_SeqInfoCache.docseq_id, v_SeqInfoCache.docseq_type, v_SeqInfoCache.docseq_name,
527: v_SeqInfoCache.aud_tab_name, v_SeqInfoCache.db_seq_name, v_SeqInfoCache.prd_tab_name,
528: v_SeqInfoCache.seq_ass_id, v_SeqInfoCache.msg_flag,
529: v_SeqInfoCache.startDate, v_SeqInfoCache.endDate
530: from FND_DOCUMENT_SEQUENCES SEQ, FND_DOC_SEQUENCE_ASSIGNMENTS SA
531: where SEQ.DOC_SEQUENCE_ID = SA.DOC_SEQUENCE_ID and
532: SA.APPLICATION_ID = v_SeqInfoCache.app_id and
533: SA.CATEGORY_CODE = v_SeqInfoCache.cat_code and
534: ( SA.SET_OF_BOOKS_ID = v_SeqInfoCache.sob_id or SA.SET_OF_BOOKS_ID is NULL ) and

Line 806: select FND_DOCUMENT_SEQUENCES_S.nextval into v_docSeqId from dual;

802: end; /* Audit Table name block */
803:
804: /* hopefully we have checked enough to do an insert so lets pop the id sequence */
805: begin /* get next DOC_SEQUENCE_ID block */
806: select FND_DOCUMENT_SEQUENCES_S.nextval into v_docSeqId from dual;
807: exception
808: when others then
809: fnd_message.set_name( 'FND', 'SQL-GENERIC ERROR' );
810: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );

Line 814: fnd_message.set_token( 'SQLSTMT', 'select FND_DOCUMENT_SEQUENCES_S.nextval from dual', FALSE );

810: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );
811: fnd_message.set_token( 'ROUTINE', 'define_doc_seq', FALSE );
812: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
813: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
814: fnd_message.set_token( 'SQLSTMT', 'select FND_DOCUMENT_SEQUENCES_S.nextval from dual', FALSE );
815: app_exception.raise_exception;
816: return( FND_SEQNUM.ORAFAIL );
817: end; /* FND_DOCUMENT_SEQUENCES_S block */
818:

Line 817: end; /* FND_DOCUMENT_SEQUENCES_S block */

813: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
814: fnd_message.set_token( 'SQLSTMT', 'select FND_DOCUMENT_SEQUENCES_S.nextval from dual', FALSE );
815: app_exception.raise_exception;
816: return( FND_SEQNUM.ORAFAIL );
817: end; /* FND_DOCUMENT_SEQUENCES_S block */
818:
819: IF docseq_type = 'A' THEN
820: v_dbSeqNm := 'FND_DOC_SEQ_'|| to_char(v_docSeqId) || '_S';
821: FND_SEQNUM.create_db_seq( v_dbSeqNm, init_value );

Line 1089: fnd_message.set_token( 'SQLSTMT', 'update FND_DOCUMENT_SEQUENCES set TABLE_NAME (..' || docseq_name || '..)', FALSE );

1085: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );
1086: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
1087: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
1088: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
1089: fnd_message.set_token( 'SQLSTMT', 'update FND_DOCUMENT_SEQUENCES set TABLE_NAME (..' || docseq_name || '..)', FALSE );
1090: app_exception.raise_exception;
1091: return( FND_SEQNUM.ORAFAIL );
1092: end; /* Doc_Seq update block */
1093: