APPS.INV_TXN_MANAGER_GRP dependencies on FND_DATE

Line 4296: fnd_date.date_to_canonical(LOT_EXPIRATION_DATE),

4292: HOLD_DATE,
4293: REASON_ID,
4294: -- INVCONV end fabdi
4295: SERIAL_TRANSACTION_TEMP_ID,
4296: fnd_date.date_to_canonical(LOT_EXPIRATION_DATE),
4297: ROWID,
4298: parent_object_type, --R12 Genealogy enhancements
4299: parent_object_id, --R12 Genealogy enhancements
4300: parent_object_number, --R12 Genealogy enhancements

Line 4663: -- nsinghi bug#5209065 rework. Added fnd_date.date_to_canonical call.

4659: END IF;
4660:
4661: -- nsinghi bug 5209065. Added the following line.
4662: -- Expiration date was getting reset and hence ensured that appropriate value gets updated to MTLI.
4663: -- nsinghi bug#5209065 rework. Added fnd_date.date_to_canonical call.
4664: l_lotexpdate := fnd_date.date_to_canonical(l_expiration_date);
4665:
4666: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
4667: SET GRADE_CODE = l_grade_code ,

Line 4664: l_lotexpdate := fnd_date.date_to_canonical(l_expiration_date);

4660:
4661: -- nsinghi bug 5209065. Added the following line.
4662: -- Expiration date was getting reset and hence ensured that appropriate value gets updated to MTLI.
4663: -- nsinghi bug#5209065 rework. Added fnd_date.date_to_canonical call.
4664: l_lotexpdate := fnd_date.date_to_canonical(l_expiration_date);
4665:
4666: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
4667: SET GRADE_CODE = l_grade_code ,
4668: RETEST_DATE = l_retest_date ,

Line 4812: fnd_date.date_to_canonical(EXPIRATION_DATE)

4808: and expiration is set */
4809: IF ((p_shlfcode <> 1) AND (l_lotexpdate IS NULL)) THEN
4810: BEGIN
4811: SELECT
4812: fnd_date.date_to_canonical(EXPIRATION_DATE)
4813: INTO l_lotexpdate
4814: FROM MTL_LOT_NUMBERS
4815: WHERE INVENTORY_ITEM_ID = p_itemid
4816: AND ORGANIZATION_ID = p_orgid

Line 4821: SELECT fnd_date.date_to_canonical(SYSDATE + p_shlfdays)

4817: AND LOT_NUMBER = l_lotnum;
4818: EXCEPTION
4819: WHEN NO_DATA_FOUND THEN
4820: IF ((p_shlfcode = 2) AND (l_lotexpdate IS NULL)) THEN
4821: SELECT fnd_date.date_to_canonical(SYSDATE + p_shlfdays)
4822: INTO l_lotexpdate
4823: FROM DUAL;
4824: END IF;
4825:

Line 4932: LOT_EXPIRATION_DATE = fnd_date.canonical_to_date(l_lotexpdate),

4928: PROGRAM_ID = l_progid,
4929: PROGRAM_UPDATE_DATE = SYSDATE,
4930: REQUEST_ID = l_reqstid,
4931: PRIMARY_QUANTITY = nvl(l_lotpriqty, abs(PRIMARY_QUANTITY)*sign(TRANSACTION_QUANTITY) ), --ADM bug 9959125
4932: LOT_EXPIRATION_DATE = fnd_date.canonical_to_date(l_lotexpdate),
4933: SERIAL_TRANSACTION_TEMP_ID = l_sertempid
4934: WHERE ROWID = l_lotrowid;
4935:
4936: /* Material Status Enhancement - Tracking bug: 13519864 */

Line 7942: l_trxdate,--Bug #4156979 Removed the call to fnd_date.canonical_to_date

7938: IF ( l_acttype = 24 AND l_srctype = 14 ) THEN /* PCST */
7939: CSTPPCIT.periodic_cost_validate(
7940: l_org_cost_group_id,
7941: l_cost_type_id,
7942: l_trxdate,--Bug #4156979 Removed the call to fnd_date.canonical_to_date
7943: l_intid,
7944: l_orgid,
7945: l_itemid,
7946: l_new_avg_cst,