APPS.POS_ASN_SEARCH_PKG dependencies on FND_DATE

Line 488: fnd_date.initialize(l_format_mask);

484: into l_format_mask
485: from icx_sessions
486: where session_id = l_session_id;
487:
488: fnd_date.initialize(l_format_mask);
489:
490: if pos_date_start is null then
491:
492: l_start_date := sysdate;

Line 496: l_start_date := fnd_date.chardate_to_date(pos_date_start);

492: l_start_date := sysdate;
493:
494: else
495:
496: l_start_date := fnd_date.chardate_to_date(pos_date_start);
497:
498: end if;
499:
500: if pos_date_end is null then

Line 506: l_end_date := fnd_date.chardate_to_date(pos_date_end);

502: l_end_date := sysdate;
503:
504: else
505:
506: l_end_date := fnd_date.chardate_to_date(pos_date_end);
507:
508: end if;
509:
510: l_where_clause := l_where_clause || ' and due_date between ''' ||

Line 511: fnd_date.date_to_chardate(l_start_date) ||

507:
508: end if;
509:
510: l_where_clause := l_where_clause || ' and due_date between ''' ||
511: fnd_date.date_to_chardate(l_start_date) ||
512: ''' and ''' ||
513: fnd_date.date_to_chardate(l_end_date) || '''';
514:
515: end if;

Line 513: fnd_date.date_to_chardate(l_end_date) || '''';

509:
510: l_where_clause := l_where_clause || ' and due_date between ''' ||
511: fnd_date.date_to_chardate(l_start_date) ||
512: ''' and ''' ||
513: fnd_date.date_to_chardate(l_end_date) || '''';
514:
515: end if;
516:
517: UpdateResultSet(l_where_clause, l_session_id);