eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_API_PUB dependencies on FND_DATE

Line 272: fnd_date.date_to_canonical ( origination_date ),

268: CURSOR lot_temp_csr ( p_lot_number VARCHAR2, p_trx_temp_id NUMBER )
269: IS
270: SELECT TO_CHAR ( vendor_id ),
271: grade_code,
272: fnd_date.date_to_canonical ( origination_date ),
273: date_code,
274: TO_CHAR ( status_id ),
275: fnd_date.date_to_canonical ( change_date ),
276: TO_NUMBER ( age ),

Line 275: fnd_date.date_to_canonical ( change_date ),

271: grade_code,
272: fnd_date.date_to_canonical ( origination_date ),
273: date_code,
274: TO_CHAR ( status_id ),
275: fnd_date.date_to_canonical ( change_date ),
276: TO_NUMBER ( age ),
277: fnd_date.date_to_canonical ( retest_date ),
278: fnd_date.date_to_canonical ( maturity_date ),
279: lot_attribute_category,

Line 277: fnd_date.date_to_canonical ( retest_date ),

273: date_code,
274: TO_CHAR ( status_id ),
275: fnd_date.date_to_canonical ( change_date ),
276: TO_NUMBER ( age ),
277: fnd_date.date_to_canonical ( retest_date ),
278: fnd_date.date_to_canonical ( maturity_date ),
279: lot_attribute_category,
280: TO_CHAR ( item_size ),
281: color,

Line 278: fnd_date.date_to_canonical ( maturity_date ),

274: TO_CHAR ( status_id ),
275: fnd_date.date_to_canonical ( change_date ),
276: TO_NUMBER ( age ),
277: fnd_date.date_to_canonical ( retest_date ),
278: fnd_date.date_to_canonical ( maturity_date ),
279: lot_attribute_category,
280: TO_CHAR ( item_size ),
281: color,
282: TO_CHAR ( volume ),

Line 285: fnd_date.date_to_canonical ( best_by_date ),

281: color,
282: TO_CHAR ( volume ),
283: volume_uom,
284: place_of_origin,
285: fnd_date.date_to_canonical ( best_by_date ),
286: TO_CHAR ( LENGTH ),
287: length_uom,
288: TO_CHAR ( recycled_content ),
289: TO_CHAR ( thickness ),

Line 314: fnd_date.date_to_canonical ( d_attribute1 ),

310: c_attribute17,
311: c_attribute18,
312: c_attribute19,
313: c_attribute20,
314: fnd_date.date_to_canonical ( d_attribute1 ),
315: fnd_date.date_to_canonical ( d_attribute2 ),
316: fnd_date.date_to_canonical ( d_attribute3 ),
317: fnd_date.date_to_canonical ( d_attribute4 ),
318: fnd_date.date_to_canonical ( d_attribute5 ),

Line 315: fnd_date.date_to_canonical ( d_attribute2 ),

311: c_attribute18,
312: c_attribute19,
313: c_attribute20,
314: fnd_date.date_to_canonical ( d_attribute1 ),
315: fnd_date.date_to_canonical ( d_attribute2 ),
316: fnd_date.date_to_canonical ( d_attribute3 ),
317: fnd_date.date_to_canonical ( d_attribute4 ),
318: fnd_date.date_to_canonical ( d_attribute5 ),
319: fnd_date.date_to_canonical ( d_attribute6 ),

Line 316: fnd_date.date_to_canonical ( d_attribute3 ),

312: c_attribute19,
313: c_attribute20,
314: fnd_date.date_to_canonical ( d_attribute1 ),
315: fnd_date.date_to_canonical ( d_attribute2 ),
316: fnd_date.date_to_canonical ( d_attribute3 ),
317: fnd_date.date_to_canonical ( d_attribute4 ),
318: fnd_date.date_to_canonical ( d_attribute5 ),
319: fnd_date.date_to_canonical ( d_attribute6 ),
320: fnd_date.date_to_canonical ( d_attribute7 ),

Line 317: fnd_date.date_to_canonical ( d_attribute4 ),

313: c_attribute20,
314: fnd_date.date_to_canonical ( d_attribute1 ),
315: fnd_date.date_to_canonical ( d_attribute2 ),
316: fnd_date.date_to_canonical ( d_attribute3 ),
317: fnd_date.date_to_canonical ( d_attribute4 ),
318: fnd_date.date_to_canonical ( d_attribute5 ),
319: fnd_date.date_to_canonical ( d_attribute6 ),
320: fnd_date.date_to_canonical ( d_attribute7 ),
321: fnd_date.date_to_canonical ( d_attribute8 ),

Line 318: fnd_date.date_to_canonical ( d_attribute5 ),

314: fnd_date.date_to_canonical ( d_attribute1 ),
315: fnd_date.date_to_canonical ( d_attribute2 ),
316: fnd_date.date_to_canonical ( d_attribute3 ),
317: fnd_date.date_to_canonical ( d_attribute4 ),
318: fnd_date.date_to_canonical ( d_attribute5 ),
319: fnd_date.date_to_canonical ( d_attribute6 ),
320: fnd_date.date_to_canonical ( d_attribute7 ),
321: fnd_date.date_to_canonical ( d_attribute8 ),
322: fnd_date.date_to_canonical ( d_attribute9 ),

Line 319: fnd_date.date_to_canonical ( d_attribute6 ),

315: fnd_date.date_to_canonical ( d_attribute2 ),
316: fnd_date.date_to_canonical ( d_attribute3 ),
317: fnd_date.date_to_canonical ( d_attribute4 ),
318: fnd_date.date_to_canonical ( d_attribute5 ),
319: fnd_date.date_to_canonical ( d_attribute6 ),
320: fnd_date.date_to_canonical ( d_attribute7 ),
321: fnd_date.date_to_canonical ( d_attribute8 ),
322: fnd_date.date_to_canonical ( d_attribute9 ),
323: fnd_date.date_to_canonical ( d_attribute10 ),

