DBA Data[Home] [Help]

APPS.BEN_ICD_ELEMENT_ENTRY_PKG dependencies on FND_DATE

Line 207: l_entry_value1 := fnd_date.date_to_displaydate(to_date(p_entry_value1,'YYYY/MM/DD HH24:MI:SS'));

203: for l_input_value in c_input_values loop
204: if(p_input_value_id1 = l_input_value.input_value_id ) then
205: -- the format coming in is already canonical but the api is expecting a user format
206: if( 'D' = l_input_value.uom) then
207: l_entry_value1 := fnd_date.date_to_displaydate(to_date(p_entry_value1,'YYYY/MM/DD HH24:MI:SS'));
208: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
209: l_entry_value1 := replace(p_entry_value1,'.',',');
210: else
211: l_entry_value1 := p_entry_value1;

Line 215: l_entry_value2 := fnd_date.date_to_displaydate(to_date(p_entry_value2,'YYYY/MM/DD HH24:MI:SS'));

211: l_entry_value1 := p_entry_value1;
212: end if ;
213: elsif(p_input_value_id2 = l_input_value.input_value_id ) then
214: if( 'D' = l_input_value.uom) then
215: l_entry_value2 := fnd_date.date_to_displaydate(to_date(p_entry_value2,'YYYY/MM/DD HH24:MI:SS'));
216: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
217: l_entry_value2 := replace(p_entry_value2,'.',',');
218: else
219: l_entry_value2 := p_entry_value2;

Line 224: l_entry_value3 := fnd_date.date_to_displaydate(to_date(p_entry_value3,'YYYY/MM/DD HH24:MI:SS'));

220: end if ;
221:
222: elsif(p_input_value_id3 = l_input_value.input_value_id) then
223: if( 'D' = l_input_value.uom) then
224: l_entry_value3 := fnd_date.date_to_displaydate(to_date(p_entry_value3,'YYYY/MM/DD HH24:MI:SS'));
225: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
226: l_entry_value3 := replace(p_entry_value3,'.',',');
227: else
228: l_entry_value3 := p_entry_value3;

Line 233: l_entry_value4 := fnd_date.date_to_displaydate(to_date(p_entry_value4,'YYYY/MM/DD HH24:MI:SS'));

229: end if ;
230:
231: elsif(p_input_value_id4 = l_input_value.input_value_id) then
232: if( 'D' = l_input_value.uom) then
233: l_entry_value4 := fnd_date.date_to_displaydate(to_date(p_entry_value4,'YYYY/MM/DD HH24:MI:SS'));
234: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
235: l_entry_value4 := replace(p_entry_value4,'.',',');
236: else
237: l_entry_value4 := p_entry_value4;

Line 242: l_entry_value5 := fnd_date.date_to_displaydate(to_date(p_entry_value5,'YYYY/MM/DD HH24:MI:SS'));

238: end if ;
239:
240: elsif(p_input_value_id5 = l_input_value.input_value_id) then
241: if( 'D' = l_input_value.uom) then
242: l_entry_value5 := fnd_date.date_to_displaydate(to_date(p_entry_value5,'YYYY/MM/DD HH24:MI:SS'));
243: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
244: l_entry_value5 := replace(p_entry_value5,'.',',');
245: else
246: l_entry_value5 := p_entry_value5;

Line 251: l_entry_value6 := fnd_date.date_to_displaydate(to_date(p_entry_value6,'YYYY/MM/DD HH24:MI:SS'));

247: end if ;
248:
249: elsif(p_input_value_id6 = l_input_value.input_value_id) then
250: if( 'D' = l_input_value.uom) then
251: l_entry_value6 := fnd_date.date_to_displaydate(to_date(p_entry_value6,'YYYY/MM/DD HH24:MI:SS'));
252: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
253: l_entry_value6 := replace(p_entry_value6,'.',',');
254: else
255: l_entry_value6 := p_entry_value6;

Line 260: l_entry_value7 := fnd_date.date_to_displaydate(to_date(p_entry_value7,'YYYY/MM/DD HH24:MI:SS'));

256: end if ;
257:
258: elsif(p_input_value_id7 = l_input_value.input_value_id ) then
259: if( 'D' = l_input_value.uom) then
260: l_entry_value7 := fnd_date.date_to_displaydate(to_date(p_entry_value7,'YYYY/MM/DD HH24:MI:SS'));
261: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
262: l_entry_value7 := replace(p_entry_value7,'.',',');
263: else
264: l_entry_value7 := p_entry_value7;

Line 269: l_entry_value8 := fnd_date.date_to_displaydate(to_date(p_entry_value8,'YYYY/MM/DD HH24:MI:SS'));

265: end if ;
266:
267: elsif(p_input_value_id8 = l_input_value.input_value_id) then
268: if( 'D' = l_input_value.uom) then
269: l_entry_value8 := fnd_date.date_to_displaydate(to_date(p_entry_value8,'YYYY/MM/DD HH24:MI:SS'));
270: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
271: l_entry_value8 := replace(p_entry_value8,'.',',');
272: else
273: l_entry_value8 := p_entry_value8;

Line 278: l_entry_value9 := fnd_date.date_to_displaydate(to_date(p_entry_value9,'YYYY/MM/DD HH24:MI:SS'));

274: end if ;
275:
276: elsif(p_input_value_id9 = l_input_value.input_value_id) then
277: if( 'D' = l_input_value.uom) then
278: l_entry_value9 := fnd_date.date_to_displaydate(to_date(p_entry_value9,'YYYY/MM/DD HH24:MI:SS'));
279: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
280: l_entry_value9 := replace(p_entry_value9,'.',',');
281: else
282: l_entry_value9 := p_entry_value9;

Line 286: l_entry_value10 := fnd_date.date_to_displaydate(to_date(p_entry_value10,'YYYY/MM/DD HH24:MI:SS'));

282: l_entry_value9 := p_entry_value9;
283: end if ;
284: elsif(p_input_value_id10 = l_input_value.input_value_id) then
285: if( 'D' = l_input_value.uom) then
286: l_entry_value10 := fnd_date.date_to_displaydate(to_date(p_entry_value10,'YYYY/MM/DD HH24:MI:SS'));
287: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
288: l_entry_value10 := replace(p_entry_value10,'.',',');
289: else
290: l_entry_value10 := p_entry_value10;

Line 294: l_entry_value11 := fnd_date.date_to_displaydate(to_date(p_entry_value11,'YYYY/MM/DD HH24:MI:SS'));

290: l_entry_value10 := p_entry_value10;
291: end if ;
292: elsif(p_input_value_id11 = l_input_value.input_value_id) then
293: if( 'D' = l_input_value.uom) then
294: l_entry_value11 := fnd_date.date_to_displaydate(to_date(p_entry_value11,'YYYY/MM/DD HH24:MI:SS'));
295: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
296: l_entry_value11 := replace(p_entry_value11,'.',',');
297: else
298: l_entry_value11 := p_entry_value11;

Line 302: l_entry_value12 := fnd_date.date_to_displaydate(to_date(p_entry_value12,'YYYY/MM/DD HH24:MI:SS'));

298: l_entry_value11 := p_entry_value11;
299: end if ;
300: elsif(p_input_value_id12 = l_input_value.input_value_id) then
301: if( 'D' = l_input_value.uom) then
302: l_entry_value12 := fnd_date.date_to_displaydate(to_date(p_entry_value12,'YYYY/MM/DD HH24:MI:SS'));
303: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
304: l_entry_value12 := replace(p_entry_value12,'.',',');
305: else
306: l_entry_value12 := p_entry_value12;

Line 310: l_entry_value13 := fnd_date.date_to_displaydate(to_date(p_entry_value13,'YYYY/MM/DD HH24:MI:SS'));

306: l_entry_value12 := p_entry_value12;
307: end if ;
308: elsif(p_input_value_id13 = l_input_value.input_value_id) then
309: if( 'D' = l_input_value.uom) then
310: l_entry_value13 := fnd_date.date_to_displaydate(to_date(p_entry_value13,'YYYY/MM/DD HH24:MI:SS'));
311: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
312: l_entry_value13 := replace(p_entry_value13,'.',',');
313: else
314: l_entry_value13 := p_entry_value13;

Line 318: l_entry_value14 := fnd_date.date_to_displaydate(to_date(p_entry_value14,'YYYY/MM/DD HH24:MI:SS'));

314: l_entry_value13 := p_entry_value13;
315: end if ;
316: elsif(p_input_value_id14 = l_input_value.input_value_id ) then
317: if( 'D' = l_input_value.uom) then
318: l_entry_value14 := fnd_date.date_to_displaydate(to_date(p_entry_value14,'YYYY/MM/DD HH24:MI:SS'));
319: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
320: l_entry_value14 := replace(p_entry_value14,'.',',');
321: else
322: l_entry_value14 := p_entry_value14;

Line 327: l_entry_value15 := fnd_date.date_to_displaydate(to_date(p_entry_value15,'YYYY/MM/DD HH24:MI:SS'));

323: end if ;
324:
325: elsif(p_input_value_id15 = l_input_value.input_value_id) then
326: if( 'D' = l_input_value.uom) then
327: l_entry_value15 := fnd_date.date_to_displaydate(to_date(p_entry_value15,'YYYY/MM/DD HH24:MI:SS'));
328: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
329: l_entry_value15 := replace(p_entry_value15,'.',',');
330: else
331: l_entry_value15 := p_entry_value15;

