APPS.POA_DBI_PO_DIST_F_C dependencies on FND_DATE

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

70: l_start_date VARCHAR2(22);
71: l_end_date varchar2(22);
72: l_glob_date VARCHAR2(22);
73: /*
74: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
75: l_from_date := fnd_date.displayDT_to_date(p_from_date);
76: l_to_date := fnd_date.displayDT_to_date(p_to_date);
77: */
78: l_ret number;

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

71: l_end_date varchar2(22);
72: l_glob_date VARCHAR2(22);
73: /*
74: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
75: l_from_date := fnd_date.displayDT_to_date(p_from_date);
76: l_to_date := fnd_date.displayDT_to_date(p_to_date);
77: */
78: l_ret number;
79: l_batch_size NUMBER;

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

72: l_glob_date VARCHAR2(22);
73: /*
74: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
75: l_from_date := fnd_date.displayDT_to_date(p_from_date);
76: l_to_date := fnd_date.displayDT_to_date(p_to_date);
77: */
78: l_ret number;
79: l_batch_size NUMBER;
80: l_start_time DATE;

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

123: l_start_date := To_char(bis_common_parameters.get_global_start_date
124: , 'YYYY/MM/DD HH24:MI:SS');
125: d_start_date := bis_common_parameters.get_global_start_date;
126: ELSE
127: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAPODIST')) - 0.004,'YYYY/MM/DD HH24:MI:SS');
128: /* note that if there is not a success record in the log, we should get global start date as l_start_date */
129: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAPODIST')) - 0.004;
130: END IF;
131:

Line 129: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAPODIST')) - 0.004;

125: d_start_date := bis_common_parameters.get_global_start_date;
126: ELSE
127: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAPODIST')) - 0.004,'YYYY/MM/DD HH24:MI:SS');
128: /* note that if there is not a success record in the log, we should get global start date as l_start_date */
129: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAPODIST')) - 0.004;
130: END IF;
131:
132:
133: l_end_date := To_char(Sysdate, 'YYYY/MM/DD HH24:MI:SS');