DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on FND_DOCUMENT_SEQUENCES

Line 5097: l_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;

5093: WHERE trx_header_id NOT IN (
5094: SELECT trx_header_id FROM
5095: ar_trx_errors_gt);
5096:
5097: l_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
5098: l_doc_sequence_id ra_customer_trx.doc_sequence_id%type;
5099: l_doc_sequence_value ra_customer_trx.doc_sequence_value%type;
5100: l_dummy BINARY_INTEGER;
5101:

Line 5108: l_sequence_type fnd_document_sequences.type%TYPE;

5104:
5105:
5106:
5107: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
5108: l_sequence_type fnd_document_sequences.type%TYPE;
5109: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
5110: l_prod_table_name fnd_document_sequences.table_name%TYPE;
5111: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
5112: l_mesg_flag fnd_document_sequences.message_flag%TYPE;

Line 5109: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;

5105:
5106:
5107: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
5108: l_sequence_type fnd_document_sequences.type%TYPE;
5109: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
5110: l_prod_table_name fnd_document_sequences.table_name%TYPE;
5111: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
5112: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
5113: l_update_trx boolean := FALSE;

Line 5110: l_prod_table_name fnd_document_sequences.table_name%TYPE;

5106:
5107: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
5108: l_sequence_type fnd_document_sequences.type%TYPE;
5109: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
5110: l_prod_table_name fnd_document_sequences.table_name%TYPE;
5111: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
5112: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
5113: l_update_trx boolean := FALSE;
5114: l_seq_err boolean := FALSE;

Line 5111: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;

5107: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
5108: l_sequence_type fnd_document_sequences.type%TYPE;
5109: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
5110: l_prod_table_name fnd_document_sequences.table_name%TYPE;
5111: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
5112: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
5113: l_update_trx boolean := FALSE;
5114: l_seq_err boolean := FALSE;
5115: l_trx_str VARCHAR2(2000);

Line 5112: l_mesg_flag fnd_document_sequences.message_flag%TYPE;

5108: l_sequence_type fnd_document_sequences.type%TYPE;
5109: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
5110: l_prod_table_name fnd_document_sequences.table_name%TYPE;
5111: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
5112: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
5113: l_update_trx boolean := FALSE;
5114: l_seq_err boolean := FALSE;
5115: l_trx_str VARCHAR2(2000);
5116: l_org_str VARCHAR2(30);