508: l_org_id number;
509: l_expense_report_id number;
510: l_created_by number;
511: l_preparer_id number;
512: l_preparer_name wf_users.name%type;
513: l_preparer_display_name wf_users.display_name%type;
514: l_employee_id number;
515: l_employee_name wf_users.name%type;
516: l_employee_display_name wf_users.display_name%type;
509: l_expense_report_id number;
510: l_created_by number;
511: l_preparer_id number;
512: l_preparer_name wf_users.name%type;
513: l_preparer_display_name wf_users.display_name%type;
514: l_employee_id number;
515: l_employee_name wf_users.name%type;
516: l_employee_display_name wf_users.display_name%type;
517: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
511: l_preparer_id number;
512: l_preparer_name wf_users.name%type;
513: l_preparer_display_name wf_users.display_name%type;
514: l_employee_id number;
515: l_employee_name wf_users.name%type;
516: l_employee_display_name wf_users.display_name%type;
517: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
518: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
519: l_total varchar2(80);
512: l_preparer_name wf_users.name%type;
513: l_preparer_display_name wf_users.display_name%type;
514: l_employee_id number;
515: l_employee_name wf_users.name%type;
516: l_employee_display_name wf_users.display_name%type;
517: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
518: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
519: l_total varchar2(80);
520: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
2574: l_item_key VARCHAR2(100) := to_char(FND_GLOBAL.CONC_REQUEST_ID);
2575: l_item_type VARCHAR2(10) := C_APWRECPT;
2576: l_supervisor_id ap_expense_report_headers.employee_id%TYPE;
2577: l_temp_emp_id ap_expense_report_headers.employee_id%TYPE;
2578: l_supName wf_users.name%type;
2579: l_supDisplayName wf_users.display_name%type;
2580:
2581:
2582: /*
2575: l_item_type VARCHAR2(10) := C_APWRECPT;
2576: l_supervisor_id ap_expense_report_headers.employee_id%TYPE;
2577: l_temp_emp_id ap_expense_report_headers.employee_id%TYPE;
2578: l_supName wf_users.name%type;
2579: l_supDisplayName wf_users.display_name%type;
2580:
2581:
2582: /*
2583: Criteria for this cursor is: