eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_EXPENSE_WF dependencies on AP_WEB_EMPLOYEE_INFO

Line 12309: l_cumulative_mileage AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE := nvl(p_cumulative_mileage,0);

12305: l_distance_uom AP_POL_HEADERS.DISTANCE_UOM%TYPE;
12306: l_employee_role_flag AP_POL_HEADERS.EMPLOYEE_ROLE_FLAG%TYPE;
12307: l_distance_thresholds_flag AP_POL_HEADERS.DISTANCE_THRESHOLDS_FLAG%TYPE;
12308: l_debug_info VARCHAR2(200);
12309: l_cumulative_mileage AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE := nvl(p_cumulative_mileage,0);
12310: l_currency_preference AP_POL_HEADERS.CURRENCY_PREFERENCE%TYPE;
12311: bDistanceWithinRange BOOLEAN := FALSE;
12312: bDistanceThresholdCrossed BOOLEAN := FALSE;
12313: bFoundSingleRate BOOLEAN := FALSE;

Line 12315: l_orig_cum_mileage AP_WEB_EMPLOYEE_INFO.VALUE_TYPE%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:
12319: c_schedule_line_cursor AP_WEB_DB_SCHLINE_PKG.ScheduleLinesCursor;

Line 12461: p_cumulative_mileage IN AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,

12457:
12458:
12459: -------------------------------------------------------------------------------
12460: PROCEDURE updateCumulativeMileage(
12461: p_cumulative_mileage IN AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
12462: p_period_id IN AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE,
12463: p_employee_id IN AP_WEB_EMPLOYEE_INFO.EMPLOYEE_ID%TYPE) IS
12464: -------------------------------------------------------------------------------
12465: l_count NUMBER := 0;

Line 12462: p_period_id IN AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE,

12458:
12459: -------------------------------------------------------------------------------
12460: PROCEDURE updateCumulativeMileage(
12461: p_cumulative_mileage IN AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
12462: p_period_id IN AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE,
12463: p_employee_id IN AP_WEB_EMPLOYEE_INFO.EMPLOYEE_ID%TYPE) IS
12464: -------------------------------------------------------------------------------
12465: l_count NUMBER := 0;
12466: BEGIN

Line 12463: p_employee_id IN AP_WEB_EMPLOYEE_INFO.EMPLOYEE_ID%TYPE) IS

12459: -------------------------------------------------------------------------------
12460: PROCEDURE updateCumulativeMileage(
12461: p_cumulative_mileage IN AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
12462: p_period_id IN AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE,
12463: p_employee_id IN AP_WEB_EMPLOYEE_INFO.EMPLOYEE_ID%TYPE) IS
12464: -------------------------------------------------------------------------------
12465: l_count NUMBER := 0;
12466: BEGIN
12467:

Line 12470: FROM ap_web_employee_info_all

12466: BEGIN
12467:
12468: SELECT count(*)
12469: INTO l_count
12470: FROM ap_web_employee_info_all
12471: WHERE value_type = 'CUM_REIMB_DISTANCE'
12472: AND period_id = p_period_id
12473: AND employee_id = p_employee_id;
12474:

Line 12476: UPDATE ap_web_employee_info_all

12472: AND period_id = p_period_id
12473: AND employee_id = p_employee_id;
12474:
12475: IF (l_count > 0 ) THEN
12476: UPDATE ap_web_employee_info_all
12477: SET numeric_value = p_cumulative_mileage,
12478: last_update_date = sysdate,
12479: last_updated_by = p_employee_id
12480: WHERE value_type = 'CUM_REIMB_DISTANCE'

Line 12484: INSERT INTO ap_web_employee_info_all

12480: WHERE value_type = 'CUM_REIMB_DISTANCE'
12481: AND period_id = p_period_id
12482: AND employee_id = p_employee_id;
12483: ELSE
12484: INSERT INTO ap_web_employee_info_all
12485: (EMPLOYEE_ID,
12486: VALUE_TYPE,
12487: NUMERIC_VALUE,
12488: PERIOD_ID,

Line 12728: p_cumulative_mileage IN OUT NOCOPY AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,

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: --------------------------------------------------------------------------------
12731: l_cumulative_mileage NUMBER := p_cumulative_mileage;
12732: l_ml_trip_distance NUMBER := p_mileage_line_array(p_ml_index).trip_distance;

Line 12972: l_cumulative_mileage AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE;

12968: l_ml_end_date DATE;
12969: l_ml_numberOfDays NUMBER;
12970: l_ml_distribution_line_number AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
12971: l_ml_policy_id AP_POL_HEADERS.policy_id%TYPE;
12972: l_cumulative_mileage AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE;
12973: l_period_id AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE;
12974: l_debug_info VARCHAR2(200);
12975: C_WF_VERSION NUMBER := 0;
12976: l_new_rate NUMBER := 0;

Line 12973: l_period_id AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE;

12969: l_ml_numberOfDays NUMBER;
12970: l_ml_distribution_line_number AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
12971: l_ml_policy_id AP_POL_HEADERS.policy_id%TYPE;
12972: l_cumulative_mileage AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE;
12973: l_period_id AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE;
12974: l_debug_info VARCHAR2(200);
12975: C_WF_VERSION NUMBER := 0;
12976: l_new_rate NUMBER := 0;
12977: l_ml_avg_mileage_rate AP_WEB_DB_EXPLINE_PKG.expLines_avg_mileage_rate;