Line 320: fnd_date.date_to_canonical ( d_attribute7 ),

316: fnd_date.date_to_canonical ( d_attribute3 ),
317: fnd_date.date_to_canonical ( d_attribute4 ),
318: fnd_date.date_to_canonical ( d_attribute5 ),
319: fnd_date.date_to_canonical ( d_attribute6 ),
320: fnd_date.date_to_canonical ( d_attribute7 ),
321: fnd_date.date_to_canonical ( d_attribute8 ),
322: fnd_date.date_to_canonical ( d_attribute9 ),
323: fnd_date.date_to_canonical ( d_attribute10 ),
324: TO_CHAR ( n_attribute1 ),

Line 321: fnd_date.date_to_canonical ( d_attribute8 ),

317: fnd_date.date_to_canonical ( d_attribute4 ),
318: fnd_date.date_to_canonical ( d_attribute5 ),
319: fnd_date.date_to_canonical ( d_attribute6 ),
320: fnd_date.date_to_canonical ( d_attribute7 ),
321: fnd_date.date_to_canonical ( d_attribute8 ),
322: fnd_date.date_to_canonical ( d_attribute9 ),
323: fnd_date.date_to_canonical ( d_attribute10 ),
324: TO_CHAR ( n_attribute1 ),
325: TO_CHAR ( n_attribute2 ),

Line 322: fnd_date.date_to_canonical ( d_attribute9 ),

318: fnd_date.date_to_canonical ( d_attribute5 ),
319: fnd_date.date_to_canonical ( d_attribute6 ),
320: fnd_date.date_to_canonical ( d_attribute7 ),
321: fnd_date.date_to_canonical ( d_attribute8 ),
322: fnd_date.date_to_canonical ( d_attribute9 ),
323: fnd_date.date_to_canonical ( d_attribute10 ),
324: TO_CHAR ( n_attribute1 ),
325: TO_CHAR ( n_attribute2 ),
326: TO_CHAR ( n_attribute3 ),

Line 323: fnd_date.date_to_canonical ( d_attribute10 ),

319: fnd_date.date_to_canonical ( d_attribute6 ),
320: fnd_date.date_to_canonical ( d_attribute7 ),
321: fnd_date.date_to_canonical ( d_attribute8 ),
322: fnd_date.date_to_canonical ( d_attribute9 ),
323: fnd_date.date_to_canonical ( d_attribute10 ),
324: TO_CHAR ( n_attribute1 ),
325: TO_CHAR ( n_attribute2 ),
326: TO_CHAR ( n_attribute3 ),
327: TO_CHAR ( n_attribute4 ),

Line 1302: fnd_date.canonical_to_date(g_lot_attributes_tbl(3).column_value),

1298: x_object_id,
1299: g_lot_attributes_tbl(68).column_value,
1300: TO_NUMBER(g_lot_attributes_tbl(1).column_value),
1301: g_lot_attributes_tbl(2).column_value,
1302: fnd_date.canonical_to_date(g_lot_attributes_tbl(3).column_value),
1303: g_lot_attributes_tbl(4).column_value,
1304: decode(l_dest_status_enabled,'Y',TO_NUMBER(g_lot_attributes_tbl(5).column_value),1), --Added bug 4066234
1305: fnd_date.canonical_to_date (g_lot_attributes_tbl(6).column_value),
1306: TO_NUMBER(g_lot_attributes_tbl(7).column_value),

Line 1305: fnd_date.canonical_to_date (g_lot_attributes_tbl(6).column_value),

1301: g_lot_attributes_tbl(2).column_value,
1302: fnd_date.canonical_to_date(g_lot_attributes_tbl(3).column_value),
1303: g_lot_attributes_tbl(4).column_value,
1304: decode(l_dest_status_enabled,'Y',TO_NUMBER(g_lot_attributes_tbl(5).column_value),1), --Added bug 4066234
1305: fnd_date.canonical_to_date (g_lot_attributes_tbl(6).column_value),
1306: TO_NUMBER(g_lot_attributes_tbl(7).column_value),
1307: fnd_date.canonical_to_date(g_lot_attributes_tbl(8).column_value),
1308: fnd_date.canonical_to_date(g_lot_attributes_tbl(9).column_value),
1309: g_lot_attributes_tbl(10).column_value,

Line 1307: fnd_date.canonical_to_date(g_lot_attributes_tbl(8).column_value),

1303: g_lot_attributes_tbl(4).column_value,
1304: decode(l_dest_status_enabled,'Y',TO_NUMBER(g_lot_attributes_tbl(5).column_value),1), --Added bug 4066234
1305: fnd_date.canonical_to_date (g_lot_attributes_tbl(6).column_value),
1306: TO_NUMBER(g_lot_attributes_tbl(7).column_value),
1307: fnd_date.canonical_to_date(g_lot_attributes_tbl(8).column_value),
1308: fnd_date.canonical_to_date(g_lot_attributes_tbl(9).column_value),
1309: g_lot_attributes_tbl(10).column_value,
1310: TO_NUMBER(g_lot_attributes_tbl(11).column_value),
1311: g_lot_attributes_tbl(12).column_value,

Line 1308: fnd_date.canonical_to_date(g_lot_attributes_tbl(9).column_value),

1304: decode(l_dest_status_enabled,'Y',TO_NUMBER(g_lot_attributes_tbl(5).column_value),1), --Added bug 4066234
1305: fnd_date.canonical_to_date (g_lot_attributes_tbl(6).column_value),
1306: TO_NUMBER(g_lot_attributes_tbl(7).column_value),
1307: fnd_date.canonical_to_date(g_lot_attributes_tbl(8).column_value),
1308: fnd_date.canonical_to_date(g_lot_attributes_tbl(9).column_value),
1309: g_lot_attributes_tbl(10).column_value,
1310: TO_NUMBER(g_lot_attributes_tbl(11).column_value),
1311: g_lot_attributes_tbl(12).column_value,
1312: TO_NUMBER(g_lot_attributes_tbl(13).column_value),

