DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on FND_DATE

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

265: pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. Ramananda for for File.Sql.35
266: ) IS
267:
268: /* Ramananda for bug# 4336482 */
269: p_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_from_date); --Ramananda for File.Sql.35
270: p_to_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_to_date); --Ramananda for File.Sql.35
271: /* Ramananda for bug# 4336482 */
272:
273: p_override_manual_taxes VARCHAR2(1);

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

266: ) IS
267:
268: /* Ramananda for bug# 4336482 */
269: p_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_from_date); --Ramananda for File.Sql.35
270: p_to_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_to_date); --Ramananda for File.Sql.35
271: /* Ramananda for bug# 4336482 */
272:
273: p_override_manual_taxes VARCHAR2(1);
274: p_commit_interval NUMBER(9);

Line 1171: using fnd_date.canonical_to_date function.

1167: 5. 28/04/2005 rallamse for Bug#4336482, Version 116.1
1168: For SEED there is a change in concurrent "JAINMTCH" to use FND_STANDARD_DATE with STANDARD_DATE format
1169: Procedure ja_in_mass_tax_changes signature modified by converting p_from_date, p_to_date of DATE datatype
1170: to pv_to_date, pv_to_date of varchar2 datatype. The varchar2 values are converted to DATE fromat
1171: using fnd_date.canonical_to_date function.
1172:
1173: 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
1174: as required for CASE COMPLAINCE.
1175:

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

1261: v_message_01 := 'There is no defaulting tax category in the set up';
1262: v_debug := FALSE;
1263: v_document_find_failed := 'N';
1264: v_failed := 'N';
1265: p_from_date := fnd_date.canonical_to_date(pv_from_date);
1266: p_to_date := fnd_date.canonical_to_date(pv_to_date);
1267: v_log_file_name := 'jai_cmn_mtax_pkg.do_tax_redefaultation.log';
1268: /* Added below code for bug#7351304 by JMEENA*/
1269: IF p_from_date IS NULL THEN

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

1262: v_debug := FALSE;
1263: v_document_find_failed := 'N';
1264: v_failed := 'N';
1265: p_from_date := fnd_date.canonical_to_date(pv_from_date);
1266: p_to_date := fnd_date.canonical_to_date(pv_to_date);
1267: v_log_file_name := 'jai_cmn_mtax_pkg.do_tax_redefaultation.log';
1268: /* Added below code for bug#7351304 by JMEENA*/
1269: IF p_from_date IS NULL THEN
1270: p_from_date := to_date('01/01/1940','DD-MM-YYYY');