APPS.AP_WEB_VALIDATE_UTIL dependencies on AP_WEB_DB_EXPTEMPLATE_PKG

Line 960: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTemplateId(

956:
957: debug_info := 'Validate Expense Template';
958: BEGIN
959: -- Fix bug 1472710, removed initcap for ExpReportHeaderInfo.template_name
960: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTemplateId(
961: ExpReportHeaderInfo.template_name,
962: ExpReportHeaderInfo.template_id)) THEN
963: ExpReportHeaderInfo.template_id := NULL;
964: ExpReportHeaderInfo.template_name := NULL;

Line 1251: l_calc_amt_enabled_for_disc := AP_WEB_DB_EXPTEMPLATE_PKG.IsCustomCalculateEnabled(

1247:
1248: END IF; -- (p_report_header_info.number_max_flexfield > 0)
1249:
1250: IF p_bCalling_from_disconnected THEN
1251: l_calc_amt_enabled_for_disc := AP_WEB_DB_EXPTEMPLATE_PKG.IsCustomCalculateEnabled(
1252: p_report_header_info.template_id,
1253: p_report_line_info.parameter_id);
1254:
1255: END IF;

Line 2718: l_just_required_cursor AP_WEB_DB_EXPTEMPLATE_PKG.JustificationExpTypeCursor;

2714:
2715:
2716: PROCEDURE initJustificationRequiredArray IS
2717: l_debug_info VARCHAR2(2000);
2718: l_just_required_cursor AP_WEB_DB_EXPTEMPLATE_PKG.JustificationExpTypeCursor;
2719: i INTEGER;
2720: BEGIN
2721: l_debug_info := 'Fill justification required array';
2722: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

Line 2723: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetJustifReqdExpTypesCursor(l_just_required_cursor)) THEN

2719: i INTEGER;
2720: BEGIN
2721: l_debug_info := 'Fill justification required array';
2722: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2723: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetJustifReqdExpTypesCursor(l_just_required_cursor)) THEN
2724: i := 1;
2725: LOOP
2726: FETCH l_just_required_cursor INTO C_justreq_array(i);
2727: EXIT when l_just_required_cursor%NOTFOUND;