PACKAGE BODY: APPS.BIX_EMAIL_UTIL_PKG

Source

1 PACKAGE BODY BIX_EMAIL_UTIL_PKG AS
2 /*$Header: bixxeutb.plb 115.7 2002/11/27 00:27:00 djambula noship $*/
3 
4 FUNCTION get_email_table_footer(p_context IN VARCHAR2 )
5          RETURN VARCHAR2 IS
6 l_max_date VARCHAR2(20);
7 l_date_format VARCHAR2(50);
8 BEGIN
9   l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
10   IF(l_date_format IS NULL) THEN
11   l_date_format := 'MM/DD/YYYY';
12   END IF;
13   l_date_format := l_date_format||' HH24:MI:SS';
14   SELECT to_char(MAX(period_start_date_time),l_date_format)
15   INTO   l_max_date
16   FROM   bix_dm_email_sum;
17   RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
18 EXCEPTION
19    WHEN OTHERS THEN
20     RETURN NULL;
21 END get_email_table_footer;
22 
23 FUNCTION get_max_date_of_email_table(p_context IN VARCHAR2 )
24          RETURN VARCHAR2 IS
25 l_max_date VARCHAR2(20);
26 l_date_format VARCHAR2(50);
27 BEGIN
28   l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
29   IF(l_date_format IS NULL) THEN
30   l_date_format := 'MM/DD/YYYY';
31   END IF;
32   l_date_format := l_date_format||' HH24:MI:SS';
33   SELECT to_char(MAX(period_start_date_time),l_date_format)
34   INTO   l_max_date
35   FROM   bix_dm_email_sum;
36   RETURN l_max_date;
37 EXCEPTION
38    WHEN OTHERS THEN
39     RETURN NULL;
40 END get_max_date_of_email_table;
41 
42 FUNCTION get_agent_table_footer(p_context IN VARCHAR2 )
43          RETURN VARCHAR2 IS
44 l_max_date VARCHAR2(20);
45 l_date_format VARCHAR2(50);
46 BEGIN
47   l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
48   IF(l_date_format IS NULL) THEN
49   l_date_format := 'MM/DD/YYYY';
50   END IF;
51   l_date_format := l_date_format||' HH24:MI:SS';
52   SELECT to_char(MAX(period_start_date_time),l_date_format)
53   INTO   l_max_date
54   FROM   bix_dm_email_agent_sum;
55   RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
56 EXCEPTION
57    WHEN OTHERS THEN
58     RETURN NULL;
59 END get_agent_table_footer;
60 
61 FUNCTION get_max_date_of_agent_table(p_context IN VARCHAR2 )
62          RETURN VARCHAR2 IS
63 l_max_date VARCHAR2(20);
64 l_date_format VARCHAR2(50);
65 BEGIN
66   l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
67   IF(l_date_format IS NULL) THEN
68   l_date_format := 'MM/DD/YYYY';
69   END IF;
70   l_date_format := l_date_format||' HH24:MI:SS';
71   SELECT to_char(MAX(period_start_date_time),l_date_format)
72   INTO   l_max_date
73   FROM   bix_dm_email_agent_sum;
74   RETURN  l_max_date;
75 EXCEPTION
76    WHEN OTHERS THEN
77     RETURN NULL;
78 END get_max_date_of_agent_table;
79 
80 END BIX_EMAIL_UTIL_PKG;