[Home] [Help]
PACKAGE: APPS.IBY_EMAIL_REPORT
Source
1 PACKAGE IBY_EMAIL_REPORT AUTHID CURRENT_USER AS
2 /*$Header: ibyvmals.pls 115.1 2002/11/18 22:22:03 jleybovi noship $*/
3
4 ------------------------------------------------------------------------
5 -- Constants Declaration
6 ------------------------------------------------------------------------
7 C_USERTYPE_ADHOC CONSTANT VARCHAR2(10) := 'ADHOC_USER';
8 C_USERTYPE_REGISTERED CONSTANT VARCHAR2(10) := 'REGD_USER';
9
10 -------------------------------------------------------------------------
11 --**Defining all DataStructures required by the APIs**--
12 -- The following input and output PL/SQL record/table types are defined
13 -- to store the User Information
14 -------------------------------------------------------------------------
15
16 --INPUT and OUTPUT DataStructures
17
18 --1. Record Types
19
20 TYPE UserInfo_rec_type IS RECORD (
21 username VARCHAR2(100),
22 emailaddr VARCHAR2(200),
23 usertype VARCHAR2(10)
24 );
25
26 --2. Table Types
27
28 TYPE UserInfo_tbl_type IS TABLE OF UserInfo_rec_type;
29
30 -- 1. populate_userinfo
31 PROCEDURE populate_userinfo( email_users_str VARCHAR2);
32
33 --------------------------------------------------------------------------------------
34 -- API Signatures--
35 --------------------------------------------------------------------------------------
36 -- 1. Send_Mail
37 -- Start of comments
38 -- API name : Send_Mail
39 -- Type : Public
40 -- Pre-reqs : None
41 -- Function : Sends an email report.
42 -- Parameters :
43 -- IN : p_item_key IN VARCHAR2
44 -- p_user_name IN VARCHAR2
45 --
46 -- OUT : x_return_status OUT NOCOPY VARCHAR2
47 -- x_msg_count OUT NOCOPY VARCHAR2
48 -- Version :
49 -- Current version 1.0
50 -- Previous version 1.0
51 -- Initial version 1.0
52 -- End of comments
53 --------------------------------------------------------------------------------------
54 -- 1. Send_Mail
55 PROCEDURE Send_Mail (p_item_key IN VARCHAR2,
56 p_user_name IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER
59 );
60
61 --------------------------------------------------------------------------------------
62 -- 2. Send_Report
63 -- Start of comments
64 -- API name : Send_Report
65 -- Type : Public
66 -- Pre-reqs : None
67 -- Function : Implements Concurrent Program.
68 -- Parameters :
69 -- IN : p_email_users IN VARCHAR2
70 --
71 -- OUT : ERRBUF OUT NOCOPY VARCHAR2
72 -- RETCODE OUT NOCOPY NUMBER
73 -- Version :
74 -- Current version 1.0
75 -- Previous version 1.0
76 -- Initial version 1.0
77 -- End of comments
78 --------------------------------------------------------------------------------------
79 -- 2. Send_Report
80
81 Procedure Send_Report(ERRBUF OUT NOCOPY VARCHAR2,
82 RETCODE OUT NOCOPY NUMBER,
83 p_email_users IN VARCHAR2
84 );
85
86 END IBY_EMAIL_REPORT;