[Home] [Help]
PACKAGE: APPS.IEM_AGENT_ACT_PVT
Source
1 PACKAGE IEM_AGENT_ACT_PVT as
2 /* $Header: iemvagns.pls 120.0 2005/06/02 13:51:59 appldev noship $*/
3 -- Start of Comments
4 -- API name : create_item
5 -- Type : Private
6 -- Function : This procedure insert/delete a record in the table IEM_AGENTS
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN
10 -- p_api_version_number IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
12 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
13 --
14 -- OUT
15 -- x_return_status OUT VARCHAR2
16 -- x_msg_count OUT NUMBER
17 -- x_msg_data OUT VARCHAR2
18 --
19 -- Version : 1.0
20 -- Notes :
21 --
22 -- End of comments
23 -- **********************************************************
24
25 PROCEDURE create_item (p_api_version_number IN NUMBER,
26 p_init_msg_list IN VARCHAR2 ,
27 p_commit IN VARCHAR2 ,
28 p_resource_id IN VARCHAR2,
29 p_email_account_id IN NUMBER,
30 p_signature IN VARCHAR2,
31 p_CREATED_BY NUMBER,
32 p_CREATION_DATE DATE,
33 p_LAST_UPDATED_BY NUMBER,
34 p_LAST_UPDATE_DATE DATE,
35 p_LAST_UPDATE_LOGIN NUMBER,
36 p_ATTRIBUTE1 VARCHAR2,
37 p_ATTRIBUTE2 VARCHAR2,
38 p_ATTRIBUTE3 VARCHAR2,
39 p_ATTRIBUTE4 VARCHAR2,
40 p_ATTRIBUTE5 VARCHAR2,
41 p_ATTRIBUTE6 VARCHAR2,
42 p_ATTRIBUTE7 VARCHAR2,
43 p_ATTRIBUTE8 VARCHAR2,
44 p_ATTRIBUTE9 VARCHAR2,
45 p_ATTRIBUTE10 VARCHAR2,
46 p_ATTRIBUTE11 VARCHAR2,
47 p_ATTRIBUTE12 VARCHAR2,
48 p_ATTRIBUTE13 VARCHAR2,
49 p_ATTRIBUTE14 VARCHAR2,
50 p_ATTRIBUTE15 VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56 -- Start of Comments
57 -- API name : delete_item
58 -- Type : Private
59 -- Function : This procedure delete a record in the table IEM_AGENTS
60 -- Pre-reqs : None.
61 -- Parameters :
62 -- IN
63 -- p_api_version_number IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
65 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
66 -- p_message_id in number,
67
68 -- OUT
69 -- x_return_status OUT VARCHAR2
70 -- x_msg_count OUT NUMBER
71 -- x_msg_data OUT VARCHAR2
72 --
73 -- Version : 1.0
74 -- Notes :
75 --
76 -- End of comments
77 -- **********************************************************
78
79 PROCEDURE delete_item (p_api_version_number IN NUMBER,
80 p_init_msg_list IN VARCHAR2 ,
81 p_commit IN VARCHAR2 ,
82 p_resource_id in number,
83 p_email_account_id in number,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE create_agntacct_by_agent (p_api_version_number IN NUMBER,
90 p_init_msg_list IN VARCHAR2 ,
91 p_commit IN VARCHAR2 ,
92 p_in_resource_tbl IN jtf_varchar2_Table_100,
93 p_email_account_id in number,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE delete_agntacct_by_agent (p_api_version_number IN NUMBER,
100 p_init_msg_list IN VARCHAR2 ,
101 p_commit IN VARCHAR2 ,
102 p_out_resource_tbl IN jtf_varchar2_Table_100,
103 p_email_account_id in number,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2
107 );
108
109 PROCEDURE update_agntacct_by_agent_wrap (p_api_version_number IN NUMBER,
110 p_init_msg_list IN VARCHAR2 ,
111 p_commit IN VARCHAR2 ,
112 p_in_resource_tbl IN jtf_varchar2_Table_100,
113 p_out_resource_tbl IN jtf_varchar2_Table_100,
114 p_email_account_id in number,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2
118 );
119
120 PROCEDURE create_agntacct_by_account (p_api_version_number IN NUMBER,
121 p_init_msg_list IN VARCHAR2 ,
122 p_commit IN VARCHAR2 ,
123 p_in_email_account_tbl IN jtf_varchar2_Table_100,
124 p_resource_id in number,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2
128 );
129
130 PROCEDURE delete_agntacct_by_account (p_api_version_number IN NUMBER,
131 p_init_msg_list IN VARCHAR2 ,
132 p_commit IN VARCHAR2 ,
133 p_out_email_account_tbl IN jtf_varchar2_Table_100,
134 p_resource_id in number,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2
138 );
139
140 PROCEDURE update_agntacct_by_acct_wrap (p_api_version_number IN NUMBER,
141 p_init_msg_list IN VARCHAR2 ,
142 p_commit IN VARCHAR2 ,
143 p_in_email_account_tbl IN jtf_varchar2_Table_100,
144 p_out_email_account_tbl IN jtf_varchar2_Table_100,
145 p_resource_id in number,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2
149 );
150
151 END IEM_AGENT_ACT_PVT;