APPS.OKC_ARTICLES_IMPORT_GRP dependencies on FND_DATE

Line 429: fnd_date.date_to_displaydt( a.start_date, FND_DATE.calendar_aware_alt) start_date,

425: CURSOR get_info_csr IS
426: SELECT a.source_file_name,
427: nvl(hr.name,' ') org_name,
428: --to_char( a.start_date,'DD-MON-YYYY HH24:MI:SS') start_date,
429: fnd_date.date_to_displaydt( a.start_date, FND_DATE.calendar_aware_alt) start_date,
430: f.meaning validate_meaning,
431: nvl(f1.meaning,' ') global_flag_meaning,
432: nvl(f2.meaning,' ') status_meaning
433: FROM OKC_ART_INT_BATPROCS_ALL a,

Line 450: fnd_date.date_to_displaydt( a.start_date, FND_DATE.calendar_aware_alt) start_date,

446:
447: -- For Non-XML Based Clause Import (Old Import)
448: CURSOR get_old_info_csr IS
449: SELECT
450: fnd_date.date_to_displaydt( a.start_date, FND_DATE.calendar_aware_alt) start_date,
451: f.meaning validate_meaning,a.fetch_size
452: FROM OKC_ART_INT_BATPROCS_ALL a,
453: fnd_lookups f
454: WHERE a.validate_only_yn = f.lookup_code

Line 588: l_start_date := nvl(fnd_date.canonical_to_date(p_start_date),

584: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
585: RAISE FND_API.G_EXC_ERROR;
586: END IF;
587:
588: l_start_date := nvl(fnd_date.canonical_to_date(p_start_date),
589: to_date('01-01-0001', 'DD-MM-YYYY'));
590: l_end_date := nvl(fnd_date.canonical_to_date(p_end_date), sysdate+1);
591:
592:

Line 590: l_end_date := nvl(fnd_date.canonical_to_date(p_end_date), sysdate+1);

586: END IF;
587:
588: l_start_date := nvl(fnd_date.canonical_to_date(p_start_date),
589: to_date('01-01-0001', 'DD-MM-YYYY'));
590: l_end_date := nvl(fnd_date.canonical_to_date(p_end_date), sysdate+1);
591:
592:
593: IF ( p_end_date is NULL
594: AND p_start_date is NULL