APPS.OPI_DBI_PTP_BASELINE_PKG dependencies on OPI_DBI_BASELINE_DEFINITIONS

Line 1055: from OPI_DBI_BASELINE_DEFINITIONS def,

1051: cursor l_baseline_info is
1052: select def.baseline_id,
1053: def.data_start_date,
1054: sched.from_date
1055: from OPI_DBI_BASELINE_DEFINITIONS def,
1056: OPI_DBI_BASELINE_SCHEDULES sched
1057: where def.baseline_id = sched.baseline_id
1058: and sched.next_collection_date <= trunc(sysdate)
1059: and sched.schedule_type = 1

Line 1297: from OPI_DBI_BASELINE_DEFINITIONS def,

1293: RPAD(setup.plan_name, 20, ' ') || ' ' ||
1294: RPAD(TO_CHAR(sched.from_date, 'DD-MON-YYYY'), 20, ' ') || ' ' ||
1295: RPAD(TO_CHAR(plan.data_start_date, 'DD-MON-YYYY'), 20, ' ')
1296: bulk collect into l_strings
1297: from OPI_DBI_BASELINE_DEFINITIONS def,
1298: OPI_DBI_BASELINE_SCHEDULES sched,
1299: OPI_DBI_BASELINE_PLANS setup,
1300: ISC_DBI_PLANS plan
1301: where def.baseline_id = sched.baseline_id

Line 1320: lock table opi_dbi_baseline_definitions in exclusive mode;

1316:
1317: --lock schedules to be processed
1318: BIS_COLLECTION_UTILITIES.put_line('Lock rows of schedules to be processed.');
1319: l_segment_num := 60;
1320: lock table opi_dbi_baseline_definitions in exclusive mode;
1321:
1322:
1323: --start loading new data
1324: BIS_COLLECTION_UTILITIES.put_line('Start loading new data');

Line 1330: OPI_DBI_BASELINE_DEFINITIONS def

1326: BEGIN
1327: select def.baseline_name, sched.baseline_id, def.last_collected_date
1328: bulk collect into l_strings, l_baseline_ids, l_collected_dates
1329: from OPI_DBI_BASELINE_SCHEDULES sched,
1330: OPI_DBI_BASELINE_DEFINITIONS def
1331: where sched.next_collection_date <= g_sysdate
1332: and sched.schedule_type = 1
1333: and def.baseline_id = sched.baseline_id
1334: ;

Line 1572: from OPI_DBI_BASELINE_DEFINITIONS def,

1568: BEGIN
1569: select SUM(decode(sign(sched.from_date - def.last_from_date), -1, 1, 0)) del_cnt,
1570: SUM(decode(sign(sched.from_date - def.last_from_date), 1, 1, 0)) arv_cnt
1571: into l_delete, l_archive
1572: from OPI_DBI_BASELINE_DEFINITIONS def,
1573: OPI_DBI_BASELINE_SCHEDULES sched
1574: where sched.next_collection_date <= g_sysdate
1575: and sched.schedule_type = 1
1576: and sched.baseline_id = def.baseline_id

Line 1709: from OPI_DBI_BASELINE_DEFINITIONS def,

1705: g_last_updated_by,
1706: g_sysdate,
1707: g_last_updated_by,
1708: g_last_update_login
1709: from OPI_DBI_BASELINE_DEFINITIONS def,
1710: OPI_DBI_BASELINE_SCHEDULES sched,
1711: OPI_DBI_BASELINE_PLANS setup,
1712: ISC_DBI_PLANS plan,
1713: ISC_DBI_PLAN_ORGANIZATIONS orgs

Line 1724: update OPI_DBI_BASELINE_DEFINITIONS def

1720: and plan.plan_id = orgs.plan_id
1721: ;
1722:
1723: l_segment_num := 180;
1724: update OPI_DBI_BASELINE_DEFINITIONS def
1725: set (data_start_date, last_collected_date, last_from_date, last_to_date, last_update_date, last_updated_by, last_update_login)
1726: =
1727: (select nvl(def.data_start_date, sched.FROM_DATE),
1728: g_sysdate,

Line 1814: update OPI_DBI_BASELINE_DEFINITIONS def

1810: and conv.from_date = l_baseline_record.data_start_date
1811: ;
1812:
1813: l_segment_num := 200;
1814: update OPI_DBI_BASELINE_DEFINITIONS def
1815: set data_start_date = last_from_date
1816: where baseline_id = l_baseline_record.baseline_id
1817: ;
1818: END IF;