DBA Data[Home] [Help]

APPS.AR_ADJVALIDATE_PVT dependencies on FND_DOCUMENT_SEQUENCES

Line 2791: l_sequence_name fnd_document_sequences.name%type;

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;

Line 2792: l_doc_sequence_id fnd_document_sequences.doc_sequence_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;

Line 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;

Line 2797: l_db_sequence_name fnd_document_sequences.db_sequence_name%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:

Line 2798: l_prod_table_name fnd_document_sequences.table_name%TYPE;

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

Line 2799: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;

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:

Line 2800: l_mesg_flag fnd_document_sequences.message_flag%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:
2804: IF PG_DEBUG in ('Y', 'C') THEN