2787: p_return_status IN OUT NOCOPY varchar2
2788: ) IS
2789:
2790: l_dummy BINARY_INTEGER;
2791: l_sequence_name fnd_document_sequences.name%type;
2792: l_doc_sequence_id fnd_document_sequences.doc_sequence_id%type ;
2793:
2794: --bug2629883
2795: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2788: ) IS
2789:
2790: l_dummy BINARY_INTEGER;
2791: l_sequence_name fnd_document_sequences.name%type;
2792: l_doc_sequence_id fnd_document_sequences.doc_sequence_id%type ;
2793:
2794: --bug2629883
2795: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2796: l_sequence_type fnd_document_sequences.type%TYPE;
2792: l_doc_sequence_id fnd_document_sequences.doc_sequence_id%type ;
2793:
2794: --bug2629883
2795: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2796: l_sequence_type fnd_document_sequences.type%TYPE;
2797: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
2798: l_prod_table_name fnd_document_sequences.table_name%TYPE;
2799: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
2800: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
2793:
2794: --bug2629883
2795: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2796: l_sequence_type fnd_document_sequences.type%TYPE;
2797: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
2798: l_prod_table_name fnd_document_sequences.table_name%TYPE;
2799: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
2800: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
2801:
2794: --bug2629883
2795: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2796: l_sequence_type fnd_document_sequences.type%TYPE;
2797: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
2798: l_prod_table_name fnd_document_sequences.table_name%TYPE;
2799: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
2800: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
2801:
2802: BEGIN
2795: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
2796: l_sequence_type fnd_document_sequences.type%TYPE;
2797: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
2798: l_prod_table_name fnd_document_sequences.table_name%TYPE;
2799: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
2800: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
2801:
2802: BEGIN
2803:
2796: l_sequence_type fnd_document_sequences.type%TYPE;
2797: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
2798: l_prod_table_name fnd_document_sequences.table_name%TYPE;
2799: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
2800: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
2801:
2802: BEGIN
2803:
2804: IF PG_DEBUG in ('Y', 'C') THEN