[Home] [Help]
1: PACKAGE BODY AP_WEB_POLICY_UTILS AS
2: /* $Header: apwpolub.pls 120.62.12010000.4 2008/11/11 12:40:57 sodash ship $ */
3:
4: -- Max Length for Policy Schedule Name and Policy Schedule Period Name
5: C_PolicyNameMaxLength CONSTANT NUMBER := 60;
2008: vc.OPTION_CODE AS NEW_VEHICLE_CATEGORY,
2009: decode(vc.OPTION_CODE, null, vt.OPTION_CODE, decode(vc.VEHICLE_TYPE_CODE, ''R'', vt.OPTION_CODE, null)) AS NEW_VEHICLE_TYPE,
2010: decode(vc.OPTION_CODE, null, ft.OPTION_CODE, decode(vc.FUEL_TYPE_CODE, ''R'', ft.OPTION_CODE, null)) AS NEW_FUEL_TYPE,
2011: dt.THRESHOLD AS NEW_RANGE_LOW,
2012: ap_web_policy_UTILS.getHighEndOfThreshold(:p_policy_id, dt.THRESHOLD) AS NEW_RANGE_HIGH,
2013: :p_rate_type AS NEW_RATE_TYPE_CODE
2014: from
2015: '
2016: from sys.dual; /* l_insert_cursor */
2878: or
2879: (pl.RANGE_LOW is not null
2880: and
2881: nvl(pl.RANGE_HIGH, :dummy_number) <>
2882: nvl(AP_WEB_POLICY_UTILS.getHighEndOfThreshold(pl.POLICY_ID,
2883: pl.RANGE_LOW,
2884: nvl(pl.rate_type_code,''STANDARD'')), :dummy_number)
2885: )
2886: '
5011: l.LOCATION_ID AS NEW_LOCATION_ID,
5012: r.ROLE_ID AS NEW_ROLE_ID,
5013: c.CURRENCY_CODE AS NEW_CURRENCY_CODE,
5014: dt.THRESHOLD AS NEW_RANGE_LOW,
5015: ap_web_policy_UTILS.getHighEndOfThreshold(:p_policy_id, dt.THRESHOLD, :p_rate_type) AS NEW_RANGE_HIGH,
5016: :p_rate_type AS NEW_RATE_TYPE_CODE
5017: from
5018: '
5019: from sys.dual; /* l_insert_cursor */
6258: )
6259: )
6260: -- ACC Seasonality condition.
6261: AND (h.category_code <> 'ACCOMMODATIONS' OR l.start_of_season IS NULL OR l.end_of_season IS NULL OR
6262: 'Y' = AP_WEB_POLICY_UTILS.isDateInSeason(p_expense_date, l.start_of_season, l.end_of_season))
6263: AND l.parent_line_id is null -- Bug: 6866388, Too Many rows fetched
6264: AND p_expense_date between nvl(l.effective_start_date, p_expense_date) and nvl(l.effective_end_date, p_expense_date+1); -- 6994883
6265:
6266: return l_policy_line_id;
6400:
6401: END activatePolicyLines;
6402:
6403:
6404: END AP_WEB_POLICY_UTILS;