Line 1315: fnd_date.canonical_to_date(g_lot_attributes_tbl(16).column_value),

1311: g_lot_attributes_tbl(12).column_value,
1312: TO_NUMBER(g_lot_attributes_tbl(13).column_value),
1313: g_lot_attributes_tbl(14).column_value,
1314: g_lot_attributes_tbl(15).column_value,
1315: fnd_date.canonical_to_date(g_lot_attributes_tbl(16).column_value),
1316: TO_NUMBER(g_lot_attributes_tbl(17).column_value),
1317: g_lot_attributes_tbl(18).column_value,
1318: TO_NUMBER(g_lot_attributes_tbl(19).column_value),
1319: TO_NUMBER(g_lot_attributes_tbl(20).column_value),

Line 1344: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).column_value),

1340: g_lot_attributes_tbl(41).column_value,
1341: g_lot_attributes_tbl(42).column_value,
1342: g_lot_attributes_tbl(43).column_value,
1343: g_lot_attributes_tbl(44).column_value,
1344: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).column_value),
1345: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1346: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1347: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1348: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),

Line 1345: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),

1341: g_lot_attributes_tbl(42).column_value,
1342: g_lot_attributes_tbl(43).column_value,
1343: g_lot_attributes_tbl(44).column_value,
1344: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).column_value),
1345: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1346: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1347: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1348: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1349: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),

Line 1346: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),

1342: g_lot_attributes_tbl(43).column_value,
1343: g_lot_attributes_tbl(44).column_value,
1344: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).column_value),
1345: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1346: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1347: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1348: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1349: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1350: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),

Line 1347: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),

1343: g_lot_attributes_tbl(44).column_value,
1344: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).column_value),
1345: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1346: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1347: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1348: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1349: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1350: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1351: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),

Line 1348: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),

1344: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).column_value),
1345: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1346: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1347: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1348: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1349: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1350: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1351: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1352: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),

Line 1349: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),

1345: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1346: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1347: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1348: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1349: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1350: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1351: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1352: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),
1353: fnd_date.canonical_to_date(g_lot_attributes_tbl(54).column_value),

Line 1350: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),

1346: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1347: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1348: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1349: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1350: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1351: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1352: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),
1353: fnd_date.canonical_to_date(g_lot_attributes_tbl(54).column_value),
1354: TO_NUMBER(g_lot_attributes_tbl(55).column_value),

Line 1351: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),

1347: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1348: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1349: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1350: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1351: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1352: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),
1353: fnd_date.canonical_to_date(g_lot_attributes_tbl(54).column_value),
1354: TO_NUMBER(g_lot_attributes_tbl(55).column_value),
1355: TO_NUMBER(g_lot_attributes_tbl(56).column_value),

Line 1352: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),

1348: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1349: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1350: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1351: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1352: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),
1353: fnd_date.canonical_to_date(g_lot_attributes_tbl(54).column_value),
1354: TO_NUMBER(g_lot_attributes_tbl(55).column_value),
1355: TO_NUMBER(g_lot_attributes_tbl(56).column_value),
1356: TO_NUMBER(g_lot_attributes_tbl(57).column_value),

Line 1353: fnd_date.canonical_to_date(g_lot_attributes_tbl(54).column_value),

1349: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1350: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1351: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1352: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),
1353: fnd_date.canonical_to_date(g_lot_attributes_tbl(54).column_value),
1354: TO_NUMBER(g_lot_attributes_tbl(55).column_value),
1355: TO_NUMBER(g_lot_attributes_tbl(56).column_value),
1356: TO_NUMBER(g_lot_attributes_tbl(57).column_value),
1357: TO_NUMBER(g_lot_attributes_tbl(58).column_value),

Line 1496: fnd_date.date_to_canonical ( origination_date ),

1492: CURSOR lot_temp_csr ( p_lot_number VARCHAR2, p_trx_temp_id NUMBER )
1493: IS
1494: SELECT TO_CHAR ( vendor_id ),
1495: grade_code,
1496: fnd_date.date_to_canonical ( origination_date ),
1497: date_code,
1498: TO_CHAR ( status_id ),
1499: fnd_date.date_to_canonical ( change_date ),
1500: TO_NUMBER ( age ),

Line 1499: fnd_date.date_to_canonical ( change_date ),

1495: grade_code,
1496: fnd_date.date_to_canonical ( origination_date ),
1497: date_code,
1498: TO_CHAR ( status_id ),
1499: fnd_date.date_to_canonical ( change_date ),
1500: TO_NUMBER ( age ),
1501: fnd_date.date_to_canonical ( retest_date ),
1502: fnd_date.date_to_canonical ( maturity_date ),
1503: lot_attribute_category,

Line 1501: fnd_date.date_to_canonical ( retest_date ),

1497: date_code,
1498: TO_CHAR ( status_id ),
1499: fnd_date.date_to_canonical ( change_date ),
1500: TO_NUMBER ( age ),
1501: fnd_date.date_to_canonical ( retest_date ),
1502: fnd_date.date_to_canonical ( maturity_date ),
1503: lot_attribute_category,
1504: TO_CHAR ( item_size ),
1505: color,

Line 1502: fnd_date.date_to_canonical ( maturity_date ),

1498: TO_CHAR ( status_id ),
1499: fnd_date.date_to_canonical ( change_date ),
1500: TO_NUMBER ( age ),
1501: fnd_date.date_to_canonical ( retest_date ),
1502: fnd_date.date_to_canonical ( maturity_date ),
1503: lot_attribute_category,
1504: TO_CHAR ( item_size ),
1505: color,
1506: TO_CHAR ( volume ),

