APPS.AP_WEB_UPLOAD_PDM_PKG dependencies on AP_POL_SCHEDULE_PERIODS

Line 931: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL

927: l_schedule_period_id NUMBER(15);
928:
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

Line 935: insert into AP_POL_SCHEDULE_PERIODS

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,
938: SCHEDULE_PERIOD_NAME,
939: POLICY_ID,

Line 1331: from ap_pol_schedule_periods

1327: ------------------------------------------------------------------------
1328:
1329: cursor schedule_period_cur is
1330: select schedule_period_id
1331: from ap_pol_schedule_periods
1332: where policy_id = p_policy_id
1333: and rownum = 1;
1334:
1335: schedule_period_rec schedule_period_cur%ROWTYPE;

Line 1433: from ap_pol_schedule_periods

1429: ------------------------------------------------------------------------
1430:
1431: CURSOR period_cur IS
1432: select schedule_period_id
1433: from ap_pol_schedule_periods
1434: where policy_id = p_policy_id
1435: and upper(schedule_period_name) = upper(p_period_name)
1436: and start_date = p_period_start_date
1437: and rownum = 1;

Line 1469: from ap_pol_schedule_periods

1465: ------------------------------------------------------------------------
1466:
1467: CURSOR latest_period_cur IS
1468: select max(start_date) as start_date
1469: from ap_pol_schedule_periods
1470: where policy_id = p_policy_id
1471: and rownum = 1;
1472:
1473: latest_period_rec latest_period_cur%ROWTYPE;

Line 2696: update ap_pol_schedule_periods

2692:
2693: --
2694: put_line('End date current open Schedule Period');
2695: --
2696: update ap_pol_schedule_periods
2697: set end_date = p_period_start_date - 1
2698: where policy_id = p_policy_id
2699: and end_date is null;
2700: