APPS.AP_WEB_UPLOAD_PDM_PKG dependencies on AP_POL_SCHEDULE_PERIODS

Line 910: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL

906: l_schedule_period_id NUMBER(15);
907:
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

Line 914: insert into AP_POL_SCHEDULE_PERIODS

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,
917: SCHEDULE_PERIOD_NAME,
918: POLICY_ID,

Line 1309: from ap_pol_schedule_periods

1305: ------------------------------------------------------------------------
1306:
1307: cursor schedule_period_cur is
1308: select schedule_period_id
1309: from ap_pol_schedule_periods
1310: where policy_id = p_policy_id
1311: and rownum = 1;
1312:
1313: schedule_period_rec schedule_period_cur%ROWTYPE;

Line 1411: from ap_pol_schedule_periods

1407: ------------------------------------------------------------------------
1408:
1409: CURSOR period_cur IS
1410: select schedule_period_id
1411: from ap_pol_schedule_periods
1412: where policy_id = p_policy_id
1413: and upper(schedule_period_name) = upper(p_period_name)
1414: and start_date = p_period_start_date
1415: and rownum = 1;

Line 1447: from ap_pol_schedule_periods

1443: ------------------------------------------------------------------------
1444:
1445: CURSOR latest_period_cur IS
1446: select max(start_date) as start_date
1447: from ap_pol_schedule_periods
1448: where policy_id = p_policy_id
1449: and rownum = 1;
1450:
1451: latest_period_rec latest_period_cur%ROWTYPE;

Line 2667: update ap_pol_schedule_periods

2663:
2664: --
2665: put_line('End date current open Schedule Period');
2666: --
2667: update ap_pol_schedule_periods
2668: set end_date = p_period_start_date - 1
2669: where policy_id = p_policy_id
2670: and end_date is null;
2671: