67: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
68: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
69: l_next_approver_id NUMBER;
70: l_next_approver_user_name fnd_user.user_name%TYPE;
71: l_next_approver_disp_name wf_users.display_name%TYPE;
72: l_orig_system wf_users.orig_system%TYPE := ame_util.perOrigSystem;
73: l_sequence_num NUMBER;
74: l_approver_type VARCHAR2(30);
75:
68: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
69: l_next_approver_id NUMBER;
70: l_next_approver_user_name fnd_user.user_name%TYPE;
71: l_next_approver_disp_name wf_users.display_name%TYPE;
72: l_orig_system wf_users.orig_system%TYPE := ame_util.perOrigSystem;
73: l_sequence_num NUMBER;
74: l_approver_type VARCHAR2(30);
75:
76: l_doc_string varchar2(200);
1622: l_parent_item_type wf_items.parent_item_type%TYPE;
1623: l_parent_item_key wf_items.parent_item_key%TYPE;
1624:
1625: l_child_approver_empid number;
1626: l_child_approver_user_name wf_users.name%TYPE;
1627: l_child_approver_display_name wf_users.display_name%TYPE;
1628:
1629: begin
1630:
1623: l_parent_item_key wf_items.parent_item_key%TYPE;
1624:
1625: l_child_approver_empid number;
1626: l_child_approver_user_name wf_users.name%TYPE;
1627: l_child_approver_display_name wf_users.display_name%TYPE;
1628:
1629: begin
1630:
1631: l_progress := 'Process_Response_Approve: 001';
1729: l_parent_item_type wf_items.parent_item_type%TYPE;
1730: l_parent_item_key wf_items.parent_item_key%TYPE;
1731:
1732: l_child_approver_empid number;
1733: l_child_approver_user_name wf_users.name%TYPE;
1734: l_child_approver_display_name wf_users.display_name%TYPE;
1735:
1736: begin
1737:
1730: l_parent_item_key wf_items.parent_item_key%TYPE;
1731:
1732: l_child_approver_empid number;
1733: l_child_approver_user_name wf_users.name%TYPE;
1734: l_child_approver_display_name wf_users.display_name%TYPE;
1735:
1736: begin
1737:
1738: l_progress := 'Process_Response_Reject: 001';
1843: l_parent_item_type wf_items.parent_item_type%TYPE;
1844: l_parent_item_key wf_items.parent_item_key%TYPE;
1845:
1846: l_child_approver_empid number;
1847: l_child_approver_user_name wf_users.name%TYPE;
1848: l_child_approver_display_name wf_users.display_name%TYPE;
1849:
1850:
1851: begin
1844: l_parent_item_key wf_items.parent_item_key%TYPE;
1845:
1846: l_child_approver_empid number;
1847: l_child_approver_user_name wf_users.name%TYPE;
1848: l_child_approver_display_name wf_users.display_name%TYPE;
1849:
1850:
1851: begin
1852:
1963: l_parent_item_type wf_items.parent_item_type%TYPE;
1964: l_parent_item_key wf_items.parent_item_key%TYPE;
1965:
1966: l_child_approver_empid number;
1967: l_child_approver_user_name wf_users.name%TYPE;
1968: l_child_approver_display_name wf_users.display_name%TYPE;
1969:
1970: begin
1971:
1964: l_parent_item_key wf_items.parent_item_key%TYPE;
1965:
1966: l_child_approver_empid number;
1967: l_child_approver_user_name wf_users.name%TYPE;
1968: l_child_approver_display_name wf_users.display_name%TYPE;
1969:
1970: begin
1971:
1972: l_progress := 'Process_Response_Forward: 001';
2071: l_parent_item_type wf_items.parent_item_type%TYPE;
2072: l_parent_item_key wf_items.parent_item_key%TYPE;
2073:
2074: l_child_approver_empid number;
2075: l_child_approver_user_name wf_users.name%TYPE;
2076: l_child_approver_display_name wf_users.display_name%TYPE;
2077:
2078: begin
2079:
2072: l_parent_item_key wf_items.parent_item_key%TYPE;
2073:
2074: l_child_approver_empid number;
2075: l_child_approver_user_name wf_users.name%TYPE;
2076: l_child_approver_display_name wf_users.display_name%TYPE;
2077:
2078: begin
2079:
2080: l_progress := 'Process_Response_Approve_Forward: 001';
3721: l_parent_item_type wf_items.parent_item_type%TYPE;
3722: l_parent_item_key wf_items.parent_item_key%TYPE;
3723:
3724: l_child_approver_empid number;
3725: l_child_approver_user_name wf_users.name%TYPE;
3726: l_child_approver_display_name wf_users.display_name%TYPE;
3727:
3728: begin
3729:
3722: l_parent_item_key wf_items.parent_item_key%TYPE;
3723:
3724: l_child_approver_empid number;
3725: l_child_approver_user_name wf_users.name%TYPE;
3726: l_child_approver_display_name wf_users.display_name%TYPE;
3727:
3728: begin
3729:
3730: l_progress := 'Process_Response_Exception: 001';