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 693: FROM dual

689: FUNCTION location_translation_complete(p_language_code IN VARCHAR2) RETURN VARCHAR2 IS
690:
691: CURSOR locations_defined_cur IS
692: SELECT 'Y'
693: FROM dual
694: WHERE exists (select 'x' from ap_pol_locations_b);
695: l_locations_defined VARCHAR2(1);
696:
697: CURSOR missing_translations_cur IS

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

1821: l_currency_preference ap_pol_headers.currency_preference%TYPE;
1822:
1823: l_src_stmt VARCHAR2(160) := 'union all select CURRENCY_CODE from ap_pol_headers where POLICY_ID = :p_policy_id';
1824:
1825: l_vc_stmt VARCHAR2(80) := 'union all select to_char(null), to_char(null), to_char(null) from sys.dual';
1826: l_number_stmt VARCHAR2(80) := 'union all select to_number(null) from sys.dual';
1827: l_number2_stmt VARCHAR2(80) := 'union all select to_number(null), to_number(null) from sys.dual';
1828: l_varchar2_stmt VARCHAR2(80) := 'union all select to_char(null) from sys.dual';
1829:

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

1822:
1823: l_src_stmt VARCHAR2(160) := 'union all select CURRENCY_CODE from ap_pol_headers where POLICY_ID = :p_policy_id';
1824:
1825: l_vc_stmt VARCHAR2(80) := 'union all select to_char(null), to_char(null), to_char(null) from sys.dual';
1826: l_number_stmt VARCHAR2(80) := 'union all select to_number(null) from sys.dual';
1827: l_number2_stmt VARCHAR2(80) := 'union all select to_number(null), to_number(null) from sys.dual';
1828: l_varchar2_stmt VARCHAR2(80) := 'union all select to_char(null) from sys.dual';
1829:
1830: BEGIN

Line 1827: l_number2_stmt VARCHAR2(80) := 'union all select to_number(null), to_number(null) from sys.dual';

1823: l_src_stmt VARCHAR2(160) := 'union all select CURRENCY_CODE from ap_pol_headers where POLICY_ID = :p_policy_id';
1824:
1825: l_vc_stmt VARCHAR2(80) := 'union all select to_char(null), to_char(null), to_char(null) from sys.dual';
1826: l_number_stmt VARCHAR2(80) := 'union all select to_number(null) from sys.dual';
1827: l_number2_stmt VARCHAR2(80) := 'union all select to_number(null), to_number(null) from sys.dual';
1828: l_varchar2_stmt VARCHAR2(80) := 'union all select to_char(null) from sys.dual';
1829:
1830: BEGIN
1831:

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

1824:
1825: l_vc_stmt VARCHAR2(80) := 'union all select to_char(null), to_char(null), to_char(null) from sys.dual';
1826: l_number_stmt VARCHAR2(80) := 'union all select to_number(null) from sys.dual';
1827: l_number2_stmt VARCHAR2(80) := 'union all select to_number(null), to_number(null) from sys.dual';
1828: l_varchar2_stmt VARCHAR2(80) := 'union all select to_char(null) from sys.dual';
1829:
1830: BEGIN
1831:
1832: select currency_preference

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

2071: dt.RANGE_HIGH AS NEW_RANGE_HIGH,
2072: :p_rate_type AS NEW_RATE_TYPE_CODE
2073: from
2074: '
2075: from sys.dual; /* l_insert_cursor */
2076:
2077: ---------------------------------------
2078: -- cursor for all locations to use
2079: ---------------------------------------

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

2089: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2090: '||l_location_enabled||'
2091: ) l,
2092: '
2093: from sys.dual; /* l_l_cursor */
2094:
2095: ---------------------------------------
2096: -- cursor for all roles to use
2097: ---------------------------------------

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

2107: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2108: '||l_role_enabled||'
2109: ) r,
2110: '
2111: from sys.dual; /* l_r_cursor */
2112:
2113: ---------------------------------------
2114: -- cursor for all currency codes to use
2115: ---------------------------------------

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

2125: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2126: '||l_currency_enabled||'
2127: ) c,
2128: '
2129: from sys.dual; /* l_c_cursor */
2130:
2131: ---------------------------------------
2132: -- cursor for all vehicle categories to use
2133: ---------------------------------------

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