Line 1509: fnd_date.date_to_canonical ( best_by_date ),

1505: color,
1506: TO_CHAR ( volume ),
1507: volume_uom,
1508: place_of_origin,
1509: fnd_date.date_to_canonical ( best_by_date ),
1510: TO_CHAR ( LENGTH ),
1511: length_uom,
1512: TO_CHAR ( recycled_content ),
1513: TO_CHAR ( thickness ),

Line 1538: fnd_date.date_to_canonical ( d_attribute1 ),

1534: c_attribute17,
1535: c_attribute18,
1536: c_attribute19,
1537: c_attribute20,
1538: fnd_date.date_to_canonical ( d_attribute1 ),
1539: fnd_date.date_to_canonical ( d_attribute2 ),
1540: fnd_date.date_to_canonical ( d_attribute3 ),
1541: fnd_date.date_to_canonical ( d_attribute4 ),
1542: fnd_date.date_to_canonical ( d_attribute5 ),

Line 1539: fnd_date.date_to_canonical ( d_attribute2 ),

1535: c_attribute18,
1536: c_attribute19,
1537: c_attribute20,
1538: fnd_date.date_to_canonical ( d_attribute1 ),
1539: fnd_date.date_to_canonical ( d_attribute2 ),
1540: fnd_date.date_to_canonical ( d_attribute3 ),
1541: fnd_date.date_to_canonical ( d_attribute4 ),
1542: fnd_date.date_to_canonical ( d_attribute5 ),
1543: fnd_date.date_to_canonical ( d_attribute6 ),

Line 1540: fnd_date.date_to_canonical ( d_attribute3 ),

1536: c_attribute19,
1537: c_attribute20,
1538: fnd_date.date_to_canonical ( d_attribute1 ),
1539: fnd_date.date_to_canonical ( d_attribute2 ),
1540: fnd_date.date_to_canonical ( d_attribute3 ),
1541: fnd_date.date_to_canonical ( d_attribute4 ),
1542: fnd_date.date_to_canonical ( d_attribute5 ),
1543: fnd_date.date_to_canonical ( d_attribute6 ),
1544: fnd_date.date_to_canonical ( d_attribute7 ),

Line 1541: fnd_date.date_to_canonical ( d_attribute4 ),

1537: c_attribute20,
1538: fnd_date.date_to_canonical ( d_attribute1 ),
1539: fnd_date.date_to_canonical ( d_attribute2 ),
1540: fnd_date.date_to_canonical ( d_attribute3 ),
1541: fnd_date.date_to_canonical ( d_attribute4 ),
1542: fnd_date.date_to_canonical ( d_attribute5 ),
1543: fnd_date.date_to_canonical ( d_attribute6 ),
1544: fnd_date.date_to_canonical ( d_attribute7 ),
1545: fnd_date.date_to_canonical ( d_attribute8 ),

Line 1542: fnd_date.date_to_canonical ( d_attribute5 ),

1538: fnd_date.date_to_canonical ( d_attribute1 ),
1539: fnd_date.date_to_canonical ( d_attribute2 ),
1540: fnd_date.date_to_canonical ( d_attribute3 ),
1541: fnd_date.date_to_canonical ( d_attribute4 ),
1542: fnd_date.date_to_canonical ( d_attribute5 ),
1543: fnd_date.date_to_canonical ( d_attribute6 ),
1544: fnd_date.date_to_canonical ( d_attribute7 ),
1545: fnd_date.date_to_canonical ( d_attribute8 ),
1546: fnd_date.date_to_canonical ( d_attribute9 ),

Line 1543: fnd_date.date_to_canonical ( d_attribute6 ),

1539: fnd_date.date_to_canonical ( d_attribute2 ),
1540: fnd_date.date_to_canonical ( d_attribute3 ),
1541: fnd_date.date_to_canonical ( d_attribute4 ),
1542: fnd_date.date_to_canonical ( d_attribute5 ),
1543: fnd_date.date_to_canonical ( d_attribute6 ),
1544: fnd_date.date_to_canonical ( d_attribute7 ),
1545: fnd_date.date_to_canonical ( d_attribute8 ),
1546: fnd_date.date_to_canonical ( d_attribute9 ),
1547: fnd_date.date_to_canonical ( d_attribute10 ),

Line 1544: fnd_date.date_to_canonical ( d_attribute7 ),

1540: fnd_date.date_to_canonical ( d_attribute3 ),
1541: fnd_date.date_to_canonical ( d_attribute4 ),
1542: fnd_date.date_to_canonical ( d_attribute5 ),
1543: fnd_date.date_to_canonical ( d_attribute6 ),
1544: fnd_date.date_to_canonical ( d_attribute7 ),
1545: fnd_date.date_to_canonical ( d_attribute8 ),
1546: fnd_date.date_to_canonical ( d_attribute9 ),
1547: fnd_date.date_to_canonical ( d_attribute10 ),
1548: TO_CHAR ( n_attribute1 ),

Line 1545: fnd_date.date_to_canonical ( d_attribute8 ),

1541: fnd_date.date_to_canonical ( d_attribute4 ),
1542: fnd_date.date_to_canonical ( d_attribute5 ),
1543: fnd_date.date_to_canonical ( d_attribute6 ),
1544: fnd_date.date_to_canonical ( d_attribute7 ),
1545: fnd_date.date_to_canonical ( d_attribute8 ),
1546: fnd_date.date_to_canonical ( d_attribute9 ),
1547: fnd_date.date_to_canonical ( d_attribute10 ),
1548: TO_CHAR ( n_attribute1 ),
1549: TO_CHAR ( n_attribute2 ),

Line 1546: fnd_date.date_to_canonical ( d_attribute9 ),

