APPS.AP_WEB_OA_CUSTOM_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

Line 106: FUNCTION GetNewExpenseReportInvoice(p_employeeId IN ap_expense_report_headers.employee_id%TYPE,

102: -- p_employeeId id of the employee whom the report is for
103: -- p_userId fnd user_id of the employee whom the report is for
104: -- p_reportHeaderId report_header_id of the curent report
105: ------------------------------------------------------------------------------------
106: FUNCTION GetNewExpenseReportInvoice(p_employeeId IN ap_expense_report_headers.employee_id%TYPE,
107: p_userId IN fnd_user.user_id%TYPE,
108: p_reportHeaderId IN ap_expense_report_headers.report_header_id%TYPE) RETURN VARCHAR2 IS
109: l_reportNumber ap_expense_report_headers.invoice_num%TYPE := NULL;
110: l_userName fnd_user.user_name%TYPE := null;

Line 108: p_reportHeaderId IN ap_expense_report_headers.report_header_id%TYPE) RETURN VARCHAR2 IS

104: -- p_reportHeaderId report_header_id of the curent report
105: ------------------------------------------------------------------------------------
106: FUNCTION GetNewExpenseReportInvoice(p_employeeId IN ap_expense_report_headers.employee_id%TYPE,
107: p_userId IN fnd_user.user_id%TYPE,
108: p_reportHeaderId IN ap_expense_report_headers.report_header_id%TYPE) RETURN VARCHAR2 IS
109: l_reportNumber ap_expense_report_headers.invoice_num%TYPE := NULL;
110: l_userName fnd_user.user_name%TYPE := null;
111: l_nReport NUMBER := 0;
112: BEGIN

Line 109: l_reportNumber ap_expense_report_headers.invoice_num%TYPE := NULL;

105: ------------------------------------------------------------------------------------
106: FUNCTION GetNewExpenseReportInvoice(p_employeeId IN ap_expense_report_headers.employee_id%TYPE,
107: p_userId IN fnd_user.user_id%TYPE,
108: p_reportHeaderId IN ap_expense_report_headers.report_header_id%TYPE) RETURN VARCHAR2 IS
109: l_reportNumber ap_expense_report_headers.invoice_num%TYPE := NULL;
110: l_userName fnd_user.user_name%TYPE := null;
111: l_nReport NUMBER := 0;
112: BEGIN
113: -- IF (p_employeeId is not NULL AND p_userId is not NULL) THEN

Line 138: -- FROM ap_expense_report_headers

134:
135: -- Get the total of the number of expense report
136: -- this employee has for current year
137: -- SELECT count(*) INTO l_nReport
138: -- FROM ap_expense_report_headers
139: -- WHERE employee_id = p_employeeId
140: -- AND to_char(sysdate, 'RR') = to_char(CREATION_DATE, 'RR');
141:
142: -- l_nReport := l_nReport + 1;