APPS.AP_WEB_DB_EXPTEMPLATE_PKG dependencies on AP_EXPENSE_REPORT_PARAMS

Line 36: ap_expense_report_params erp,

32: OPEN P_cursor FOR
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))

Line 69: FROM ap_expense_report_params erp;

65: SELECT nvl(web_friendly_prompt, prompt) web_prompt,
66: erp.parameter_id,
67: erp.justification_required_flag,
68: erp.require_receipt_amount
69: FROM ap_expense_report_params erp;
70:
71: return TRUE;
72: EXCEPTION
73: WHEN NO_DATA_FOUND THEN

Line 95: FROM ap_expense_report_params erp,

91: erp.require_receipt_amount,
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'

Line 131: FROM ap_expense_report_params erp,

127: nvl(erp.justification_required_flag,'V') justif_req,
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))

Line 156: FROM ap_expense_report_params erp

152: --------------------------------------------------------------------------------
153: BEGIN
154: OPEN p_cursor FOR
155: SELECT erp.parameter_id
156: FROM ap_expense_report_params erp
157: WHERE nvl(erp.justification_required_flag,'V') = 'Y'
158: ORDER BY nvl(web_friendly_prompt, prompt);
159:
160: return TRUE;

Line 233: FROM ap_expense_report_params

229: -------------------------------------------------------------------
230: BEGIN
231: SELECT prompt
232: INTO p_exp_prompt
233: FROM ap_expense_report_params
234: WHERE parameter_id = p_parameter_id;
235:
236: return TRUE;
237:

Line 254: FROM ap_expense_report_params

250: -------------------------------------------------------------------
251: BEGIN
252: SELECT parameter_id
253: INTO p_parameter_id
254: FROM ap_expense_report_params
255: WHERE expense_type_code = 'PERSONAL';
256:
257: return TRUE;
258:

Line 289: FROM AP_EXPENSE_REPORT_PARAMS

285: P_ExpTypeRec.vat_code,
286: P_ExpTypeRec.amt_incl_tax,
287: P_ExpTypeRec.line_type,
288: p_ExpTypeRec.pa_exp_type
289: FROM AP_EXPENSE_REPORT_PARAMS
290: WHERE PARAMETER_ID = P_ExpTypeID;
291:
292: return TRUE;
293: EXCEPTION

Line 401: FROM AP_EXPENSE_REPORT_PARAMS

397: nvl(require_receipt_amount,-1)
398: INTO p_item_description,
399: p_line_type_lookup_code,
400: p_require_receipt_amount
401: FROM AP_EXPENSE_REPORT_PARAMS
402: WHERE parameter_id = p_xtype;
403: END IF;
404:
405: RETURN TRUE;

Line 447: l_calculate_amount_enabled AP_EXPENSE_REPORT_PARAMS.calculate_amount_flag%TYPE;

443: FUNCTION IsCustomCalculateEnabled(p_template_id IN VARCHAR2,
444: p_parameter_id IN VARCHAR2)
445: RETURN BOOLEAN IS
446:
447: l_calculate_amount_enabled AP_EXPENSE_REPORT_PARAMS.calculate_amount_flag%TYPE;
448: l_debug_info VARCHAR2(2000);
449:
450: BEGIN
451:

Line 459: ap_expense_report_params erp

455:
456: SELECT erp.calculate_amount_flag
457: INTO l_calculate_amount_enabled
458: FROM ap_lookup_codes lc,
459: ap_expense_report_params erp
460: WHERE (erp.expense_report_id = to_number(p_template_id)
461: AND erp.parameter_id = to_number(p_parameter_id))
462: AND erp.line_type_lookup_code = lc.lookup_code
463: AND lc.lookup_type = 'INVOICE DISTRIBUTION TYPE';

Line 512: FROM AP_EXPENSE_REPORT_PARAMS

508: l_debug_info := 'Retrieving require_receipt_amount';
509: -------------------------------------------------------------------
510: SELECT require_receipt_amount
511: INTO p_require_receipt_amount
512: FROM AP_EXPENSE_REPORT_PARAMS
513: WHERE PARAMETER_ID = P_ExpTypeID;
514:
515: return TRUE;
516: EXCEPTION

Line 539: FROM ap_expense_report_params

535: RETURN BOOLEAN IS
536: BEGIN
537: SELECT parameter_id
538: INTO p_parameter_id
539: FROM ap_expense_report_params
540: WHERE expense_type_code = 'ROUNDING';
541:
542: return TRUE;
543: