211: IF p_tdate IS NOT NULL AND p_fdate IS NOT NULL THEN
212:
213: /* B5857203, Rajesh Patangya ONDEMAND:ASCP/OPM BATCH RELEASE FAILURE * ORA-06550 */
214:
215: l_from_date := fnd_date.canonical_to_date(p_fdate);
216: l_to_date := fnd_date.canonical_to_date(p_tdate);
217:
218: -- l_from_date := fnd_date.charDT_to_date(p_fdate);
219: -- l_to_date := fnd_date.charDT_to_date(p_tdate);
212:
213: /* B5857203, Rajesh Patangya ONDEMAND:ASCP/OPM BATCH RELEASE FAILURE * ORA-06550 */
214:
215: l_from_date := fnd_date.canonical_to_date(p_fdate);
216: l_to_date := fnd_date.canonical_to_date(p_tdate);
217:
218: -- l_from_date := fnd_date.charDT_to_date(p_fdate);
219: -- l_to_date := fnd_date.charDT_to_date(p_tdate);
220:
214:
215: l_from_date := fnd_date.canonical_to_date(p_fdate);
216: l_to_date := fnd_date.canonical_to_date(p_tdate);
217:
218: -- l_from_date := fnd_date.charDT_to_date(p_fdate);
219: -- l_to_date := fnd_date.charDT_to_date(p_tdate);
220:
221: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
222: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
215: l_from_date := fnd_date.canonical_to_date(p_fdate);
216: l_to_date := fnd_date.canonical_to_date(p_tdate);
217:
218: -- l_from_date := fnd_date.charDT_to_date(p_fdate);
219: -- l_to_date := fnd_date.charDT_to_date(p_tdate);
220:
221: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
222: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
223: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);