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_UPLOAD_PDM_PKG dependencies on STANDARD

Line 1044: 'STANDARD',

1040: 'USD',
1041: --RATE,
1042: p_rate,
1043: --RATE_TYPE_CODE,
1044: 'STANDARD',
1045: --CALCULATION_METHOD,
1046: p_calc_method,
1047: --ACCOMMODATION_CALC_METHOD,
1048: decode(p_use_free_acc_add, 'Y', 'AMOUNT', decode(p_use_free_acc_ded, 'Y', 'AMOUNT', null)),

Line 2027: put_line('Create Standard Rate');

2023:
2024: if (l_policy_line_id is null) then
2025:
2026: --
2027: put_line('Create Standard Rate');
2028: --
2029:
2030: l_policy_line_id := CreatePolicyLine(p_policy_id => l_policy_id,
2031: p_schedule_period_id => l_schedule_period_id,

Line 2055: put_line('Created Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);

2051: p_use_free_acc_add => p_use_free_acc_add,
2052: p_use_free_acc_ded => p_use_free_acc_ded);
2053:
2054: --
2055: put_line('Created Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
2056: --
2057: g_num_std_rates_created := g_num_std_rates_created + 1;
2058:
2059: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

Line 2092: put_line('Standard Rate Id exists: '||l_policy_line_id);

2088:
2089: else
2090:
2091: --
2092: put_line('Standard Rate Id exists: '||l_policy_line_id);
2093: --
2094:
2095: end if; /* l_policy_line_id is null */
2096:

Line 2110: put_line('Cannot create Standard Rate for Invalid Location Id: '||l_location_id);

2106:
2107: else
2108:
2109: --
2110: put_line('Cannot create Standard Rate for Invalid Location Id: '||l_location_id);
2111: --
2112: AddToInvalidLocs(rates_rec.city_locality, rates_rec.county, rates_rec.state_province, rates_rec.country);
2113:
2114:

Line 2127: put_line('Checking for Undefined CONUS Standard Rate');

2123: --
2124: put_line('------------------------------------------------------------');
2125: --
2126: --
2127: put_line('Checking for Undefined CONUS Standard Rate');
2128: --
2129:
2130: open undefined_conus_rate_cur;
2131:

Line 2165: put_line('Create Undefined CONUS Standard Rate');

2161:
2162: end if; /* l_schedule_option_id is null */
2163:
2164: --
2165: put_line('Create Undefined CONUS Standard Rate');
2166: --
2167:
2168: l_policy_line_id := CreatePolicyLine(p_policy_id => l_policy_id,
2169: p_schedule_period_id => l_schedule_period_id,

Line 2193: put_line('Created Undefined CONUS Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);

2189: p_use_free_acc_add => p_use_free_acc_add,
2190: p_use_free_acc_ded => p_use_free_acc_ded);
2191:
2192: --
2193: put_line('Created Undefined CONUS Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
2194: --
2195: g_num_std_rates_created := g_num_std_rates_created + 1;
2196:
2197: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

Line 2230: put_line('Got Undefined CONUS Standard Rate with rate: '||l_rate);

2226:
2227: else
2228: l_rate := undefined_conus_rate_rec.rate;
2229: --
2230: put_line('Got Undefined CONUS Standard Rate with rate: '||l_rate);
2231: --
2232: end if;
2233:
2234: close undefined_conus_rate_cur;

Line 2242: put_line('Always check for Undefined Location Standard Rate');

2238: --
2239: put_line('------------------------------------------------------------');
2240: --
2241: --
2242: put_line('Always check for Undefined Location Standard Rate');
2243: --
2244:
2245: open undefined_loc_rate_cur;
2246:

Line 2280: put_line('Create Undefined Location Standard Rate');

2276:
2277: end if; /* l_schedule_option_id is null */
2278:
2279: --
2280: put_line('Create Undefined Location Standard Rate');
2281: --
2282:
2283: l_policy_line_id := CreatePolicyLine(p_policy_id => l_policy_id,
2284: p_schedule_period_id => l_schedule_period_id,

Line 2308: put_line('Created Undefined Location Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);

2304: p_use_free_acc_add => p_use_free_acc_add,
2305: p_use_free_acc_ded => p_use_free_acc_ded);
2306:
2307: --
2308: put_line('Created Undefined Location Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
2309: --
2310: g_num_std_rates_created := g_num_std_rates_created + 1;
2311:
2312: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

Line 2345: put_line('Got Undefined Location Standard Rate with rate: '||l_rate);

2341:
2342: else
2343: l_rate := undefined_loc_rate_rec.rate;
2344: --
2345: put_line('Got Undefined Location Standard Rate with rate: '||l_rate);
2346: --
2347: end if;
2348:
2349: close undefined_loc_rate_cur;

Line 2356: put_line('Always check for Gap Standard Rate');

2352: --
2353: put_line('------------------------------------------------------------');
2354: --
2355: --
2356: put_line('Always check for Gap Standard Rate');
2357: --
2358: OPEN rates_gap_cur;
2359: loop
2360:

Line 2370: put_line('Create Gap Standard Rate');

2366: rates_gap_rec.end_of_season := null;
2367: end if;
2368:
2369: --
2370: put_line('Create Gap Standard Rate');
2371: --
2372:
2373: l_policy_line_id := CreatePolicyLine(p_policy_id => l_policy_id,
2374: p_schedule_period_id => l_schedule_period_id,

Line 2398: put_line('Created Gap Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);

2394: p_use_free_acc_add => p_use_free_acc_add,
2395: p_use_free_acc_ded => p_use_free_acc_ded);
2396:
2397: --
2398: put_line('Created Gap Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
2399: --
2400: g_num_std_rates_created := g_num_std_rates_created + 1;
2401:
2402: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

Line 2872: put_line('Create Standard Rate');

2868:
2869: if (l_policy_line_id is null) then
2870:
2871: --
2872: put_line('Create Standard Rate');
2873: --
2874:
2875: l_policy_line_id := CreatePolicyLine(p_policy_id => p_policy_id,
2876: p_schedule_period_id => l_schedule_period_id,

Line 2900: put_line('Created Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);

2896: p_use_free_acc_add => p_use_free_acc_add,
2897: p_use_free_acc_ded => p_use_free_acc_ded);
2898:
2899: --
2900: put_line('Created Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
2901: --
2902: g_num_std_rates_created := g_num_std_rates_created + 1;
2903:
2904: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

Line 2937: put_line('Standard Rate Id exists: '||l_policy_line_id);

2933:
2934: else
2935:
2936: --
2937: put_line('Standard Rate Id exists: '||l_policy_line_id);
2938: --
2939:
2940: end if; /* l_policy_line_id is null */
2941:

Line 2957: put_line('Cannot create Standard Rate for Invalid Location Id: '||l_location_id);

2953:
2954: else
2955:
2956: --
2957: put_line('Cannot create Standard Rate for Invalid Location Id: '||l_location_id);
2958: --
2959: AddToInvalidLocs(rates_rec.city_locality, rates_rec.county, rates_rec.state_province, rates_rec.country);
2960:
2961: end if; /* l_location_id is not null and l_location_status <> 'INVALID' */

Line 2975: put_line('Checking for Undefined CONUS Standard Rate');

2971: --
2972: put_line('------------------------------------------------------------');
2973: --
2974: --
2975: put_line('Checking for Undefined CONUS Standard Rate');
2976: --
2977:
2978: --
2979: put_line('Process Roles');

Line 3035: put_line('Create Undefined CONUS Standard Rate');

3031:
3032: end if; /* l_schedule_option_id is null */
3033:
3034: --
3035: put_line('Create Undefined CONUS Standard Rate');
3036: --
3037:
3038: l_policy_line_id := CreatePolicyLine(p_policy_id => p_policy_id,
3039: p_schedule_period_id => l_schedule_period_id,

Line 3063: put_line('Created Undefined CONUS Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);

3059: p_use_free_acc_add => p_use_free_acc_add,
3060: p_use_free_acc_ded => p_use_free_acc_ded);
3061:
3062: --
3063: put_line('Created Undefined CONUS Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
3064: --
3065: g_num_std_rates_created := g_num_std_rates_created + 1;
3066:
3067: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

Line 3100: put_line('Got Undefined CONUS Standard Rate with rate: '||l_rate);

3096:
3097: else
3098: l_rate := undefined_conus_rate_rec.rate;
3099: --
3100: put_line('Got Undefined CONUS Standard Rate with rate: '||l_rate);
3101: --
3102: end if; /* undefined_conus_rate_cur%notfound */
3103:
3104: close undefined_conus_rate_cur;

Line 3117: put_line('Always check for Undefined Location Standard Rate');

3113: --
3114: put_line('------------------------------------------------------------');
3115: --
3116: --
3117: put_line('Always check for Undefined Location Standard Rate');
3118: --
3119:
3120: --
3121: put_line('Process Roles');

Line 3177: put_line('Create Undefined Location Standard Rate');

3173:
3174: end if; /* l_schedule_option_id is null */
3175:
3176: --
3177: put_line('Create Undefined Location Standard Rate');
3178: --
3179:
3180: l_policy_line_id := CreatePolicyLine(p_policy_id => p_policy_id,
3181: p_schedule_period_id => l_schedule_period_id,

Line 3205: put_line('Created Undefined Location Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);

3201: p_use_free_acc_add => p_use_free_acc_add,
3202: p_use_free_acc_ded => p_use_free_acc_ded);
3203:
3204: --
3205: put_line('Created Undefined Location Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
3206: --
3207: g_num_std_rates_created := g_num_std_rates_created + 1;
3208:
3209: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

Line 3242: put_line('Got Undefined Location Standard Rate with rate: '||l_rate);

3238:
3239: else
3240: l_rate := undefined_loc_rate_rec.rate;
3241: --
3242: put_line('Got Undefined Location Standard Rate with rate: '||l_rate);
3243: --
3244: end if; /* undefined_loc_rate_cur%notfound */
3245:
3246: close undefined_loc_rate_cur;

Line 3257: put_line('Always check for Gap Standard Rate');

3253: --
3254: put_line('------------------------------------------------------------');
3255: --
3256: --
3257: put_line('Always check for Gap Standard Rate');
3258: --
3259: --
3260: put_line('Process Roles');
3261: --

Line 3293: put_line('Create Gap Standard Rate');

3289: rates_gap_rec.end_of_season := null;
3290: end if;
3291:
3292: --
3293: put_line('Create Gap Standard Rate');
3294: --
3295:
3296: l_policy_line_id := CreatePolicyLine(p_policy_id => p_policy_id,
3297: p_schedule_period_id => l_schedule_period_id,

Line 3321: put_line('Created Gap Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);

3317: p_use_free_acc_add => p_use_free_acc_add,
3318: p_use_free_acc_ded => p_use_free_acc_ded);
3319:
3320: --
3321: put_line('Created Gap Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
3322: --
3323: g_num_std_rates_created := g_num_std_rates_created + 1;
3324:
3325: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

Line 3555: put_line('Total number of Standard Rates created = ' || g_num_std_rates_created);

3551: put_line('-- U P L O A D S U M M A R Y --');
3552: put_line('------------------------------------------------------------');
3553: put_line('Total number of records in the file = ' || g_num_recs_processed);
3554: put_line('Total number of Locations created = ' || g_num_locs_created );
3555: put_line('Total number of Standard Rates created = ' || g_num_std_rates_created);
3556: put_line('Total number of Standard Rates updated = ' || g_num_std_rates_updated);
3557: put_line('Total number of Night Rates created = ' || g_num_night_rates_created);
3558: --
3559: if (g_num_locs_invalid > 0) then

Line 3556: put_line('Total number of Standard Rates updated = ' || g_num_std_rates_updated);

3552: put_line('------------------------------------------------------------');
3553: put_line('Total number of records in the file = ' || g_num_recs_processed);
3554: put_line('Total number of Locations created = ' || g_num_locs_created );
3555: put_line('Total number of Standard Rates created = ' || g_num_std_rates_created);
3556: put_line('Total number of Standard Rates updated = ' || g_num_std_rates_updated);
3557: put_line('Total number of Night Rates created = ' || g_num_night_rates_created);
3558: --
3559: if (g_num_locs_invalid > 0) then
3560: put_line('------------------------------------------------------------');