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 13072: l_cumulative_mileage AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE := nvl(p_cumulative_mileage,0);

13068: l_distance_uom AP_POL_HEADERS.DISTANCE_UOM%TYPE;
13069: l_employee_role_flag AP_POL_HEADERS.EMPLOYEE_ROLE_FLAG%TYPE;
13070: l_distance_thresholds_flag AP_POL_HEADERS.DISTANCE_THRESHOLDS_FLAG%TYPE;
13071: l_debug_info VARCHAR2(200);
13072: l_cumulative_mileage AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE := nvl(p_cumulative_mileage,0);
13073: l_currency_preference AP_POL_HEADERS.CURRENCY_PREFERENCE%TYPE;
13074: bDistanceWithinRange BOOLEAN := FALSE;
13075: bDistanceThresholdCrossed BOOLEAN := FALSE;
13076: bFoundSingleRate BOOLEAN := FALSE;

Line 13078: l_orig_cum_mileage AP_WEB_EMPLOYEE_INFO.VALUE_TYPE%TYPE;

13074: bDistanceWithinRange BOOLEAN := FALSE;
13075: bDistanceThresholdCrossed BOOLEAN := FALSE;
13076: bFoundSingleRate BOOLEAN := FALSE;
13077: l_schedule_line_array AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array;
13078: l_orig_cum_mileage AP_WEB_EMPLOYEE_INFO.VALUE_TYPE%TYPE;
13079: i NUMBER := 1;
13080: j NUMBER := 1;
13081: l_ou_distance_field AP_POL_CAT_OPTIONS.DISTANCE_FIELD%TYPE;
13082: l_threshold_tolerance NUMBER := 0;

Line 13243: p_cumulative_mileage IN AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,

13239:
13240:
13241: -------------------------------------------------------------------------------
13242: PROCEDURE updateCumulativeMileage(
13243: p_cumulative_mileage IN AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
13244: p_period_id IN AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE,
13245: p_employee_id IN AP_WEB_EMPLOYEE_INFO.EMPLOYEE_ID%TYPE) IS
13246: -------------------------------------------------------------------------------
13247: l_count NUMBER := 0;

Line 13244: p_period_id IN AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE,

13240:
13241: -------------------------------------------------------------------------------
13242: PROCEDURE updateCumulativeMileage(
13243: p_cumulative_mileage IN AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
13244: p_period_id IN AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE,
13245: p_employee_id IN AP_WEB_EMPLOYEE_INFO.EMPLOYEE_ID%TYPE) IS
13246: -------------------------------------------------------------------------------
13247: l_count NUMBER := 0;
13248: BEGIN

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

13241: -------------------------------------------------------------------------------
13242: PROCEDURE updateCumulativeMileage(
13243: p_cumulative_mileage IN AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
13244: p_period_id IN AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE,
13245: p_employee_id IN AP_WEB_EMPLOYEE_INFO.EMPLOYEE_ID%TYPE) IS
13246: -------------------------------------------------------------------------------
13247: l_count NUMBER := 0;
13248: BEGIN
13249:

Line 13252: FROM ap_web_employee_info_all

13248: BEGIN
13249:
13250: SELECT count(*)
13251: INTO l_count
13252: FROM ap_web_employee_info_all
13253: WHERE value_type = 'CUM_REIMB_DISTANCE'
13254: AND period_id = p_period_id
13255: AND employee_id = p_employee_id;
13256:

Line 13258: UPDATE ap_web_employee_info_all

13254: AND period_id = p_period_id
13255: AND employee_id = p_employee_id;
13256:
13257: IF (l_count > 0 ) THEN
13258: UPDATE ap_web_employee_info_all
13259: SET numeric_value = p_cumulative_mileage,
13260: last_update_date = sysdate,
13261: last_updated_by = p_employee_id
13262: WHERE value_type = 'CUM_REIMB_DISTANCE'

Line 13266: INSERT INTO ap_web_employee_info_all

13262: WHERE value_type = 'CUM_REIMB_DISTANCE'
13263: AND period_id = p_period_id
13264: AND employee_id = p_employee_id;
13265: ELSE
13266: INSERT INTO ap_web_employee_info_all
13267: (EMPLOYEE_ID,
13268: VALUE_TYPE,
13269: NUMERIC_VALUE,
13270: PERIOD_ID,

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

13511: p_sh_distance_uom IN AP_POL_HEADERS.DISTANCE_UOM%TYPE,
13512: p_sh_currency_code IN AP_POL_HEADERS.CURRENCY_CODE%TYPE,
13513: p_schedule_line_array IN AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array,
13514: p_mileage_line_array_count IN OUT NOCOPY NUMBER,
13515: p_cumulative_mileage IN OUT NOCOPY AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
13516: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array)IS
13517: --------------------------------------------------------------------------------
13518: l_cumulative_mileage NUMBER := p_cumulative_mileage;
13519: l_ml_trip_distance NUMBER := p_mileage_line_array(p_ml_index).trip_distance;

Line 13760: l_cumulative_mileage AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE;

13756: l_ml_end_date DATE;
13757: l_ml_numberOfDays NUMBER;
13758: l_ml_distribution_line_number AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
13759: l_ml_policy_id AP_POL_HEADERS.policy_id%TYPE;
13760: l_cumulative_mileage AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE;
13761: l_period_id AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE;
13762: l_debug_info VARCHAR2(200);
13763: C_WF_VERSION NUMBER := 0;
13764: l_new_rate NUMBER := 0;

Line 13761: l_period_id AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE;

13757: l_ml_numberOfDays NUMBER;
13758: l_ml_distribution_line_number AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
13759: l_ml_policy_id AP_POL_HEADERS.policy_id%TYPE;
13760: l_cumulative_mileage AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE;
13761: l_period_id AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE;
13762: l_debug_info VARCHAR2(200);
13763: C_WF_VERSION NUMBER := 0;
13764: l_new_rate NUMBER := 0;
13765: l_ml_avg_mileage_rate AP_WEB_DB_EXPLINE_PKG.expLines_avg_mileage_rate;