2143: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2144: '||l_vehicle_category_enabled||'
2145: ) vc,
2146: '
2147: from sys.dual; /* l_vc_cursor */
2148:
2149: ---------------------------------------
2150: -- cursor for all vehicle types to use
2151: ---------------------------------------

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

2161: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2162: '||l_vehicle_type_enabled||'
2163: ) vt,
2164: '
2165: from sys.dual; /* l_vt_cursor */
2166:
2167: ---------------------------------------
2168: -- cursor for all fuel types to use
2169: ---------------------------------------

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

2179: and nvl(END_DATE, SYSDATE+1) > SYSDATE
2180: '||l_fuel_type_enabled||'
2181: ) ft,
2182: '
2183: from sys.dual; /* l_ft_cursor */
2184:
2185: ---------------------------------------
2186: -- cursor for all thresholds to use
2187: ---------------------------------------

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

2199: and nvl(rate_type_code, ''NULL'') = nvl(:p_rate_type, ''NULL'')
2200: '||l_thresholds_enabled||'
2201: ) dt
2202: '
2203: from sys.dual; /* l_dt_cursor */
2204:
2205:
2206: ---------------------------------------
2207: -- cursor for where rows

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

2222: or NEW_RANGE_HIGH is not null
2223: )
2224: )
2225: '
2226: from sys.dual; /* l_where_cursor */
2227:
2228:
2229: ---------------------------------------
2230: -- cursor for adding new rules/options

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

2256: and nvl(epl.RATE_TYPE_CODE, :dummy_varchar2) = nvl(NEW_RATE_TYPE_CODE, :dummy_varchar2)
2257: )
2258: )
2259: '
2260: from sys.dual; /* l_not_exists_cursor */
2261:
2262:
2263:
2264:

Line 2314: FROM DUAL;

2310: IF ( l_zero_threshold_count = 0 ) THEN
2311: BEGIN
2312: SELECT ap_pol_schedule_options_s.NEXTVAL
2313: INTO l_schedule_option_rec.schedule_option_id
2314: FROM DUAL;
2315:
2316: INSERT INTO ap_pol_schedule_options
2317: (
2318: policy_id,

Line 2386: FROM DUAL;

2382: IF ( l_zero_threshold_count = 0 ) THEN
2383: BEGIN
2384: SELECT ap_pol_schedule_options_s.NEXTVAL
2385: INTO l_schedule_option_rec.schedule_option_id
2386: FROM DUAL;
2387:
2388: INSERT INTO ap_pol_schedule_options
2389: (
2390: policy_id,

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

2694: and pso.LOCATION_ID is not null
2695: )
2696: )
2697: '
2698: from sys.dual; /* l_l_cursor */
2699:
2700: cursor l_r_cursor is
2701: select
2702: '

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

2721: and pso.ROLE_ID is not null
2722: )
2723: )
2724: '
2725: from sys.dual; /* l_r_cursor */
2726:
2727: cursor l_c_cursor is
2728: select
2729: '

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

2767: and ph.CURRENCY_CODE = pl.CURRENCY_CODE
2768: )
2769: )
2770: '
2771: from sys.dual; /* l_c_cursor */
2772:
2773: cursor l_vc_cursor is
2774: select
2775: '

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

2794: and pso.OPTION_CODE is not null
2795: )
2796: )
2797: '
2798: from sys.dual; /* l_vc_cursor */
2799:
2800: cursor l_vt_cursor is
2801: select
2802: '

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

2838: and pso.VEHICLE_TYPE_CODE <> ''R''
2839: )
2840: )
2841: '
2842: from sys.dual; /* l_vt_cursor */
2843:
2844: cursor l_ft_cursor is
2845: select
2846: '

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

2882: and pso.FUEL_TYPE_CODE <> ''R''
2883: )
2884: )
2885: '
2886: from sys.dual; /* l_ft_cursor */
2887:
2888: cursor l_dt_cursor is
2889: select
2890: '

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

2931: pl.RANGE_LOW,
2932: nvl(pl.rate_type_code,''STANDARD'')), :dummy_number)
2933: )
2934: '
2935: from sys.dual; /* l_dt_cursor */
2936:
2937: ---------------------------------------
2938: -- cursor for addon mileage rates
2939: -- Note: we do not need to remove any addon rate lines

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

2955: )
2956:
2957: )
2958: '
2959: from sys.dual; /* l_amr_cursor */
2960:
2961:
2962: BEGIN
2963:

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

3164: )
3165: )
3166: )
3167: '
3168: from sys.dual; /* l_inactive_cursor */
3169:
3170:
3171: cursor l_active_cursor is
3172: select

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

3276: ) or pl.RANGE_LOW is null
3277: )
3278: )
3279: '
3280: from sys.dual; /* l_active_cursor */
3281:
3282: BEGIN
3283:
3284: --------------------------------------------------------------

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

3520: where POLICY_ID = :p_from_policy_id
3521: and SCHEDULE_PERIOD_ID = :p_from_schedule_period_id
3522: and PARENT_LINE_ID is null
3523: '
3524: from sys.dual; /* l_duplicate_cursor */
3525:
3526:
3527: BEGIN
3528:

Line 3876: from sys.dual;

3872: BEGIN
3873:
3874: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL
3875: into l_schedule_period_id
3876: from sys.dual;
3877:
3878: insert into AP_POL_SCHEDULE_PERIODS
3879: (
3880: SCHEDULE_PERIOD_ID,

Line 3921: sys.dual;

3917: sysdate AS LAST_UPDATE_DATE,
3918: p_user_id AS LAST_UPDATED_BY,
3919: p_reimbursement_percentage AS REIMBURSEMENT_PERCENTAGE
3920: from
3921: sys.dual;
3922:
3923: return l_schedule_period_id;
3924:
3925: EXCEPTION

Line 3965: from sys.dual;

3961: '2_DECIMALS', nvl(p_value, 0) + ROUND(nvl(p_value, 0) * (p_update_by/100), 2),
3962: '3_DECIMALS', nvl(p_value, 0) + ROUND(nvl(p_value, 0) * (p_update_by/100), 3),
3963: nvl(p_value, 0) + ROUND(nvl(p_value, 0) * (p_update_by/100)))
3964: into l_new_value
3965: from sys.dual;
3966:
3967: if (p_rounding_rule = c_NEAREST_FIVE) then
3968: if (mod(l_new_value, 5) >= 2.5) then
3969: l_new_value := l_new_value - mod(l_new_value, 5) + 5;

Line 4074: from sys.dual;

4070: BEGIN
4071:
4072: select AP_POL_HEADERS_S.NEXTVAL
4073: into p_to_policy_id
4074: from sys.dual;
4075:
4076:
4077: insert into AP_POL_HEADERS
4078: (

Line 4478: from dual

4474: FUNCTION does_location_exist RETURN VARCHAR2 IS
4475:
4476: CURSOR location_cur IS
4477: select 1 location_count
4478: from dual
4479: where exists
4480: (select 1
4481: from ap_pol_locations_b);
4482:

Line 4614: FROM dual

4610: IF p_policy_id IS NOT NULL AND
4611: p_end_date IS NOT NULL THEN
4612:
4613: SELECT 1 INTO l_count_rows
4614: FROM dual
4615: WHERE exists
4616: (select 1
4617: from ap_expense_report_params_all
4618: where company_policy_id = p_policy_id and nvl(end_date,p_end_date+1) > p_end_date);

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

5086: dt.RANGE_HIGH AS NEW_RANGE_HIGH,
5087: :p_rate_type AS NEW_RATE_TYPE_CODE
5088: from
5089: '
5090: from sys.dual; /* l_insert_cursor */
5091:
5092: ---------------------------------------
5093: -- cursor for all locations to use
5094: ---------------------------------------

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

5104: and nvl(END_DATE, SYSDATE+1) > SYSDATE
5105: '||l_location_enabled||'
5106: ) l,
5107: '
5108: from sys.dual; /* l_l_cursor */
5109:
5110: ---------------------------------------
5111: -- cursor for all roles to use
5112: ---------------------------------------

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

