1 Package OKI_ALERT_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKIRAUTS.pls 115.9 2002/07/12 01:16:13 rpotnuru noship $*/
3 /*---------------------------------------------------------------------------+
4 | |
5 | PACKAGE: OKI_ALERT_UTIL_PVT |
6 | DESC : Private interface for OKI ALERT UTILITIES Packag
7 | FILE : OKIRAUTS.pls |
8 | |
9 *-------------------------------------------------------------------------- */
10 --------------------------------------------------------------------------------
11 --
12 -- Modification History
13 -- 03-DEC-2001 brrao created
14 -- 29-JAN-2001 mezra Added get_gv_prev_x_qtr_end_date and dflt_gv_qed for
15 -- functions for the oki_expiration_graph graph component
16 -- for the bins.
17 -- 04-FEB-2002 mezra Change get_gv_prev_x_qtr_end_date and dflt_gv_qed
18 -- function to remove hard coded 'DD-MON-YY format
19 -- mask.
20 -- 30-APR-2002 mezra Added dbdrv command and correct header syntax.
21 --
22 --------------------------------------------------------------------------------
23
24 g_output_stream UTL_FILE.FILE_TYPE;
25 g_alert_dist_list VARCHAR2(1000);
26 g_alert_publish_dir VARCHAR2(1000);
27 g_utl_file_dest VARCHAR2(1000);
28 g_oki_alert_url VARCHAR2(1000);
29 g_oki_parent_url VARCHAR2(1000);
30
31 VERSION CONSTANT NUMBER := 1.0;
32
33 PROCEDURE Send_email (ERRBUF OUT VARCHAR2,
34 RETCODE OUT NUMBER,
35 subject IN VARCHAR2,
36 body IN VARCHAR2,
37 email_list IN VARCHAR2 );
38
39 PROCEDURE Send_Email (
40 p_api_version IN NUMBER,
41 p_commit IN VARCHAR2 := FND_API.g_false,
42 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
43 email_list IN VARCHAR2,
44 subject IN VARCHAR2,
45 body IN VARCHAR2,
46 return_status OUT VARCHAR2,
47 x_msg_count OUT NUMBER,
48 x_msg_data OUT VARCHAR2
49 );
50
51 procedure myprint(p_str IN VARCHAR2);
52
53 FUNCTION set_output_stream(p_file_name IN VARCHAR2) RETURN BOOLEAN;
54 -- 1. Success
55 -- 0. Failure
56 PROCEDURE end_output_stream;
57
58 procedure reportHeaderCell(p_str IN VARCHAR2, p_ref in VARCHAR2);
59 procedure populateCell(p_str IN VARCHAR2,
60 p_align IN VARCHAR2,
61 p_link IN VARCHAR2,
62 p_class in VARCHAR2,
63 p_width in VARCHAR2);
64 procedure create_page( p_title IN varchar2);
65 procedure create_mainheader( p_title IN varchar2, p_run_date IN DATE);
66 procedure start_row;
67 procedure end_row;
68 procedure create_crumb( p_title IN varchar2,
69 p_link IN VARCHAR2,
70 flag in VARCHAR2);
71 procedure end_table(p_run_date IN DATE );
72 procedure spaceCell(p_space in VARCHAR2,p_str IN VARCHAR2,
73 p_align IN VARCHAR2, p_link IN VARCHAR2,
74 p_class in VARCHAR2, p_width in VARCHAR2);
75 procedure start_table( p_align IN varchar2 default 'L',
76 p_cellpadding IN NUMBER default 0,
77 p_bdr in NUMBER default 0);
78 procedure print_error(p_string IN VARCHAR2);
79
80 -- This function returns the quarter end date. It takes the quarter and year
81 -- as the starting date and uses the number of quarters parameter to determine
82 -- the number of quarters to go back and determine the quarter start date.
83 FUNCTION get_gv_prev_x_qtr_end_date
84 ( p_qtr_end_date IN DATE DEFAULT NULL
85 , p_number_of_qtrs IN NUMBER DEFAULT NULL
86 ) RETURN DATE ;
87
88 /* Commented by Ravi on 02-11-2002
89 -- This function defaults the current quarter start date.
90 FUNCTION dflt_gv_qed
91 ( p_name IN VARCHAR2 DEFAULT NULL
92 ) RETURN VARCHAR2 ;
93 */
94
95 END ; -- Package Specification OKI_ALERT_UTIL_PVT