346: */
347:
348: select ap_pol_locations_s.nextval
349: into l_location_id
350: from dual;
351:
352: insert into AP_POL_LOCATIONS_B (
353: LOCATION_ID,
354: TERRITORY_CODE,
750: BEGIN
751:
752: select AP_POL_HEADERS_S.NEXTVAL
753: into l_policy_id
754: from dual;
755:
756: insert into AP_POL_HEADERS
757: (
758: POLICY_ID,
848: BEGIN
849:
850: select AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL
851: into l_schedule_option_id
852: from dual;
853:
854: insert into AP_POL_SCHEDULE_OPTIONS
855: (
856: SCHEDULE_OPTION_ID,
908: BEGIN
909:
910: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL
911: into l_schedule_period_id
912: from dual;
913:
914: insert into AP_POL_SCHEDULE_PERIODS
915: (
916: SCHEDULE_PERIOD_ID,
985: BEGIN
986:
987: select AP_POL_LINES_S.NEXTVAL
988: into l_policy_line_id
989: from dual;
990:
991:
992: insert into AP_POL_LINES
993: (
1129: BEGIN
1130:
1131: select AP_POL_LINES_S.NEXTVAL
1132: into l_night_rate_line_id
1133: from dual;
1134:
1135:
1136: insert into AP_POL_LINES
1137: (