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 383: fnd_date.date_to_canonical ( origination_date ),

379: CURSOR lot_temp_csr ( p_lot_number VARCHAR2, p_trx_temp_id NUMBER )
380: IS
381: SELECT TO_CHAR ( vendor_id ),
382: grade_code,
383: fnd_date.date_to_canonical ( origination_date ),
384: date_code,
385: TO_CHAR ( status_id ),
386: fnd_date.date_to_canonical ( change_date ),
387: TO_NUMBER ( age ),

Line 386: fnd_date.date_to_canonical ( change_date ),

382: grade_code,
383: fnd_date.date_to_canonical ( origination_date ),
384: date_code,
385: TO_CHAR ( status_id ),
386: fnd_date.date_to_canonical ( change_date ),
387: TO_NUMBER ( age ),
388: fnd_date.date_to_canonical ( retest_date ),
389: fnd_date.date_to_canonical ( maturity_date ),
390: lot_attribute_category,

Line 388: fnd_date.date_to_canonical ( retest_date ),

384: date_code,
385: TO_CHAR ( status_id ),
386: fnd_date.date_to_canonical ( change_date ),
387: TO_NUMBER ( age ),
388: fnd_date.date_to_canonical ( retest_date ),
389: fnd_date.date_to_canonical ( maturity_date ),
390: lot_attribute_category,
391: TO_CHAR ( item_size ),
392: color,

Line 389: fnd_date.date_to_canonical ( maturity_date ),

385: TO_CHAR ( status_id ),
386: fnd_date.date_to_canonical ( change_date ),
387: TO_NUMBER ( age ),
388: fnd_date.date_to_canonical ( retest_date ),
389: fnd_date.date_to_canonical ( maturity_date ),
390: lot_attribute_category,
391: TO_CHAR ( item_size ),
392: color,
393: TO_CHAR ( volume ),

Line 396: fnd_date.date_to_canonical ( best_by_date ),

392: color,
393: TO_CHAR ( volume ),
394: volume_uom,
395: place_of_origin,
396: fnd_date.date_to_canonical ( best_by_date ),
397: TO_CHAR ( LENGTH ),
398: length_uom,
399: TO_CHAR ( recycled_content ),
400: TO_CHAR ( thickness ),

Line 425: fnd_date.date_to_canonical ( d_attribute1 ),

421: c_attribute17,
422: c_attribute18,
423: c_attribute19,
424: c_attribute20,
425: fnd_date.date_to_canonical ( d_attribute1 ),
426: fnd_date.date_to_canonical ( d_attribute2 ),
427: fnd_date.date_to_canonical ( d_attribute3 ),
428: fnd_date.date_to_canonical ( d_attribute4 ),
429: fnd_date.date_to_canonical ( d_attribute5 ),

Line 426: fnd_date.date_to_canonical ( d_attribute2 ),

422: c_attribute18,
423: c_attribute19,
424: c_attribute20,
425: fnd_date.date_to_canonical ( d_attribute1 ),
426: fnd_date.date_to_canonical ( d_attribute2 ),
427: fnd_date.date_to_canonical ( d_attribute3 ),
428: fnd_date.date_to_canonical ( d_attribute4 ),
429: fnd_date.date_to_canonical ( d_attribute5 ),
430: fnd_date.date_to_canonical ( d_attribute6 ),

Line 427: fnd_date.date_to_canonical ( d_attribute3 ),

423: c_attribute19,
424: c_attribute20,
425: fnd_date.date_to_canonical ( d_attribute1 ),
426: fnd_date.date_to_canonical ( d_attribute2 ),
427: fnd_date.date_to_canonical ( d_attribute3 ),
428: fnd_date.date_to_canonical ( d_attribute4 ),
429: fnd_date.date_to_canonical ( d_attribute5 ),
430: fnd_date.date_to_canonical ( d_attribute6 ),
431: fnd_date.date_to_canonical ( d_attribute7 ),

Line 428: fnd_date.date_to_canonical ( d_attribute4 ),

424: c_attribute20,
425: fnd_date.date_to_canonical ( d_attribute1 ),
426: fnd_date.date_to_canonical ( d_attribute2 ),
427: fnd_date.date_to_canonical ( d_attribute3 ),
428: fnd_date.date_to_canonical ( d_attribute4 ),
429: fnd_date.date_to_canonical ( d_attribute5 ),
430: fnd_date.date_to_canonical ( d_attribute6 ),
431: fnd_date.date_to_canonical ( d_attribute7 ),
432: fnd_date.date_to_canonical ( d_attribute8 ),

Line 429: fnd_date.date_to_canonical ( d_attribute5 ),

425: fnd_date.date_to_canonical ( d_attribute1 ),
426: fnd_date.date_to_canonical ( d_attribute2 ),
427: fnd_date.date_to_canonical ( d_attribute3 ),
428: fnd_date.date_to_canonical ( d_attribute4 ),
429: fnd_date.date_to_canonical ( d_attribute5 ),
430: fnd_date.date_to_canonical ( d_attribute6 ),
431: fnd_date.date_to_canonical ( d_attribute7 ),
432: fnd_date.date_to_canonical ( d_attribute8 ),
433: fnd_date.date_to_canonical ( d_attribute9 ),

Line 430: fnd_date.date_to_canonical ( d_attribute6 ),

426: fnd_date.date_to_canonical ( d_attribute2 ),
427: fnd_date.date_to_canonical ( d_attribute3 ),
428: fnd_date.date_to_canonical ( d_attribute4 ),
429: fnd_date.date_to_canonical ( d_attribute5 ),
430: fnd_date.date_to_canonical ( d_attribute6 ),
431: fnd_date.date_to_canonical ( d_attribute7 ),
432: fnd_date.date_to_canonical ( d_attribute8 ),
433: fnd_date.date_to_canonical ( d_attribute9 ),
434: fnd_date.date_to_canonical ( d_attribute10 ),

