DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on FND_DATE

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

2888:
2889: --update number of days in ar_cmgt_cf_recommends
2890:
2891: UPDATE AR_CMGT_CF_RECOMMENDS
2892: SET RECOMMENDATION_VALUE2 = fnd_date.DATE_TO_CANONICAL(trunc(sysdate) + to_number(trunc(l_dayz))),
2893: last_update_date = sysdate,
2894: last_updated_by = fnd_global.user_id,
2895: last_update_login = fnd_global.login_id
2896: WHERE RECOMMENDATION_ID = l_reco_id;