APPS.FND_SEQNUM dependencies on DUAL

Line 100: v_proc_stmt := 'select ' || dbseqnm || '.nextval ' || 'into :next_val from sys.dual';

96: v_proc_stmt varchar2(100);
97: v_nextVal integer;
98:
99: begin
100: v_proc_stmt := 'select ' || dbseqnm || '.nextval ' || 'into :next_val from sys.dual';
101:
102: EXECUTE IMMEDIATE v_proc_stmt INTO v_nextVal;
103: return( v_nextVal );
104:

Line 170: 'into :next_val from sys.dual; end;';

166:
167: c := dbms_sql.open_cursor;
168:
169: proc_stmt := 'begin select ' || dbseqnm || '.nextval ' ||
170: 'into :next_val from sys.dual; end;';
171:
172: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
173: dbms_sql.bind_variable(c, 'next_val', next_val);
174:

Line 220: 'into :next_val from sys.dual; end;';

216:
217: c := dbms_sql.open_cursor;
218:
219: proc_stmt := 'begin select ' || dbseqnm || '.nextval ' ||
220: 'into :next_val from sys.dual; end;';
221:
222: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
223: dbms_sql.bind_variable(c, 'next_val', next_val);
224:

Line 791: 'FND') || '_DOC_SEQUENCE_AUDIT' into v_audTabNm from dual;

787: 160,'ALR', 168,'RG', 200,'AP', 201,'PO', 222,'AR', 260,'CE',
788: 300,'OE', 401,'INV', 500,'SA', 700,'MFG', 702,'BOM', 703,'ENG',
789: 704,'MRP', 705,'CRP', 706,'WIP', 800,'PER', 801,'PAY', 802,'FF',
790: 803,'DT', 804,'SSP', 7000,'JA', 7002,'JE', 7003,'JG', 7004,'JL',
791: 'FND') || '_DOC_SEQUENCE_AUDIT' into v_audTabNm from dual;
792: exception
793: when others then
794: fnd_message.set_name( 'FND', 'SQL-GENERIC ERROR' );
795: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );

Line 799: fnd_message.set_token( 'SQLSTMT', 'select DECODE(' || to_char(app_id) || '...) from dual', FALSE );

795: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );
796: fnd_message.set_token( 'ROUTINE', 'define_doc_seq', FALSE );
797: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
798: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
799: fnd_message.set_token( 'SQLSTMT', 'select DECODE(' || to_char(app_id) || '...) from dual', FALSE );
800: app_exception.raise_exception;
801: return( FND_SEQNUM.ORAFAIL );
802: end; /* Audit Table name block */
803:

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 984: begin /* DATE check - again most of this code in forms so dual maintain */

980: app_exception.raise_exception;
981: return( FND_SEQNUM.ORAFAIL );
982: end; /* Document Flexfield block */
983:
984: begin /* DATE check - again most of this code in forms so dual maintain */
985: -- first the forms format mask only allows whole dates no hours so ...
986: v_startDate := trunc( p_startDate );
987: v_endDate := trunc( p_endDate );
988: IF v_endDate is NULL THEN

Line 1059: select FND_DOC_SEQUENCE_ASSIGNMENTS_S.nextval into v_seqAssID from dual;

1055: end; /* DATE check block */
1056:
1057: /* hopefully we have checked enough to do an insert so lets pop the id sequence */
1058: begin /* get next DOC_SEQUENCE_ASSIGNMENT_ID block */
1059: select FND_DOC_SEQUENCE_ASSIGNMENTS_S.nextval into v_seqAssID from dual;
1060: exception
1061: when others then
1062: fnd_message.set_name( 'FND', 'SQL-GENERIC ERROR' );
1063: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );

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

1063: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );
1064: fnd_message.set_token( 'ROUTINE', 'define_doc_seq', FALSE );
1065: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
1066: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
1067: fnd_message.set_token( 'SQLSTMT', 'select FND_DOC_SEQUENCE_ASSIGNMENTS_S.nextval from dual', FALSE );
1068: app_exception.raise_exception;
1069: return( FND_SEQNUM.ORAFAIL );
1070: end; /* FND_DOC_SEQUENCE_ASSIGNMENTS_S block */
1071: