[Home] [Help]
PACKAGE: APPS.IEM_MS_MSGMETA_PVT
Source
1 PACKAGE IEM_MS_MSGMETA_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvhdrs.pls 120.4 2011/07/27 08:25:26 lkullamb ship $ */
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 -- lkullamb 07/27/2011 Changed create_string_msg_body to accept
14 -- jtf_varchar2_Table_4000 instead of jtf_varchar2_Table_2000
15 -- --------- ------ ------------------------------------------
16
17 TYPE key_tbl_type IS table of VARCHAR(100) INDEX BY BINARY_INTEGER;
18
19 PROCEDURE create_msg_meta (
20 p_api_version_number IN NUMBER,
21 p_init_msg_list IN VARCHAR2 := null,
22 p_commit IN VARCHAR2 := null,
23 P_subject IN VARCHAR2,
24 p_sent_date IN VARCHAR2, --DATE,
25 p_priority IN VARCHAR2,
26 p_msg_id IN VARCHAR2,
27 p_UID IN NUMBER,
28 p_x_mailer IN varchar2,
29 p_language IN varchar2,
30 p_content_type IN varchar2,
31 p_organization IN varchar2,
32 p_message_size IN NUMBER,
33 p_email_account IN NUMBER,
34 p_from IN varchar2,
35 p_to IN varchar2,
36 p_cc IN varchar2,
37 p_reply_to IN varchar2,
38 p_message_id IN number,
39 x_ref_key OUT NOCOPY varchar2,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2
43 ) ;
44
45
46 PROCEDURE create_headers(
47 p_api_version_number IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := null,
49 p_commit IN VARCHAR2 := null,
50 p_msg_meta_id IN jtf_varchar2_Table_100,
51 p_name_tbl IN jtf_varchar2_Table_300,
52 p_value_tbl IN jtf_varchar2_Table_2000,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2
56 ) ;
57 -- Start of Comments
58
59 PROCEDURE create_string_msg_body(
60 p_api_version_number IN NUMBER,
61 p_init_msg_list IN VARCHAR2,
62 p_commit IN VARCHAR2,
63 p_message_id IN NUMBER,
64 p_part_type IN varchar2,
65 p_msg_body IN jtf_varchar2_Table_4000, -- fix for bug 12778600
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2
69
70 );
71 PROCEDURE insert_preproc_wrapper (
72 p_api_version_number IN NUMBER,
73 p_init_msg_list IN VARCHAR2 := null,
74 p_commit IN VARCHAR2 := null,
75 p_msg_id IN NUMBER,
76 p_acct_id IN NUMBER,
77 p_priority IN NUMBER,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2
81 );
82 END IEM_MS_MSGMETA_PVT ;