DBA Data[Home] [Help]

APPS.EDW_GL_ACCT_M_C dependencies on EDW_COLLECTION_UTIL

Line 1232: EDW_COLLECTION_UTIL.get_dblink_names(l_source_link, g_target_link);

1228: INITDEBUG;
1229:
1230:
1231: -- get databaselink
1232: EDW_COLLECTION_UTIL.get_dblink_names(l_source_link, g_target_link);
1233:
1234: l_from_date :=fnd_date.canonical_to_date(p_from_date);
1235: l_to_date :=fnd_date.canonical_to_date(p_to_date);
1236:

Line 1260: IF (Not EDW_COLLECTION_UTIL.setup(g_dimension_name)) THEN

1256: l_source_temp_table_name:='EDW_VBH_TEMP'||p_dimension_no;
1257: l_target_temp_table_name := l_source_temp_table_name || '@' || g_target_link;
1258:
1259:
1260: IF (Not EDW_COLLECTION_UTIL.setup(g_dimension_name)) THEN
1261: VBHDEBUG('setup failed');
1262: errbuf := fnd_message.get;
1263: Return;
1264: END IF;

Line 1277: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

1273: edw_log.put_line('Dimension number '|| p_dimension_no);
1274: edw_log.put_line('Dimension physical name : '||g_dimension_name);
1275:
1276: EDW_GL_ACCT_M_C.g_push_date_range1 := nvl(l_from_date,
1277: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1278: EDW_GL_ACCT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1279: EDW_LOG.PUT_LINE( 'The collection range is from '||to_char(EDW_GL_ACCT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||to_char(EDW_GL_ACCT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
1280: EDW_LOG.PUT_LINE(' ');
1281:

Line 1278: EDW_GL_ACCT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

1274: edw_log.put_line('Dimension physical name : '||g_dimension_name);
1275:
1276: EDW_GL_ACCT_M_C.g_push_date_range1 := nvl(l_from_date,
1277: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1278: EDW_GL_ACCT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1279: EDW_LOG.PUT_LINE( 'The collection range is from '||to_char(EDW_GL_ACCT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||to_char(EDW_GL_ACCT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
1280: EDW_LOG.PUT_LINE(' ');
1281:
1282: select FND_PROFILE.VALUE('EDW_PARALLEL_SRC') into g_parallel_level from dual;

Line 1482: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count - l_dups_removed ,null,g_push_date_range1, g_push_date_range2);

1478:
1479: -- ---------------------------------------------------------------------------
1480: -- END OF Collection , Developer Customizable Section
1481: -- ---------------------------------------------------------------------------
1482: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count - l_dups_removed ,null,g_push_date_range1, g_push_date_range2);
1483:
1484:
1485:
1486: Exception

Line 1493: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_GL_ACCT_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);

1489: Retcode:=sqlcode;
1490: l_exception_msg := Retcode || ':' || Errbuf;
1491: EDW_GL_ACCT_M_C.g_exception_msg := l_exception_msg;
1492: rollback;
1493: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_GL_ACCT_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);
1494:
1495: End push;
1496:
1497: END EDW_GL_ACCT_M_C ;