PACKAGE BODY: APPS.OTA_FRM_XMLP_PKG

Source

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