[Home] [Help]
30: This is required as effective dates are removed Regime setup
31:
32: 3 12/04/2005 Brathod, for Bug# 4286646, Version 115.2
33: Issue :-
34: Because of change in Valueset from JA_IN_DATE to FND_STANDARD_DATE Concurrent was resulting
35: in error because JA_IN_DATE uses normal date format while FND_STANDARD_DATE uses NLS_DATE format
36: and it is passed as character value.
37: Fix :-
38: Procedure signature modified to convert p_trx_from_date, p_trx_from_date from date to
31:
32: 3 12/04/2005 Brathod, for Bug# 4286646, Version 115.2
33: Issue :-
34: Because of change in Valueset from JA_IN_DATE to FND_STANDARD_DATE Concurrent was resulting
35: in error because JA_IN_DATE uses normal date format while FND_STANDARD_DATE uses NLS_DATE format
36: and it is passed as character value.
37: Fix :-
38: Procedure signature modified to convert p_trx_from_date, p_trx_from_date from date to
39: pv_trx_from_date, pv_trx_from_date varchar2. And the varchar2 values are converted back
1804: p_organization_id IN NUMBER DEFAULT NULL /*5694855*/
1805: ) IS
1806:
1807: v_today DATE ; -- := trunc(sysdate) -- File.Sql.35 by Brathod
1808: lv_standard_lookup CONSTANT varchar2(30) := 'STANDARD'; --rchandan for bug#4428980
1809: lv_debit_lookup CONSTANT varchar2(30) := 'DEBIT'; --rchandan for bug#4428980
1810: lv_credit_lookup CONSTANT varchar2(30) := 'CREDIT'; --Added by Eric Ma for bug#10376849 on 14-Dec-2010
1811: --Bug 4991017. Added by Lakshmi Gopalsami
1812: lv_entity_code CONSTANT varchar2(30) := 'AP_INVOICES';
1857: and xte.entity_code =lv_entity_code --'AP_INVOICES'
1858: and xte.source_id_int_1 = ai.invoice_id
1859: AND aid.invoice_id = ai.invoice_id
1860: and aid.accounting_event_id = xah.event_id
1861: AND ai.invoice_type_lookup_code IN (lv_standard_lookup, lv_debit_lookup,lv_credit_lookup) --lv_credit_lookup is added by Eric Ma for bug#10376849 on 14-Dec-2010
1862: --AND ai.cancelled_date IS NULL --Commented out by Xiao, for POT cancellation, reg bug#12533434
1863: AND ( aid.line_type_lookup_code = jai_constants.misc_line
1864: or exists (select 1 from jai_rcv_tp_invoices jtp where AID.invoice_id = jtp.invoice_id)) /* modified by vumaasha for bug 8965721 */
1865: AND aid.posted_flag = 'Y'
2882: END IF; --Add by Xiao for POT change, reg bug#12533434
2883:
2884: END LOOP;
2885:
2886: -- Logic to Process Prepayment Applications onto standard invoices that fall in the processing period
2887: FOR pp IN c_prepayment_applications(p_trx_from_date, p_trx_to_date) LOOP
2888: --11666653
2889: IF p_debug = 'Y' THEN
2890: fnd_file.put_line(fnd_file.log, 'Enter FOR pp IN c_prepayment_applications(p_trx_from_date, p_trx_to_date) LOOP pp.invoice_id'||pp.invoice_id);
4454: AND xte.entity_code = 'AP_INVOICES'
4455: AND xte.source_id_int_1 = ai.invoice_id
4456: AND aid.invoice_id = ai.invoice_id
4457: AND aid.accounting_event_id = xah.event_id
4458: AND ai.invoice_type_lookup_code IN ('STANDARD', 'DEBIT', 'CREDIT')
4459: AND aid.parent_reversal_id IS NULL
4460: AND nvl(aid.reversal_flag, 'N') = 'N' /*12793930 - Ensure Repository entries are not passed if a line is discarded*/
4461: AND ( aid.line_type_lookup_code = jai_constants.misc_line
4462: OR EXISTS (SELECT 1
4511: FROM ap_invoices_all ai
4512: , ap_invoice_distributions_all aid
4513: WHERE aid.invoice_id = ai.invoice_id
4514: AND aid.set_of_books_id = cp_sob_id
4515: AND ai.invoice_type_lookup_code IN ('STANDARD', 'DEBIT', 'CREDIT')
4516: AND ai.cancelled_date IS NOT NULL
4517: AND aid.line_type_lookup_code = jai_constants.misc_line
4518: AND aid.accounting_date between trunc(cp_start_date) AND (trunc(cp_till_date+1)-1/(24*60*60))
4519: AND ai.org_id = p_org_id