DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on STANDARD

Line 34: Because of change in Valueset from JA_IN_DATE to FND_STANDARD_DATE Concurrent was resulting

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

Line 35: in error because JA_IN_DATE uses normal date format while FND_STANDARD_DATE uses NLS_DATE format

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

Line 832: lv_standard_lookup CONSTANT varchar2(30) := 'STANDARD'; --rchandan for bug#4428980

828: p_organization_id IN NUMBER DEFAULT NULL /*5694855*/
829: ) IS
830:
831: v_today DATE ; -- := trunc(sysdate) -- File.Sql.35 by Brathod
832: lv_standard_lookup CONSTANT varchar2(30) := 'STANDARD'; --rchandan for bug#4428980
833: lv_debit_lookup CONSTANT varchar2(30) := 'DEBIT'; --rchandan for bug#4428980
834: --Bug 4991017. Added by Lakshmi Gopalsami
835: lv_entity_code CONSTANT varchar2(30) := 'AP_INVOICES';
836:

Line 883: AND ai.invoice_type_lookup_code IN (lv_standard_lookup, lv_debit_lookup)

879: and xte.entity_code =lv_entity_code --'AP_INVOICES'
880: and xte.source_id_int_1 = ai.invoice_id
881: AND aid.invoice_id = ai.invoice_id
882: and aid.accounting_event_id = xah.event_id
883: AND ai.invoice_type_lookup_code IN (lv_standard_lookup, lv_debit_lookup)
884: AND ai.cancelled_date IS NULL
885: AND aid.line_type_lookup_code = jai_constants.misc_line
886: AND aid.posted_flag = 'Y'
887: AND trunc(xah.accounting_date) between cp_start_date AND cp_till_date

Line 1454: -- Logic to Process Prepayment Applications onto standard invoices that fall in the processing period

1450: END IF;
1451:
1452: END LOOP;
1453:
1454: -- Logic to Process Prepayment Applications onto standard invoices that fall in the processing period
1455: FOR pp IN c_prepayment_applications(p_trx_from_date, p_trx_to_date) LOOP
1456:
1457: FOR dist IN c_invoice_distributions(pp.invoice_id) LOOP
1458: