APPS.INV_TXN_MANAGER_GRP dependencies on FND_DATE

Line 4007: fnd_date.date_to_canonical(LOT_EXPIRATION_DATE),

4003: HOLD_DATE,
4004: REASON_ID,
4005: -- INVCONV end fabdi
4006: SERIAL_TRANSACTION_TEMP_ID,
4007: fnd_date.date_to_canonical(LOT_EXPIRATION_DATE),
4008: ROWID,
4009: parent_object_type, --R12 Genealogy enhancements
4010: parent_object_id, --R12 Genealogy enhancements
4011: parent_object_number, --R12 Genealogy enhancements

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

4364: END IF;
4365:
4366: -- nsinghi bug 5209065. Added the following line.
4367: -- Expiration date was getting reset and hence ensured that appropriate value gets updated to MTLI.
4368: -- nsinghi bug#5209065 rework. Added fnd_date.date_to_canonical call.
4369: l_lotexpdate := fnd_date.date_to_canonical(l_expiration_date);
4370:
4371: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
4372: SET GRADE_CODE = l_grade_code ,

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

4365:
4366: -- nsinghi bug 5209065. Added the following line.
4367: -- Expiration date was getting reset and hence ensured that appropriate value gets updated to MTLI.
4368: -- nsinghi bug#5209065 rework. Added fnd_date.date_to_canonical call.
4369: l_lotexpdate := fnd_date.date_to_canonical(l_expiration_date);
4370:
4371: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
4372: SET GRADE_CODE = l_grade_code ,
4373: RETEST_DATE = l_retest_date ,

Line 4513: fnd_date.date_to_canonical(EXPIRATION_DATE)

4509: and expiration is set */
4510: IF ((p_shlfcode <> 1) AND (l_lotexpdate IS NULL)) THEN
4511: BEGIN
4512: SELECT
4513: fnd_date.date_to_canonical(EXPIRATION_DATE)
4514: INTO l_lotexpdate
4515: FROM MTL_LOT_NUMBERS
4516: WHERE INVENTORY_ITEM_ID = p_itemid
4517: AND ORGANIZATION_ID = p_orgid

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

4518: AND LOT_NUMBER = l_lotnum;
4519: EXCEPTION
4520: WHEN NO_DATA_FOUND THEN
4521: IF ((p_shlfcode = 2) AND (l_lotexpdate IS NULL)) THEN
4522: SELECT fnd_date.date_to_canonical(SYSDATE + p_shlfdays)
4523: INTO l_lotexpdate
4524: FROM DUAL;
4525: END IF;
4526:

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

4625: PROGRAM_ID = l_progid,
4626: PROGRAM_UPDATE_DATE = SYSDATE,
4627: REQUEST_ID = l_reqstid,
4628: PRIMARY_QUANTITY = l_lotpriqty,
4629: LOT_EXPIRATION_DATE = fnd_date.canonical_to_date(l_lotexpdate),
4630: SERIAL_TRANSACTION_TEMP_ID = l_sertempid
4631: WHERE ROWID = l_lotrowid;
4632:
4633: END LOOP;

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

7508: IF ( l_acttype = 24 AND l_srctype = 14 ) THEN /* PCST */
7509: CSTPPCIT.periodic_cost_validate(
7510: l_org_cost_group_id,
7511: l_cost_type_id,
7512: l_trxdate,--Bug #4156979 Removed the call to fnd_date.canonical_to_date
7513: l_intid,
7514: l_orgid,
7515: l_itemid,
7516: l_new_avg_cst,