APPS.OPI_DBI_PTP_BASELINE_PKG dependencies on DBMS_MVIEW

Line 1145: DBMS_MVIEW.REFRESH('OPI_PTP_SUM_STG_MV','?',parallelism => g_degree);

1141: select stop_reason_code into l_refresh from opi_dbi_run_log_curr where etl_id = 7 and source = 1;
1142: IF l_refresh = 1 THEN
1143: BIS_COLLECTION_UTILITIES.put_line('re-synchronize OPI_PTP_SUM_STG_MV with OPI_DBI_PTP_PLAN_STG.');
1144: EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL QUERY';
1145: DBMS_MVIEW.REFRESH('OPI_PTP_SUM_STG_MV','?',parallelism => g_degree);
1146: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL QUERY';
1147: END IF;
1148: EXCEPTION
1149: WHEN NO_DATA_FOUND THEN

Line 1845: DBMS_MVIEW.REFRESH('OPI_PTP_SUM_STG_MV','?',parallelism => g_degree);

1841: --analyze table first per performance team's advice
1842: FND_STATS.GATHER_TABLE_STATS(errbuf,retcode,'OPI','OPI_DBI_PTP_PLAN_STG');
1843: BEGIN
1844: EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL QUERY';
1845: DBMS_MVIEW.REFRESH('OPI_PTP_SUM_STG_MV','?',parallelism => g_degree);
1846: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL QUERY';
1847: update opi_dbi_run_log_curr
1848: set stop_reason_code = 2
1849: where etl_id = 7 and source = 1;

Line 1917: dbms_mview.refresh('OPI_PTP_RPT_BND_MV',

1913: PROCEDURE REFRESH_RPT_BND_MV(errbuf in out NOCOPY varchar2, retcode in out NOCOPY varchar2)
1914: IS
1915: BEGIN
1916: -- very small mv. don't need parallelism, which will introduces unnecessary overhead
1917: dbms_mview.refresh('OPI_PTP_RPT_BND_MV',
1918: '?'
1919: );
1920:
1921: END REFRESH_RPT_BND_MV;

Line 1927: dbms_mview.refresh('OPI_PTP_CBN_MV',

1923: PROCEDURE REFRESH_CBN_MV(errbuf in out NOCOPY varchar2, retcode in out NOCOPY varchar2)
1924: IS
1925: BEGIN
1926:
1927: dbms_mview.refresh('OPI_PTP_CBN_MV',
1928: '?',
1929: parallelism => g_degree -- PARALLELISM
1930: );
1931:

Line 1939: dbms_mview.refresh('OPI_PTP_ITEM_F_MV',

1935: PROCEDURE REFRESH_ITEM_F_MV(errbuf in out NOCOPY varchar2, retcode in out NOCOPY varchar2)
1936: IS
1937: BEGIN
1938:
1939: dbms_mview.refresh('OPI_PTP_ITEM_F_MV',
1940: '?',
1941: parallelism => g_degree -- PARALLELISM
1942: );
1943:

Line 1951: dbms_mview.refresh('OPI_PTP_SUM_F_MV',

1947: PROCEDURE REFRESH_SUM_F_MV(errbuf in out NOCOPY varchar2, retcode in out NOCOPY varchar2)
1948: IS
1949: BEGIN
1950:
1951: dbms_mview.refresh('OPI_PTP_SUM_F_MV',
1952: '?',
1953: parallelism => g_degree -- PARALLELISM
1954: );
1955: END REFRESH_SUM_F_MV;

Line 1961: dbms_mview.refresh('OPI_PTP_SUM_STG_MV',

1957: PROCEDURE REFRESH_SUM_STG_MV(errbuf in out NOCOPY varchar2, retcode in out NOCOPY varchar2)
1958: IS
1959: BEGIN
1960:
1961: dbms_mview.refresh('OPI_PTP_SUM_STG_MV',
1962: '?',
1963: parallelism => g_degree -- PARALLELISM
1964: );
1965: END REFRESH_SUM_STG_MV;