APPS.OPI_DBI_WMS_RTP_F_C dependencies on FND_DATE

Line 81: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004,'YYYY/MM/DD HH24:MI:SS');

77: l_start_date := To_char(bis_common_parameters.get_global_start_date
78: , 'YYYY/MM/DD HH24:MI:SS');
79: d_start_date := bis_common_parameters.get_global_start_date;
80: ELSE
81: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004,'YYYY/MM/DD HH24:MI:SS');
82: /* note that if there is not a success record in the log, we should get global start date as l_start_date */
83: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004;
84: END IF;
85:

Line 83: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004;

79: d_start_date := bis_common_parameters.get_global_start_date;
80: ELSE
81: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004,'YYYY/MM/DD HH24:MI:SS');
82: /* note that if there is not a success record in the log, we should get global start date as l_start_date */
83: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004;
84: END IF;
85:
86: l_end_date := To_char(Sysdate, 'YYYY/MM/DD HH24:MI:SS');
87: d_end_date := Sysdate;