eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_PTP_BASELINE_PKG dependencies on OPI_DBI_PTP_PLAN_F

Line 1069: p_object_name => 'OPI_DBI_PTP_PLAN_F'

1065: l_segment_num := 10;
1066: /* we don't truncate table here at first run. purge/deletion should be provided separately*/
1067:
1068: IF BIS_COLLECTION_UTILITIES.SETUP(
1069: p_object_name => 'OPI_DBI_PTP_PLAN_F'
1070: ) = false then
1071: BIS_COLLECTION_UTILITIES.put_line('Fail to initialize through BIS_COLLECTION_UTILITIES.SETUP.');
1072: retcode := g_error;
1073: errbuf := 'Program stops.';

Line 1590: delete from OPI_DBI_PTP_PLAN_F

1586: l_segment_num := 140;
1587: IF l_delete > 0 THEN
1588: BIS_COLLECTION_UTILITIES.put_line('Clean up data in baseline fact table.');
1589: BEGIN
1590: delete from OPI_DBI_PTP_PLAN_F
1591: where
1592: rowid in
1593: (select f.rowid
1594: from OPI_DBI_PTP_PLAN_F f,

Line 1594: from OPI_DBI_PTP_PLAN_F f,

1590: delete from OPI_DBI_PTP_PLAN_F
1591: where
1592: rowid in
1593: (select f.rowid
1594: from OPI_DBI_PTP_PLAN_F f,
1595: OPI_DBI_BASELINE_SCHEDULES sched
1596: where sched.next_collection_date <= g_sysdate
1597: and sched.schedule_type = 1
1598: and f.baseline_id = sched.baseline_id

Line 1614: insert /+ append parallel(OPI_DBI_PTP_PLAN_F) /

1610: l_segment_num := 150;
1611: IF l_archive > 0 THEN
1612: BIS_COLLECTION_UTILITIES.put_line('Archive data into baseline fact table.');
1613: BEGIN
1614: insert /*+ append parallel(OPI_DBI_PTP_PLAN_F) */
1615: into OPI_DBI_PTP_PLAN_F
1616: (
1617: ORGANIZATION_ID,
1618: BASELINE_ID,

Line 1615: into OPI_DBI_PTP_PLAN_F