Line 431: fnd_date.date_to_canonical ( d_attribute7 ),

427: fnd_date.date_to_canonical ( d_attribute3 ),
428: fnd_date.date_to_canonical ( d_attribute4 ),
429: fnd_date.date_to_canonical ( d_attribute5 ),
430: fnd_date.date_to_canonical ( d_attribute6 ),
431: fnd_date.date_to_canonical ( d_attribute7 ),
432: fnd_date.date_to_canonical ( d_attribute8 ),
433: fnd_date.date_to_canonical ( d_attribute9 ),
434: fnd_date.date_to_canonical ( d_attribute10 ),
435: TO_CHAR ( n_attribute1 ),

Line 432: fnd_date.date_to_canonical ( d_attribute8 ),

428: fnd_date.date_to_canonical ( d_attribute4 ),
429: fnd_date.date_to_canonical ( d_attribute5 ),
430: fnd_date.date_to_canonical ( d_attribute6 ),
431: fnd_date.date_to_canonical ( d_attribute7 ),
432: fnd_date.date_to_canonical ( d_attribute8 ),
433: fnd_date.date_to_canonical ( d_attribute9 ),
434: fnd_date.date_to_canonical ( d_attribute10 ),
435: TO_CHAR ( n_attribute1 ),
436: TO_CHAR ( n_attribute2 ),

Line 433: fnd_date.date_to_canonical ( d_attribute9 ),

429: fnd_date.date_to_canonical ( d_attribute5 ),
430: fnd_date.date_to_canonical ( d_attribute6 ),
431: fnd_date.date_to_canonical ( d_attribute7 ),
432: fnd_date.date_to_canonical ( d_attribute8 ),
433: fnd_date.date_to_canonical ( d_attribute9 ),
434: fnd_date.date_to_canonical ( d_attribute10 ),
435: TO_CHAR ( n_attribute1 ),
436: TO_CHAR ( n_attribute2 ),
437: TO_CHAR ( n_attribute3 ),

Line 434: fnd_date.date_to_canonical ( d_attribute10 ),

430: fnd_date.date_to_canonical ( d_attribute6 ),
431: fnd_date.date_to_canonical ( d_attribute7 ),
432: fnd_date.date_to_canonical ( d_attribute8 ),
433: fnd_date.date_to_canonical ( d_attribute9 ),
434: fnd_date.date_to_canonical ( d_attribute10 ),
435: TO_CHAR ( n_attribute1 ),
436: TO_CHAR ( n_attribute2 ),
437: TO_CHAR ( n_attribute3 ),
438: TO_CHAR ( n_attribute4 ),

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

1415: x_object_id,
1416: g_lot_attributes_tbl(68).column_value,
1417: TO_NUMBER(g_lot_attributes_tbl(1).column_value),
1418: g_lot_attributes_tbl(2).column_value,
1419: fnd_date.canonical_to_date(g_lot_attributes_tbl(3).column_value),
1420: g_lot_attributes_tbl(4).column_value,
1421: decode(l_dest_status_enabled,'Y',TO_NUMBER(g_lot_attributes_tbl(5).column_value),1), --Added bug 4066234
1422: fnd_date.canonical_to_date (g_lot_attributes_tbl(6).column_value),
1423: TO_NUMBER(g_lot_attributes_tbl(7).column_value),

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

1418: g_lot_attributes_tbl(2).column_value,
1419: fnd_date.canonical_to_date(g_lot_attributes_tbl(3).column_value),
1420: g_lot_attributes_tbl(4).column_value,
1421: decode(l_dest_status_enabled,'Y',TO_NUMBER(g_lot_attributes_tbl(5).column_value),1), --Added bug 4066234
1422: fnd_date.canonical_to_date (g_lot_attributes_tbl(6).column_value),
1423: TO_NUMBER(g_lot_attributes_tbl(7).column_value),
1424: fnd_date.canonical_to_date(g_lot_attributes_tbl(8).column_value),
1425: fnd_date.canonical_to_date(g_lot_attributes_tbl(9).column_value),
1426: g_lot_attributes_tbl(10).column_value,

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

1420: g_lot_attributes_tbl(4).column_value,
1421: decode(l_dest_status_enabled,'Y',TO_NUMBER(g_lot_attributes_tbl(5).column_value),1), --Added bug 4066234
1422: fnd_date.canonical_to_date (g_lot_attributes_tbl(6).column_value),
1423: TO_NUMBER(g_lot_attributes_tbl(7).column_value),
1424: fnd_date.canonical_to_date(g_lot_attributes_tbl(8).column_value),
1425: fnd_date.canonical_to_date(g_lot_attributes_tbl(9).column_value),
1426: g_lot_attributes_tbl(10).column_value,
1427: TO_NUMBER(g_lot_attributes_tbl(11).column_value),
1428: g_lot_attributes_tbl(12).column_value,

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

1421: decode(l_dest_status_enabled,'Y',TO_NUMBER(g_lot_attributes_tbl(5).column_value),1), --Added bug 4066234
1422: fnd_date.canonical_to_date (g_lot_attributes_tbl(6).column_value),
1423: TO_NUMBER(g_lot_attributes_tbl(7).column_value),
1424: fnd_date.canonical_to_date(g_lot_attributes_tbl(8).column_value),
1425: fnd_date.canonical_to_date(g_lot_attributes_tbl(9).column_value),
1426: g_lot_attributes_tbl(10).column_value,
1427: TO_NUMBER(g_lot_attributes_tbl(11).column_value),
1428: g_lot_attributes_tbl(12).column_value,
1429: TO_NUMBER(g_lot_attributes_tbl(13).column_value),

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

