APPS.POA_DBI_RCV_TXN_F_C dependencies on FND_DATE

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

58: l_start_date VARCHAR2(22);
59: l_end_date varchar2(22);
60: l_glob_date VARCHAR2(22);
61: /*
62: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
63: l_from_date := fnd_date.displayDT_to_date(p_from_date);
64: l_to_date := fnd_date.displayDT_to_date(p_to_date);
65: */
66: l_ret number;

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

59: l_end_date varchar2(22);
60: l_glob_date VARCHAR2(22);
61: /*
62: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
63: l_from_date := fnd_date.displayDT_to_date(p_from_date);
64: l_to_date := fnd_date.displayDT_to_date(p_to_date);
65: */
66: l_ret number;
67: l_batch_size NUMBER;

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

60: l_glob_date VARCHAR2(22);
61: /*
62: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
63: l_from_date := fnd_date.displayDT_to_date(p_from_date);
64: l_to_date := fnd_date.displayDT_to_date(p_to_date);
65: */
66: l_ret number;
67: l_batch_size NUMBER;
68: l_start_time DATE;

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

116: l_start_date := To_char(bis_common_parameters.get_global_start_date
117: , 'YYYY/MM/DD HH24:MI:SS');
118: d_start_date := bis_common_parameters.get_global_start_date;
119: ELSE
120: l_start_date := '''' || To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POARCVTXN')) - 0.004,'YYYY/MM/DD HH24:MI:SS') || '''';
121: /* note that if there is not a success record in the log, we should get global start date as l_start_date */
122: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POARCVTXN')) - 0.004;
123: END IF;
124:

Line 122: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POARCVTXN')) - 0.004;

118: d_start_date := bis_common_parameters.get_global_start_date;
119: ELSE
120: l_start_date := '''' || To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POARCVTXN')) - 0.004,'YYYY/MM/DD HH24:MI:SS') || '''';
121: /* note that if there is not a success record in the log, we should get global start date as l_start_date */
122: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POARCVTXN')) - 0.004;
123: END IF;
124:
125: l_end_date := '''' || To_char(Sysdate, 'YYYY/MM/DD HH24:MI:SS') || '''';
126: d_end_date := Sysdate;