DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on FND_DATE

Line 3377: SET RECOMMENDATION_VALUE2 = fnd_date.DATE_TO_CANONICAL(trunc(sysdate) + to_number(trunc(l_dayz))),

3373:
3374: --update number of days in ar_cmgt_cf_recommends
3375:
3376: UPDATE AR_CMGT_CF_RECOMMENDS
3377: SET RECOMMENDATION_VALUE2 = fnd_date.DATE_TO_CANONICAL(trunc(sysdate) + to_number(trunc(l_dayz))),
3378: last_update_date = sysdate,
3379: last_updated_by = fnd_global.user_id,
3380: last_update_login = fnd_global.login_id
3381: WHERE RECOMMENDATION_ID = l_reco_id;