2759: p_return_status IN OUT NOCOPY varchar2
2760: ) IS
2761:
2762: l_dummy BINARY_INTEGER;
2763: l_sequence_name fnd_document_sequences.name%type;
2764: l_doc_sequence_id fnd_document_sequences.doc_sequence_id%type ;
2765:
2766: --bug2629883
2767: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2760: ) IS
2761:
2762: l_dummy BINARY_INTEGER;
2763: l_sequence_name fnd_document_sequences.name%type;
2764: l_doc_sequence_id fnd_document_sequences.doc_sequence_id%type ;
2765:
2766: --bug2629883
2767: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2768: l_sequence_type fnd_document_sequences.type%TYPE;
2764: l_doc_sequence_id fnd_document_sequences.doc_sequence_id%type ;
2765:
2766: --bug2629883
2767: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2768: l_sequence_type fnd_document_sequences.type%TYPE;
2769: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
2770: l_prod_table_name fnd_document_sequences.table_name%TYPE;
2771: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
2772: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
2765:
2766: --bug2629883
2767: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2768: l_sequence_type fnd_document_sequences.type%TYPE;
2769: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
2770: l_prod_table_name fnd_document_sequences.table_name%TYPE;
2771: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
2772: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
2773:
2766: --bug2629883
2767: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2768: l_sequence_type fnd_document_sequences.type%TYPE;
2769: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
2770: l_prod_table_name fnd_document_sequences.table_name%TYPE;
2771: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
2772: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
2773:
2774: BEGIN
2767: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2768: l_sequence_type fnd_document_sequences.type%TYPE;
2769: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
2770: l_prod_table_name fnd_document_sequences.table_name%TYPE;
2771: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
2772: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
2773:
2774: BEGIN
2775:
2768: l_sequence_type fnd_document_sequences.type%TYPE;
2769: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
2770: l_prod_table_name fnd_document_sequences.table_name%TYPE;
2771: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
2772: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
2773:
2774: BEGIN
2775:
2776: IF PG_DEBUG in ('Y', 'C') THEN