1428: g_lot_attributes_tbl(12).column_value,
1429: TO_NUMBER(g_lot_attributes_tbl(13).column_value),
1430: g_lot_attributes_tbl(14).column_value,
1431: g_lot_attributes_tbl(15).column_value,
1432: fnd_date.canonical_to_date(g_lot_attributes_tbl(16).column_value),
1433: TO_NUMBER(g_lot_attributes_tbl(17).column_value),
1434: g_lot_attributes_tbl(18).column_value,
1435: TO_NUMBER(g_lot_attributes_tbl(19).column_value),
1436: TO_NUMBER(g_lot_attributes_tbl(20).column_value),

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

1457: g_lot_attributes_tbl(41).column_value,
1458: g_lot_attributes_tbl(42).column_value,
1459: g_lot_attributes_tbl(43).column_value,
1460: g_lot_attributes_tbl(44).column_value,
1461: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).column_value),
1462: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1463: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1464: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1465: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),

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

1458: g_lot_attributes_tbl(42).column_value,
1459: g_lot_attributes_tbl(43).column_value,
1460: g_lot_attributes_tbl(44).column_value,
1461: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).column_value),
1462: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1463: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1464: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1465: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1466: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),

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

1459: g_lot_attributes_tbl(43).column_value,
1460: g_lot_attributes_tbl(44).column_value,
1461: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).column_value),
1462: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1463: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1464: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1465: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1466: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1467: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),

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

1460: g_lot_attributes_tbl(44).column_value,
1461: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).column_value),
1462: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1463: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1464: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1465: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1466: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1467: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1468: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),

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

1461: fnd_date.canonical_to_date(g_lot_attributes_tbl(45).column_value),
1462: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1463: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1464: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1465: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1466: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1467: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1468: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1469: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),

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

1462: fnd_date.canonical_to_date(g_lot_attributes_tbl(46).column_value),
1463: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1464: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1465: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1466: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1467: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1468: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1469: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),
1470: fnd_date.canonical_to_date(g_lot_attributes_tbl(54).column_value),

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

1463: fnd_date.canonical_to_date(g_lot_attributes_tbl(47).column_value),
1464: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1465: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1466: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1467: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1468: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1469: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),
1470: fnd_date.canonical_to_date(g_lot_attributes_tbl(54).column_value),
1471: TO_NUMBER(g_lot_attributes_tbl(55).column_value),

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

1464: fnd_date.canonical_to_date(g_lot_attributes_tbl(48).column_value),
1465: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1466: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1467: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1468: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1469: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),
1470: fnd_date.canonical_to_date(g_lot_attributes_tbl(54).column_value),
1471: TO_NUMBER(g_lot_attributes_tbl(55).column_value),
1472: TO_NUMBER(g_lot_attributes_tbl(56).column_value),

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

1465: fnd_date.canonical_to_date(g_lot_attributes_tbl(49).column_value),
1466: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1467: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1468: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1469: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),
1470: fnd_date.canonical_to_date(g_lot_attributes_tbl(54).column_value),
1471: TO_NUMBER(g_lot_attributes_tbl(55).column_value),
1472: TO_NUMBER(g_lot_attributes_tbl(56).column_value),
1473: TO_NUMBER(g_lot_attributes_tbl(57).column_value),

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

1466: fnd_date.canonical_to_date(g_lot_attributes_tbl(50).column_value),
1467: fnd_date.canonical_to_date(g_lot_attributes_tbl(51).column_value),
1468: fnd_date.canonical_to_date(g_lot_attributes_tbl(52).column_value),
1469: fnd_date.canonical_to_date(g_lot_attributes_tbl(53).column_value),
1470: fnd_date.canonical_to_date(g_lot_attributes_tbl(54).column_value),
1471: TO_NUMBER(g_lot_attributes_tbl(55).column_value),
1472: TO_NUMBER(g_lot_attributes_tbl(56).column_value),
1473: TO_NUMBER(g_lot_attributes_tbl(57).column_value),
1474: TO_NUMBER(g_lot_attributes_tbl(58).column_value),

Line 1615: fnd_date.date_to_canonical ( origination_date ),

1611: CURSOR lot_temp_csr ( p_lot_number VARCHAR2, p_trx_temp_id NUMBER )
1612: IS
1613: SELECT TO_CHAR ( vendor_id ),
1614: grade_code,
1615: fnd_date.date_to_canonical ( origination_date ),
1616: date_code,
1617: TO_CHAR ( status_id ),
1618: fnd_date.date_to_canonical ( change_date ),
1619: TO_NUMBER ( age ),

Line 1618: fnd_date.date_to_canonical ( change_date ),

1614: grade_code,
1615: fnd_date.date_to_canonical ( origination_date ),
1616: date_code,
1617: TO_CHAR ( status_id ),
1618: fnd_date.date_to_canonical ( change_date ),
1619: TO_NUMBER ( age ),
1620: fnd_date.date_to_canonical ( retest_date ),
1621: fnd_date.date_to_canonical ( maturity_date ),
1622: lot_attribute_category,

Line 1620: fnd_date.date_to_canonical ( retest_date ),

1616: date_code,
1617: TO_CHAR ( status_id ),
1618: fnd_date.date_to_canonical ( change_date ),
1619: TO_NUMBER ( age ),
1620: fnd_date.date_to_canonical ( retest_date ),
1621: fnd_date.date_to_canonical ( maturity_date ),
1622: lot_attribute_category,
1623: TO_CHAR ( item_size ),
1624: color,