Line 601: l_entry_value1 := fnd_date.date_to_displaydate(to_date(p_entry_value1,'YYYY/MM/DD HH24:MI:SS'));

597: for l_input_value in c_input_values loop
598: if(p_input_value_id1 = l_input_value.input_value_id ) then
599: -- the format coming in is already canonical but the api is expecting a user format
600: if( 'D' = l_input_value.uom) then
601: l_entry_value1 := fnd_date.date_to_displaydate(to_date(p_entry_value1,'YYYY/MM/DD HH24:MI:SS'));
602: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
603: l_entry_value1 := replace(p_entry_value1,'.',',');
604: else
605: l_entry_value1 := p_entry_value1;

Line 609: l_entry_value2 := fnd_date.date_to_displaydate(to_date(p_entry_value2,'YYYY/MM/DD HH24:MI:SS'));

605: l_entry_value1 := p_entry_value1;
606: end if ;
607: elsif(p_input_value_id2 = l_input_value.input_value_id ) then
608: if( 'D' = l_input_value.uom) then
609: l_entry_value2 := fnd_date.date_to_displaydate(to_date(p_entry_value2,'YYYY/MM/DD HH24:MI:SS'));
610: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
611: l_entry_value2 := replace(p_entry_value2,'.',',');
612: else
613: l_entry_value2 := p_entry_value2;

Line 618: l_entry_value3 := fnd_date.date_to_displaydate(to_date(p_entry_value3,'YYYY/MM/DD HH24:MI:SS'));

614: end if ;
615:
616: elsif(p_input_value_id3 = l_input_value.input_value_id) then
617: if( 'D' = l_input_value.uom) then
618: l_entry_value3 := fnd_date.date_to_displaydate(to_date(p_entry_value3,'YYYY/MM/DD HH24:MI:SS'));
619: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
620: l_entry_value3 := replace(p_entry_value3,'.',',');
621: else
622: l_entry_value3 := p_entry_value3;

Line 627: l_entry_value4 := fnd_date.date_to_displaydate(to_date(p_entry_value4,'YYYY/MM/DD HH24:MI:SS'));

623: end if ;
624:
625: elsif(p_input_value_id4 = l_input_value.input_value_id) then
626: if( 'D' = l_input_value.uom) then
627: l_entry_value4 := fnd_date.date_to_displaydate(to_date(p_entry_value4,'YYYY/MM/DD HH24:MI:SS'));
628: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
629: l_entry_value4 := replace(p_entry_value4,'.',',');
630: else
631: l_entry_value4 := p_entry_value4;

Line 636: l_entry_value5 := fnd_date.date_to_displaydate(to_date(p_entry_value5,'YYYY/MM/DD HH24:MI:SS'));

632: end if ;
633:
634: elsif(p_input_value_id5 = l_input_value.input_value_id) then
635: if( 'D' = l_input_value.uom) then
636: l_entry_value5 := fnd_date.date_to_displaydate(to_date(p_entry_value5,'YYYY/MM/DD HH24:MI:SS'));
637: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
638: l_entry_value5 := replace(p_entry_value5,'.',',');
639: else
640: l_entry_value5 := p_entry_value5;

Line 645: l_entry_value6 := fnd_date.date_to_displaydate(to_date(p_entry_value6,'YYYY/MM/DD HH24:MI:SS'));

641: end if ;
642:
643: elsif(p_input_value_id6 = l_input_value.input_value_id) then
644: if( 'D' = l_input_value.uom) then
645: l_entry_value6 := fnd_date.date_to_displaydate(to_date(p_entry_value6,'YYYY/MM/DD HH24:MI:SS'));
646: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
647: l_entry_value6 := replace(p_entry_value6,'.',',');
648: else
649: l_entry_value6 := p_entry_value6;

Line 654: l_entry_value7 := fnd_date.date_to_displaydate(to_date(p_entry_value7,'YYYY/MM/DD HH24:MI:SS'));

650: end if ;
651:
652: elsif(p_input_value_id7 = l_input_value.input_value_id ) then
653: if( 'D' = l_input_value.uom) then
654: l_entry_value7 := fnd_date.date_to_displaydate(to_date(p_entry_value7,'YYYY/MM/DD HH24:MI:SS'));
655: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
656: l_entry_value7 := replace(p_entry_value7,'.',',');
657: else
658: l_entry_value7 := p_entry_value7;

Line 663: l_entry_value8 := fnd_date.date_to_displaydate(to_date(p_entry_value8,'YYYY/MM/DD HH24:MI:SS'));

