DBA Data[Home] [Help]

APPS.UMX_REG_REQUESTS_PVT dependencies on FND_DATE

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

1211: 'fnd.plsql.UMXVRRSB.get_pend_acct_info',
1212: 'activeFrom: ' || x_active_from);
1213: end if;
1214:
1215: if (x_active_from is null) or (fnd_date.canonical_to_date (x_active_from) <= sysdate) then
1216: -- active from is null, get fnd message for "Date of approval"
1217: fnd_message.set_name ('FND', 'UMX_USER_ACCT_ACTIVE_FROM_VAL');
1218: x_active_from := fnd_message.get;
1219: else

Line 1220: x_active_from := fnd_date.date_to_displaydate (fnd_date.canonical_to_date (x_active_from));

1216: -- active from is null, get fnd message for "Date of approval"
1217: fnd_message.set_name ('FND', 'UMX_USER_ACCT_ACTIVE_FROM_VAL');
1218: x_active_from := fnd_message.get;
1219: else
1220: x_active_from := fnd_date.date_to_displaydate (fnd_date.canonical_to_date (x_active_from));
1221: end if;
1222:
1223: x_active_to := wf_engine.getitemattrtext (
1224: itemtype => UMX_REGISTRATION_UTIL.G_ITEM_TYPE,

Line 1229: x_active_to := fnd_date.date_to_displaydate (fnd_date.canonical_to_date (x_active_to));

1225: itemkey => x_reg_request_id,
1226: aname => 'REQUESTED_END_DATE');
1227:
1228: if (x_active_to is not null) then
1229: x_active_to := fnd_date.date_to_displaydate (fnd_date.canonical_to_date (x_active_to));
1230: end if;
1231:
1232: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1233: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,