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;
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:
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:
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
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:
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
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:
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