1201: end if;
1202:
1203: -- Get activeFrom and activeTo
1204: x_active_from := wf_engine.getitemattrtext (
1205: itemtype => UMX_REGISTRATION_UTIL.G_ITEM_TYPE,
1206: itemkey => x_reg_request_id,
1207: aname => 'REQUESTED_START_DATE');
1208:
1209: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
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,
1225: itemkey => x_reg_request_id,
1226: aname => 'REQUESTED_END_DATE');
1227:
1228: if (x_active_to is not null) then
1428: x_errstack out nocopy varchar2) IS
1429:
1430: cursor get_child_workflow is
1431: select * from wf_items
1432: where parent_item_type = umx_registration_util.g_item_type
1433: and parent_item_key = p_reg_request_id;
1434:
1435: child get_child_workflow%rowtype;
1436:
1442: 'p_reg_request_id: ' || p_reg_request_id);
1443: end if;
1444:
1445: -- Find the status of the main workflow first
1446: x_itemtype := umx_registration_util.g_item_type;
1447: x_itemkey := p_reg_request_id;
1448: wf_engine.iteminfo (itemtype => x_itemtype,
1449: itemkey => x_itemkey,
1450: status => x_status,