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,
771: BEGIN
772:
773: select AP_POL_HEADERS_S.NEXTVAL
774: into l_policy_id
775: from dual;
776:
777: insert into AP_POL_HEADERS
778: (
779: POLICY_ID,
869: BEGIN
870:
871: select AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL
872: into l_schedule_option_id
873: from dual;
874:
875: insert into AP_POL_SCHEDULE_OPTIONS
876: (
877: SCHEDULE_OPTION_ID,
929: BEGIN
930:
931: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL
932: into l_schedule_period_id
933: from dual;
934:
935: insert into AP_POL_SCHEDULE_PERIODS
936: (
937: SCHEDULE_PERIOD_ID,
1006: BEGIN
1007:
1008: select AP_POL_LINES_S.NEXTVAL
1009: into l_policy_line_id
1010: from dual;
1011:
1012:
1013: insert into AP_POL_LINES
1014: (
1151: BEGIN
1152:
1153: select AP_POL_LINES_S.NEXTVAL
1154: into l_night_rate_line_id
1155: from dual;
1156:
1157:
1158: insert into AP_POL_LINES
1159: (