DBA Data[Home] [Help]

APPS.AP_VOID_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 156: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,

152:
153: CURSOR C_Interest_Inv_Cur IS
154: SELECT aid.invoice_id invoice_id,
155: aid.dist_code_combination_id dist_code_combination_id,
156: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,
157: aid.invoice_line_number invoice_line_number, /* bug 5169128 */
158: aid.invoice_distribution_id parent_reversal_id, -- 2806074
159: aid.set_of_books_id set_of_books_id,
160: aid.amount * -1 amount,

Line 171: FROM ap_invoice_distributions aid,

167: -- aid.ussgl_transaction_code ussgl_transaction_code,
168: aid.org_id org_id,
169: aid.type_1099 type_1099,
170: aid.income_tax_region income_tax_region
171: FROM ap_invoice_distributions aid,
172: gl_code_combinations gl,
173: ap_invoice_payments aip,
174: ap_invoice_relationships air,
175: ap_lookup_codes alc

Line 209: ap_invoice_distributions_all aid_prepay,

205: -- bug9441420
206: CURSOR Prepay_Appl IS
207: SELECT DISTINCT aid.invoice_id
208: FROM ap_invoice_payments_all aip,
209: ap_invoice_distributions_all aid_prepay,
210: ap_invoices_all ai_prepay,
211: ap_invoice_distributions_all aid
212: WHERE aip.check_id = P_Check_ID
213: AND aip.invoice_id = aid_prepay.invoice_id

Line 211: ap_invoice_distributions_all aid

207: SELECT DISTINCT aid.invoice_id
208: FROM ap_invoice_payments_all aip,
209: ap_invoice_distributions_all aid_prepay,
210: ap_invoices_all ai_prepay,
211: ap_invoice_distributions_all aid
212: WHERE aip.check_id = P_Check_ID
213: AND aip.invoice_id = aid_prepay.invoice_id
214: AND aid_prepay.invoice_id = ai_prepay.invoice_id
215: AND ai_prepay.invoice_type_lookup_code = 'PREPAYMENT'

Line 593: l_debug_info := 'INSERT ap_invoice_distributions for Interest Invoice';

589: WHERE AIP.invoice_id = AIR.related_invoice_id
590: AND AIP.check_id = P_Check_Id
591: AND NVL(aip.reversal_flag, 'N') <> 'Y');
592:
593: l_debug_info := 'INSERT ap_invoice_distributions for Interest Invoice';
594: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
595: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
596: END IF;
597:

Line 600: FROM ap_invoice_distributions aid,

596: END IF;
597:
598: SELECT MAX(aid.distribution_line_number)
599: INTO l_max_dist_line_num
600: FROM ap_invoice_distributions aid,
601: gl_code_combinations gl,
602: ap_invoice_payments aip,
603: ap_invoice_relationships air,
604: ap_lookup_codes alc

Line 624: INSERT INTO ap_invoice_distributions_all

620:
621: l_max_dist_line_num := l_max_dist_line_num + 1;
622:
623:
624: INSERT INTO ap_invoice_distributions_all
625: (INVOICE_ID,
626: DIST_CODE_COMBINATION_ID,
627: INVOICE_DISTRIBUTION_ID,
628: INVOICE_LINE_NUMBER, /* bug 5169128 */

Line 726: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

722: Interest_Inv_Cur.income_tax_region);
723:
724: --Bug 4539462 DBI logging
725: AP_DBI_PKG.Maintain_DBI_Summary
726: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
727: p_operation => 'I',
728: p_key_value1 => Interest_Inv_Cur.invoice_id,
729: p_key_value2 => Interest_Inv_Cur.invoice_distribution_id,
730: p_calling_sequence => l_curr_calling_sequence);