382: purpose_prompt VARCHAR2(50);
383: template_prompt VARCHAR2(50);
384: approver_prompt VARCHAR2(50);
385:
386: l_employee_num HR_EMPLOYEES.employee_num%TYPE := 100;
387: l_employee_name HR_EMPLOYEES.full_name%TYPE := '';
388: l_cost_center VARCHAR2(150);
389: l_OverriderReq VARCHAR2(10);
390: l_approver_id HR_EMPLOYEES.employee_num%TYPE := 100;
383: template_prompt VARCHAR2(50);
384: approver_prompt VARCHAR2(50);
385:
386: l_employee_num HR_EMPLOYEES.employee_num%TYPE := 100;
387: l_employee_name HR_EMPLOYEES.full_name%TYPE := '';
388: l_cost_center VARCHAR2(150);
389: l_OverriderReq VARCHAR2(10);
390: l_approver_id HR_EMPLOYEES.employee_num%TYPE := 100;
391: l_approver_name HR_EMPLOYEES.full_name%TYPE := '';
386: l_employee_num HR_EMPLOYEES.employee_num%TYPE := 100;
387: l_employee_name HR_EMPLOYEES.full_name%TYPE := '';
388: l_cost_center VARCHAR2(150);
389: l_OverriderReq VARCHAR2(10);
390: l_approver_id HR_EMPLOYEES.employee_num%TYPE := 100;
391: l_approver_name HR_EMPLOYEES.full_name%TYPE := '';
392:
393:
394: BEGIN
387: l_employee_name HR_EMPLOYEES.full_name%TYPE := '';
388: l_cost_center VARCHAR2(150);
389: l_OverriderReq VARCHAR2(10);
390: l_approver_id HR_EMPLOYEES.employee_num%TYPE := 100;
391: l_approver_name HR_EMPLOYEES.full_name%TYPE := '';
392:
393:
394: BEGIN
395: