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 1065: 'STANDARD',

1061: 'USD',
1062: --RATE,
1063: p_rate,
1064: --RATE_TYPE_CODE,
1065: 'STANDARD',
1066: --CALCULATION_METHOD,
1067: p_calc_method,
1068: -- Accommodataion Calc Method and Accomodation Adjustment is set only to Night Rate Lines if Free Accomodation is Enabled.- bug 6430013
1069: --ACCOMMODATION_CALC_METHOD,

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

2052:
2053: if (l_policy_line_id is null) then
2054:
2055: --
2056: put_line('Create Standard Rate');
2057: --
2058:
2059: l_policy_line_id := CreatePolicyLine(p_policy_id => l_policy_id,
2060: p_schedule_period_id => l_schedule_period_id,

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

2080: p_use_free_acc_add => p_use_free_acc_add,
2081: p_use_free_acc_ded => p_use_free_acc_ded);
2082:
2083: --
2084: put_line('Created Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
2085: --
2086: g_num_std_rates_created := g_num_std_rates_created + 1;
2087:
2088: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

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

2117:
2118: else
2119:
2120: --
2121: put_line('Standard Rate Id exists: '||l_policy_line_id);
2122: --
2123:
2124: end if; /* l_policy_line_id is null */
2125:

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

2135:
2136: else
2137:
2138: --
2139: put_line('Cannot create Standard Rate for Invalid Location Id: '||l_location_id);
2140: --
2141: AddToInvalidLocs(rates_rec.city_locality, rates_rec.county, rates_rec.state_province, rates_rec.country);
2142:
2143:

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

2152: --
2153: put_line('------------------------------------------------------------');
2154: --
2155: --
2156: put_line('Checking for Undefined CONUS Standard Rate');
2157: --
2158:
2159: open undefined_conus_rate_cur;
2160:

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

2190:
2191: end if; /* l_schedule_option_id is null */
2192:
2193: --
2194: put_line('Create Undefined CONUS Standard Rate');
2195: --
2196:
2197: l_policy_line_id := CreatePolicyLine(p_policy_id => l_policy_id,
2198: p_schedule_period_id => l_schedule_period_id,

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

2218: p_use_free_acc_add => p_use_free_acc_add,
2219: p_use_free_acc_ded => p_use_free_acc_ded);
2220:
2221: --
2222: put_line('Created Undefined CONUS Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
2223: --
2224: g_num_std_rates_created := g_num_std_rates_created + 1;
2225:
2226: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

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

2255:
2256: else
2257: l_rate := undefined_conus_rate_rec.rate;
2258: --
2259: put_line('Got Undefined CONUS Standard Rate with rate: '||l_rate);
2260: --
2261: end if;
2262:
2263: close undefined_conus_rate_cur;

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

2267: --
2268: put_line('------------------------------------------------------------');
2269: --
2270: --
2271: put_line('Always check for Undefined Location Standard Rate');
2272: --
2273:
2274: open undefined_loc_rate_cur;
2275:

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

2305:
2306: end if; /* l_schedule_option_id is null */
2307:
2308: --
2309: put_line('Create Undefined Location Standard Rate');
2310: --
2311:
2312: l_policy_line_id := CreatePolicyLine(p_policy_id => l_policy_id,
2313: p_schedule_period_id => l_schedule_period_id,

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

2333: p_use_free_acc_add => p_use_free_acc_add,
2334: p_use_free_acc_ded => p_use_free_acc_ded);
2335:
2336: --
2337: put_line('Created Undefined Location Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
2338: --
2339: g_num_std_rates_created := g_num_std_rates_created + 1;
2340:
2341: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

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

2370:
2371: else
2372: l_rate := undefined_loc_rate_rec.rate;
2373: --
2374: put_line('Got Undefined Location Standard Rate with rate: '||l_rate);
2375: --
2376: end if;
2377:
2378: close undefined_loc_rate_cur;

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

2381: --
2382: put_line('------------------------------------------------------------');
2383: --
2384: --
2385: put_line('Always check for Gap Standard Rate');
2386: --
2387: OPEN rates_gap_cur;
2388: loop
2389:

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

2395: rates_gap_rec.end_of_season := null;
2396: end if;
2397:
2398: --
2399: put_line('Create Gap Standard Rate');
2400: --
2401:
2402: l_policy_line_id := CreatePolicyLine(p_policy_id => l_policy_id,
2403: p_schedule_period_id => l_schedule_period_id,

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

2423: p_use_free_acc_add => p_use_free_acc_add,
2424: p_use_free_acc_ded => p_use_free_acc_ded);
2425:
2426: --
2427: put_line('Created Gap Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
2428: --
2429: g_num_std_rates_created := g_num_std_rates_created + 1;
2430:
2431: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

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

2905:
2906: if (l_policy_line_id is null) then
2907:
2908: --
2909: put_line('Create Standard Rate');
2910: --
2911:
2912: l_policy_line_id := CreatePolicyLine(p_policy_id => p_policy_id,
2913: p_schedule_period_id => l_schedule_period_id,

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

2933: p_use_free_acc_add => p_use_free_acc_add,
2934: p_use_free_acc_ded => p_use_free_acc_ded);
2935:
2936: --
2937: put_line('Created Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
2938: --
2939: g_num_std_rates_created := g_num_std_rates_created + 1;
2940:
2941: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

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

2970:
2971: else
2972:
2973: --
2974: put_line('Standard Rate Id exists: '||l_policy_line_id);
2975: --
2976:
2977: end if; /* l_policy_line_id is null */
2978:

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

2990:
2991: else
2992:
2993: --
2994: put_line('Cannot create Standard Rate for Invalid Location Id: '||l_location_id);
2995: --
2996: AddToInvalidLocs(rates_rec.city_locality, rates_rec.county, rates_rec.state_province, rates_rec.country);
2997:
2998: end if; /* l_location_id is not null and l_location_status <> 'INVALID' */

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

3008: --
3009: put_line('------------------------------------------------------------');
3010: --
3011: --
3012: put_line('Checking for Undefined CONUS Standard Rate');
3013: --
3014:
3015: --
3016: put_line('Process Roles');

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

3068:
3069: end if; /* l_schedule_option_id is null */
3070:
3071: --
3072: put_line('Create Undefined CONUS Standard Rate');
3073: --
3074:
3075: l_policy_line_id := CreatePolicyLine(p_policy_id => p_policy_id,
3076: p_schedule_period_id => l_schedule_period_id,

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

3096: p_use_free_acc_add => p_use_free_acc_add,
3097: p_use_free_acc_ded => p_use_free_acc_ded);
3098:
3099: --
3100: put_line('Created Undefined CONUS Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
3101: --
3102: g_num_std_rates_created := g_num_std_rates_created + 1;
3103:
3104: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

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

3133:
3134: else
3135: l_rate := undefined_conus_rate_rec.rate;
3136: --
3137: put_line('Got Undefined CONUS Standard Rate with rate: '||l_rate);
3138: --
3139: end if; /* undefined_conus_rate_cur%notfound */
3140:
3141: close undefined_conus_rate_cur;

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

3150: --
3151: put_line('------------------------------------------------------------');
3152: --
3153: --
3154: put_line('Always check for Undefined Location Standard Rate');
3155: --
3156:
3157: --
3158: put_line('Process Roles');

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

3210:
3211: end if; /* l_schedule_option_id is null */
3212:
3213: --
3214: put_line('Create Undefined Location Standard Rate');
3215: --
3216:
3217: l_policy_line_id := CreatePolicyLine(p_policy_id => p_policy_id,
3218: p_schedule_period_id => l_schedule_period_id,

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

3238: p_use_free_acc_add => p_use_free_acc_add,
3239: p_use_free_acc_ded => p_use_free_acc_ded);
3240:
3241: --
3242: put_line('Created Undefined Location Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
3243: --
3244: g_num_std_rates_created := g_num_std_rates_created + 1;
3245:
3246: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

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

3275:
3276: else
3277: l_rate := undefined_loc_rate_rec.rate;
3278: --
3279: put_line('Got Undefined Location Standard Rate with rate: '||l_rate);
3280: --
3281: end if; /* undefined_loc_rate_cur%notfound */
3282:
3283: close undefined_loc_rate_cur;

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

3290: --
3291: put_line('------------------------------------------------------------');
3292: --
3293: --
3294: put_line('Always check for Gap Standard Rate');
3295: --
3296: --
3297: put_line('Process Roles');
3298: --

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

3326: rates_gap_rec.end_of_season := null;
3327: end if;
3328:
3329: --
3330: put_line('Create Gap Standard Rate');
3331: --
3332:
3333: l_policy_line_id := CreatePolicyLine(p_policy_id => p_policy_id,
3334: p_schedule_period_id => l_schedule_period_id,

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

3354: p_use_free_acc_add => p_use_free_acc_add,
3355: p_use_free_acc_ded => p_use_free_acc_ded);
3356:
3357: --
3358: put_line('Created Gap Standard Rate Id: '||l_policy_line_id||' with rate: '||l_rate);
3359: --
3360: g_num_std_rates_created := g_num_std_rates_created + 1;
3361:
3362: if (nvl(p_use_free_acc_add, 'N') = 'Y') then

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

3588: put_line('-- U P L O A D S U M M A R Y --');
3589: put_line('------------------------------------------------------------');
3590: put_line('Total number of records in the file = ' || g_num_recs_processed);
3591: put_line('Total number of Locations created = ' || g_num_locs_created );
3592: put_line('Total number of Standard Rates created = ' || g_num_std_rates_created);
3593: put_line('Total number of Standard Rates updated = ' || g_num_std_rates_updated);
3594: put_line('Total number of Night Rates created = ' || g_num_night_rates_created);
3595: --
3596: if (g_num_locs_invalid > 0) then

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

3589: put_line('------------------------------------------------------------');
3590: put_line('Total number of records in the file = ' || g_num_recs_processed);
3591: put_line('Total number of Locations created = ' || g_num_locs_created );
3592: put_line('Total number of Standard Rates created = ' || g_num_std_rates_created);
3593: put_line('Total number of Standard Rates updated = ' || g_num_std_rates_updated);
3594: put_line('Total number of Night Rates created = ' || g_num_night_rates_created);
3595: --
3596: if (g_num_locs_invalid > 0) then
3597: put_line('------------------------------------------------------------');