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_POLICY_UTILS dependencies on DUAL

Line 682: FROM dual

678: FUNCTION location_translation_complete(p_language_code IN VARCHAR2) RETURN VARCHAR2 IS
679:
680: CURSOR locations_defined_cur IS
681: SELECT 'Y'
682: FROM dual
683: WHERE exists (select 'x' from ap_pol_locations_b);
684: l_locations_defined VARCHAR2(1);
685:
686: CURSOR missing_translations_cur IS

Line 1769: l_vc_stmt VARCHAR2(80) := 'union all select to_char(null), to_char(null), to_char(null) from sys.dual';

1765: l_currency_preference ap_pol_headers.currency_preference%TYPE;
1766:
1767: l_src_stmt VARCHAR2(160) := 'union all select CURRENCY_CODE from ap_pol_headers where POLICY_ID = :p_policy_id';
1768:
1769: l_vc_stmt VARCHAR2(80) := 'union all select to_char(null), to_char(null), to_char(null) from sys.dual';
1770: l_number_stmt VARCHAR2(80) := 'union all select to_number(null) from sys.dual';
1771: l_varchar2_stmt VARCHAR2(80) := 'union all select to_char(null) from sys.dual';
1772:
1773: BEGIN

Line 1770: l_number_stmt VARCHAR2(80) := 'union all select to_number(null) from sys.dual';

1766:
1767: l_src_stmt VARCHAR2(160) := 'union all select CURRENCY_CODE from ap_pol_headers where POLICY_ID = :p_policy_id';
1768:
1769: l_vc_stmt VARCHAR2(80) := 'union all select to_char(null), to_char(null), to_char(null) from sys.dual';
1770: l_number_stmt VARCHAR2(80) := 'union all select to_number(null) from sys.dual';
1771: l_varchar2_stmt VARCHAR2(80) := 'union all select to_char(null) from sys.dual';
1772:
1773: BEGIN
1774:

Line 1771: l_varchar2_stmt VARCHAR2(80) := 'union all select to_char(null) from sys.dual';

1767: l_src_stmt VARCHAR2(160) := 'union all select CURRENCY_CODE from ap_pol_headers where POLICY_ID = :p_policy_id';
1768:
1769: l_vc_stmt VARCHAR2(80) := 'union all select to_char(null), to_char(null), to_char(null) from sys.dual';
1770: l_number_stmt VARCHAR2(80) := 'union all select to_number(null) from sys.dual';
1771: l_varchar2_stmt VARCHAR2(80) := 'union all select to_char(null) from sys.dual';
1772:
1773: BEGIN
1774:
1775: select currency_preference

Line 2016: from sys.dual; /* l_insert_cursor */

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 */
2017:
2018: ---------------------------------------
2019: -- cursor for all locations to use
2020: ---------------------------------------

Line 2034: from sys.dual; /* l_l_cursor */

2030: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2031: '||l_location_enabled||'
2032: ) l,
2033: '
2034: from sys.dual; /* l_l_cursor */
2035:
2036: ---------------------------------------
2037: -- cursor for all roles to use
2038: ---------------------------------------

Line 2052: from sys.dual; /* l_r_cursor */

2048: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2049: '||l_role_enabled||'
2050: ) r,
2051: '
2052: from sys.dual; /* l_r_cursor */
2053:
2054: ---------------------------------------
2055: -- cursor for all currency codes to use
2056: ---------------------------------------

Line 2070: from sys.dual; /* l_c_cursor */

2066: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2067: '||l_currency_enabled||'
2068: ) c,
2069: '
2070: from sys.dual; /* l_c_cursor */
2071:
2072: ---------------------------------------
2073: -- cursor for all vehicle categories to use
2074: ---------------------------------------

Line 2088: from sys.dual; /* l_vc_cursor */

2084: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2085: '||l_vehicle_category_enabled||'
2086: ) vc,
2087: '
2088: from sys.dual; /* l_vc_cursor */
2089:
2090: ---------------------------------------
2091: -- cursor for all vehicle types to use
2092: ---------------------------------------

Line 2106: from sys.dual; /* l_vt_cursor */

2102: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2103: '||l_vehicle_type_enabled||'
2104: ) vt,
2105: '
2106: from sys.dual; /* l_vt_cursor */
2107:
2108: ---------------------------------------
2109: -- cursor for all fuel types to use
2110: ---------------------------------------

Line 2124: from sys.dual; /* l_ft_cursor */

2120: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2121: '||l_fuel_type_enabled||'
2122: ) ft,
2123: '
2124: from sys.dual; /* l_ft_cursor */
2125:
2126: ---------------------------------------
2127: -- cursor for all thresholds to use
2128: ---------------------------------------

Line 2143: from sys.dual; /* l_dt_cursor */

2139: and nvl(rate_type_code, ''NULL'') = nvl(:p_rate_type, ''NULL'')
2140: '||l_thresholds_enabled||'
2141: ) dt
2142: '
2143: from sys.dual; /* l_dt_cursor */
2144:
2145:
2146: ---------------------------------------
2147: -- cursor for where rows

Line 2166: from sys.dual; /* l_where_cursor */

2162: or NEW_RANGE_HIGH is not null
2163: )
2164: )
2165: '
2166: from sys.dual; /* l_where_cursor */
2167:
2168:
2169: ---------------------------------------
2170: -- cursor for adding new rules/options

Line 2211: from sys.dual; /* l_not_exists_cursor */

2207: and nvl(epl.RATE_TYPE_CODE, :dummy_varchar2) = nvl(NEW_RATE_TYPE_CODE, :dummy_varchar2)
2208: )
2209: )
2210: '
2211: from sys.dual; /* l_not_exists_cursor */
2212:
2213:
2214:
2215:

Line 2265: FROM DUAL;

2261: IF ( l_zero_threshold_count = 0 ) THEN
2262: BEGIN
2263: SELECT ap_pol_schedule_options_s.NEXTVAL
2264: INTO l_schedule_option_rec.schedule_option_id
2265: FROM DUAL;
2266:
2267: INSERT INTO ap_pol_schedule_options
2268: (
2269: policy_id,

Line 2337: FROM DUAL;

2333: IF ( l_zero_threshold_count = 0 ) THEN
2334: BEGIN
2335: SELECT ap_pol_schedule_options_s.NEXTVAL
2336: INTO l_schedule_option_rec.schedule_option_id
2337: FROM DUAL;
2338:
2339: INSERT INTO ap_pol_schedule_options
2340: (
2341: policy_id,

Line 2650: from sys.dual; /* l_l_cursor */

2646: and pso.LOCATION_ID is not null
2647: )
2648: )
2649: '
2650: from sys.dual; /* l_l_cursor */
2651:
2652: cursor l_r_cursor is
2653: select
2654: '

Line 2677: from sys.dual; /* l_r_cursor */

2673: and pso.ROLE_ID is not null
2674: )
2675: )
2676: '
2677: from sys.dual; /* l_r_cursor */
2678:
2679: cursor l_c_cursor is
2680: select
2681: '

Line 2723: from sys.dual; /* l_c_cursor */

2719: and ph.CURRENCY_CODE = pl.CURRENCY_CODE
2720: )
2721: )
2722: '
2723: from sys.dual; /* l_c_cursor */
2724:
2725: cursor l_vc_cursor is
2726: select
2727: '

Line 2750: from sys.dual; /* l_vc_cursor */

2746: and pso.OPTION_CODE is not null
2747: )
2748: )
2749: '
2750: from sys.dual; /* l_vc_cursor */
2751:
2752: cursor l_vt_cursor is
2753: select
2754: '

Line 2794: from sys.dual; /* l_vt_cursor */

2790: and pso.VEHICLE_TYPE_CODE <> ''R''
2791: )
2792: )
2793: '
2794: from sys.dual; /* l_vt_cursor */
2795:
2796: cursor l_ft_cursor is
2797: select
2798: '

Line 2838: from sys.dual; /* l_ft_cursor */

2834: and pso.FUEL_TYPE_CODE <> ''R''
2835: )
2836: )
2837: '
2838: from sys.dual; /* l_ft_cursor */
2839:
2840: cursor l_dt_cursor is
2841: select
2842: '

Line 2887: from sys.dual; /* l_dt_cursor */

2883: pl.RANGE_LOW,
2884: nvl(pl.rate_type_code,''STANDARD'')), :dummy_number)
2885: )
2886: '
2887: from sys.dual; /* l_dt_cursor */
2888:
2889: ---------------------------------------
2890: -- cursor for addon mileage rates
2891: -- Note: we do not need to remove any addon rate lines

Line 2911: from sys.dual; /* l_amr_cursor */

2907: )
2908:
2909: )
2910: '
2911: from sys.dual; /* l_amr_cursor */
2912:
2913:
2914: BEGIN
2915:

Line 3120: from sys.dual; /* l_inactive_cursor */

3116: )
3117: )
3118: )
3119: '
3120: from sys.dual; /* l_inactive_cursor */
3121:
3122:
3123: cursor l_active_cursor is
3124: select

Line 3232: from sys.dual; /* l_active_cursor */

3228: ) or pl.RANGE_LOW is null
3229: )
3230: )
3231: '
3232: from sys.dual; /* l_active_cursor */
3233:
3234: BEGIN
3235:
3236: --------------------------------------------------------------

Line 3472: from sys.dual; /* l_duplicate_cursor */

