DBA Data[Home] [Help]

APPS.OPI_EDW_COLLECT_MBI_FACTS_F_C dependencies on EDW_COLLECTION_UTIL

Line 20: edw_log.put_line('call EDW_COLLECTION_UTIL ');

16: Errbuf :=NULL;
17: Retcode:=0;
18:
19: edw_log.put_line(' ');
20: edw_log.put_line('call EDW_COLLECTION_UTIL ');
21: -- -------------------------------------------
22: -- call edw_collection_util.setup
23: -- -------------------------------------------
24: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,

Line 22: -- call edw_collection_util.setup

18:
19: edw_log.put_line(' ');
20: edw_log.put_line('call EDW_COLLECTION_UTIL ');
21: -- -------------------------------------------
22: -- call edw_collection_util.setup
23: -- -------------------------------------------
24: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,
25: l_staging_table,
26: l_staging_table,

Line 24: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,

20: edw_log.put_line('call EDW_COLLECTION_UTIL ');
21: -- -------------------------------------------
22: -- call edw_collection_util.setup
23: -- -------------------------------------------
24: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,
25: l_staging_table,
26: l_staging_table,
27: l_exception_msg)) THEN
28: errbuf := fnd_message.get;

Line 46: EDW_COLLECTION_UTIL.G_local_last_push_start_date -

42: -- date is NULL.
43: -- --------------------------------------------
44:
45: l_from_date := nvl(l_from_date,
46: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
47: EDW_COLLECTION_UTIL.g_offset);
48: l_to_date := nvl(l_to_date,
49: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
50: -- End of code change for bug fix 2140267.

Line 47: EDW_COLLECTION_UTIL.g_offset);

43: -- --------------------------------------------
44:
45: l_from_date := nvl(l_from_date,
46: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
47: EDW_COLLECTION_UTIL.g_offset);
48: l_to_date := nvl(l_to_date,
49: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
50: -- End of code change for bug fix 2140267.
51: IF l_fact_name = 'OPI_EDW_INV_DAILY_STAT_F' THEN

Line 49: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

45: l_from_date := nvl(l_from_date,
46: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
47: EDW_COLLECTION_UTIL.g_offset);
48: l_to_date := nvl(l_to_date,
49: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
50: -- End of code change for bug fix 2140267.
51: IF l_fact_name = 'OPI_EDW_INV_DAILY_STAT_F' THEN
52: edw_log.put_line(' ');
53: -- edw_log.put_line(' Start of Collect Process Inventory Daily Status ');