APPS.AP_AUTO_DM_CREATION_PKG dependencies on FND_DOCUMENT_SEQUENCES

Line 1193: l_db_seq_name fnd_document_sequences.db_sequence_name%TYPE;

1189: l_invoice_num ap_invoices.invoice_num%TYPE;
1190: l_terms_date DATE;
1191: l_inv_desc ap_invoices.description%TYPE;
1192: l_seq_num_profile VARCHAR2(25);
1193: l_db_seq_name fnd_document_sequences.db_sequence_name%TYPE;
1194: l_db_seq_id fnd_document_sequences.doc_sequence_id%TYPE;
1195: l_doc_seq_value NUMBER;
1196: l_invoice_amount ap_invoices.invoice_amount%TYPE;
1197: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;

Line 1194: l_db_seq_id fnd_document_sequences.doc_sequence_id%TYPE;

1190: l_terms_date DATE;
1191: l_inv_desc ap_invoices.description%TYPE;
1192: l_seq_num_profile VARCHAR2(25);
1193: l_db_seq_name fnd_document_sequences.db_sequence_name%TYPE;
1194: l_db_seq_id fnd_document_sequences.doc_sequence_id%TYPE;
1195: l_doc_seq_value NUMBER;
1196: l_invoice_amount ap_invoices.invoice_amount%TYPE;
1197: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;
1198: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;

Line 1528: FROM fnd_document_sequences SEQ,

1524: SELECT SEQ.db_sequence_name,
1525: SEQ.doc_sequence_id
1526: INTO l_db_seq_name,
1527: l_db_seq_id
1528: FROM fnd_document_sequences SEQ,
1529: fnd_doc_sequence_assignments SA
1530: WHERE SEQ.doc_sequence_id = SA.doc_sequence_id
1531: AND SA.application_id = 200
1532: AND SA.category_code = 'DBM INV'