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.

[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on AP_POL_HEADERS

Line 13068: l_distance_uom AP_POL_HEADERS.DISTANCE_UOM%TYPE;

13064: l_start_expense_date AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
13065: l_end_expense_date AP_WEB_DB_EXPLINE_PKG.expLines_endExpDate;
13066: l_web_parameter_iD AP_WEB_DB_EXPLINE_PKG.expLines_webParamID;
13067: l_policy_id AP_EXPENSE_REPORT_PARAMS.COMPANY_POLICY_ID%TYPE;
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);

Line 13069: l_employee_role_flag AP_POL_HEADERS.EMPLOYEE_ROLE_FLAG%TYPE;

13065: l_end_expense_date AP_WEB_DB_EXPLINE_PKG.expLines_endExpDate;
13066: l_web_parameter_iD AP_WEB_DB_EXPLINE_PKG.expLines_webParamID;
13067: l_policy_id AP_EXPENSE_REPORT_PARAMS.COMPANY_POLICY_ID%TYPE;
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;

Line 13070: l_distance_thresholds_flag AP_POL_HEADERS.DISTANCE_THRESHOLDS_FLAG%TYPE;

13066: l_web_parameter_iD AP_WEB_DB_EXPLINE_PKG.expLines_webParamID;
13067: l_policy_id AP_EXPENSE_REPORT_PARAMS.COMPANY_POLICY_ID%TYPE;
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;

Line 13073: l_currency_preference AP_POL_HEADERS.CURRENCY_PREFERENCE%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;
13077: l_schedule_line_array AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array;

Line 13116: AP_POL_HEADERS SH

13112: l_currency_preference
13113: FROM ap_expense_report_lines XL,
13114: AP_EXPENSE_REPORT_HEADERS XH,
13115: AP_EXPENSE_REPORT_PARAMS XP,
13116: AP_POL_HEADERS SH
13117: WHERE XH.report_header_id = p_report_header_id
13118: AND XH.report_header_id = XL.report_header_id
13119: AND XL.distribution_line_number = p_distribution_line_number
13120: AND (XP.WEB_ENABLED_FLAG = 'Y'

Line 13126: l_debug_info := 'Retrieving info from the ap_pol_headers';

13122: AND XL.web_parameter_id = XP.parameter_id
13123: AND XP.company_policy_id = SH.policy_id;
13124:
13125: --------------------------------------------------
13126: l_debug_info := 'Retrieving info from the ap_pol_headers';
13127: --------------------------------------------------
13128: SELECT AH.DISTANCE_UOM,
13129: AH.DISTANCE_THRESHOLDS_FLAG,
13130: AH.EMPLOYEE_ROLE_FLAG

Line 13134: FROM AP_POL_HEADERS AH

13130: AH.EMPLOYEE_ROLE_FLAG
13131: INTO l_distance_uom,
13132: l_distance_thresholds_flag,
13133: l_employee_role_flag
13134: FROM AP_POL_HEADERS AH
13135: WHERE AH.POLICY_ID = l_policy_id;
13136:
13137: IF (l_distance_thresholds_flag is not null) THEN
13138: IF ((l_distance_uom = C_KILOMETERS) AND (l_distance_unit_code = C_MILES)) THEN

Line 13315: p_sh_distance_uom IN AP_POL_HEADERS.distance_uom%TYPE,

13311: END getAddonMileageRatesSum;
13312:
13313: -------------------------------------------------------------------------------
13314: FUNCTION getRate(
13315: p_sh_distance_uom IN AP_POL_HEADERS.distance_uom%TYPE,
13316: p_sh_currency_code IN AP_POL_HEADERS.currency_code%TYPE,
13317: p_mileage_line IN AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Rec,
13318: p_schedule_line IN AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Rec)
13319: RETURN NUMBER IS

Line 13316: p_sh_currency_code IN AP_POL_HEADERS.currency_code%TYPE,

13312:
13313: -------------------------------------------------------------------------------
13314: FUNCTION getRate(
13315: p_sh_distance_uom IN AP_POL_HEADERS.distance_uom%TYPE,
13316: p_sh_currency_code IN AP_POL_HEADERS.currency_code%TYPE,
13317: p_mileage_line IN AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Rec,
13318: p_schedule_line IN AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Rec)
13319: RETURN NUMBER IS
13320: -------------------------------------------------------------------------------

Line 13511: p_sh_distance_uom IN AP_POL_HEADERS.DISTANCE_UOM%TYPE,

13507:
13508: --------------------------------------------------------------------------------
13509: PROCEDURE processCrossThreshold(
13510: p_ml_index IN NUMBER,
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,

Line 13512: p_sh_currency_code IN AP_POL_HEADERS.CURRENCY_CODE%TYPE,

13508: --------------------------------------------------------------------------------
13509: PROCEDURE processCrossThreshold(
13510: p_ml_index IN NUMBER,
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

Line 13696: ap_pol_headers. The unit of measure will be according to

13692:
13693: l_daily_distance := l_updated_trip_dist / p_mileage_line_array(p_ml_index).number_of_days;
13694:
13695: /* The rate from the schedule line array is the rate stored in
13696: ap_pol_headers. The unit of measure will be according to
13697: ap_pol_headers. However, when calculating the rate for the
13698: lines, we need to get convert the rate according to the UOM
13699: in ap_expense_report_lines. -Akita */
13700: l_new_rate := getRate(

Line 13697: ap_pol_headers. However, when calculating the rate for the

13693: l_daily_distance := l_updated_trip_dist / p_mileage_line_array(p_ml_index).number_of_days;
13694:
13695: /* The rate from the schedule line array is the rate stored in
13696: ap_pol_headers. The unit of measure will be according to
13697: ap_pol_headers. However, when calculating the rate for the
13698: lines, we need to get convert the rate according to the UOM
13699: in ap_expense_report_lines. -Akita */
13700: l_new_rate := getRate(
13701: p_sh_distance_uom => p_sh_distance_uom,

Line 13759: l_ml_policy_id AP_POL_HEADERS.policy_id%TYPE;

13755: l_ml_start_date DATE;
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;

Line 13772: l_sh_distance_uom AP_POL_HEADERS.distance_uom%TYPE;

13768: c_expense_lines_cursor AP_WEB_DB_EXPLINE_PKG.ExpLinesCursor;
13769: l_employee_id NUMBER;
13770: l_schedule_line_array AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array;
13771: l_temp NUMBER;
13772: l_sh_distance_uom AP_POL_HEADERS.distance_uom%TYPE;
13773: l_sh_currency_code AP_POL_HEADERS.currency_code%TYPE;
13774: l_index NUMBER := 0;
13775: l_lines_created NUMBER := 0;
13776: l_temp_mileage_line_array AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array;

Line 13773: l_sh_currency_code AP_POL_HEADERS.currency_code%TYPE;

13769: l_employee_id NUMBER;
13770: l_schedule_line_array AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array;
13771: l_temp NUMBER;
13772: l_sh_distance_uom AP_POL_HEADERS.distance_uom%TYPE;
13773: l_sh_currency_code AP_POL_HEADERS.currency_code%TYPE;
13774: l_index NUMBER := 0;
13775: l_lines_created NUMBER := 0;
13776: l_temp_mileage_line_array AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array;
13777: l_mileage_line_array AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array;