Line 1621: fnd_date.date_to_canonical ( maturity_date ),

1617: TO_CHAR ( status_id ),
1618: fnd_date.date_to_canonical ( change_date ),
1619: TO_NUMBER ( age ),
1620: fnd_date.date_to_canonical ( retest_date ),
1621: fnd_date.date_to_canonical ( maturity_date ),
1622: lot_attribute_category,
1623: TO_CHAR ( item_size ),
1624: color,
1625: TO_CHAR ( volume ),

Line 1628: fnd_date.date_to_canonical ( best_by_date ),

1624: color,
1625: TO_CHAR ( volume ),
1626: volume_uom,
1627: place_of_origin,
1628: fnd_date.date_to_canonical ( best_by_date ),
1629: TO_CHAR ( LENGTH ),
1630: length_uom,
1631: TO_CHAR ( recycled_content ),
1632: TO_CHAR ( thickness ),

Line 1657: fnd_date.date_to_canonical ( d_attribute1 ),

1653: c_attribute17,
1654: c_attribute18,
1655: c_attribute19,
1656: c_attribute20,
1657: fnd_date.date_to_canonical ( d_attribute1 ),
1658: fnd_date.date_to_canonical ( d_attribute2 ),
1659: fnd_date.date_to_canonical ( d_attribute3 ),
1660: fnd_date.date_to_canonical ( d_attribute4 ),
1661: fnd_date.date_to_canonical ( d_attribute5 ),

Line 1658: fnd_date.date_to_canonical ( d_attribute2 ),

1654: c_attribute18,
1655: c_attribute19,
1656: c_attribute20,
1657: fnd_date.date_to_canonical ( d_attribute1 ),
1658: fnd_date.date_to_canonical ( d_attribute2 ),
1659: fnd_date.date_to_canonical ( d_attribute3 ),
1660: fnd_date.date_to_canonical ( d_attribute4 ),
1661: fnd_date.date_to_canonical ( d_attribute5 ),
1662: fnd_date.date_to_canonical ( d_attribute6 ),

Line 1659: fnd_date.date_to_canonical ( d_attribute3 ),

1655: c_attribute19,
1656: c_attribute20,
1657: fnd_date.date_to_canonical ( d_attribute1 ),
1658: fnd_date.date_to_canonical ( d_attribute2 ),
1659: fnd_date.date_to_canonical ( d_attribute3 ),
1660: fnd_date.date_to_canonical ( d_attribute4 ),
1661: fnd_date.date_to_canonical ( d_attribute5 ),
1662: fnd_date.date_to_canonical ( d_attribute6 ),
1663: fnd_date.date_to_canonical ( d_attribute7 ),

Line 1660: fnd_date.date_to_canonical ( d_attribute4 ),

1656: c_attribute20,
1657: fnd_date.date_to_canonical ( d_attribute1 ),
1658: fnd_date.date_to_canonical ( d_attribute2 ),
1659: fnd_date.date_to_canonical ( d_attribute3 ),
1660: fnd_date.date_to_canonical ( d_attribute4 ),
1661: fnd_date.date_to_canonical ( d_attribute5 ),
1662: fnd_date.date_to_canonical ( d_attribute6 ),
1663: fnd_date.date_to_canonical ( d_attribute7 ),
1664: fnd_date.date_to_canonical ( d_attribute8 ),

Line 1661: fnd_date.date_to_canonical ( d_attribute5 ),

1657: fnd_date.date_to_canonical ( d_attribute1 ),
1658: fnd_date.date_to_canonical ( d_attribute2 ),
1659: fnd_date.date_to_canonical ( d_attribute3 ),
1660: fnd_date.date_to_canonical ( d_attribute4 ),
1661: fnd_date.date_to_canonical ( d_attribute5 ),
1662: fnd_date.date_to_canonical ( d_attribute6 ),
1663: fnd_date.date_to_canonical ( d_attribute7 ),
1664: fnd_date.date_to_canonical ( d_attribute8 ),
1665: fnd_date.date_to_canonical ( d_attribute9 ),

Line 1662: fnd_date.date_to_canonical ( d_attribute6 ),

1658: fnd_date.date_to_canonical ( d_attribute2 ),
1659: fnd_date.date_to_canonical ( d_attribute3 ),
1660: fnd_date.date_to_canonical ( d_attribute4 ),
1661: fnd_date.date_to_canonical ( d_attribute5 ),
1662: fnd_date.date_to_canonical ( d_attribute6 ),
1663: fnd_date.date_to_canonical ( d_attribute7 ),
1664: fnd_date.date_to_canonical ( d_attribute8 ),
1665: fnd_date.date_to_canonical ( d_attribute9 ),
1666: fnd_date.date_to_canonical ( d_attribute10 ),

Line 1663: fnd_date.date_to_canonical ( d_attribute7 ),

1659: fnd_date.date_to_canonical ( d_attribute3 ),
1660: fnd_date.date_to_canonical ( d_attribute4 ),
1661: fnd_date.date_to_canonical ( d_attribute5 ),
1662: fnd_date.date_to_canonical ( d_attribute6 ),
1663: fnd_date.date_to_canonical ( d_attribute7 ),
1664: fnd_date.date_to_canonical ( d_attribute8 ),
1665: fnd_date.date_to_canonical ( d_attribute9 ),
1666: fnd_date.date_to_canonical ( d_attribute10 ),
1667: TO_CHAR ( n_attribute1 ),

Line 1664: fnd_date.date_to_canonical ( d_attribute8 ),

