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_POL_HEADERS

Line 12305: l_distance_uom AP_POL_HEADERS.DISTANCE_UOM%TYPE;

12301: l_start_expense_date AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
12302: l_end_expense_date AP_WEB_DB_EXPLINE_PKG.expLines_endExpDate;
12303: l_web_parameter_iD AP_WEB_DB_EXPLINE_PKG.expLines_webParamID;
12304: l_policy_id AP_EXPENSE_REPORT_PARAMS.COMPANY_POLICY_ID%TYPE;
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);

Line 12306: l_employee_role_flag AP_POL_HEADERS.EMPLOYEE_ROLE_FLAG%TYPE;

12302: l_end_expense_date AP_WEB_DB_EXPLINE_PKG.expLines_endExpDate;
12303: l_web_parameter_iD AP_WEB_DB_EXPLINE_PKG.expLines_webParamID;
12304: l_policy_id AP_EXPENSE_REPORT_PARAMS.COMPANY_POLICY_ID%TYPE;
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;

Line 12307: l_distance_thresholds_flag AP_POL_HEADERS.DISTANCE_THRESHOLDS_FLAG%TYPE;

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

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

Line 12351: AP_POL_HEADERS SH

12347: l_currency_preference
12348: FROM ap_expense_report_lines XL,
12349: AP_EXPENSE_REPORT_HEADERS XH,
12350: AP_EXPENSE_REPORT_PARAMS XP,
12351: AP_POL_HEADERS SH
12352: WHERE XH.report_header_id = p_report_header_id
12353: AND XH.report_header_id = XL.report_header_id
12354: AND XL.distribution_line_number = p_distribution_line_number
12355: AND (XP.WEB_ENABLED_FLAG = 'Y'

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

12357: AND XL.web_parameter_id = XP.parameter_id
12358: AND XP.company_policy_id = SH.policy_id;
12359:
12360: --------------------------------------------------
12361: l_debug_info := 'Retrieving info from the ap_pol_headers';
12362: --------------------------------------------------
12363: SELECT AH.DISTANCE_UOM,
12364: AH.DISTANCE_THRESHOLDS_FLAG,
12365: AH.EMPLOYEE_ROLE_FLAG

Line 12369: FROM AP_POL_HEADERS AH

12365: AH.EMPLOYEE_ROLE_FLAG
12366: INTO l_distance_uom,
12367: l_distance_thresholds_flag,
12368: l_employee_role_flag
12369: FROM AP_POL_HEADERS AH
12370: WHERE AH.POLICY_ID = l_policy_id;
12371:
12372: IF (l_distance_thresholds_flag is not null) THEN
12373: IF ((l_distance_uom = C_KILOMETERS) AND (l_distance_unit_code = C_MILES)) THEN

Line 12533: p_sh_distance_uom IN AP_POL_HEADERS.distance_uom%TYPE,

12529: END getAddonMileageRatesSum;
12530:
12531: -------------------------------------------------------------------------------
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

Line 12534: p_sh_currency_code IN AP_POL_HEADERS.currency_code%TYPE,

12530:
12531: -------------------------------------------------------------------------------
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: -------------------------------------------------------------------------------

Line 12724: p_sh_distance_uom IN AP_POL_HEADERS.DISTANCE_UOM%TYPE,

12720:
12721: --------------------------------------------------------------------------------
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,

Line 12725: p_sh_currency_code IN AP_POL_HEADERS.CURRENCY_CODE%TYPE,

12721: --------------------------------------------------------------------------------
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

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

12884:
12885: l_daily_distance := l_updated_trip_dist / p_mileage_line_array(p_ml_index).number_of_days;
12886:
12887: /* The rate from the schedule line array is the rate stored in
12888: ap_pol_headers. The unit of measure will be according to
12889: ap_pol_headers. However, when calculating the rate for the
12890: lines, we need to get convert the rate according to the UOM
12891: in ap_expense_report_lines. -Akita */
12892: l_new_rate := getRate(

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

12885: l_daily_distance := l_updated_trip_dist / p_mileage_line_array(p_ml_index).number_of_days;
12886:
12887: /* The rate from the schedule line array is the rate stored in
12888: ap_pol_headers. The unit of measure will be according to
12889: ap_pol_headers. However, when calculating the rate for the
12890: lines, we need to get convert the rate according to the UOM
12891: in ap_expense_report_lines. -Akita */
12892: l_new_rate := getRate(
12893: p_sh_distance_uom => p_sh_distance_uom,

Line 12971: l_ml_policy_id AP_POL_HEADERS.policy_id%TYPE;

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

Line 12984: l_sh_distance_uom AP_POL_HEADERS.distance_uom%TYPE;

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;
12987: l_lines_created NUMBER := 0;
12988: l_temp_mileage_line_array AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array;

Line 12985: l_sh_currency_code AP_POL_HEADERS.currency_code%TYPE;

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;
12987: l_lines_created NUMBER := 0;
12988: l_temp_mileage_line_array AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array;
12989: l_mileage_line_array AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array;