DBA Data[Home] [Help]

APPS.AR_ADJVALIDATE_PVT dependencies on FND_DOCUMENT_SEQUENCES

Line 2763: l_sequence_name fnd_document_sequences.name%type;

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;

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

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

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

Line 2770: l_prod_table_name fnd_document_sequences.table_name%TYPE;

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

Line 2771: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;

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:

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