DBA Data[Home] [Help]

APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on FND_DATE

Line 3925: l_expiry_days := to_number(trunc( fnd_date.displaydate_to_date( l_end_date ) - fnd_date.displaydate_to_date( sysdate )));

3921: ITEMTYPE => l_itemtype,
3922: ITEMKEY => l_itemkey,
3923: ANAME => 'END_DATE' );
3924: --l_date_format := 'DD-MON-YYYY';
3925: l_expiry_days := to_number(trunc( fnd_date.displaydate_to_date( l_end_date ) - fnd_date.displaydate_to_date( sysdate )));
3926: IF l_expiry_days <0 THEN
3927: l_expiry_days := 0;
3928: END IF;
3929: wf_engine.setItemAttrText

Line 5442: l_expiry_days := to_number(trunc( fnd_date.displaydate_to_date( nvl(l_end_date, sysdate) ) - fnd_date.displaydate_to_date( sysdate )));

5438: , AVALUE => p_entity_id
5439: );
5440: /* Set the Expiry in # of days */
5441: --l_date_format := 'DD-MON-YYYY';
5442: l_expiry_days := to_number(trunc( fnd_date.displaydate_to_date( nvl(l_end_date, sysdate) ) - fnd_date.displaydate_to_date( sysdate )));
5443: IF l_expiry_days <0 THEN
5444: l_expiry_days := 0;
5445: END IF;
5446: