[Home] [Help]
PACKAGE: APPS.IEM_MS_MSGMETA_PVT
Source
1 PACKAGE IEM_MS_MSGMETA_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvhdrs.pls 120.3 2005/08/24 16:01:52 appldev noship $ */
3 --
4 --
5 -- Purpose: Mantain message store header tables
6 --
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- Liang Xia 10/05/2004 Created
10 -- Liang Xia 10/16/2004 Redefined interface of create_headers
11 -- Liang Xia 11/16/2004 Changed to compliance with final odf patch
12 -- Liang Xia 08/18/2005 Changed create_msg_meta to accept message_id for DPM
13 -- --------- ------ ------------------------------------------
14
15 TYPE key_tbl_type IS table of VARCHAR(100) INDEX BY BINARY_INTEGER;
16
17 PROCEDURE create_msg_meta (
18 p_api_version_number IN NUMBER,
19 p_init_msg_list IN VARCHAR2 := null,
20 p_commit IN VARCHAR2 := null,
21 P_subject IN VARCHAR2,
22 p_sent_date IN VARCHAR2, --DATE,
23 p_priority IN VARCHAR2,
24 p_msg_id IN VARCHAR2,
25 p_UID IN NUMBER,
26 p_x_mailer IN varchar2,
27 p_language IN varchar2,
28 p_content_type IN varchar2,
29 p_organization IN varchar2,
30 p_message_size IN NUMBER,
31 p_email_account IN NUMBER,
32 p_from IN varchar2,
33 p_to IN varchar2,
34 p_cc IN varchar2,
35 p_reply_to IN varchar2,
36 p_message_id IN number,
37 x_ref_key OUT NOCOPY varchar2,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2
41 ) ;
42
43
44 PROCEDURE create_headers(
45 p_api_version_number IN NUMBER,
46 p_init_msg_list IN VARCHAR2 := null,
47 p_commit IN VARCHAR2 := null,
48 p_msg_meta_id IN jtf_varchar2_Table_100,
49 p_name_tbl IN jtf_varchar2_Table_300,
50 p_value_tbl IN jtf_varchar2_Table_2000,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2
54 ) ;
55 -- Start of Comments
56
57 PROCEDURE create_string_msg_body(
58 p_api_version_number IN NUMBER,
59 p_init_msg_list IN VARCHAR2,
60 p_commit IN VARCHAR2,
61 p_message_id IN NUMBER,
62 p_part_type IN varchar2,
63 p_msg_body IN jtf_varchar2_Table_2000,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2
67
68 );
69 PROCEDURE insert_preproc_wrapper (
70 p_api_version_number IN NUMBER,
71 p_init_msg_list IN VARCHAR2 := null,
72 p_commit IN VARCHAR2 := null,
73 p_msg_id IN NUMBER,
74 p_acct_id IN NUMBER,
75 p_priority IN NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2
79 );
80 END IEM_MS_MSGMETA_PVT ;