DBA Data[Home] [Help]

APPS.EDW_GEOGRAPHY_M_C dependencies on FND_DATE

Line 44: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');

40: END IF;
41:
42: EDW_COLLECTION_UTIL.get_dblink_names(g_source_link, g_target_link);
43:
44: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
45: l_from_date := fnd_date.displayDT_to_date(p_from_date);
46: l_to_date := fnd_date.displayDT_to_date(p_to_date);
47:
48: g_push_date_range1 := nvl(l_from_date,

Line 45: l_from_date := fnd_date.displayDT_to_date(p_from_date);

41:
42: EDW_COLLECTION_UTIL.get_dblink_names(g_source_link, g_target_link);
43:
44: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
45: l_from_date := fnd_date.displayDT_to_date(p_from_date);
46: l_to_date := fnd_date.displayDT_to_date(p_to_date);
47:
48: g_push_date_range1 := nvl(l_from_date,
49: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

Line 46: l_to_date := fnd_date.displayDT_to_date(p_to_date);

42: EDW_COLLECTION_UTIL.get_dblink_names(g_source_link, g_target_link);
43:
44: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
45: l_from_date := fnd_date.displayDT_to_date(p_from_date);
46: l_to_date := fnd_date.displayDT_to_date(p_to_date);
47:
48: g_push_date_range1 := nvl(l_from_date,
49: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
50: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);