DBA Data[Home] [Help]

APPS.ASO_PA_APR_WF_PVT dependencies on WF_USERS

Line 1544: l_current_username wf_users.name%TYPE;

1540: l_child_wf_cur l_child_wf%ROWTYPE;
1541: l_current_person_id NUMBER;
1542: l_current_appr_group_id NUMBER;
1543: l_abort NUMBER;
1544: l_current_username wf_users.name%TYPE;
1545: tempOrigSystem ame_util.stringType;
1546: l_approval_det_id number;
1547: l_child_username wf_users.name%TYPE;
1548: l_fnd_usr_id number;

Line 1547: l_child_username wf_users.name%TYPE;

1543: l_abort NUMBER;
1544: l_current_username wf_users.name%TYPE;
1545: tempOrigSystem ame_util.stringType;
1546: l_approval_det_id number;
1547: l_child_username wf_users.name%TYPE;
1548: l_fnd_usr_id number;
1549:
1550: BEGIN
1551:

Line 1804: l_child_approver_user_name wf_users.name%TYPE;

1800:
1801: l_parent_item_type wf_items.parent_item_type%TYPE;
1802: l_parent_item_key wf_items.parent_item_key%TYPE;
1803: l_child_approver_empid NUMBER;
1804: l_child_approver_user_name wf_users.name%TYPE;
1805: l_child_approver_display_name wf_users.display_name%TYPE;
1806: l_api_name VARCHAR2(500) := 'process_response_approve';
1807:
1808:

Line 1805: l_child_approver_display_name wf_users.display_name%TYPE;

1801: l_parent_item_type wf_items.parent_item_type%TYPE;
1802: l_parent_item_key wf_items.parent_item_key%TYPE;
1803: l_child_approver_empid NUMBER;
1804: l_child_approver_user_name wf_users.name%TYPE;
1805: l_child_approver_display_name wf_users.display_name%TYPE;
1806: l_api_name VARCHAR2(500) := 'process_response_approve';
1807:
1808:
1809: BEGIN

Line 1924: l_child_approver_user_name wf_users.name%TYPE;

1920:
1921: l_parent_item_type wf_items.parent_item_type%TYPE;
1922: l_parent_item_key wf_items.parent_item_key%TYPE;
1923: l_child_approver_empid NUMBER;
1924: l_child_approver_user_name wf_users.name%TYPE;
1925: l_child_approver_display_name wf_users.display_name%TYPE;
1926: l_api_name VARCHAR2(500) := 'process_response_reject';
1927:
1928:

Line 1925: l_child_approver_display_name wf_users.display_name%TYPE;

1921: l_parent_item_type wf_items.parent_item_type%TYPE;
1922: l_parent_item_key wf_items.parent_item_key%TYPE;
1923: l_child_approver_empid NUMBER;
1924: l_child_approver_user_name wf_users.name%TYPE;
1925: l_child_approver_display_name wf_users.display_name%TYPE;
1926: l_api_name VARCHAR2(500) := 'process_response_reject';
1927:
1928:
1929: BEGIN

Line 2042: l_child_approver_user_name wf_users.name%TYPE;

2038:
2039: l_parent_item_type wf_items.parent_item_type%TYPE;
2040: l_parent_item_key wf_items.parent_item_key%TYPE;
2041: l_child_approver_empid NUMBER;
2042: l_child_approver_user_name wf_users.name%TYPE;
2043: l_child_approver_display_name wf_users.display_name%TYPE;
2044: l_api_name VARCHAR2(500) := 'Process_Response_timedout';
2045:
2046:

Line 2043: l_child_approver_display_name wf_users.display_name%TYPE;

2039: l_parent_item_type wf_items.parent_item_type%TYPE;
2040: l_parent_item_key wf_items.parent_item_key%TYPE;
2041: l_child_approver_empid NUMBER;
2042: l_child_approver_user_name wf_users.name%TYPE;
2043: l_child_approver_display_name wf_users.display_name%TYPE;
2044: l_api_name VARCHAR2(500) := 'Process_Response_timedout';
2045:
2046:
2047: BEGIN