DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on FND_DOCUMENT_SEQUENCES

Line 4970: l_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;

4966: WHERE trx_header_id NOT IN (
4967: SELECT trx_header_id FROM
4968: ar_trx_errors_gt);
4969:
4970: l_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
4971: l_doc_sequence_id ra_customer_trx.doc_sequence_id%type;
4972: l_doc_sequence_value ra_customer_trx.doc_sequence_value%type;
4973: l_dummy BINARY_INTEGER;
4974:

Line 4981: l_sequence_type fnd_document_sequences.type%TYPE;

4977:
4978:
4979:
4980: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
4981: l_sequence_type fnd_document_sequences.type%TYPE;
4982: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
4983: l_prod_table_name fnd_document_sequences.table_name%TYPE;
4984: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
4985: l_mesg_flag fnd_document_sequences.message_flag%TYPE;

Line 4982: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;

4978:
4979:
4980: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
4981: l_sequence_type fnd_document_sequences.type%TYPE;
4982: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
4983: l_prod_table_name fnd_document_sequences.table_name%TYPE;
4984: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
4985: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
4986: l_update_trx boolean := FALSE;

Line 4983: l_prod_table_name fnd_document_sequences.table_name%TYPE;

4979:
4980: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
4981: l_sequence_type fnd_document_sequences.type%TYPE;
4982: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
4983: l_prod_table_name fnd_document_sequences.table_name%TYPE;
4984: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
4985: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
4986: l_update_trx boolean := FALSE;
4987: l_seq_err boolean := FALSE;

Line 4984: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;

4980: l_seq_assign_id fnd_doc_sequence_assignments.doc_sequence_assignment_id%TYPE;
4981: l_sequence_type fnd_document_sequences.type%TYPE;
4982: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
4983: l_prod_table_name fnd_document_sequences.table_name%TYPE;
4984: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
4985: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
4986: l_update_trx boolean := FALSE;
4987: l_seq_err boolean := FALSE;
4988: l_trx_str VARCHAR2(2000);

Line 4985: l_mesg_flag fnd_document_sequences.message_flag%TYPE;

4981: l_sequence_type fnd_document_sequences.type%TYPE;
4982: l_db_sequence_name fnd_document_sequences.db_sequence_name%TYPE;
4983: l_prod_table_name fnd_document_sequences.table_name%TYPE;
4984: l_audit_table_name fnd_document_sequences.audit_table_name%TYPE;
4985: l_mesg_flag fnd_document_sequences.message_flag%TYPE;
4986: l_update_trx boolean := FALSE;
4987: l_seq_err boolean := FALSE;
4988: l_trx_str VARCHAR2(2000);
4989: l_org_str VARCHAR2(30);