5122: and nvl(END_DATE, SYSDATE+1) > SYSDATE
5123: '||l_role_enabled||'
5124: ) r,
5125: '
5126: from sys.dual; /* l_r_cursor */
5127:
5128: ---------------------------------------
5129: -- cursor for all currency codes to use
5130: ---------------------------------------

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

5140: and nvl(END_DATE, SYSDATE+1) > SYSDATE
5141: '||l_currency_enabled||'
5142: ) c,
5143: '
5144: from sys.dual; /* l_c_cursor */
5145:
5146: ---------------------------------------
5147: -- cursor for all thresholds to use
5148: ---------------------------------------

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

5160: and nvl(rate_type_code, :p_rate_type) = :p_rate_type
5161: '||l_thresholds_enabled||'
5162: ) dt
5163: '
5164: from sys.dual; /* l_dt_cursor */
5165:
5166: ---------------------------------------
5167: -- cursor for where rows
5168: ---------------------------------------

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

5179: or NEW_RANGE_HIGH is not null
5180: )
5181: )
5182: '
5183: from sys.dual; /* l_where_cursor */
5184:
5185:
5186: ---------------------------------------
5187: -- cursor for adding new rules/options

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

5210: and nvl(epl.RATE_TYPE_CODE, :dummy_varchar2) = nvl(NEW_RATE_TYPE_CODE, :dummy_varchar2)
5211: )
5212: )
5213: '
5214: from sys.dual; /* l_not_exists_cursor */
5215:
5216:
5217: BEGIN
5218:

Line 7366: UNION ALL SELECT ' || p_report_header_id || ' FROM DUAL) aerh WHERE aerl.report_header_id = aerh.report_header_id

7362:
7363: -- Bug# 12992286: Duplicate Detection performance fix
7364: l_stmt := 'SELECT aerl.* FROM ap_expense_report_lines_all aerl, (SELECT report_header_id FROM ap_expense_report_headers_all
7365: WHERE employee_id = ' || p_employee_id || ' AND expense_status_code NOT IN (''REJECTED'', ''SAVED'', ''INPROGRESS'', ''WITHDRAWN'')
7366: UNION ALL SELECT ' || p_report_header_id || ' FROM DUAL) aerh WHERE aerl.report_header_id = aerh.report_header_id
7367: AND (aerl.report_header_id <> ' || p_report_header_id || ' OR (aerl.report_header_id = ' || p_report_header_id || '
7368: AND distribution_line_number < ' || p_distribution_line_number || ' AND report_line_id <> ' || p_report_line_id || '))
7369: AND (itemization_parent_id is NULL OR itemization_parent_id <> -1) AND category_code = ''' || p_category_code|| '''
7370: AND ((''' || p_category_code|| ''' NOT IN (''PER_DIEM'', ''MILEAGE'') AND start_expense_date = ''' || p_start_date || ''')

Line 7389: UNION ALL SELECT ' || p_report_header_id || ' FROM DUAL) aerh WHERE aerl.report_header_id = aerh.report_header_id

7385: atts.employee_flag = ''Y'' AND atts.employee_id = ' || p_employee_id || ')';*/
7386:
7387: l_att_stmt := 'SELECT aerl.* FROM ap_expense_report_lines_all aerl, (SELECT report_header_id FROM ap_expense_report_headers_all
7388: WHERE expense_status_code NOT IN (''REJECTED'', ''SAVED'', ''INPROGRESS'', ''WITHDRAWN'')
7389: UNION ALL SELECT ' || p_report_header_id || ' FROM DUAL) aerh WHERE aerl.report_header_id = aerh.report_header_id
7390: AND (aerl.report_header_id <> ' || p_report_header_id || ' OR (aerl.report_header_id = ' || p_report_header_id || '
7391: AND distribution_line_number < ' || p_distribution_line_number || ' AND report_line_id <> ' || p_report_line_id || '))
7392: AND (itemization_parent_id is NULL OR itemization_parent_id <> -1) AND category_code = ''' || p_category_code|| '''
7393: AND ((''' || p_category_code|| ''' NOT IN (''PER_DIEM'', ''MILEAGE'') AND start_expense_date = ''' || p_start_date || ''')