APPS.AP_WEB_DB_EXPTEMPLATE_PKG dependencies on AP_EXPENSE_REPORTS

Line 10: FROM ap_expense_reports

6: --------------------------------------------------------------------------------
7: BEGIN
8: OPEN p_cursor FOR
9: SELECT expense_report_id, report_type
10: FROM ap_expense_reports
11: WHERE web_enabled_flag = 'Y'
12: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))
13: AND AP_WEB_DB_EXPTEMPLATE_PKG.IsExpTemplateWebEnabled(expense_report_id) = 'Y'
14: ORDER BY UPPER(report_type);

Line 37: ap_expense_reports er

33: SELECT nvl(erp.web_friendly_prompt, erp.prompt),
34: to_char(erp.parameter_id)
35: FROM ap_lookup_codes lc,
36: ap_expense_report_params erp,
37: ap_expense_reports er
38: WHERE (erp.expense_report_id = p_xtemplateid
39: OR ( erp.web_enabled_flag = 'Y'
40: AND trunc(sysdate) <= trunc(nvl(er.inactive_date, sysdate))
41: )

Line 96: ap_expense_reports er

92: erp.card_exp_type_lookup_code,
93: erp.amount_includes_tax_flag,
94: nvl(erp.justification_required_flag,'V') justif_req
95: FROM ap_expense_report_params erp,
96: ap_expense_reports er
97: WHERE erp.expense_report_id = p_report_id
98: OR (erp.web_enabled_flag = 'Y'
99: AND er.web_enabled_flag = 'Y'
100: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))

Line 132: ap_expense_reports er

128: calculate_amount_flag,
129: erp.amount_includes_tax_flag,
130: erp.pa_expenditure_type
131: FROM ap_expense_report_params erp,
132: ap_expense_reports er
133: WHERE erp.expense_report_id = er.expense_report_id
134: AND trunc(sysdate) <= trunc(nvl(er.inactive_date, sysdate))
135: AND trunc(sysdate) <= trunc(nvl(erp.end_date, sysdate))
136: AND er.web_enabled_flag = 'Y';

Line 185: FROM ap_expense_reports WHERE web_enabled_flag = 'Y'

181: l_debugInfo := 'getTemplateName';
182: -------------------------------------------------------
183: SELECT report_type
184: INTO P_TemplateName
185: FROM ap_expense_reports WHERE web_enabled_flag = 'Y'
186: AND expense_report_id = P_TemplateID;
187:
188: return TRUE;
189: EXCEPTION

Line 212: FROM ap_expense_reports

208: /*
209: -- Fix 1472710, Added check to verify if the template is valid.
210: SELECT expense_report_id
211: INTO p_exp_temp_id
212: FROM ap_expense_reports
213: WHERE web_enabled_flag = 'Y'
214: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))
215: AND report_type = p_report_type;
216: */

Line 229: FROM ap_expense_reports

225: p_apps_id => FND_PROFILE.VALUE('RESP_APPL_ID'));
226:
227: SELECT expense_report_id
228: INTO p_exp_temp_id
229: FROM ap_expense_reports
230: WHERE web_enabled_flag = 'Y'
231: AND trunc(sysdate) <= trunc(nvl(inactive_date + v_graceperiod, sysdate))
232: AND report_type = p_report_type;
233:

Line 324: FUNCTION IsExpTemplateWebEnabled(p_expense_report_id IN ap_expense_reports.expense_report_id%TYPE)

320: END GetExpTypeInfo;
321:
322:
323: -------------------------------------------------------------------
324: FUNCTION IsExpTemplateWebEnabled(p_expense_report_id IN ap_expense_reports.expense_report_id%TYPE)
325: RETURN VARCHAR2 IS
326: -------------------------------------------------------------------
327:
328: l_exp_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;

Line 384: FROM ap_expense_reports

380: -------------------------------------------------------------------
381: BEGIN
382: SELECT COUNT(*)
383: INTO p_count
384: FROM ap_expense_reports
385: WHERE web_enabled_flag = 'Y'
386: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate))
387: AND AP_WEB_DB_EXPTEMPLATE_PKG.IsExpTemplateWebEnabled(expense_report_id) = 'Y';
388: