[Home] [Help]
1200: x_approver_email => x_approver_email_address);
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:
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,
1225: itemkey => x_reg_request_id,
1226: aname => 'REQUESTED_END_DATE');
1227:
1400: --
1401: -- Procedure : get_error_wf_info
1402: -- Type : Private
1403: -- Pre_reqs : None
1404: -- Description : This API will call wf_engine.iteminfo to get the status
1405: -- of the main UMX Workflow and all its event subscribers.
1406: -- Input Parameters (Mandatory):
1407: -- p_reg_request_id: Registration Request ID
1408: --
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,
1451: result => x_result,
1452: actid => x_actid,
1464: for child in get_child_workflow
1465: loop
1466: x_itemtype := child.item_type;
1467: x_itemkey := child.item_key;
1468: wf_engine.iteminfo (itemtype => x_itemtype,
1469: itemkey => x_itemkey,
1470: status => x_status,
1471: result => x_result,
1472: actid => x_actid,
1495: --
1496: -- Procedure : get_error_wf_info
1497: -- Type : Private
1498: -- Pre_reqs : None
1499: -- Description : This API will call wf_engine.iteminfo to get the status
1500: -- of the main UMX Workflow and all its event subscribers.
1501: -- Input Parameters (Mandatory):
1502: -- p_user_id: User ID of the requester
1503: --
1583: --
1584: -- Function : is_pend_request_error
1585: -- Type : Private
1586: -- Pre_reqs : None
1587: -- Description : This API will call wf_engine.iteminfo to get the status
1588: -- of the main UMX Workflow and all its event subscribers.
1589: -- It will return 'Y' if account is in error stage and 'N' if otherwise.
1590: -- Input Parameters (Mandatory):
1591: -- p_reg_request_id: Registration Request ID
1639: --
1640: -- Function : is_pend_account_error
1641: -- Type : Private
1642: -- Pre_reqs : None
1643: -- Description : This API will call wf_engine.iteminfo to get the status
1644: -- of the main UMX Workflow and all its event subscribers.
1645: -- It will return 'Y' if account is in error stage and 'N' if otherwise.
1646: -- Input Parameters (Mandatory):
1647: -- p_user_id: User ID of the requester