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 AP_POL_LINES_S

Line 168: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );

164: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE);
165:
166: PROCEDURE permutateAddonRates( p_user_id IN NUMBER,
167: p_policy_id IN ap_pol_headers.policy_id%TYPE,
168: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );
169:
170: PROCEDURE permutateNightRates( p_user_id IN NUMBER,
171: p_policy_id IN ap_pol_headers.policy_id%TYPE,
172: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );

Line 172: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );

168: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );
169:
170: PROCEDURE permutateNightRates( p_user_id IN NUMBER,
171: p_policy_id IN ap_pol_headers.policy_id%TYPE,
172: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );
173:
174: PROCEDURE permutateConusLines( p_user_id IN NUMBER,
175: p_policy_id IN ap_pol_headers.policy_id%TYPE);
176:

Line 2032: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,

2028: LAST_UPDATE_DATE,
2029: LAST_UPDATED_BY
2030: )
2031: select
2032: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
2033: :p_policy_id AS POLICY_ID,
2034: :p_schedule_period_id AS SCHEDULE_PERIOD_ID,
2035: NEW_LOCATION_ID AS LOCATION_ID,
2036: NEW_ROLE_ID AS ROLE_ID,

Line 3470: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,

3466: REIMBURSEMENT_PERCENTAGE,
3467: MAX_RECEIPT_AMT
3468: )
3469: select
3470: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
3471: :p_to_policy_id AS POLICY_ID,
3472: :p_to_schedule_period_id AS SCHEDULE_PERIOD_ID,
3473: LOCATION_ID,
3474: ROLE_ID,

Line 3596: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE,

3592: |
3593: *=======================================================================*/
3594: PROCEDURE preservePolicyLine(p_user_id IN NUMBER,
3595: p_policy_id IN ap_pol_lines.policy_id%TYPE,
3596: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE,
3597: p_policy_line_id IN ap_pol_lines.policy_line_id%TYPE) IS
3598:
3599: l_preserve_count NUMBER := 0;
3600:

Line 3664: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,

3660: MAX_RECEIPT_AMT
3661: )
3662: select
3663: p_policy_line_id AS PARENT_LINE_ID,
3664: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
3665: p_policy_id AS POLICY_ID,
3666: p_schedule_period_id AS SCHEDULE_PERIOD_ID,
3667: LOCATION_ID,
3668: ROLE_ID,

Line 5056: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,

5052: LAST_UPDATE_DATE,
5053: LAST_UPDATED_BY
5054: )
5055: select
5056: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
5057: :p_policy_id AS POLICY_ID,
5058: :p_schedule_period_id AS SCHEDULE_PERIOD_ID,
5059: NEW_LOCATION_ID AS LOCATION_ID,
5060: NEW_ROLE_ID AS ROLE_ID,

Line 5361: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE ) IS

5357: |
5358: *=======================================================================*/
5359: PROCEDURE permutateAddonRates( p_user_id IN NUMBER,
5360: p_policy_id IN ap_pol_headers.policy_id%TYPE,
5361: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE ) IS
5362:
5363: l_policy_line_count NUMBER;
5364:
5365: BEGIN

Line 5403: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,

5399: LAST_UPDATE_DATE,
5400: LAST_UPDATED_BY
5401: )
5402: select
5403: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
5404: apl.POLICY_ID,
5405: apl.SCHEDULE_PERIOD_ID,
5406: apl.location_id,
5407: apl.role_id,

Line 5469: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,

5465: LAST_UPDATE_DATE,
5466: LAST_UPDATED_BY
5467: )
5468: select
5469: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
5470: apl.POLICY_ID,
5471: apl.SCHEDULE_PERIOD_ID,
5472: apl.location_id,
5473: apl.role_id,

Line 5545: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE ) IS

5541: |
5542: *=======================================================================*/
5543: PROCEDURE permutateNightRates( p_user_id IN NUMBER,
5544: p_policy_id IN ap_pol_headers.policy_id%TYPE,
5545: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE ) IS
5546:
5547: -- -------------------------------------
5548: -- Cursor for inserting new permutation
5549: -- -------------------------------------

Line 5651: AP_POL_LINES_S.NEXTVAL,

