DBA Data[Home] [Help]

APPS.POR_AME_REQ_WF_PVT dependencies on WF_USERS

Line 52: l_next_approver_disp_name wf_users.display_name%TYPE;

48: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
49: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
50: l_next_approver_id NUMBER;
51: l_next_approver_user_name fnd_user.user_name%TYPE;
52: l_next_approver_disp_name wf_users.display_name%TYPE;
53: l_orig_system wf_users.orig_system%TYPE := ame_util.perOrigSystem;
54: l_sequence_num NUMBER;
55: l_approver_type VARCHAR2(30);
56:

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

49: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
50: l_next_approver_id NUMBER;
51: l_next_approver_user_name fnd_user.user_name%TYPE;
52: l_next_approver_disp_name wf_users.display_name%TYPE;
53: l_orig_system wf_users.orig_system%TYPE := ame_util.perOrigSystem;
54: l_sequence_num NUMBER;
55: l_approver_type VARCHAR2(30);
56:
57: l_doc_string varchar2(200);

Line 1105: l_child_approver_user_name wf_users.name%TYPE;

1101: l_parent_item_type wf_items.parent_item_type%TYPE;
1102: l_parent_item_key wf_items.parent_item_key%TYPE;
1103:
1104: l_child_approver_empid number;
1105: l_child_approver_user_name wf_users.name%TYPE;
1106: l_child_approver_display_name wf_users.display_name%TYPE;
1107:
1108: begin
1109:

Line 1106: l_child_approver_display_name wf_users.display_name%TYPE;

1102: l_parent_item_key wf_items.parent_item_key%TYPE;
1103:
1104: l_child_approver_empid number;
1105: l_child_approver_user_name wf_users.name%TYPE;
1106: l_child_approver_display_name wf_users.display_name%TYPE;
1107:
1108: begin
1109:
1110: l_progress := 'Process_Response_Approve: 001';

Line 1212: l_child_approver_user_name wf_users.name%TYPE;

1208: l_parent_item_type wf_items.parent_item_type%TYPE;
1209: l_parent_item_key wf_items.parent_item_key%TYPE;
1210:
1211: l_child_approver_empid number;
1212: l_child_approver_user_name wf_users.name%TYPE;
1213: l_child_approver_display_name wf_users.display_name%TYPE;
1214:
1215: begin
1216:

Line 1213: l_child_approver_display_name wf_users.display_name%TYPE;

1209: l_parent_item_key wf_items.parent_item_key%TYPE;
1210:
1211: l_child_approver_empid number;
1212: l_child_approver_user_name wf_users.name%TYPE;
1213: l_child_approver_display_name wf_users.display_name%TYPE;
1214:
1215: begin
1216:
1217: l_progress := 'Process_Response_Reject: 001';

Line 1326: l_child_approver_user_name wf_users.name%TYPE;

1322: l_parent_item_type wf_items.parent_item_type%TYPE;
1323: l_parent_item_key wf_items.parent_item_key%TYPE;
1324:
1325: l_child_approver_empid number;
1326: l_child_approver_user_name wf_users.name%TYPE;
1327: l_child_approver_display_name wf_users.display_name%TYPE;
1328:
1329:
1330: begin

Line 1327: l_child_approver_display_name wf_users.display_name%TYPE;

1323: l_parent_item_key wf_items.parent_item_key%TYPE;
1324:
1325: l_child_approver_empid number;
1326: l_child_approver_user_name wf_users.name%TYPE;
1327: l_child_approver_display_name wf_users.display_name%TYPE;
1328:
1329:
1330: begin
1331: