PACKAGE BODY: APPS.OTA_FRM_XMLP_PKG

Source

1 PACKAGE BODY ota_frm_xmlp_pkg AS
2 /* $Header: otafrmxmlp.pkb 120.2 2008/01/08 10:11:20 aabalakr noship $ */
3 
4   FUNCTION C_FORUM_NAME_p RETURN varchar2 IS
5   cursor c_forum_name_csr is
6    select name
7    from ota_forums_tl
8    where forum_id = P_FORUM_ID
9    and language = userenv('LANG');
10   BEGIN
11      open c_forum_name_csr;
12      fetch c_forum_name_csr into C_FORUM_NAME;
13      close c_forum_name_csr;
14      return  C_FORUM_NAME;
15   END C_FORUM_NAME_p;
16 
17   Function C_FROM_DATE_p return varchar2 is
18   Begin
19      select fnd_date.date_to_displaydate(to_date(substr((P_FROM_DATE),1,10),'yyyy/mm/dd'))
20      into C_FROM_DATE
21      from dual;
22      return C_FROM_DATE;
23   END;
24 
25   Function C_TO_DATE_p return varchar2 is
26   Begin
27      select fnd_date.date_to_displaydate(to_date(substr((P_TO_DATE),1,10),'yyyy/mm/dd'))
28      into C_TO_DATE
29      from dual;
30      return C_TO_DATE;
31   END;
32 
33 END ota_frm_xmlp_pkg;
34