APPS.HRI_OPL_REC_VAC dependencies on FND_DATE

Line 898: g_start_date := fnd_date.displaydt_to_date(

894: g_end_date IS NULL
895: THEN
896: -- log('Input dates NULL.');
897: --
898: g_start_date := fnd_date.displaydt_to_date(
899: hri_bpl_conc_log.get_last_collect_to_date(
900: g_cncrnt_prgrm_shrtnm
901: ,g_target_table));
902: --

Line 991: g_start_date := fnd_date.canonical_to_date(p_start_date);

987: output('PL/SQL Start: ' || to_char(sysdate,'HH24:MI:SS'));
988: --
989: -- Set globals
990: --
991: g_start_date := fnd_date.canonical_to_date(p_start_date);
992: g_end_date := fnd_date.canonical_to_date(p_end_date);
993: --
994: IF p_chunk_size IS NULL
995: THEN

Line 992: g_end_date := fnd_date.canonical_to_date(p_end_date);

988: --
989: -- Set globals
990: --
991: g_start_date := fnd_date.canonical_to_date(p_start_date);
992: g_end_date := fnd_date.canonical_to_date(p_end_date);
993: --
994: IF p_chunk_size IS NULL
995: THEN
996: --

Line 1127: l_start_date := fnd_date.date_to_canonical

1123: l_start_date := hri_oltp_conc_param.get_parameter_value
1124: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
1125: p_process_table_name => 'HRI_MB_REC_VACANCY_CT');
1126: ELSE
1127: l_start_date := fnd_date.date_to_canonical
1128: (fnd_date.displaydt_to_date
1129: (hri_bpl_conc_log.get_last_collect_to_date
1130: ('HRI_MB_REC_VACANCY_CT','HRI_MB_REC_VACANCY_CT')));
1131: END IF;

Line 1128: (fnd_date.displaydt_to_date

1124: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
1125: p_process_table_name => 'HRI_MB_REC_VACANCY_CT');
1126: ELSE
1127: l_start_date := fnd_date.date_to_canonical
1128: (fnd_date.displaydt_to_date
1129: (hri_bpl_conc_log.get_last_collect_to_date
1130: ('HRI_MB_REC_VACANCY_CT','HRI_MB_REC_VACANCY_CT')));
1131: END IF;
1132:

Line 1135: p_end_date => fnd_date.date_to_canonical(sysdate),

1131: END IF;
1132:
1133: load(p_chunk_size => to_number(null),
1134: p_start_date => l_start_date,
1135: p_end_date => fnd_date.date_to_canonical(sysdate),
1136: p_full_refresh => l_full_refresh);
1137: --
1138: EXCEPTION
1139: --