DBA Data[Home] [Help]

APPS.AP_WEB_PCARD_WORKFLOW_PKG dependencies on WF_USERS

Line 15: l_employee_name wf_users.name%type; --8770726

11: l_item_type VARCHAR2(100) := 'APEMPVFY';
12: l_item_key VARCHAR2(100);
13: l_employee_id NUMBER;
14: l_status_lookup_code VARCHAR2(15);
15: l_employee_name wf_users.name%type; --8770726
16: l_employee_display_name wf_users.display_name%type; --8770726
17: l_employee_notification_method AP_CARD_PROFILES.emp_notification_lookup_code%TYPE;
18: l_new_emp_verification_id NUMBER;
19: l_num_records_updated NUMBER;

Line 16: l_employee_display_name wf_users.display_name%type; --8770726

12: l_item_key VARCHAR2(100);
13: l_employee_id NUMBER;
14: l_status_lookup_code VARCHAR2(15);
15: l_employee_name wf_users.name%type; --8770726
16: l_employee_display_name wf_users.display_name%type; --8770726
17: l_employee_notification_method AP_CARD_PROFILES.emp_notification_lookup_code%TYPE;
18: l_new_emp_verification_id NUMBER;
19: l_num_records_updated NUMBER;
20: l_lines_without_dists_flag BOOLEAN := FALSE;

Line 337: l_employee_name wf_users.name%type; --Bug 10220928

333: p_org_id IN NUMBER)IS
334: l_item_type VARCHAR2(100) := 'APPCMGR';
335: l_item_key VARCHAR2(100);
336: l_employee_id NUMBER;
337: l_employee_name wf_users.name%type; --Bug 10220928
338: l_employee_display_name wf_users.display_name%type; --Bug 10220928
339: l_manager_id NUMBER;
340: l_manager_name wf_users.name%type; --Bug 10220928
341: l_manager_display_name wf_users.display_name%type; --Bug 10220928

Line 338: l_employee_display_name wf_users.display_name%type; --Bug 10220928

334: l_item_type VARCHAR2(100) := 'APPCMGR';
335: l_item_key VARCHAR2(100);
336: l_employee_id NUMBER;
337: l_employee_name wf_users.name%type; --Bug 10220928
338: l_employee_display_name wf_users.display_name%type; --Bug 10220928
339: l_manager_id NUMBER;
340: l_manager_name wf_users.name%type; --Bug 10220928
341: l_manager_display_name wf_users.display_name%type; --Bug 10220928
342: l_manager_approval_method AP_CARD_PROFILES.mgr_approval_lookup_code%TYPE;

Line 340: l_manager_name wf_users.name%type; --Bug 10220928

336: l_employee_id NUMBER;
337: l_employee_name wf_users.name%type; --Bug 10220928
338: l_employee_display_name wf_users.display_name%type; --Bug 10220928
339: l_manager_id NUMBER;
340: l_manager_name wf_users.name%type; --Bug 10220928
341: l_manager_display_name wf_users.display_name%type; --Bug 10220928
342: l_manager_approval_method AP_CARD_PROFILES.mgr_approval_lookup_code%TYPE;
343: l_new_manager_approval_id NUMBER;
344: l_url VARCHAR2(1000);

Line 341: l_manager_display_name wf_users.display_name%type; --Bug 10220928

337: l_employee_name wf_users.name%type; --Bug 10220928
338: l_employee_display_name wf_users.display_name%type; --Bug 10220928
339: l_manager_id NUMBER;
340: l_manager_name wf_users.name%type; --Bug 10220928
341: l_manager_display_name wf_users.display_name%type; --Bug 10220928
342: l_manager_approval_method AP_CARD_PROFILES.mgr_approval_lookup_code%TYPE;
343: l_new_manager_approval_id NUMBER;
344: l_url VARCHAR2(1000);
345: l_debug_info VARCHAR2(200);

Line 1412: l_employee_name wf_users.name%type; --Bug 10220928

1408: p_result OUT NOCOPY VARCHAR2) IS
1409: ------------------------------------------------------------------------------
1410: l_manager_approval_id NUMBER;
1411: l_employee_id NUMBER;
1412: l_employee_name wf_users.name%type; --Bug 10220928
1413: l_employee_display_name wf_users.display_name%type; --Bug 10220928
1414: l_transaction_date VARCHAR2(15);
1415: l_merchant_name VARCHAR2(30);
1416: l_amount NUMBER;

Line 1413: l_employee_display_name wf_users.display_name%type; --Bug 10220928

1409: ------------------------------------------------------------------------------
1410: l_manager_approval_id NUMBER;
1411: l_employee_id NUMBER;
1412: l_employee_name wf_users.name%type; --Bug 10220928
1413: l_employee_display_name wf_users.display_name%type; --Bug 10220928
1414: l_transaction_date VARCHAR2(15);
1415: l_merchant_name VARCHAR2(30);
1416: l_amount NUMBER;
1417: l_currency_code VARCHAR2(15);