APPS.AP_WEB_EXPENSE_WF dependencies on AP_WEB_DB_SCHLINE_PKG

Line 12293: p_schedule_line_array OUT NOCOPY AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array) IS

12289: p_report_header_id IN NUMBER,
12290: p_distribution_line_number IN NUMBER,
12291: p_employee_id IN NUMBER,
12292: p_cumulative_mileage IN NUMBER,
12293: p_schedule_line_array OUT NOCOPY AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array) IS
12294: ---------------------------------------------------------
12295: l_vehicle_category_code AP_WEB_DB_EXPLINE_PKG.expLines_vehicle_category_code;
12296: l_vehicle_type AP_WEB_DB_EXPLINE_PKG.expLines_vehicle_type;
12297: l_fuel_type AP_WEB_DB_EXPLINE_PKG.expLines_fuel_type;

Line 12314: l_schedule_line_array AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array;

12310: l_currency_preference AP_POL_HEADERS.CURRENCY_PREFERENCE%TYPE;
12311: bDistanceWithinRange BOOLEAN := FALSE;
12312: bDistanceThresholdCrossed BOOLEAN := FALSE;
12313: bFoundSingleRate BOOLEAN := FALSE;
12314: l_schedule_line_array AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array;
12315: l_orig_cum_mileage AP_WEB_EMPLOYEE_INFO.VALUE_TYPE%TYPE;
12316: i NUMBER := 1;
12317: j NUMBER := 1;
12318:

Line 12319: c_schedule_line_cursor AP_WEB_DB_SCHLINE_PKG.ScheduleLinesCursor;

12315: l_orig_cum_mileage AP_WEB_EMPLOYEE_INFO.VALUE_TYPE%TYPE;
12316: i NUMBER := 1;
12317: j NUMBER := 1;
12318:
12319: c_schedule_line_cursor AP_WEB_DB_SCHLINE_PKG.ScheduleLinesCursor;
12320:
12321: BEGIN
12322: --------------------------------------------------
12323: l_debug_info := 'Retrieving info from the Database';

Line 12405: IF ( AP_WEB_DB_SCHLINE_PKG.GetScheduleLinesCursor(l_policy_id,

12401: --------------------------------------------------
12402: l_orig_cum_mileage := l_cumulative_mileage;
12403: l_cumulative_mileage := l_cumulative_mileage + l_trip_distance;
12404:
12405: IF ( AP_WEB_DB_SCHLINE_PKG.GetScheduleLinesCursor(l_policy_id,
12406: l_vehicle_category_code,
12407: l_vehicle_type,
12408: l_fuel_type,
12409: l_currency_code,

Line 12536: p_schedule_line IN AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Rec)

12532: FUNCTION getRate(
12533: p_sh_distance_uom IN AP_POL_HEADERS.distance_uom%TYPE,
12534: p_sh_currency_code IN AP_POL_HEADERS.currency_code%TYPE,
12535: p_mileage_line IN AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Rec,
12536: p_schedule_line IN AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Rec)
12537: RETURN NUMBER IS
12538: -------------------------------------------------------------------------------
12539: l_debug_info VARCHAR2(200);
12540: l_conversion_type VARCHAR2(30);

Line 12726: p_schedule_line_array IN AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array,

12722: PROCEDURE processCrossThreshold(
12723: p_ml_index IN NUMBER,
12724: p_sh_distance_uom IN AP_POL_HEADERS.DISTANCE_UOM%TYPE,
12725: p_sh_currency_code IN AP_POL_HEADERS.CURRENCY_CODE%TYPE,
12726: p_schedule_line_array IN AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array,
12727: p_mileage_line_array_count IN OUT NOCOPY NUMBER,
12728: p_cumulative_mileage IN OUT NOCOPY AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
12729: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array)IS
12730: --------------------------------------------------------------------------------

Line 12982: l_schedule_line_array AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array;

12978: l_ml_distance_unit_code AP_WEB_DB_EXPLINE_PKG.expLines_distance_unit_code;
12979: l_ml_trip_distance AP_WEB_DB_EXPLINE_PKG.expLines_trip_distance;
12980: c_expense_lines_cursor AP_WEB_DB_EXPLINE_PKG.ExpLinesCursor;
12981: l_employee_id NUMBER;
12982: l_schedule_line_array AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array;
12983: l_temp NUMBER;
12984: l_sh_distance_uom AP_POL_HEADERS.distance_uom%TYPE;
12985: l_sh_currency_code AP_POL_HEADERS.currency_code%TYPE;
12986: l_index NUMBER := 0;

Line 13149: AP_WEB_DB_SCHLINE_PKG.getSchHeaderInfo(

13145:
13146: --------------------------------------------
13147: l_debug_info := 'Get distance UOM from schedule header';
13148: --------------------------------------------
13149: AP_WEB_DB_SCHLINE_PKG.getSchHeaderInfo(
13150: p_policy_id => l_mileage_line_array(i).policy_id,
13151: p_sh_distance_uom => l_sh_distance_uom,
13152: p_sh_currency_code => l_sh_currency_code,
13153: p_sh_distance_thresholds_flag => l_sh_distance_thresholds_flag);