659: end if ;
660:
661: elsif(p_input_value_id8 = l_input_value.input_value_id) then
662: if( 'D' = l_input_value.uom) then
663: l_entry_value8 := fnd_date.date_to_displaydate(to_date(p_entry_value8,'YYYY/MM/DD HH24:MI:SS'));
664: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
665: l_entry_value8 := replace(p_entry_value8,'.',',');
666: else
667: l_entry_value8 := p_entry_value8;

Line 672: l_entry_value9 := fnd_date.date_to_displaydate(to_date(p_entry_value9,'YYYY/MM/DD HH24:MI:SS'));

668: end if ;
669:
670: elsif(p_input_value_id9 = l_input_value.input_value_id) then
671: if( 'D' = l_input_value.uom) then
672: l_entry_value9 := fnd_date.date_to_displaydate(to_date(p_entry_value9,'YYYY/MM/DD HH24:MI:SS'));
673: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
674: l_entry_value9 := replace(p_entry_value9,'.',',');
675: else
676: l_entry_value9 := p_entry_value9;

Line 680: l_entry_value10 := fnd_date.date_to_displaydate(to_date(p_entry_value10,'YYYY/MM/DD HH24:MI:SS'));

676: l_entry_value9 := p_entry_value9;
677: end if ;
678: elsif(p_input_value_id10 = l_input_value.input_value_id) then
679: if( 'D' = l_input_value.uom) then
680: l_entry_value10 := fnd_date.date_to_displaydate(to_date(p_entry_value10,'YYYY/MM/DD HH24:MI:SS'));
681: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
682: l_entry_value10 := replace(p_entry_value10,'.',',');
683: else
684: l_entry_value10 := p_entry_value10;

Line 688: l_entry_value11 := fnd_date.date_to_displaydate(to_date(p_entry_value11,'YYYY/MM/DD HH24:MI:SS'));

684: l_entry_value10 := p_entry_value10;
685: end if ;
686: elsif(p_input_value_id11 = l_input_value.input_value_id) then
687: if( 'D' = l_input_value.uom) then
688: l_entry_value11 := fnd_date.date_to_displaydate(to_date(p_entry_value11,'YYYY/MM/DD HH24:MI:SS'));
689: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
690: l_entry_value11 := replace(p_entry_value11,'.',',');
691: else
692: l_entry_value11 := p_entry_value11;

Line 696: l_entry_value12 := fnd_date.date_to_displaydate(to_date(p_entry_value12,'YYYY/MM/DD HH24:MI:SS'));

692: l_entry_value11 := p_entry_value11;
693: end if ;
694: elsif(p_input_value_id12 = l_input_value.input_value_id) then
695: if( 'D' = l_input_value.uom) then
696: l_entry_value12 := fnd_date.date_to_displaydate(to_date(p_entry_value12,'YYYY/MM/DD HH24:MI:SS'));
697: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
698: l_entry_value12 := replace(p_entry_value12,'.',',');
699: else
700: l_entry_value12 := p_entry_value12;

Line 704: l_entry_value13 := fnd_date.date_to_displaydate(to_date(p_entry_value13,'YYYY/MM/DD HH24:MI:SS'));

700: l_entry_value12 := p_entry_value12;
701: end if ;
702: elsif(p_input_value_id13 = l_input_value.input_value_id) then
703: if( 'D' = l_input_value.uom) then
704: l_entry_value13 := fnd_date.date_to_displaydate(to_date(p_entry_value13,'YYYY/MM/DD HH24:MI:SS'));
705: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
706: l_entry_value13 := replace(p_entry_value13,'.',',');
707: else
708: l_entry_value13 := p_entry_value13;

Line 712: l_entry_value14 := fnd_date.date_to_displaydate(to_date(p_entry_value14,'YYYY/MM/DD HH24:MI:SS'));

708: l_entry_value13 := p_entry_value13;
709: end if ;
710: elsif(p_input_value_id14 = l_input_value.input_value_id ) then
711: if( 'D' = l_input_value.uom) then
712: l_entry_value14 := fnd_date.date_to_displaydate(to_date(p_entry_value14,'YYYY/MM/DD HH24:MI:SS'));
713: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
714: l_entry_value14 := replace(p_entry_value14,'.',',');
715: else
716: l_entry_value14 := p_entry_value14;

Line 721: l_entry_value15 := fnd_date.date_to_displaydate(to_date(p_entry_value15,'YYYY/MM/DD HH24:MI:SS'));

717: end if ;
718:
719: elsif(p_input_value_id15 = l_input_value.input_value_id) then
720: if( 'D' = l_input_value.uom) then
721: l_entry_value15 := fnd_date.date_to_displaydate(to_date(p_entry_value15,'YYYY/MM/DD HH24:MI:SS'));
722: elsif ('M' = l_input_value.uom and icx_numeric <> '.,')then
723: l_entry_value15 := replace(p_entry_value15,'.',',');
724: else
725: l_entry_value15 := p_entry_value15;