DBA Data[Home] [Help]

APPS.POR_AME_REQ_WF_PVT dependencies on WF_USERS

Line 71: l_next_approver_disp_name wf_users.display_name%TYPE;

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:

Line 72: l_orig_system wf_users.orig_system%TYPE := ame_util.perOrigSystem;

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

Line 1626: l_child_approver_user_name wf_users.name%TYPE;

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:

Line 1627: l_child_approver_display_name wf_users.display_name%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:
1631: l_progress := 'Process_Response_Approve: 001';

Line 1733: l_child_approver_user_name wf_users.name%TYPE;

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:

Line 1734: l_child_approver_display_name wf_users.display_name%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:
1738: l_progress := 'Process_Response_Reject: 001';

Line 1847: l_child_approver_user_name wf_users.name%TYPE;

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

Line 1848: l_child_approver_display_name wf_users.display_name%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
1852:

Line 1967: l_child_approver_user_name wf_users.name%TYPE;

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:

Line 1968: l_child_approver_display_name wf_users.display_name%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:
1972: l_progress := 'Process_Response_Forward: 001';

Line 2075: l_child_approver_user_name wf_users.name%TYPE;

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:

Line 2076: l_child_approver_display_name wf_users.display_name%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:
2080: l_progress := 'Process_Response_Approve_Forward: 001';

Line 3725: l_child_approver_user_name wf_users.name%TYPE;

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:

Line 3726: l_child_approver_display_name wf_users.display_name%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:
3730: l_progress := 'Process_Response_Exception: 001';