5647: LAST_UPDATED_BY
5648: )
5649: values
5650: (
5651: AP_POL_LINES_S.NEXTVAL,
5652: c_nightrate.POLICY_ID,
5653: c_nightrate.SCHEDULE_PERIOD_ID,
5654: c_nightrate.LOCATION_ID,
5655: c_nightrate.ROLE_ID,

Line 5731: AP_POL_LINES_S.NEXTVAL,

5727: LAST_UPDATED_BY
5728: )
5729: values
5730: (
5731: AP_POL_LINES_S.NEXTVAL,
5732: c_nightrate.POLICY_ID,
5733: c_nightrate.SCHEDULE_PERIOD_ID,
5734: c_nightrate.LOCATION_ID,
5735: c_nightrate.ROLE_ID,

Line 6043: SELECT AP_POL_LINES_S.NEXTVAL,

6039: LAST_UPDATE_DATE,
6040: LAST_UPDATED_BY,
6041: REIMBURSEMENT_PERCENTAGE
6042: )
6043: SELECT AP_POL_LINES_S.NEXTVAL,
6044: apl.POLICY_ID,
6045: apl.SCHEDULE_PERIOD_ID,
6046: apl.RATE_TYPE_CODE,
6047: 'NEW' as STATUS,

Line 6136: p_start_of_season ap_pol_lines.start_of_season%TYPE,

6132: | 21-Feb-2006 albowicz Created
6133: |
6134: *=======================================================================*/
6135: FUNCTION isDateInSeason (p_date DATE,
6136: p_start_of_season ap_pol_lines.start_of_season%TYPE,
6137: p_end_of_season ap_pol_lines.end_of_season%TYPE) RETURN VARCHAR2 IS
6138: l_start_month INTEGER;
6139: l_start_day INTEGER;
6140: l_end_month INTEGER;

Line 6381: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type,

6377: | 08-Jun-2006 krmenon Created
6378: |
6379: *=======================================================================*/
6380: FUNCTION checkForInvalidLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
6381: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type,
6382: p_std_invalid OUT NOCOPY NUMBER,
6383: p_first_invalid OUT NOCOPY NUMBER,
6384: p_last_invalid OUT NOCOPY NUMBER,
6385: p_same_invalid OUT NOCOPY NUMBER,

Line 6470: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type) IS

6466: | 08-Jun-2006 krmenon Created
6467: |
6468: *=======================================================================*/
6469: PROCEDURE activatePolicyLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
6470: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type) IS
6471: BEGIN
6472:
6473: UPDATE ap_pol_lines
6474: SET status = 'ACTIVE'

Line 6507: l_stmt := ' Update ap_pol_lines set ' ||

