DBA Data[Home] [Help]

APPS.EDW_LOOKUP_M_C dependencies on FND_DATE

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

25: errbuf := fnd_message.get;
26: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
27: End If;
28:
29: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
30: l_from_date := fnd_date.displayDT_to_date(p_from_date);
31: l_to_date := fnd_date.displayDT_to_date(p_to_date);
32:
33: l_push_date_range1 := nvl(l_from_date,

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

26: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
27: End If;
28:
29: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
30: l_from_date := fnd_date.displayDT_to_date(p_from_date);
31: l_to_date := fnd_date.displayDT_to_date(p_to_date);
32:
33: l_push_date_range1 := nvl(l_from_date,
34: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

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

27: End If;
28:
29: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
30: l_from_date := fnd_date.displayDT_to_date(p_from_date);
31: l_to_date := fnd_date.displayDT_to_date(p_to_date);
32:
33: l_push_date_range1 := nvl(l_from_date,
34: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
35: l_push_date_range2 := nvl(l_to_date, EDW_COLLECTION_UTIL.G_local_curr_push_start_date);