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