APPS.EDW_FLEX_PUSH_C dependencies on EDW_COLLECTION_UTIL

Line 37: EDW_COLLECTION_UTIL.get_dblink_names(l_source_link, l_target_link);

33: g_dimension := p_dimension;
34:
35: /* should ideally change the value set to pass short names */
36: -- get databaselink
37: EDW_COLLECTION_UTIL.get_dblink_names(l_source_link, l_target_link);
38:
39: stmt:= 'SELECT dim_name from edw_dimensions_md_v@'|| l_target_link ||
40: ' where dim_long_name = :longname';
41:

Line 53: IF (Not EDW_COLLECTION_UTIL.setup(g_dimension)) THEN

49:
50:
51: g_index := substr(g_dimension, 13 , instr(g_dimension, '_M') - 13 );
52:
53: IF (Not EDW_COLLECTION_UTIL.setup(g_dimension)) THEN
54: errbuf := fnd_message.get;
55: Return;
56: END IF;
57:

Line 59: g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -

55: Return;
56: END IF;
57:
58: IF (p_from_date IS NULL) THEN
59: g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
60: EDW_COLLECTION_UTIL.g_offset;
61: ELSE
62: g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
63: END IF;

Line 60: EDW_COLLECTION_UTIL.g_offset;

56: END IF;
57:
58: IF (p_from_date IS NULL) THEN
59: g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
60: EDW_COLLECTION_UTIL.g_offset;
61: ELSE
62: g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
63: END IF;
64:

Line 66: g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

62: g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
63: END IF;
64:
65: IF (p_to_date IS NULL) THEN
66: g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
67: ELSE
68: g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
69: END IF;
70:

Line 92: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);

88: Push_Levels(g_push_date_range1, g_push_date_range2);
89:
90: l_duration := sysdate - l_temp_date;
91:
92: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);
93:
94: edw_log.put_line('Total rows inserted for '||g_dimension||' : '||g_row_count);
95: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
96: edw_log.put_line(' ');

Line 106: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_FLEX_PUSH_C.g_exception_msg,

102: Retcode:=sqlcode;
103: l_exception_msg := Retcode || ':' || Errbuf;
104: EDW_FLEX_PUSH_C.g_exception_msg := l_exception_msg;
105: rollback;
106: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_FLEX_PUSH_C.g_exception_msg,
107: g_push_date_range1, g_push_date_range2);
108:
109: commit;
110: End;

Line 134: EDW_COLLECTION_UTIL.get_dblink_names(l_source_link, l_target_link);

130:
131: edw_log.put_line('Starting Push For EDW_FLEX_DIM'||g_index||'_L'||p_level||'_LSTG');
132:
133: -- get databaselink
134: EDW_COLLECTION_UTIL.get_dblink_names(l_source_link, l_target_link);
135:
136: stmt := 'Insert Into EDW_FLEX_DIM'||
137: g_index||'_L'||p_level||'_LSTG@' || l_target_link || '(
138: NAME, INSTANCE, '||