eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_OA_CUSTOM_PKG dependencies on FND_USER

Line 103: -- p_userId fnd user_id of the employee whom the report is for

99: --
100: -- Parameters :
101: --
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,

Line 107: p_userId IN fnd_user.user_id%TYPE,

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;
111: l_nReport NUMBER := 0;

Line 110: l_userName fnd_user.user_name%TYPE := null;

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
114: -- SAMPLE CODE

Line 129: -- FROM fnd_user fnd

125: --
126: --
127: -- Get the user name
128: -- SELECT user_name INTO l_userName
129: -- FROM fnd_user fnd
130: -- WHERE fnd.employee_id = p_employeeId
131: -- AND fnd.user_id = p_userId
132: -- AND sysdate <= nvl(fnd.end_date, sysdate)
133: -- AND rownum = 1;

Line 131: -- AND fnd.user_id = p_userId

127: -- Get the user name
128: -- SELECT user_name INTO l_userName
129: -- FROM fnd_user fnd
130: -- WHERE fnd.employee_id = p_employeeId
131: -- AND fnd.user_id = p_userId
132: -- AND sysdate <= nvl(fnd.end_date, sysdate)
133: -- AND rownum = 1;
134:
135: -- Get the total of the number of expense report