3468: where POLICY_ID = :p_from_policy_id
3469: and SCHEDULE_PERIOD_ID = :p_from_schedule_period_id
3470: and PARENT_LINE_ID is null
3471: '
3472: from sys.dual; /* l_duplicate_cursor */
3473:
3474:
3475: BEGIN
3476:

Line 3815: from sys.dual;

3811: BEGIN
3812:
3813: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL
3814: into l_schedule_period_id
3815: from sys.dual;
3816:
3817: insert into AP_POL_SCHEDULE_PERIODS
3818: (
3819: SCHEDULE_PERIOD_ID,

Line 3858: sys.dual;

3854: p_user_id AS CREATED_BY,
3855: sysdate AS LAST_UPDATE_DATE,
3856: p_user_id AS LAST_UPDATED_BY
3857: from
3858: sys.dual;
3859:
3860: return l_schedule_period_id;
3861:
3862: EXCEPTION

Line 3902: from sys.dual;

3898: '2_DECIMALS', nvl(p_value, 0) + ROUND(nvl(p_value, 0) * (p_update_by/100), 2),
3899: '3_DECIMALS', nvl(p_value, 0) + ROUND(nvl(p_value, 0) * (p_update_by/100), 3),
3900: nvl(p_value, 0) + ROUND(nvl(p_value, 0) * (p_update_by/100)))
3901: into l_new_value
3902: from sys.dual;
3903:
3904: if (p_rounding_rule = c_NEAREST_FIVE) then
3905: if (mod(l_new_value, 5) >= 2.5) then
3906: l_new_value := l_new_value - mod(l_new_value, 5) + 5;

Line 4009: from sys.dual;

4005: BEGIN
4006:
4007: select AP_POL_HEADERS_S.NEXTVAL
4008: into p_to_policy_id
4009: from sys.dual;
4010:
4011:
4012: insert into AP_POL_HEADERS
4013: (

Line 4407: from dual

4403: FUNCTION does_location_exist RETURN VARCHAR2 IS
4404:
4405: CURSOR location_cur IS
4406: select 1 location_count
4407: from dual
4408: where exists
4409: (select 1
4410: from ap_pol_locations_b);
4411:

Line 4543: FROM dual

4539: IF p_policy_id IS NOT NULL AND
4540: p_end_date IS NOT NULL THEN
4541:
4542: SELECT 1 INTO l_count_rows
4543: FROM dual
4544: WHERE exists
4545: (select 1
4546: from ap_expense_report_params_all
4547: where company_policy_id = p_policy_id and nvl(end_date,p_end_date+1) > p_end_date);

Line 5019: from sys.dual; /* l_insert_cursor */

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 */
5020:
5021: ---------------------------------------
5022: -- cursor for all locations to use
5023: ---------------------------------------

Line 5037: from sys.dual; /* l_l_cursor */

5033: and nvl(END_DATE, SYSDATE+1) > SYSDATE
5034: '||l_location_enabled||'
5035: ) l,
5036: '
5037: from sys.dual; /* l_l_cursor */
5038:
5039: ---------------------------------------
5040: -- cursor for all roles to use
5041: ---------------------------------------

Line 5055: from sys.dual; /* l_r_cursor */

5051: and nvl(END_DATE, SYSDATE+1) > SYSDATE
5052: '||l_role_enabled||'
5053: ) r,
5054: '
5055: from sys.dual; /* l_r_cursor */
5056:
5057: ---------------------------------------
5058: -- cursor for all currency codes to use
5059: ---------------------------------------

Line 5073: from sys.dual; /* l_c_cursor */

5069: and nvl(END_DATE, SYSDATE+1) > SYSDATE
5070: '||l_currency_enabled||'
5071: ) c,
5072: '
5073: from sys.dual; /* l_c_cursor */
5074:
5075: ---------------------------------------
5076: -- cursor for all thresholds to use
5077: ---------------------------------------

Line 5092: from sys.dual; /* l_dt_cursor */

5088: and nvl(rate_type_code, :p_rate_type) = :p_rate_type
5089: '||l_thresholds_enabled||'
5090: ) dt
5091: '
5092: from sys.dual; /* l_dt_cursor */
5093:
5094: ---------------------------------------
5095: -- cursor for where rows
5096: ---------------------------------------

Line 5111: from sys.dual; /* l_where_cursor */

5107: or NEW_RANGE_HIGH is not null
5108: )
5109: )
5110: '
5111: from sys.dual; /* l_where_cursor */
5112:
5113:
5114: ---------------------------------------
5115: -- cursor for adding new rules/options

Line 5150: from sys.dual; /* l_not_exists_cursor */

5146: and nvl(epl.RATE_TYPE_CODE, :dummy_varchar2) = nvl(NEW_RATE_TYPE_CODE, :dummy_varchar2)
5147: )
5148: )
5149: '
5150: from sys.dual; /* l_not_exists_cursor */
5151:
5152:
5153: BEGIN
5154: