APPS.EDW_METADATA_REFRESH dependencies on FND_DATE

Line 34: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );

30: if g_owb_schema is null then
31: g_owb_schema:='EDWREP';
32: end if;
33: log('OWB Schema '||g_owb_schema);
34: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
35: g_bis_owner:=get_db_user('BIS');
36: log('Bis owner= '||g_bis_owner);
37: if g_bis_owner is null then
38: raise_application_error(-20000,errbuf);

Line 41: --log('system time is '|| fnd_date.date_to_displaydt (sysdate) );

37: if g_bis_owner is null then
38: raise_application_error(-20000,errbuf);
39: return;
40: end if;
41: --log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
42: --l_stmt:='begin OWM_VIEW_UTILITIES.AUTO_SET_PRIMARY_SOURCE(false); end;';
43: --log(l_stmt);
44: --execute immediate l_stmt;
45: --commit;

Line 46: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );

42: --l_stmt:='begin OWM_VIEW_UTILITIES.AUTO_SET_PRIMARY_SOURCE(false); end;';
43: --log(l_stmt);
44: --execute immediate l_stmt;
45: --commit;
46: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
47:
48: /*******Bug 3008332******/
49: --Getting the operational tablespace
50: g_op_table_space:=fnd_profile.value('EDW_OP_TABLE_SPACE');

Line 84: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );

80: execute immediate l_stmt;
81: log('Session altered to : DISABLED PARALLEL QUERY');
82: /****************************************************/
83:
84: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
85: log('going to execute following sql statement ');
86: l_stmt:='insert into EDW_ALL_COLUMNS_MD (
87: ENTITY_ID,
88: ENTITY_TYPE,

Line 352: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );

348: end if;
349:
350: ------------ populate secondary tables ---------------------------
351:
352: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
353: log('going to execute following sql statement ');
354: l_stmt:='insert into edw_tables_md(
355: Elementid,
356: Name,

Line 932: return ' '||fnd_date.date_to_displaydt (sysdate);

928: End;
929:
930: function get_time return varchar2 is
931: Begin
932: return ' '||fnd_date.date_to_displaydt (sysdate);
933: Exception when others then
934: null;
935: End;
936:

Line 1598: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );

1594: procedure analyze_all is
1595: l_errbuf varchar2(2000);
1596: l_retcode varchar2(200);
1597: Begin
1598: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
1599: log('going to analyze metadata tables ');
1600: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ALL_COLUMNS_MD',10,1);
1601: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SETS_MD',10,1);
1602: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SET_COLUMN_MD',10,1);

Line 1638: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );

1634: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_TARGETS_MD',10,1);
1635: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_SEQUENCES_MD',10,1);
1636: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_VIEWS_MD',10,1);
1637: log('finish analyzing metadata tables.');
1638: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
1639: Exception when others then
1640: log('Error in analye_all '||sqlerrm);
1641: null;
1642: End;