APPS.UMX_REG_REQUESTS_PVT dependencies on WF_ITEMS

Line 1420: procedure get_error_wf_info (p_reg_request_id in wf_items.item_type%type,

1416: -- x_errmsg: Error Message
1417: -- x_errstack: Error Stack
1418: --
1419: --
1420: procedure get_error_wf_info (p_reg_request_id in wf_items.item_type%type,
1421: x_itemtype out nocopy wf_items.item_type%type,
1422: x_itemkey out nocopy wf_items.item_key%type,
1423: x_status out nocopy varchar2,
1424: x_result out nocopy varchar2,

Line 1421: x_itemtype out nocopy wf_items.item_type%type,

1417: -- x_errstack: Error Stack
1418: --
1419: --
1420: procedure get_error_wf_info (p_reg_request_id in wf_items.item_type%type,
1421: x_itemtype out nocopy wf_items.item_type%type,
1422: x_itemkey out nocopy wf_items.item_key%type,
1423: x_status out nocopy varchar2,
1424: x_result out nocopy varchar2,
1425: x_actid out nocopy number,

Line 1422: x_itemkey out nocopy wf_items.item_key%type,

1418: --
1419: --
1420: procedure get_error_wf_info (p_reg_request_id in wf_items.item_type%type,
1421: x_itemtype out nocopy wf_items.item_type%type,
1422: x_itemkey out nocopy wf_items.item_key%type,
1423: x_status out nocopy varchar2,
1424: x_result out nocopy varchar2,
1425: x_actid out nocopy number,
1426: x_errname out nocopy varchar2,

Line 1431: select * from wf_items

1427: x_errmsg out nocopy varchar2,
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;

Line 1516: x_itemtype out nocopy wf_items.item_type%type,

1512: -- x_errstack: Error Stack
1513: --
1514: --
1515: procedure get_error_wf_info (p_user_id in fnd_user.user_id%type,
1516: x_itemtype out nocopy wf_items.item_type%type,
1517: x_itemkey out nocopy wf_items.item_key%type,
1518: x_status out nocopy varchar2,
1519: x_result out nocopy varchar2,
1520: x_actid out nocopy number,

Line 1517: x_itemkey out nocopy wf_items.item_key%type,

1513: --
1514: --
1515: procedure get_error_wf_info (p_user_id in fnd_user.user_id%type,
1516: x_itemtype out nocopy wf_items.item_type%type,
1517: x_itemkey out nocopy wf_items.item_key%type,
1518: x_status out nocopy varchar2,
1519: x_result out nocopy varchar2,
1520: x_actid out nocopy number,
1521: x_errname out nocopy varchar2,

Line 1598: l_itemtype wf_items.item_type%type;

1594: -- It will return 'Y' if pending account has error and 'N' if otherwise.
1595: --
1596: function is_pend_request_error (p_reg_request_id in umx_reg_requests.reg_request_id%type) return varchar2 is
1597:
1598: l_itemtype wf_items.item_type%type;
1599: l_itemkey wf_items.item_key%type;
1600: l_status varchar2(8);
1601: l_result varchar2(30);
1602: l_actid number;

Line 1599: l_itemkey wf_items.item_key%type;

1595: --
1596: function is_pend_request_error (p_reg_request_id in umx_reg_requests.reg_request_id%type) return varchar2 is
1597:
1598: l_itemtype wf_items.item_type%type;
1599: l_itemkey wf_items.item_key%type;
1600: l_status varchar2(8);
1601: l_result varchar2(30);
1602: l_actid number;
1603: l_errname varchar2(30);

Line 1654: l_itemtype wf_items.item_type%type;

1650: -- It will return 'Y' if pending account has error and 'N' if otherwise.
1651: --
1652: function is_pend_account_error (p_user_id in fnd_user.user_id%type) return varchar2 is
1653:
1654: l_itemtype wf_items.item_type%type;
1655: l_itemkey wf_items.item_key%type;
1656: l_status varchar2(8);
1657: l_result varchar2(30);
1658: l_actid number;

Line 1655: l_itemkey wf_items.item_key%type;

1651: --
1652: function is_pend_account_error (p_user_id in fnd_user.user_id%type) return varchar2 is
1653:
1654: l_itemtype wf_items.item_type%type;
1655: l_itemkey wf_items.item_key%type;
1656: l_status varchar2(8);
1657: l_result varchar2(30);
1658: l_actid number;
1659: l_errname varchar2(30);