DBA Data[Home] [Help]

APPS.UMX_REG_REQUESTS_PVT dependencies on FND_DATE

Line 1363: if (x_active_from is null) or (fnd_date.canonical_to_date (x_active_from) <= sysdate) then

1359: 'fnd.plsql.UMXVRRSB.get_pend_acct_info',
1360: 'activeFrom: ' || x_active_from);
1361: end if;
1362:
1363: if (x_active_from is null) or (fnd_date.canonical_to_date (x_active_from) <= sysdate) then
1364: -- active from is null, get fnd message for "Date of approval"
1365: fnd_message.set_name ('FND', 'UMX_USER_ACCT_ACTIVE_FROM_VAL');
1366: x_active_from := fnd_message.get;
1367: else

Line 1368: x_active_from := fnd_date.date_to_displaydate ( dateval => fnd_date.canonical_to_date (x_active_from) , calendar_aware => fnd_date.calendar_aware );

1364: -- active from is null, get fnd message for "Date of approval"
1365: fnd_message.set_name ('FND', 'UMX_USER_ACCT_ACTIVE_FROM_VAL');
1366: x_active_from := fnd_message.get;
1367: else
1368: x_active_from := fnd_date.date_to_displaydate ( dateval => fnd_date.canonical_to_date (x_active_from) , calendar_aware => fnd_date.calendar_aware );
1369: end if;
1370:
1371: x_active_to := wf_engine.getitemattrtext (
1372: itemtype => UMX_REGISTRATION_UTIL.G_ITEM_TYPE,

Line 1377: x_active_to := fnd_date.date_to_displaydate ( dateval => fnd_date.canonical_to_date (x_active_to), calendar_aware => fnd_date.calendar_aware );

1373: itemkey => x_reg_request_id,
1374: aname => 'REQUESTED_END_DATE');
1375:
1376: if (x_active_to is not null) then
1377: x_active_to := fnd_date.date_to_displaydate ( dateval => fnd_date.canonical_to_date (x_active_to), calendar_aware => fnd_date.calendar_aware );
1378: end if;
1379:
1380: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1381: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,