1660: fnd_date.date_to_canonical ( d_attribute4 ),
1661: fnd_date.date_to_canonical ( d_attribute5 ),
1662: fnd_date.date_to_canonical ( d_attribute6 ),
1663: fnd_date.date_to_canonical ( d_attribute7 ),
1664: fnd_date.date_to_canonical ( d_attribute8 ),
1665: fnd_date.date_to_canonical ( d_attribute9 ),
1666: fnd_date.date_to_canonical ( d_attribute10 ),
1667: TO_CHAR ( n_attribute1 ),
1668: TO_CHAR ( n_attribute2 ),

Line 1665: fnd_date.date_to_canonical ( d_attribute9 ),

1661: fnd_date.date_to_canonical ( d_attribute5 ),
1662: fnd_date.date_to_canonical ( d_attribute6 ),
1663: fnd_date.date_to_canonical ( d_attribute7 ),
1664: fnd_date.date_to_canonical ( d_attribute8 ),
1665: fnd_date.date_to_canonical ( d_attribute9 ),
1666: fnd_date.date_to_canonical ( d_attribute10 ),
1667: TO_CHAR ( n_attribute1 ),
1668: TO_CHAR ( n_attribute2 ),
1669: TO_CHAR ( n_attribute3 ),

Line 1666: fnd_date.date_to_canonical ( d_attribute10 ),

1662: fnd_date.date_to_canonical ( d_attribute6 ),
1663: fnd_date.date_to_canonical ( d_attribute7 ),
1664: fnd_date.date_to_canonical ( d_attribute8 ),
1665: fnd_date.date_to_canonical ( d_attribute9 ),
1666: fnd_date.date_to_canonical ( d_attribute10 ),
1667: TO_CHAR ( n_attribute1 ),
1668: TO_CHAR ( n_attribute2 ),
1669: TO_CHAR ( n_attribute3 ),
1670: TO_CHAR ( n_attribute4 ),

