DBA Data[Home] [Help]

APPS.FII_PA_UOM_CONV_F_C dependencies on EDW_LOG

Line 57: edw_log.put_line( 'The collection range is from '||

53: l_date1 := g_push_date_range1;
54: l_date2 := g_push_date_range2;
55:
56: if g_debug_flag = 'Y' then
57: edw_log.put_line( 'The collection range is from '||
58: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
59: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
60: edw_log.put_line(' ');
61: end if;

Line 60: edw_log.put_line(' ');

56: if g_debug_flag = 'Y' then
57: edw_log.put_line( 'The collection range is from '||
58: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
59: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
60: edw_log.put_line(' ');
61: end if;
62:
63: -- -----------------------------------------------------------------------------
64: -- Start of Collection , Developer Customizable Section

Line 68: edw_log.put_line(' ');

64: -- Start of Collection , Developer Customizable Section
65: -- -----------------------------------------------------------------------------
66:
67: if g_debug_flag = 'Y' then
68: edw_log.put_line(' ');
69: edw_log.put_line('Pushing data');
70: end if;
71:
72: l_temp_date := sysdate;

Line 69: edw_log.put_line('Pushing data');

65: -- -----------------------------------------------------------------------------
66:
67: if g_debug_flag = 'Y' then
68: edw_log.put_line(' ');
69: edw_log.put_line('Pushing data');
70: end if;
71:
72: l_temp_date := sysdate;
73:

Line 144: edw_log.put_line('Inserted ' || to_char(l_rows_inserted) ||

140: l_rows_inserted := nvl(sql%rowcount,0);
141: l_duration := sysdate - l_temp_date;
142:
143: if g_debug_flag = 'Y' then
144: edw_log.put_line('Inserted ' || to_char(l_rows_inserted) ||
145: ' rows into the staging table');
146: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
147: edw_log.put_line(' ');
148: end if;

Line 146: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

142:
143: if g_debug_flag = 'Y' then
144: edw_log.put_line('Inserted ' || to_char(l_rows_inserted) ||
145: ' rows into the staging table');
146: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
147: edw_log.put_line(' ');
148: end if;
149:
150: -- ---------------------------------------------------------------------------

Line 147: edw_log.put_line(' ');

143: if g_debug_flag = 'Y' then
144: edw_log.put_line('Inserted ' || to_char(l_rows_inserted) ||
145: ' rows into the staging table');
146: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
147: edw_log.put_line(' ');
148: end if;
149:
150: -- ---------------------------------------------------------------------------
151: -- END OF Collection , Developer Customizable Section