DBA Data[Home] [Help]

APPS.AP_WEB_VALIDATE_UTIL dependencies on AP_WEB_DB_EXPTEMPLATE_PKG

Line 994: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTemplateId(

990:
991: debug_info := 'Validate Expense Template';
992: BEGIN
993: -- Fix bug 1472710, removed initcap for ExpReportHeaderInfo.template_name
994: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTemplateId(
995: ExpReportHeaderInfo.template_name,
996: ExpReportHeaderInfo.template_id)) THEN
997: ExpReportHeaderInfo.template_id := NULL;
998: ExpReportHeaderInfo.template_name := NULL;

Line 1285: l_calc_amt_enabled_for_disc := AP_WEB_DB_EXPTEMPLATE_PKG.IsCustomCalculateEnabled(

1281:
1282: END IF; -- (p_report_header_info.number_max_flexfield > 0)
1283:
1284: IF p_bCalling_from_disconnected THEN
1285: l_calc_amt_enabled_for_disc := AP_WEB_DB_EXPTEMPLATE_PKG.IsCustomCalculateEnabled(
1286: p_report_header_info.template_id,
1287: p_report_line_info.parameter_id);
1288:
1289: END IF;

Line 2752: l_just_required_cursor AP_WEB_DB_EXPTEMPLATE_PKG.JustificationExpTypeCursor;

2748:
2749:
2750: PROCEDURE initJustificationRequiredArray IS
2751: l_debug_info VARCHAR2(2000);
2752: l_just_required_cursor AP_WEB_DB_EXPTEMPLATE_PKG.JustificationExpTypeCursor;
2753: i INTEGER;
2754: BEGIN
2755: l_debug_info := 'Fill justification required array';
2756: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

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

2753: i INTEGER;
2754: BEGIN
2755: l_debug_info := 'Fill justification required array';
2756: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2757: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetJustifReqdExpTypesCursor(l_just_required_cursor)) THEN
2758: i := 1;
2759: LOOP
2760: FETCH l_just_required_cursor INTO C_justreq_array(i);
2761: EXIT when l_just_required_cursor%NOTFOUND;