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 AP_POL_LINES

Line 987: select AP_POL_LINES_S.NEXTVAL

983: l_policy_line_id NUMBER(15);
984:
985: BEGIN
986:
987: select AP_POL_LINES_S.NEXTVAL
988: into l_policy_line_id
989: from dual;
990:
991:

Line 992: insert into AP_POL_LINES

988: into l_policy_line_id
989: from dual;
990:
991:
992: insert into AP_POL_LINES
993: (
994: POLICY_LINE_ID,
995: POLICY_ID,
996: SCHEDULE_PERIOD_ID,

Line 1131: select AP_POL_LINES_S.NEXTVAL

1127: l_night_rate_line_id NUMBER(15);
1128:
1129: BEGIN
1130:
1131: select AP_POL_LINES_S.NEXTVAL
1132: into l_night_rate_line_id
1133: from dual;
1134:
1135:

Line 1136: insert into AP_POL_LINES

1132: into l_night_rate_line_id
1133: from dual;
1134:
1135:
1136: insert into AP_POL_LINES
1137: (
1138: POLICY_LINE_ID,
1139: POLICY_ID,
1140: SCHEDULE_PERIOD_ID,

Line 1341: from ap_pol_lines

1337: ------------------------------------------------------------------------
1338:
1339: cursor policy_line_cur is
1340: select policy_line_id
1341: from ap_pol_lines
1342: where policy_id = p_policy_id
1343: and schedule_period_id = p_schedule_period_id
1344: and nvl(role_id, -1) = nvl(p_role_id, -1)
1345: and location_id = p_location_id

Line 1775: from ap_pol_lines l1

1771: -------------------------------
1772: cursor rates_gap_cur is
1773: select l1.location_id, min(l1.effective_start_date) as effective_start_date,
1774: '01/01' as start_of_season, '12/31' as end_of_season
1775: from ap_pol_lines l1
1776: where l1.policy_id = l_policy_id
1777: and not exists
1778: (select 'Y'
1779: from ap_pol_lines l2

Line 1779: from ap_pol_lines l2

1775: from ap_pol_lines l1
1776: where l1.policy_id = l_policy_id
1777: and not exists
1778: (select 'Y'
1779: from ap_pol_lines l2
1780: where l2.policy_id = l1.policy_id
1781: and l2.location_id = l1.location_id
1782: and l2.effective_start_date = p_period_start_date
1783: and rownum = 1

Line 1798: from ap_pol_lines

1794: -- cursor for undefined conus rate
1795: -------------------------------
1796: cursor undefined_conus_rate_cur is
1797: select rate, '01/01' as start_of_season, '12/31' as end_of_season
1798: from ap_pol_lines
1799: where policy_id = l_policy_id
1800: and location_id = l_undefined_conus_location_id;
1801:
1802: undefined_conus_rate_rec undefined_conus_rate_cur%ROWTYPE;

Line 1809: from ap_pol_lines

1805: -- cursor for undefined location rate
1806: -------------------------------
1807: cursor undefined_loc_rate_cur is
1808: select rate, '01/01' as start_of_season, '12/31' as end_of_season
1809: from ap_pol_lines
1810: where policy_id = l_policy_id
1811: and location_id = l_undefined_location_id;
1812:
1813: undefined_loc_rate_rec undefined_loc_rate_cur%ROWTYPE;

Line 2450: update ap_pol_lines apl1

2446: p_schedule_period_id IN NUMBER) IS
2447:
2448: BEGIN
2449:
2450: update ap_pol_lines apl1
2451: set apl1.effective_end_date =
2452: (
2453: select min(apl2.effective_start_date)-1
2454: from ap_pol_lines apl2

Line 2454: from ap_pol_lines apl2

2450: update ap_pol_lines apl1
2451: set apl1.effective_end_date =
2452: (
2453: select min(apl2.effective_start_date)-1
2454: from ap_pol_lines apl2
2455: where apl2.policy_id = apl1.policy_id
2456: and apl2.schedule_period_id = apl1.schedule_period_id
2457: and apl2.policy_line_id <> apl1.policy_line_id
2458: and apl2.location_id = apl1.location_id

Line 2467: from ap_pol_lines apl3

2463: and apl1.effective_end_date is null
2464: and
2465: exists
2466: (select 'Y'
2467: from ap_pol_lines apl3
2468: where apl3.policy_id = apl1.policy_id
2469: and apl3.schedule_period_id = apl1.schedule_period_id
2470: and apl3.policy_line_id <> apl1.policy_line_id
2471: and apl3.location_id = apl1.location_id

Line 2592: from ap_pol_lines l1

2588: -------------------------------
2589: cursor rates_gap_cur is
2590: select l1.role_id, l1.location_id, min(l1.effective_start_date) as effective_start_date,
2591: '01/01' as start_of_season, '12/31' as end_of_season
2592: from ap_pol_lines l1
2593: where l1.policy_id = p_policy_id
2594: and not exists
2595: (select 'Y'
2596: from ap_pol_lines l2

Line 2596: from ap_pol_lines l2

2592: from ap_pol_lines l1
2593: where l1.policy_id = p_policy_id
2594: and not exists
2595: (select 'Y'
2596: from ap_pol_lines l2
2597: where l2.policy_id = l1.policy_id
2598: and nvl(l2.role_id, -1) = nvl(l1.role_id, -1)
2599: and l2.location_id = l1.location_id
2600: and l2.effective_start_date = p_period_start_date

Line 2616: from ap_pol_lines

2612: -- cursor for undefined conus rate
2613: -------------------------------
2614: cursor undefined_conus_rate_cur is
2615: select rate, '01/01' as start_of_season, '12/31' as end_of_season
2616: from ap_pol_lines
2617: where policy_id = p_policy_id
2618: and nvl(role_id, -1) = nvl(l_role_id, -1)
2619: and location_id = l_undefined_conus_location_id;
2620:

Line 2628: from ap_pol_lines

2624: -- cursor for undefined location rate
2625: -------------------------------
2626: cursor undefined_loc_rate_cur is
2627: select rate, '01/01' as start_of_season, '12/31' as end_of_season
2628: from ap_pol_lines
2629: where policy_id = p_policy_id
2630: and nvl(role_id, -1) = nvl(l_role_id, -1)
2631: and location_id = l_undefined_location_id;
2632: