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 253: FROM ap_expense_report_params

249: -------------------------------------------------------------------
250: BEGIN
251: SELECT prompt
252: INTO p_exp_prompt
253: FROM ap_expense_report_params
254: WHERE parameter_id = p_parameter_id;
255:
256: return TRUE;
257:

Line 274: FROM ap_expense_report_params

270: -------------------------------------------------------------------
271: BEGIN
272: SELECT parameter_id
273: INTO p_parameter_id
274: FROM ap_expense_report_params
275: WHERE expense_type_code = 'PERSONAL';
276:
277: return TRUE;
278:

Line 309: FROM AP_EXPENSE_REPORT_PARAMS

305: P_ExpTypeRec.vat_code,
306: P_ExpTypeRec.amt_incl_tax,
307: P_ExpTypeRec.line_type,
308: p_ExpTypeRec.pa_exp_type
309: FROM AP_EXPENSE_REPORT_PARAMS
310: WHERE PARAMETER_ID = P_ExpTypeID;
311:
312: return TRUE;
313: EXCEPTION

Line 421: FROM AP_EXPENSE_REPORT_PARAMS

417: nvl(require_receipt_amount,-1)
418: INTO p_item_description,
419: p_line_type_lookup_code,
420: p_require_receipt_amount
421: FROM AP_EXPENSE_REPORT_PARAMS
422: WHERE parameter_id = p_xtype;
423: END IF;
424:
425: RETURN TRUE;

Line 467: l_calculate_amount_enabled AP_EXPENSE_REPORT_PARAMS.calculate_amount_flag%TYPE;

463: FUNCTION IsCustomCalculateEnabled(p_template_id IN VARCHAR2,
464: p_parameter_id IN VARCHAR2)
465: RETURN BOOLEAN IS
466:
467: l_calculate_amount_enabled AP_EXPENSE_REPORT_PARAMS.calculate_amount_flag%TYPE;
468: l_debug_info VARCHAR2(2000);
469:
470: BEGIN
471:

Line 479: ap_expense_report_params erp

475:
476: SELECT erp.calculate_amount_flag
477: INTO l_calculate_amount_enabled
478: FROM ap_lookup_codes lc,
479: ap_expense_report_params erp
480: WHERE (erp.expense_report_id = to_number(p_template_id)
481: AND erp.parameter_id = to_number(p_parameter_id))
482: AND erp.line_type_lookup_code = lc.lookup_code
483: AND lc.lookup_type = 'INVOICE DISTRIBUTION TYPE';

Line 532: FROM AP_EXPENSE_REPORT_PARAMS

528: l_debug_info := 'Retrieving require_receipt_amount';
529: -------------------------------------------------------------------
530: SELECT require_receipt_amount
531: INTO p_require_receipt_amount
532: FROM AP_EXPENSE_REPORT_PARAMS
533: WHERE PARAMETER_ID = P_ExpTypeID;
534:
535: return TRUE;
536: EXCEPTION

Line 559: FROM ap_expense_report_params

555: RETURN BOOLEAN IS
556: BEGIN
557: SELECT parameter_id
558: INTO p_parameter_id
559: FROM ap_expense_report_params
560: WHERE expense_type_code = 'ROUNDING';
561:
562: return TRUE;
563: