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 1008: select AP_POL_LINES_S.NEXTVAL

1004: l_policy_line_id NUMBER(15);
1005:
1006: BEGIN
1007:
1008: select AP_POL_LINES_S.NEXTVAL
1009: into l_policy_line_id
1010: from dual;
1011:
1012:

Line 1013: insert into AP_POL_LINES

1009: into l_policy_line_id
1010: from dual;
1011:
1012:
1013: insert into AP_POL_LINES
1014: (
1015: POLICY_LINE_ID,
1016: POLICY_ID,
1017: SCHEDULE_PERIOD_ID,

Line 1153: select AP_POL_LINES_S.NEXTVAL

1149: l_night_rate_line_id NUMBER(15);
1150:
1151: BEGIN
1152:
1153: select AP_POL_LINES_S.NEXTVAL
1154: into l_night_rate_line_id
1155: from dual;
1156:
1157:

Line 1158: insert into AP_POL_LINES

1154: into l_night_rate_line_id
1155: from dual;
1156:
1157:
1158: insert into AP_POL_LINES
1159: (
1160: POLICY_LINE_ID,
1161: POLICY_ID,
1162: SCHEDULE_PERIOD_ID,

Line 1363: from ap_pol_lines

1359: ------------------------------------------------------------------------
1360:
1361: cursor policy_line_cur is
1362: select policy_line_id
1363: from ap_pol_lines
1364: where policy_id = p_policy_id
1365: and schedule_period_id = p_schedule_period_id
1366: and nvl(role_id, -1) = nvl(p_role_id, -1)
1367: and location_id = p_location_id

Line 1797: from ap_pol_lines l1

1793: -------------------------------
1794: cursor rates_gap_cur is
1795: select l1.location_id, min(l1.effective_start_date) as effective_start_date,
1796: '01/01' as start_of_season, '12/31' as end_of_season
1797: from ap_pol_lines l1
1798: where l1.policy_id = l_policy_id
1799: and not exists
1800: (select 'Y'
1801: from ap_pol_lines l2

Line 1801: from ap_pol_lines l2

1797: from ap_pol_lines l1
1798: where l1.policy_id = l_policy_id
1799: and not exists
1800: (select 'Y'
1801: from ap_pol_lines l2
1802: where l2.policy_id = l1.policy_id
1803: and l2.location_id = l1.location_id
1804: and l2.effective_start_date = p_period_start_date
1805: and rownum = 1

Line 1820: from ap_pol_lines

1816: -- cursor for undefined conus rate
1817: -------------------------------
1818: cursor undefined_conus_rate_cur is
1819: select rate, '01/01' as start_of_season, '12/31' as end_of_season
1820: from ap_pol_lines
1821: where policy_id = l_policy_id
1822: and location_id = l_undefined_conus_location_id;
1823:
1824: undefined_conus_rate_rec undefined_conus_rate_cur%ROWTYPE;

Line 1831: from ap_pol_lines

1827: -- cursor for undefined location rate
1828: -------------------------------
1829: cursor undefined_loc_rate_cur is
1830: select rate, '01/01' as start_of_season, '12/31' as end_of_season
1831: from ap_pol_lines
1832: where policy_id = l_policy_id
1833: and location_id = l_undefined_location_id;
1834:
1835: undefined_loc_rate_rec undefined_loc_rate_cur%ROWTYPE;

Line 2479: update ap_pol_lines apl1

2475: p_schedule_period_id IN NUMBER) IS
2476:
2477: BEGIN
2478:
2479: update ap_pol_lines apl1
2480: set apl1.effective_end_date =
2481: (
2482: select min(apl2.effective_start_date)-1
2483: from ap_pol_lines apl2

Line 2483: from ap_pol_lines apl2

2479: update ap_pol_lines apl1
2480: set apl1.effective_end_date =
2481: (
2482: select min(apl2.effective_start_date)-1
2483: from ap_pol_lines apl2
2484: where apl2.policy_id = apl1.policy_id
2485: and apl2.schedule_period_id = apl1.schedule_period_id
2486: and apl2.policy_line_id <> apl1.policy_line_id
2487: and apl2.location_id = apl1.location_id

Line 2496: from ap_pol_lines apl3

2492: and apl1.effective_end_date is null
2493: and
2494: exists
2495: (select 'Y'
2496: from ap_pol_lines apl3
2497: where apl3.policy_id = apl1.policy_id
2498: and apl3.schedule_period_id = apl1.schedule_period_id
2499: and apl3.policy_line_id <> apl1.policy_line_id
2500: and apl3.location_id = apl1.location_id

Line 2621: from ap_pol_lines l1

2617: -------------------------------
2618: cursor rates_gap_cur is
2619: select l1.role_id, l1.location_id, min(l1.effective_start_date) as effective_start_date,
2620: '01/01' as start_of_season, '12/31' as end_of_season
2621: from ap_pol_lines l1
2622: where l1.policy_id = p_policy_id
2623: and not exists
2624: (select 'Y'
2625: from ap_pol_lines l2

Line 2625: from ap_pol_lines l2

2621: from ap_pol_lines l1
2622: where l1.policy_id = p_policy_id
2623: and not exists
2624: (select 'Y'
2625: from ap_pol_lines l2
2626: where l2.policy_id = l1.policy_id
2627: and nvl(l2.role_id, -1) = nvl(l1.role_id, -1)
2628: and l2.location_id = l1.location_id
2629: and l2.effective_start_date = p_period_start_date

Line 2645: from ap_pol_lines

2641: -- cursor for undefined conus rate
2642: -------------------------------
2643: cursor undefined_conus_rate_cur is
2644: select rate, '01/01' as start_of_season, '12/31' as end_of_season
2645: from ap_pol_lines
2646: where policy_id = p_policy_id
2647: and nvl(role_id, -1) = nvl(l_role_id, -1)
2648: and location_id = l_undefined_conus_location_id;
2649:

Line 2657: from ap_pol_lines

2653: -- cursor for undefined location rate
2654: -------------------------------
2655: cursor undefined_loc_rate_cur is
2656: select rate, '01/01' as start_of_season, '12/31' as end_of_season
2657: from ap_pol_lines
2658: where policy_id = p_policy_id
2659: and nvl(role_id, -1) = nvl(l_role_id, -1)
2660: and location_id = l_undefined_location_id;
2661: