1 PACKAGE BODY ota_cht_xmlp_pkg AS
2 /* $Header: otachttxmlp.pkb 120.3 2011/04/07 13:33:28 shwnayak ship $ */
3
4 calendar_aware number:=2;
5
6 FUNCTION C_CHAT_NAME_p RETURN varchar2 IS
7 cursor c_chat_name_csr is
8 select name
9 from ota_chats_tl
10 where chat_id = P_CHAT_ID
11 and language = userenv('LANG');
12 BEGIN
13 open c_chat_name_csr;
14 fetch c_chat_name_csr into C_CHAT_NAME;
15 close c_chat_name_csr;
16 return C_CHAT_NAME;
17 END C_CHAT_NAME_p;
18
19 FUNCTION C_CHAT_CONTENT_TYPE_p RETURN varchar2 IS
20 cursor c_lookup_code is
21 select es.meaning
22 from hr_lookups es
23 WHERE es.lookup_type='OTA_CHAT_REPORT_TYPES'
24 AND sysdate BETWEEN NVL(es.start_date_active,sysdate) AND NVL (es.end_date_active, sysdate)
25 AND es.enabled_flag ='Y'
26 AND es.lookup_code = P_TYPE ;
27
28 BEGIN
29 open c_lookup_code;
30 fetch c_lookup_code into C_CHAT_CONTENT_TYPE;
31 close c_lookup_code;
32 return C_CHAT_CONTENT_TYPE;
33 END C_CHAT_CONTENT_TYPE_p;
34
35 Function C_FROM_DATE_p return varchar2 is
36 Begin
37 select fnd_date.date_to_displaydate(to_date(substr((P_MESSAGE_START_DATE),1,10),'yyyy/mm/dd'),calendar_aware)
38 into C_FROM_DATE
39 from dual;
40 return C_FROM_DATE;
41 END;
42
43 Function C_TO_DATE_p return varchar2 is
44 Begin
45 select fnd_date.date_to_displaydate(to_date(substr((P_MESSAGE_END_DATE),1,10),'yyyy/mm/dd'),calendar_aware)
46 into C_TO_DATE
47 from dual;
48 return C_TO_DATE;
49 END;
50
51
52
53 END ota_cht_xmlp_pkg;
54