PACKAGE BODY: APPS.BIX_AO_UTIL_PKG

Source

1 PACKAGE BODY BIX_AO_UTIL_PKG AS
2 /*$Header: bixxaoub.plb 115.9 2002/11/27 00:27:04 djambula noship $*/
3 
4 
5 FUNCTION BIX_DM_GET_AO_footer(p_context IN VARCHAR2 ) RETURN VARCHAR2 IS
6   l_max_date VARCHAR2(20);
7   l_date_format VARCHAR2(50);
8 BEGIN
9 
10   l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
11 
12   IF(l_date_format IS NULL) THEN
13     l_date_format := 'MM/DD/YYYY';
14   END IF;
15 
16   l_date_format := l_date_format||' HH24:MI:SS';
17 
18   SELECT to_char(MAX(period_start_date_time),l_date_format)
19   INTO   l_max_date
20   FROM   bix_dm_advanced_outbound_sum;
21 
22   RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
23 
24 EXCEPTION
25    WHEN OTHERS THEN
26     RETURN NULL;
27 END BIX_DM_GET_AO_FOOTER;
28 
29 
30 
31 
32 FUNCTION BIX_DM_GET_AO_refresh_date(p_context IN VARCHAR2 ) RETURN VARCHAR2 IS
33   l_max_date VARCHAR2(20);
34   l_date_format VARCHAR2(50);
35 BEGIN
36 
37   l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
38 
39   IF(l_date_format IS NULL) THEN
40     l_date_format := 'MM/DD/YYYY';
41   END IF;
42 
43   l_date_format := l_date_format||' HH24:MI:SS';
44 
45   SELECT to_char(MAX(period_start_date_time),l_date_format)
46   INTO   l_max_date
47   FROM   bix_dm_advanced_outbound_sum;
48 
49   RETURN l_max_date;
50 
51 EXCEPTION
52    WHEN OTHERS THEN
53     RETURN NULL;
54 END BIX_DM_GET_AO_refresh_date;
55 
56 
57 FUNCTION BIX_GET_AO_a_otcm_footer(p_context IN VARCHAR2 ) RETURN VARCHAR2 IS
58   l_max_date VARCHAR2(20);
59   l_date_format VARCHAR2(50);
60 BEGIN
61 
62   l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
63 
64   IF(l_date_format IS NULL) THEN
65     l_date_format := 'MM/DD/YYYY';
66   END IF;
67 
68   l_date_format := l_date_format||' HH24:MI:SS';
69 
70   SELECT to_char(MAX(period_start_date_time),l_date_format)
71   INTO   l_max_date
72   FROM   bix_dm_agent_outcome_sum;
73 
74   RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
75 
76 EXCEPTION
77    WHEN OTHERS THEN
78     RETURN NULL;
79 END BIX_GET_AO_A_OTCM_FOOTER;
80 
81 
82 FUNCTION BIX_GET_AO_a_otcm_refresh_date(p_context IN VARCHAR2 ) RETURN VARCHAR2 IS
83   l_max_date VARCHAR2(20);
84   l_date_format VARCHAR2(50);
85 BEGIN
86 
87   l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
88 
89   IF(l_date_format IS NULL) THEN
90     l_date_format := 'MM/DD/YYYY';
91   END IF;
92 
93   l_date_format := l_date_format||' HH24:MI:SS';
94 
95   SELECT to_char(MAX(period_start_date_time),l_date_format)
96   INTO   l_max_date
97   FROM   bix_dm_agent_outcome_sum;
98 
99   RETURN l_max_date;
100 
101 EXCEPTION
102    WHEN OTHERS THEN
103     RETURN NULL;
104 END BIX_GET_AO_A_OTCM_REFRESH_DATE;
105 
106 END BIX_AO_UTIL_PKG;