APPS.INV_PROCESS_TEMP dependencies on FND_DATE

Line 1299: fnd_date.date_to_canonical(LOT_EXPIRATION_DATE) LOT_EXPIRATION_DATE,

1295: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TEMP_ID%TYPE) IS
1296: SELECT LOT_NUMBER,
1297: TRANSACTION_QUANTITY,
1298: SERIAL_TRANSACTION_TEMP_ID,
1299: fnd_date.date_to_canonical(LOT_EXPIRATION_DATE) LOT_EXPIRATION_DATE,
1300: ROWID
1301: FROM MTL_TRANSACTION_LOTS_TEMP
1302: WHERE TRANSACTION_TEMP_ID = txnTempID;
1303:

Line 1404: SELECT fnd_date.date_to_canonical(EXPIRATION_DATE)

1400: -- uom conversion
1401: if (item.shelf_life_code <> 1 AND
1402: lotrec.lot_expiration_date IS NULL)
1403: then
1404: SELECT fnd_date.date_to_canonical(EXPIRATION_DATE)
1405: INTO lotrec.lot_expiration_date
1406: FROM MTL_LOT_NUMBERS
1407: WHERE INVENTORY_ITEM_ID = item.inventory_item_id
1408: AND ORGANIZATION_ID = org.organization_id

Line 1413: fnd_date.date_to_canonical(SYSDATE+item.shelf_life_days);

1409: AND LOT_NUMBER = lotrec.lot_number;
1410: if(item.shelf_life_code = 2 AND
1411: lotrec.lot_expiration_date IS NULL) then
1412: lotrec.lot_expiration_date :=
1413: fnd_date.date_to_canonical(SYSDATE+item.shelf_life_days);
1414: end if;
1415: if(item.shelf_life_code = 4 AND
1416: lotrec.lot_expiration_date IS NULL) then
1417: loadmsg('INV_LOT_EXPREQD','INV_LOT_EXPREQD');

Line 1496: fnd_date.canonical_to_date(lotrec.lot_expiration_date),

1492: PROGRAM_UPDATE_DATE = SYSDATE,
1493: REQUEST_ID = reqstid,
1494: -- PRIMARY_QUANTITY = l_priqty,
1495: LOT_EXPIRATION_DATE =
1496: fnd_date.canonical_to_date(lotrec.lot_expiration_date),
1497: SERIAL_TRANSACTION_TEMP_ID = lotrec.SERIAL_TRANSACTION_TEMP_ID
1498: WHERE ROWID = lotrec.rowid;
1499: END LOOP;
1500: end if;