1542: fnd_date.date_to_canonical ( d_attribute5 ),
1543: fnd_date.date_to_canonical ( d_attribute6 ),
1544: fnd_date.date_to_canonical ( d_attribute7 ),
1545: fnd_date.date_to_canonical ( d_attribute8 ),
1546: fnd_date.date_to_canonical ( d_attribute9 ),
1547: fnd_date.date_to_canonical ( d_attribute10 ),
1548: TO_CHAR ( n_attribute1 ),
1549: TO_CHAR ( n_attribute2 ),
1550: TO_CHAR ( n_attribute3 ),

Line 1547: fnd_date.date_to_canonical ( d_attribute10 ),

1543: fnd_date.date_to_canonical ( d_attribute6 ),
1544: fnd_date.date_to_canonical ( d_attribute7 ),
1545: fnd_date.date_to_canonical ( d_attribute8 ),
1546: fnd_date.date_to_canonical ( d_attribute9 ),
1547: fnd_date.date_to_canonical ( d_attribute10 ),
1548: TO_CHAR ( n_attribute1 ),
1549: TO_CHAR ( n_attribute2 ),
1550: TO_CHAR ( n_attribute3 ),
1551: TO_CHAR ( n_attribute4 ),

Line 2115: fnd_date.canonical_to_date (

2111: p_serial_transaction_id,
2112: description,
2113: TO_NUMBER ( g_lot_attributes_tbl ( 1 ).column_value ),
2114: g_lot_attributes_tbl ( 2 ).column_value,
2115: fnd_date.canonical_to_date (
2116: g_lot_attributes_tbl ( 3 ).column_value
2117: ),
2118: g_lot_attributes_tbl ( 4 ).column_value,
2119: TO_NUMBER ( g_lot_attributes_tbl ( 5 ).column_value ),

Line 2120: fnd_date.canonical_to_date (

2116: g_lot_attributes_tbl ( 3 ).column_value
2117: ),
2118: g_lot_attributes_tbl ( 4 ).column_value,
2119: TO_NUMBER ( g_lot_attributes_tbl ( 5 ).column_value ),
2120: fnd_date.canonical_to_date (
2121: g_lot_attributes_tbl ( 6 ).column_value
2122: ),
2123: TO_NUMBER ( g_lot_attributes_tbl ( 7 ).column_value ),
2124: fnd_date.canonical_to_date (

Line 2124: fnd_date.canonical_to_date (

2120: fnd_date.canonical_to_date (
2121: g_lot_attributes_tbl ( 6 ).column_value
2122: ),
2123: TO_NUMBER ( g_lot_attributes_tbl ( 7 ).column_value ),
2124: fnd_date.canonical_to_date (
2125: g_lot_attributes_tbl ( 8 ).column_value
2126: ),
2127: fnd_date.canonical_to_date (
2128: g_lot_attributes_tbl ( 9 ).column_value

Line 2127: fnd_date.canonical_to_date (

2123: TO_NUMBER ( g_lot_attributes_tbl ( 7 ).column_value ),
2124: fnd_date.canonical_to_date (
2125: g_lot_attributes_tbl ( 8 ).column_value
2126: ),
2127: fnd_date.canonical_to_date (
2128: g_lot_attributes_tbl ( 9 ).column_value
2129: ),
2130: g_lot_attributes_tbl ( 10 ).column_value,
2131: TO_NUMBER ( g_lot_attributes_tbl ( 11 ).column_value ),

Line 2136: fnd_date.canonical_to_date (

2132: g_lot_attributes_tbl ( 12 ).column_value,
2133: TO_NUMBER ( g_lot_attributes_tbl ( 13 ).column_value ),
2134: g_lot_attributes_tbl ( 14 ).column_value,
2135: g_lot_attributes_tbl ( 15 ).column_value,
2136: fnd_date.canonical_to_date (
2137: g_lot_attributes_tbl ( 16 ).column_value
2138: ),
2139: TO_NUMBER ( g_lot_attributes_tbl ( 17 ).column_value ),
2140: g_lot_attributes_tbl ( 18 ).column_value,

Line 2167: fnd_date.canonical_to_date (

2163: g_lot_attributes_tbl ( 41 ).column_value,
2164: g_lot_attributes_tbl ( 42 ).column_value,
2165: g_lot_attributes_tbl ( 43 ).column_value,
2166: g_lot_attributes_tbl ( 44 ).column_value,
2167: fnd_date.canonical_to_date (
2168: g_lot_attributes_tbl ( 45 ).column_value
2169: ),
2170: fnd_date.canonical_to_date (
2171: g_lot_attributes_tbl ( 46 ).column_value

Line 2170: fnd_date.canonical_to_date (

2166: g_lot_attributes_tbl ( 44 ).column_value,
2167: fnd_date.canonical_to_date (
2168: g_lot_attributes_tbl ( 45 ).column_value
2169: ),
2170: fnd_date.canonical_to_date (
2171: g_lot_attributes_tbl ( 46 ).column_value
2172: ),
2173: fnd_date.canonical_to_date (
2174: g_lot_attributes_tbl ( 47 ).column_value

Line 2173: fnd_date.canonical_to_date (

2169: ),
2170: fnd_date.canonical_to_date (
2171: g_lot_attributes_tbl ( 46 ).column_value
2172: ),
2173: fnd_date.canonical_to_date (
2174: g_lot_attributes_tbl ( 47 ).column_value
2175: ),
2176: fnd_date.canonical_to_date (
2177: g_lot_attributes_tbl ( 48 ).column_value

Line 2176: fnd_date.canonical_to_date (

2172: ),
2173: fnd_date.canonical_to_date (
2174: g_lot_attributes_tbl ( 47 ).column_value
2175: ),
2176: fnd_date.canonical_to_date (
2177: g_lot_attributes_tbl ( 48 ).column_value
2178: ),
2179: fnd_date.canonical_to_date (
2180: g_lot_attributes_tbl ( 49 ).column_value

Line 2179: fnd_date.canonical_to_date (

2175: ),
2176: fnd_date.canonical_to_date (
2177: g_lot_attributes_tbl ( 48 ).column_value
2178: ),
2179: fnd_date.canonical_to_date (
2180: g_lot_attributes_tbl ( 49 ).column_value
2181: ),
2182: fnd_date.canonical_to_date (
2183: g_lot_attributes_tbl ( 50 ).column_value

Line 2182: fnd_date.canonical_to_date (

2178: ),
2179: fnd_date.canonical_to_date (
2180: g_lot_attributes_tbl ( 49 ).column_value
2181: ),
2182: fnd_date.canonical_to_date (
2183: g_lot_attributes_tbl ( 50 ).column_value
2184: ),
2185: fnd_date.canonical_to_date (
2186: g_lot_attributes_tbl ( 51 ).column_value

Line 2185: fnd_date.canonical_to_date (

2181: ),
2182: fnd_date.canonical_to_date (
2183: g_lot_attributes_tbl ( 50 ).column_value
2184: ),
2185: fnd_date.canonical_to_date (
2186: g_lot_attributes_tbl ( 51 ).column_value
2187: ),
2188: fnd_date.canonical_to_date (
2189: g_lot_attributes_tbl ( 52 ).column_value

Line 2188: fnd_date.canonical_to_date (

2184: ),
2185: fnd_date.canonical_to_date (
2186: g_lot_attributes_tbl ( 51 ).column_value
2187: ),
2188: fnd_date.canonical_to_date (
2189: g_lot_attributes_tbl ( 52 ).column_value
2190: ),
2191: fnd_date.canonical_to_date (
2192: g_lot_attributes_tbl ( 53 ).column_value

Line 2191: fnd_date.canonical_to_date (

2187: ),
2188: fnd_date.canonical_to_date (
2189: g_lot_attributes_tbl ( 52 ).column_value
2190: ),
2191: fnd_date.canonical_to_date (
2192: g_lot_attributes_tbl ( 53 ).column_value
2193: ),
2194: fnd_date.canonical_to_date (
2195: g_lot_attributes_tbl ( 54 ).column_value

Line 2194: fnd_date.canonical_to_date (

2190: ),
2191: fnd_date.canonical_to_date (
2192: g_lot_attributes_tbl ( 53 ).column_value
2193: ),
2194: fnd_date.canonical_to_date (
2195: g_lot_attributes_tbl ( 54 ).column_value
2196: ),
2197: TO_NUMBER ( g_lot_attributes_tbl ( 55 ).column_value ),
2198: TO_NUMBER ( g_lot_attributes_tbl ( 56 ).column_value ),

Line 3632: fnd_date.date_to_canonical ( origination_date ),

3628: END IF;
3629:
3630: SELECT TO_CHAR ( vendor_id ),
3631: grade_code,
3632: fnd_date.date_to_canonical ( origination_date ),
3633: date_code,
3634: TO_CHAR ( status_id ),
3635: fnd_date.date_to_canonical ( change_date ),
3636: TO_NUMBER ( age ),

Line 3635: fnd_date.date_to_canonical ( change_date ),

3631: grade_code,
3632: fnd_date.date_to_canonical ( origination_date ),
3633: date_code,
3634: TO_CHAR ( status_id ),
3635: fnd_date.date_to_canonical ( change_date ),
3636: TO_NUMBER ( age ),
3637: fnd_date.date_to_canonical ( retest_date ),
3638: fnd_date.date_to_canonical ( maturity_date ),
3639: lot_attribute_category,

Line 3637: fnd_date.date_to_canonical ( retest_date ),

3633: date_code,
3634: TO_CHAR ( status_id ),
3635: fnd_date.date_to_canonical ( change_date ),
3636: TO_NUMBER ( age ),
3637: fnd_date.date_to_canonical ( retest_date ),
3638: fnd_date.date_to_canonical ( maturity_date ),
3639: lot_attribute_category,
3640: TO_CHAR ( item_size ),
3641: color,

Line 3638: fnd_date.date_to_canonical ( maturity_date ),

3634: TO_CHAR ( status_id ),
3635: fnd_date.date_to_canonical ( change_date ),
3636: TO_NUMBER ( age ),
3637: fnd_date.date_to_canonical ( retest_date ),
3638: fnd_date.date_to_canonical ( maturity_date ),
3639: lot_attribute_category,
3640: TO_CHAR ( item_size ),
3641: color,
3642: TO_CHAR ( volume ),

Line 3645: fnd_date.date_to_canonical ( best_by_date ),

3641: color,
3642: TO_CHAR ( volume ),
3643: volume_uom,
3644: place_of_origin,
3645: fnd_date.date_to_canonical ( best_by_date ),
3646: TO_CHAR ( LENGTH ),
3647: length_uom,
3648: TO_CHAR ( recycled_content ),
3649: TO_CHAR ( thickness ),

Line 3674: fnd_date.date_to_canonical ( d_attribute1 ),

3670: c_attribute17,
3671: c_attribute18,
3672: c_attribute19,
3673: c_attribute20,
3674: fnd_date.date_to_canonical ( d_attribute1 ),
3675: fnd_date.date_to_canonical ( d_attribute2 ),
3676: fnd_date.date_to_canonical ( d_attribute3 ),
3677: fnd_date.date_to_canonical ( d_attribute4 ),
3678: fnd_date.date_to_canonical ( d_attribute5 ),

Line 3675: fnd_date.date_to_canonical ( d_attribute2 ),

3671: c_attribute18,
3672: c_attribute19,
3673: c_attribute20,
3674: fnd_date.date_to_canonical ( d_attribute1 ),
3675: fnd_date.date_to_canonical ( d_attribute2 ),
3676: fnd_date.date_to_canonical ( d_attribute3 ),
3677: fnd_date.date_to_canonical ( d_attribute4 ),
3678: fnd_date.date_to_canonical ( d_attribute5 ),
3679: fnd_date.date_to_canonical ( d_attribute6 ),

Line 3676: fnd_date.date_to_canonical ( d_attribute3 ),

3672: c_attribute19,
3673: c_attribute20,
3674: fnd_date.date_to_canonical ( d_attribute1 ),
3675: fnd_date.date_to_canonical ( d_attribute2 ),
3676: fnd_date.date_to_canonical ( d_attribute3 ),
3677: fnd_date.date_to_canonical ( d_attribute4 ),
3678: fnd_date.date_to_canonical ( d_attribute5 ),
3679: fnd_date.date_to_canonical ( d_attribute6 ),
3680: fnd_date.date_to_canonical ( d_attribute7 ),

Line 3677: fnd_date.date_to_canonical ( d_attribute4 ),

3673: c_attribute20,
3674: fnd_date.date_to_canonical ( d_attribute1 ),
3675: fnd_date.date_to_canonical ( d_attribute2 ),
3676: fnd_date.date_to_canonical ( d_attribute3 ),
3677: fnd_date.date_to_canonical ( d_attribute4 ),
3678: fnd_date.date_to_canonical ( d_attribute5 ),
3679: fnd_date.date_to_canonical ( d_attribute6 ),
3680: fnd_date.date_to_canonical ( d_attribute7 ),
3681: fnd_date.date_to_canonical ( d_attribute8 ),

Line 3678: fnd_date.date_to_canonical ( d_attribute5 ),

3674: fnd_date.date_to_canonical ( d_attribute1 ),
3675: fnd_date.date_to_canonical ( d_attribute2 ),
3676: fnd_date.date_to_canonical ( d_attribute3 ),
3677: fnd_date.date_to_canonical ( d_attribute4 ),
3678: fnd_date.date_to_canonical ( d_attribute5 ),
3679: fnd_date.date_to_canonical ( d_attribute6 ),
3680: fnd_date.date_to_canonical ( d_attribute7 ),
3681: fnd_date.date_to_canonical ( d_attribute8 ),
3682: fnd_date.date_to_canonical ( d_attribute9 ),

Line 3679: fnd_date.date_to_canonical ( d_attribute6 ),

3675: fnd_date.date_to_canonical ( d_attribute2 ),
3676: fnd_date.date_to_canonical ( d_attribute3 ),
3677: fnd_date.date_to_canonical ( d_attribute4 ),
3678: fnd_date.date_to_canonical ( d_attribute5 ),
3679: fnd_date.date_to_canonical ( d_attribute6 ),
3680: fnd_date.date_to_canonical ( d_attribute7 ),
3681: fnd_date.date_to_canonical ( d_attribute8 ),
3682: fnd_date.date_to_canonical ( d_attribute9 ),
3683: fnd_date.date_to_canonical ( d_attribute10 ),

Line 3680: fnd_date.date_to_canonical ( d_attribute7 ),

3676: fnd_date.date_to_canonical ( d_attribute3 ),
3677: fnd_date.date_to_canonical ( d_attribute4 ),
3678: fnd_date.date_to_canonical ( d_attribute5 ),
3679: fnd_date.date_to_canonical ( d_attribute6 ),
3680: fnd_date.date_to_canonical ( d_attribute7 ),
3681: fnd_date.date_to_canonical ( d_attribute8 ),
3682: fnd_date.date_to_canonical ( d_attribute9 ),
3683: fnd_date.date_to_canonical ( d_attribute10 ),
3684: TO_CHAR ( n_attribute1 ),

Line 3681: fnd_date.date_to_canonical ( d_attribute8 ),

3677: fnd_date.date_to_canonical ( d_attribute4 ),
3678: fnd_date.date_to_canonical ( d_attribute5 ),
3679: fnd_date.date_to_canonical ( d_attribute6 ),
3680: fnd_date.date_to_canonical ( d_attribute7 ),
3681: fnd_date.date_to_canonical ( d_attribute8 ),
3682: fnd_date.date_to_canonical ( d_attribute9 ),
3683: fnd_date.date_to_canonical ( d_attribute10 ),
3684: TO_CHAR ( n_attribute1 ),
3685: TO_CHAR ( n_attribute2 ),

Line 3682: fnd_date.date_to_canonical ( d_attribute9 ),

3678: fnd_date.date_to_canonical ( d_attribute5 ),
3679: fnd_date.date_to_canonical ( d_attribute6 ),
3680: fnd_date.date_to_canonical ( d_attribute7 ),
3681: fnd_date.date_to_canonical ( d_attribute8 ),
3682: fnd_date.date_to_canonical ( d_attribute9 ),
3683: fnd_date.date_to_canonical ( d_attribute10 ),
3684: TO_CHAR ( n_attribute1 ),
3685: TO_CHAR ( n_attribute2 ),
3686: TO_CHAR ( n_attribute3 ),

Line 3683: fnd_date.date_to_canonical ( d_attribute10 ),

3679: fnd_date.date_to_canonical ( d_attribute6 ),
3680: fnd_date.date_to_canonical ( d_attribute7 ),
3681: fnd_date.date_to_canonical ( d_attribute8 ),
3682: fnd_date.date_to_canonical ( d_attribute9 ),
3683: fnd_date.date_to_canonical ( d_attribute10 ),
3684: TO_CHAR ( n_attribute1 ),
3685: TO_CHAR ( n_attribute2 ),
3686: TO_CHAR ( n_attribute3 ),
3687: TO_CHAR ( n_attribute4 ),

Line 7179: lot_dff(3).column_value := fnd_date.date_to_canonical(p_origination_date);

7175: lot_dff(3).column_type := 'DATE';
7176: IF P_ORIGINATION_DATE =G_MISS_DATE THEN
7177: lot_dff(3).column_value := NULL;
7178: ELSE
7179: lot_dff(3).column_value := fnd_date.date_to_canonical(p_origination_date);
7180: END IF;
7181:
7182: lot_dff(4).column_name := 'DATE_CODE';
7183: lot_dff(4).column_type := 'VARCHAR2';

Line 7195: lot_dff(5).column_value := fnd_date.date_to_canonical(p_change_date);

7191: lot_dff(5).column_type := 'DATE';
7192: IF p_change_date= G_MISS_DATE THEN
7193: lot_dff(5).column_value := NULL;
7194: ELSE
7195: lot_dff(5).column_value := fnd_date.date_to_canonical(p_change_date);
7196: END IF;
7197:
7198: lot_dff(6).column_name := 'ORIGINATION_DATE';
7199: lot_dff(6).column_type := 'DATE';

Line 7203: lot_dff(6).column_value := fnd_date.date_to_canonical(p_origination_date);

7199: lot_dff(6).column_type := 'DATE';
7200: IF p_origination_date=G_MISS_DATE THEN
7201: lot_dff(6).column_value := NULL;
7202: ELSE
7203: lot_dff(6).column_value := fnd_date.date_to_canonical(p_origination_date);
7204: END IF;
7205:
7206: lot_dff(6).column_name := 'AGE';
7207: lot_dff(6).column_type := 'NUMBER';

Line 7219: lot_dff(7).column_value := fnd_date.date_to_canonical(p_retest_date);

7215: lot_dff(7).column_type := 'DATE';
7216: IF p_retest_date=G_MISS_DATE THEN
7217: lot_dff(7).column_value := NULL;
7218: ELSE
7219: lot_dff(7).column_value := fnd_date.date_to_canonical(p_retest_date);
7220: END IF;
7221:
7222: lot_dff(8).column_name := 'MATURITY_DATE';
7223: lot_dff(8).column_type := 'DATE';

Line 7227: lot_dff(8).column_value := fnd_date.date_to_canonical(p_maturity_date);

7223: lot_dff(8).column_type := 'DATE';
7224: IF p_maturity_date= G_MISS_DATE THEN
7225: lot_dff(8).column_value := NULL;
7226: ELSE
7227: lot_dff(8).column_value := fnd_date.date_to_canonical(p_maturity_date);
7228: END IF;
7229:
7230: lot_dff(9).column_name := 'ITEM_SIZE';
7231: lot_dff(9).column_type := 'NUMBER';

Line 7276: lot_dff(14).column_value := fnd_date.date_to_canonical(p_best_by_date);

7272: IF p_best_by_date= G_MISS_DATE THEN
7273: lot_dff(14).column_value := NULL;
7274: ELSE
7275: --BUG 3784406: Call date_to_canonical, instead of canonical_to_date
7276: lot_dff(14).column_value := fnd_date.date_to_canonical(p_best_by_date);
7277: END IF;
7278:
7279: lot_dff(15).column_name := 'LENGTH';
7280: lot_dff(15).column_type := 'NUMBER';

Line 7512: -- BUG 3784406: Call fnd_date.date_to_canonical

7508: l_d_attr_index := p_d_attributes_tbl.FIRST;
7509:
7510: WHILE l_d_attr_index <= p_d_attributes_tbl.LAST LOOP
7511: IF p_d_attributes_tbl(l_d_attr_index) IS NOT NULL THEN
7512: -- BUG 3784406: Call fnd_date.date_to_canonical
7513: IF g_debug = 1 THEN
7514: print_debug('Date before casting into DD:MM:YYYY format'||To_char(p_d_attributes_tbl(l_d_attr_index),'DD:MM:YYYY'), 9);
7515: END IF;
7516: lot_dff(53 + l_d_attr_index).column_value := fnd_date.date_to_canonical(p_d_attributes_tbl(l_d_attr_index));

Line 7516: lot_dff(53 + l_d_attr_index).column_value := fnd_date.date_to_canonical(p_d_attributes_tbl(l_d_attr_index));

7512: -- BUG 3784406: Call fnd_date.date_to_canonical
7513: IF g_debug = 1 THEN
7514: print_debug('Date before casting into DD:MM:YYYY format'||To_char(p_d_attributes_tbl(l_d_attr_index),'DD:MM:YYYY'), 9);
7515: END IF;
7516: lot_dff(53 + l_d_attr_index).column_value := fnd_date.date_to_canonical(p_d_attributes_tbl(l_d_attr_index));
7517: IF g_debug = 1 THEN
7518: print_debug('Date after casting in canonical format ' || lot_dff(53 + l_d_attr_index).column_value,9);
7519: END IF;
7520: ELSE

Line 7628: fnd_flex_descval.set_column_value(lot_dff(j).column_name, fnd_date.canonical_to_date(lot_dff(j).column_value));

7624: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
7625: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7626: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7627: ELSIF lot_dff(j).column_type = 'DATE' THEN
7628: fnd_flex_descval.set_column_value(lot_dff(j).column_name, fnd_date.canonical_to_date(lot_dff(j).column_value));
7629: END IF;
7630:
7631: IF lot_dff(j).column_value IS NOT NULL THEN
7632: l_value_not_null_flag := 1;

Line 7721: fnd_date.canonical_to_date(lot_dff(j).column_value));

7717: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7718: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7719: ELSIF lot_dff(j).column_type = 'DATE' THEN
7720: fnd_flex_descval.set_column_value(lot_dff(j).column_name,
7721: fnd_date.canonical_to_date(lot_dff(j).column_value));
7722: END IF;
7723:
7724: IF lot_dff(j).column_value IS NOT NULL THEN
7725: l_value_not_null_flag := 1;