Line 2234: fnd_date.canonical_to_date (

2230: p_serial_transaction_id,
2231: description,
2232: TO_NUMBER ( g_lot_attributes_tbl ( 1 ).column_value ),
2233: g_lot_attributes_tbl ( 2 ).column_value,
2234: fnd_date.canonical_to_date (
2235: g_lot_attributes_tbl ( 3 ).column_value
2236: ),
2237: g_lot_attributes_tbl ( 4 ).column_value,
2238: TO_NUMBER ( g_lot_attributes_tbl ( 5 ).column_value ),

Line 2239: fnd_date.canonical_to_date (

2235: g_lot_attributes_tbl ( 3 ).column_value
2236: ),
2237: g_lot_attributes_tbl ( 4 ).column_value,
2238: TO_NUMBER ( g_lot_attributes_tbl ( 5 ).column_value ),
2239: fnd_date.canonical_to_date (
2240: g_lot_attributes_tbl ( 6 ).column_value
2241: ),
2242: TO_NUMBER ( g_lot_attributes_tbl ( 7 ).column_value ),
2243: fnd_date.canonical_to_date (

Line 2243: fnd_date.canonical_to_date (

2239: fnd_date.canonical_to_date (
2240: g_lot_attributes_tbl ( 6 ).column_value
2241: ),
2242: TO_NUMBER ( g_lot_attributes_tbl ( 7 ).column_value ),
2243: fnd_date.canonical_to_date (
2244: g_lot_attributes_tbl ( 8 ).column_value
2245: ),
2246: fnd_date.canonical_to_date (
2247: g_lot_attributes_tbl ( 9 ).column_value

Line 2246: fnd_date.canonical_to_date (

2242: TO_NUMBER ( g_lot_attributes_tbl ( 7 ).column_value ),
2243: fnd_date.canonical_to_date (
2244: g_lot_attributes_tbl ( 8 ).column_value
2245: ),
2246: fnd_date.canonical_to_date (
2247: g_lot_attributes_tbl ( 9 ).column_value
2248: ),
2249: g_lot_attributes_tbl ( 10 ).column_value,
2250: TO_NUMBER ( g_lot_attributes_tbl ( 11 ).column_value ),

Line 2255: fnd_date.canonical_to_date (

2251: g_lot_attributes_tbl ( 12 ).column_value,
2252: TO_NUMBER ( g_lot_attributes_tbl ( 13 ).column_value ),
2253: g_lot_attributes_tbl ( 14 ).column_value,
2254: g_lot_attributes_tbl ( 15 ).column_value,
2255: fnd_date.canonical_to_date (
2256: g_lot_attributes_tbl ( 16 ).column_value
2257: ),
2258: TO_NUMBER ( g_lot_attributes_tbl ( 17 ).column_value ),
2259: g_lot_attributes_tbl ( 18 ).column_value,

Line 2286: fnd_date.canonical_to_date (

2282: g_lot_attributes_tbl ( 41 ).column_value,
2283: g_lot_attributes_tbl ( 42 ).column_value,
2284: g_lot_attributes_tbl ( 43 ).column_value,
2285: g_lot_attributes_tbl ( 44 ).column_value,
2286: fnd_date.canonical_to_date (
2287: g_lot_attributes_tbl ( 45 ).column_value
2288: ),
2289: fnd_date.canonical_to_date (
2290: g_lot_attributes_tbl ( 46 ).column_value

Line 2289: fnd_date.canonical_to_date (

2285: g_lot_attributes_tbl ( 44 ).column_value,
2286: fnd_date.canonical_to_date (
2287: g_lot_attributes_tbl ( 45 ).column_value
2288: ),
2289: fnd_date.canonical_to_date (
2290: g_lot_attributes_tbl ( 46 ).column_value
2291: ),
2292: fnd_date.canonical_to_date (
2293: g_lot_attributes_tbl ( 47 ).column_value

Line 2292: fnd_date.canonical_to_date (

2288: ),
2289: fnd_date.canonical_to_date (
2290: g_lot_attributes_tbl ( 46 ).column_value
2291: ),
2292: fnd_date.canonical_to_date (
2293: g_lot_attributes_tbl ( 47 ).column_value
2294: ),
2295: fnd_date.canonical_to_date (
2296: g_lot_attributes_tbl ( 48 ).column_value

Line 2295: fnd_date.canonical_to_date (

2291: ),
2292: fnd_date.canonical_to_date (
2293: g_lot_attributes_tbl ( 47 ).column_value
2294: ),
2295: fnd_date.canonical_to_date (
2296: g_lot_attributes_tbl ( 48 ).column_value
2297: ),
2298: fnd_date.canonical_to_date (
2299: g_lot_attributes_tbl ( 49 ).column_value

Line 2298: fnd_date.canonical_to_date (

2294: ),
2295: fnd_date.canonical_to_date (
2296: g_lot_attributes_tbl ( 48 ).column_value
2297: ),
2298: fnd_date.canonical_to_date (
2299: g_lot_attributes_tbl ( 49 ).column_value
2300: ),
2301: fnd_date.canonical_to_date (
2302: g_lot_attributes_tbl ( 50 ).column_value

Line 2301: fnd_date.canonical_to_date (

2297: ),
2298: fnd_date.canonical_to_date (
2299: g_lot_attributes_tbl ( 49 ).column_value
2300: ),
2301: fnd_date.canonical_to_date (
2302: g_lot_attributes_tbl ( 50 ).column_value
2303: ),
2304: fnd_date.canonical_to_date (
2305: g_lot_attributes_tbl ( 51 ).column_value

Line 2304: fnd_date.canonical_to_date (

2300: ),
2301: fnd_date.canonical_to_date (
2302: g_lot_attributes_tbl ( 50 ).column_value
2303: ),
2304: fnd_date.canonical_to_date (
2305: g_lot_attributes_tbl ( 51 ).column_value
2306: ),
2307: fnd_date.canonical_to_date (
2308: g_lot_attributes_tbl ( 52 ).column_value

Line 2307: fnd_date.canonical_to_date (

2303: ),
2304: fnd_date.canonical_to_date (
2305: g_lot_attributes_tbl ( 51 ).column_value
2306: ),
2307: fnd_date.canonical_to_date (
2308: g_lot_attributes_tbl ( 52 ).column_value
2309: ),
2310: fnd_date.canonical_to_date (
2311: g_lot_attributes_tbl ( 53 ).column_value

Line 2310: fnd_date.canonical_to_date (

2306: ),
2307: fnd_date.canonical_to_date (
2308: g_lot_attributes_tbl ( 52 ).column_value
2309: ),
2310: fnd_date.canonical_to_date (
2311: g_lot_attributes_tbl ( 53 ).column_value
2312: ),
2313: fnd_date.canonical_to_date (
2314: g_lot_attributes_tbl ( 54 ).column_value

Line 2313: fnd_date.canonical_to_date (

2309: ),
2310: fnd_date.canonical_to_date (
2311: g_lot_attributes_tbl ( 53 ).column_value
2312: ),
2313: fnd_date.canonical_to_date (
2314: g_lot_attributes_tbl ( 54 ).column_value
2315: ),
2316: TO_NUMBER ( g_lot_attributes_tbl ( 55 ).column_value ),
2317: TO_NUMBER ( g_lot_attributes_tbl ( 56 ).column_value ),

Line 3791: fnd_date.date_to_canonical ( origination_date ),

3787: END IF;
3788:
3789: SELECT TO_CHAR ( vendor_id ),
3790: grade_code,
3791: fnd_date.date_to_canonical ( origination_date ),
3792: date_code,
3793: TO_CHAR ( status_id ),
3794: fnd_date.date_to_canonical ( change_date ),
3795: TO_NUMBER ( age ),

Line 3794: fnd_date.date_to_canonical ( change_date ),

3790: grade_code,
3791: fnd_date.date_to_canonical ( origination_date ),
3792: date_code,
3793: TO_CHAR ( status_id ),
3794: fnd_date.date_to_canonical ( change_date ),
3795: TO_NUMBER ( age ),
3796: fnd_date.date_to_canonical ( retest_date ),
3797: fnd_date.date_to_canonical ( maturity_date ),
3798: lot_attribute_category,

Line 3796: fnd_date.date_to_canonical ( retest_date ),

3792: date_code,
3793: TO_CHAR ( status_id ),
3794: fnd_date.date_to_canonical ( change_date ),
3795: TO_NUMBER ( age ),
3796: fnd_date.date_to_canonical ( retest_date ),
3797: fnd_date.date_to_canonical ( maturity_date ),
3798: lot_attribute_category,
3799: TO_CHAR ( item_size ),
3800: color,

Line 3797: fnd_date.date_to_canonical ( maturity_date ),

3793: TO_CHAR ( status_id ),
3794: fnd_date.date_to_canonical ( change_date ),
3795: TO_NUMBER ( age ),
3796: fnd_date.date_to_canonical ( retest_date ),
3797: fnd_date.date_to_canonical ( maturity_date ),
3798: lot_attribute_category,
3799: TO_CHAR ( item_size ),
3800: color,
3801: TO_CHAR ( volume ),

Line 3804: fnd_date.date_to_canonical ( best_by_date ),

3800: color,
3801: TO_CHAR ( volume ),
3802: volume_uom,
3803: place_of_origin,
3804: fnd_date.date_to_canonical ( best_by_date ),
3805: TO_CHAR ( LENGTH ),
3806: length_uom,
3807: TO_CHAR ( recycled_content ),
3808: TO_CHAR ( thickness ),

Line 3833: fnd_date.date_to_canonical ( d_attribute1 ),

3829: c_attribute17,
3830: c_attribute18,
3831: c_attribute19,
3832: c_attribute20,
3833: fnd_date.date_to_canonical ( d_attribute1 ),
3834: fnd_date.date_to_canonical ( d_attribute2 ),
3835: fnd_date.date_to_canonical ( d_attribute3 ),
3836: fnd_date.date_to_canonical ( d_attribute4 ),
3837: fnd_date.date_to_canonical ( d_attribute5 ),

Line 3834: fnd_date.date_to_canonical ( d_attribute2 ),

3830: c_attribute18,
3831: c_attribute19,
3832: c_attribute20,
3833: fnd_date.date_to_canonical ( d_attribute1 ),
3834: fnd_date.date_to_canonical ( d_attribute2 ),
3835: fnd_date.date_to_canonical ( d_attribute3 ),
3836: fnd_date.date_to_canonical ( d_attribute4 ),
3837: fnd_date.date_to_canonical ( d_attribute5 ),
3838: fnd_date.date_to_canonical ( d_attribute6 ),

Line 3835: fnd_date.date_to_canonical ( d_attribute3 ),

3831: c_attribute19,
3832: c_attribute20,
3833: fnd_date.date_to_canonical ( d_attribute1 ),
3834: fnd_date.date_to_canonical ( d_attribute2 ),
3835: fnd_date.date_to_canonical ( d_attribute3 ),
3836: fnd_date.date_to_canonical ( d_attribute4 ),
3837: fnd_date.date_to_canonical ( d_attribute5 ),
3838: fnd_date.date_to_canonical ( d_attribute6 ),
3839: fnd_date.date_to_canonical ( d_attribute7 ),

Line 3836: fnd_date.date_to_canonical ( d_attribute4 ),

3832: c_attribute20,
3833: fnd_date.date_to_canonical ( d_attribute1 ),
3834: fnd_date.date_to_canonical ( d_attribute2 ),
3835: fnd_date.date_to_canonical ( d_attribute3 ),
3836: fnd_date.date_to_canonical ( d_attribute4 ),
3837: fnd_date.date_to_canonical ( d_attribute5 ),
3838: fnd_date.date_to_canonical ( d_attribute6 ),
3839: fnd_date.date_to_canonical ( d_attribute7 ),
3840: fnd_date.date_to_canonical ( d_attribute8 ),

Line 3837: fnd_date.date_to_canonical ( d_attribute5 ),

3833: fnd_date.date_to_canonical ( d_attribute1 ),
3834: fnd_date.date_to_canonical ( d_attribute2 ),
3835: fnd_date.date_to_canonical ( d_attribute3 ),
3836: fnd_date.date_to_canonical ( d_attribute4 ),
3837: fnd_date.date_to_canonical ( d_attribute5 ),
3838: fnd_date.date_to_canonical ( d_attribute6 ),
3839: fnd_date.date_to_canonical ( d_attribute7 ),
3840: fnd_date.date_to_canonical ( d_attribute8 ),
3841: fnd_date.date_to_canonical ( d_attribute9 ),

Line 3838: fnd_date.date_to_canonical ( d_attribute6 ),

3834: fnd_date.date_to_canonical ( d_attribute2 ),
3835: fnd_date.date_to_canonical ( d_attribute3 ),
3836: fnd_date.date_to_canonical ( d_attribute4 ),
3837: fnd_date.date_to_canonical ( d_attribute5 ),
3838: fnd_date.date_to_canonical ( d_attribute6 ),
3839: fnd_date.date_to_canonical ( d_attribute7 ),
3840: fnd_date.date_to_canonical ( d_attribute8 ),
3841: fnd_date.date_to_canonical ( d_attribute9 ),
3842: fnd_date.date_to_canonical ( d_attribute10 ),

Line 3839: fnd_date.date_to_canonical ( d_attribute7 ),

3835: fnd_date.date_to_canonical ( d_attribute3 ),
3836: fnd_date.date_to_canonical ( d_attribute4 ),
3837: fnd_date.date_to_canonical ( d_attribute5 ),
3838: fnd_date.date_to_canonical ( d_attribute6 ),
3839: fnd_date.date_to_canonical ( d_attribute7 ),
3840: fnd_date.date_to_canonical ( d_attribute8 ),
3841: fnd_date.date_to_canonical ( d_attribute9 ),
3842: fnd_date.date_to_canonical ( d_attribute10 ),
3843: TO_CHAR ( n_attribute1 ),

Line 3840: fnd_date.date_to_canonical ( d_attribute8 ),

3836: fnd_date.date_to_canonical ( d_attribute4 ),
3837: fnd_date.date_to_canonical ( d_attribute5 ),
3838: fnd_date.date_to_canonical ( d_attribute6 ),
3839: fnd_date.date_to_canonical ( d_attribute7 ),
3840: fnd_date.date_to_canonical ( d_attribute8 ),
3841: fnd_date.date_to_canonical ( d_attribute9 ),
3842: fnd_date.date_to_canonical ( d_attribute10 ),
3843: TO_CHAR ( n_attribute1 ),
3844: TO_CHAR ( n_attribute2 ),

Line 3841: fnd_date.date_to_canonical ( d_attribute9 ),

3837: fnd_date.date_to_canonical ( d_attribute5 ),
3838: fnd_date.date_to_canonical ( d_attribute6 ),
3839: fnd_date.date_to_canonical ( d_attribute7 ),
3840: fnd_date.date_to_canonical ( d_attribute8 ),
3841: fnd_date.date_to_canonical ( d_attribute9 ),
3842: fnd_date.date_to_canonical ( d_attribute10 ),
3843: TO_CHAR ( n_attribute1 ),
3844: TO_CHAR ( n_attribute2 ),
3845: TO_CHAR ( n_attribute3 ),

Line 3842: fnd_date.date_to_canonical ( d_attribute10 ),

3838: fnd_date.date_to_canonical ( d_attribute6 ),
3839: fnd_date.date_to_canonical ( d_attribute7 ),
3840: fnd_date.date_to_canonical ( d_attribute8 ),
3841: fnd_date.date_to_canonical ( d_attribute9 ),
3842: fnd_date.date_to_canonical ( d_attribute10 ),
3843: TO_CHAR ( n_attribute1 ),
3844: TO_CHAR ( n_attribute2 ),
3845: TO_CHAR ( n_attribute3 ),
3846: TO_CHAR ( n_attribute4 ),

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

7528: lot_dff(3).column_type := 'DATE';
7529: IF P_ORIGINATION_DATE =G_MISS_DATE THEN
7530: lot_dff(3).column_value := NULL;
7531: ELSE
7532: lot_dff(3).column_value := fnd_date.date_to_canonical(p_origination_date);
7533: END IF;
7534:
7535: lot_dff(4).column_name := 'DATE_CODE';
7536: lot_dff(4).column_type := 'VARCHAR2';

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

7544: lot_dff(5).column_type := 'DATE';
7545: IF p_change_date= G_MISS_DATE THEN
7546: lot_dff(5).column_value := NULL;
7547: ELSE
7548: lot_dff(5).column_value := fnd_date.date_to_canonical(p_change_date);
7549: END IF;
7550:
7551: lot_dff(6).column_name := 'ORIGINATION_DATE';
7552: lot_dff(6).column_type := 'DATE';

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

7552: lot_dff(6).column_type := 'DATE';
7553: IF p_origination_date=G_MISS_DATE THEN
7554: lot_dff(6).column_value := NULL;
7555: ELSE
7556: lot_dff(6).column_value := fnd_date.date_to_canonical(p_origination_date);
7557: END IF;
7558:
7559: lot_dff(6).column_name := 'AGE';
7560: lot_dff(6).column_type := 'NUMBER';

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

7568: lot_dff(7).column_type := 'DATE';
7569: IF p_retest_date=G_MISS_DATE THEN
7570: lot_dff(7).column_value := NULL;
7571: ELSE
7572: lot_dff(7).column_value := fnd_date.date_to_canonical(p_retest_date);
7573: END IF;
7574:
7575: lot_dff(8).column_name := 'MATURITY_DATE';
7576: lot_dff(8).column_type := 'DATE';

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

7576: lot_dff(8).column_type := 'DATE';
7577: IF p_maturity_date= G_MISS_DATE THEN
7578: lot_dff(8).column_value := NULL;
7579: ELSE
7580: lot_dff(8).column_value := fnd_date.date_to_canonical(p_maturity_date);
7581: END IF;
7582:
7583: lot_dff(9).column_name := 'ITEM_SIZE';
7584: lot_dff(9).column_type := 'NUMBER';

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

7625: IF p_best_by_date= G_MISS_DATE THEN
7626: lot_dff(14).column_value := NULL;
7627: ELSE
7628: --BUG 3784406: Call date_to_canonical, instead of canonical_to_date
7629: lot_dff(14).column_value := fnd_date.date_to_canonical(p_best_by_date);
7630: END IF;
7631:
7632: lot_dff(15).column_name := 'LENGTH';
7633: lot_dff(15).column_type := 'NUMBER';

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

7861: l_d_attr_index := p_d_attributes_tbl.FIRST;
7862:
7863: WHILE l_d_attr_index <= p_d_attributes_tbl.LAST LOOP
7864: IF p_d_attributes_tbl(l_d_attr_index) IS NOT NULL THEN
7865: -- BUG 3784406: Call fnd_date.date_to_canonical
7866: IF g_debug = 1 THEN
7867: print_debug('Date before casting into DD:MM:YYYY format'||To_char(p_d_attributes_tbl(l_d_attr_index),'DD:MM:YYYY'), 9);
7868: END IF;
7869: lot_dff(53 + l_d_attr_index).column_value := fnd_date.date_to_canonical(p_d_attributes_tbl(l_d_attr_index));

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

7865: -- BUG 3784406: Call fnd_date.date_to_canonical
7866: IF g_debug = 1 THEN
7867: print_debug('Date before casting into DD:MM:YYYY format'||To_char(p_d_attributes_tbl(l_d_attr_index),'DD:MM:YYYY'), 9);
7868: END IF;
7869: lot_dff(53 + l_d_attr_index).column_value := fnd_date.date_to_canonical(p_d_attributes_tbl(l_d_attr_index));
7870: IF g_debug = 1 THEN
7871: print_debug('Date after casting in canonical format ' || lot_dff(53 + l_d_attr_index).column_value,9);
7872: END IF;
7873: ELSE

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

7977: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
7978: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7979: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7980: ELSIF lot_dff(j).column_type = 'DATE' THEN
7981: fnd_flex_descval.set_column_value(lot_dff(j).column_name, fnd_date.canonical_to_date(lot_dff(j).column_value));
7982: END IF;
7983:
7984: IF lot_dff(j).column_value IS NOT NULL THEN
7985: l_value_not_null_flag := 1;

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

8070: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
8071: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
8072: ELSIF lot_dff(j).column_type = 'DATE' THEN
8073: fnd_flex_descval.set_column_value(lot_dff(j).column_name,
8074: fnd_date.canonical_to_date(lot_dff(j).column_value));
8075: END IF;
8076:
8077: IF lot_dff(j).column_value IS NOT NULL THEN
8078: l_value_not_null_flag := 1;