6503: BEGIN
6504: l_stmt := null;
6505:
6506: IF(l_mass_update_type = 'AMOUNT') THEN
6507: l_stmt := ' Update ap_pol_lines set ' ||
6508: ' rate = Nvl('|| l_rate || ', rate),' ||
6509: ' meal_limit = Nvl('|| l_meal_limit || ', meal_limit),' ||
6510: ' max_receipt_amt = Nvl('|| l_max_receipt_amt || ', max_receipt_amt),' ||
6511: ' calculation_method = decode('''|| l_calculation_method|| ''',''NULL'',calculation_method,'''||l_calculation_method||'''),' ||

Line 6530: l_stmt := ' Update ap_pol_lines set ' ||

6526: ELSIF(l_mass_update_type = 'PERCENT') THEN
6527: CASE l_rounding_rule
6528:
6529: WHEN 'WHOLE_NUMBER' THEN
6530: l_stmt := ' Update ap_pol_lines set ' ||
6531: ' Rate = Nvl(Round(Rate + (('||l_rate ||' * Rate)/100), 0), rate),' ||
6532: ' max_receipt_amt = Nvl(Round(max_receipt_amt + (('||l_max_receipt_amt ||' * max_receipt_amt)/100), 0), max_receipt_amt),' ||
6533: ' calculation_method = decode('''|| l_calculation_method|| ''',''NULL'',calculation_method,'''||l_calculation_method||'''),' ||
6534: ' accommodation_calc_method = decode('''|| l_accommodation_calc_method|| ''',''NULL'',accommodation_calc_method,'''||l_accommodation_calc_method||'''),' ||

Line 6551: l_stmt := ' Update ap_pol_lines set ' ||

6547: ' WHERE ' || l_where_clause;
6548:
6549: WHEN '1_DECIMALS' THEN
6550:
6551: l_stmt := ' Update ap_pol_lines set ' ||
6552: ' Rate = Nvl(Round(Rate + (('||l_rate ||' * Rate)/100), 1), rate),' ||
6553: ' max_receipt_amt = Nvl(Round(max_receipt_amt + (('||l_max_receipt_amt ||' * max_receipt_amt)/100), 1), max_receipt_amt),' ||
6554: ' meal_limit = Nvl(Round(meal_limit + (('||l_meal_limit ||' * meal_limit)/100), 1), meal_limit),' ||
6555: ' calculation_method = decode('''|| l_calculation_method|| ''',''NULL'',calculation_method,'''||l_calculation_method||'''),' ||

Line 6572: l_stmt := ' Update ap_pol_lines set ' ||

6568: ' WHERE ' || l_where_clause;
6569:
6570: WHEN '2_DECIMALS' THEN
6571:
6572: l_stmt := ' Update ap_pol_lines set ' ||
6573: ' Rate = Nvl(Round(Rate + (('||l_rate ||' * Rate)/100), 2), rate),' ||
6574: ' max_receipt_amt = Nvl(Round(max_receipt_amt + (('||l_max_receipt_amt ||' * max_receipt_amt)/100), 2), max_receipt_amt),' ||
6575: ' meal_limit = Nvl(Round(meal_limit + (('||l_meal_limit ||' * meal_limit)/100), 2), meal_limit),' ||
6576: ' calculation_method = decode('''|| l_calculation_method|| ''',''NULL'',calculation_method,'''||l_calculation_method||'''),' ||

Line 6593: l_stmt := ' Update ap_pol_lines set ' ||

6589: ' WHERE ' || l_where_clause;
6590:
6591: WHEN '3_DECIMALS' THEN
6592:
6593: l_stmt := ' Update ap_pol_lines set ' ||
6594: ' Rate = Nvl(Round(Rate + (('||l_rate ||' * Rate)/100), 3), rate),' ||
6595: ' max_receipt_amt = Nvl(Round(max_receipt_amt + (('||l_max_receipt_amt ||' * max_receipt_amt)/100), 3), max_receipt_amt),' ||
6596: ' meal_limit = Nvl(Round(meal_limit + (('||l_meal_limit ||' * meal_limit)/100), 3), meal_limit),' ||
6597: ' calculation_method = decode('''|| l_calculation_method|| ''',''NULL'',calculation_method,'''||l_calculation_method||'''),' ||

Line 6614: l_stmt := ' Update ap_pol_lines set ' ||

6610: ' WHERE ' || l_where_clause;
6611:
6612: WHEN 'NEAREST_FIVE' THEN
6613:
6614: l_stmt := ' Update ap_pol_lines set ' ||
6615: ' Rate = Nvl((Round(Round(Rate + (('||l_rate ||'* Rate)/100), 0)/5)*5), Rate), ' ||
6616: ' max_receipt_amt = Nvl((Round(Round(max_receipt_amt + (('||l_max_receipt_amt ||'* max_receipt_amt)/100), 0)/5)*5), max_receipt_amt), ' ||
6617: ' meal_limit = Nvl((Round(Round(meal_limit + (('||l_meal_limit ||'* meal_limit)/100), 0)/5)*5), meal_limit),' ||
6618: ' calculation_method = decode('''|| l_calculation_method|| ''',''NULL'',calculation_method,'''||l_calculation_method||'''),' ||

Line 6635: l_stmt := ' Update ap_pol_lines set ' ||

6631: ' WHERE ' || l_where_clause;
6632:
6633: WHEN 'NEAREST_TEN' THEN
6634:
6635: l_stmt := ' Update ap_pol_lines set ' ||
6636: ' Rate = Nvl((Round(Round(Rate + (('||l_rate ||'* Rate)/100), 0)/10)*10), Rate), ' ||
6637: ' max_receipt_amt = Nvl((Round(Round(max_receipt_amt + (('||l_max_receipt_amt ||'* max_receipt_amt)/100), 0)/10)*10), max_receipt_amt), ' ||
6638: ' meal_limit = Nvl((Round(Round(meal_limit + (('||l_meal_limit ||'* meal_limit)/100), 0)/10)*10), meal_limit),' ||
6639: ' calculation_method = decode('''|| l_calculation_method|| ''',''NULL'',calculation_method,'''||l_calculation_method||'''),' ||