DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on FND_DATE

Line 228: p_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_from_date); --Ramananda for File.Sql.35

224: pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
225: ) IS
226:
227: /* Ramananda for bug# 4336482 */
228: p_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_from_date); --Ramananda for File.Sql.35
229: p_to_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_to_date); --Ramananda for File.Sql.35
230: /* Ramananda for bug# 4336482 */
231:
232: p_override_manual_taxes VARCHAR2(1);

Line 229: p_to_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_to_date); --Ramananda for File.Sql.35

225: ) IS
226:
227: /* Ramananda for bug# 4336482 */
228: p_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_from_date); --Ramananda for File.Sql.35
229: p_to_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_to_date); --Ramananda for File.Sql.35
230: /* Ramananda for bug# 4336482 */
231:
232: p_override_manual_taxes VARCHAR2(1);
233: p_commit_interval NUMBER(9);

Line 841: using fnd_date.canonical_to_date function.

837: 5. 28/04/2005 rallamse for Bug#4336482, Version 116.1
838: For SEED there is a change in concurrent "JAINMTCH" to use FND_STANDARD_DATE with STANDARD_DATE format
839: Procedure ja_in_mass_tax_changes signature modified by converting p_from_date, p_to_date of DATE datatype
840: to pv_to_date, pv_to_date of varchar2 datatype. The varchar2 values are converted to DATE fromat
841: using fnd_date.canonical_to_date function.
842:
843: 6. 08-Jun-2005 Version 116.2 jai_cmn_mtax -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
844: as required for CASE COMPLAINCE.
845:

Line 915: p_from_date := fnd_date.canonical_to_date(pv_from_date);

911: v_message_01 := 'There is no defaulting tax category in the set up';
912: v_debug := FALSE;
913: v_document_find_failed := 'N';
914: v_failed := 'N';
915: p_from_date := fnd_date.canonical_to_date(pv_from_date);
916: p_to_date := fnd_date.canonical_to_date(pv_to_date);
917: v_log_file_name := 'jai_cmn_mtax_pkg.do_tax_redefaultation.log';
918: /* Added below code for bug#7351304 by JMEENA*/
919: IF p_from_date IS NULL THEN

Line 916: p_to_date := fnd_date.canonical_to_date(pv_to_date);

912: v_debug := FALSE;
913: v_document_find_failed := 'N';
914: v_failed := 'N';
915: p_from_date := fnd_date.canonical_to_date(pv_from_date);
916: p_to_date := fnd_date.canonical_to_date(pv_to_date);
917: v_log_file_name := 'jai_cmn_mtax_pkg.do_tax_redefaultation.log';
918: /* Added below code for bug#7351304 by JMEENA*/
919: IF p_from_date IS NULL THEN
920: p_from_date := to_date('01/01/1940','DD-MM-YYYY');