[Home] [Help]
PACKAGE: APPS.IEM_EMAIL_CATEGORY_MAPS_PVT
Source
1 PACKAGE IEM_EMAIL_CATEGORY_MAPS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvcats.pls 115.4 2002/12/03 01:28:28 sboorela shipped $ */
3
4
5 -- Start of Comments
6 -- API name : create_item
7 -- Type : Private
8 -- Function : This procedure create a record in the table IEM_EMAIL_CATEGORY_MAPS
9 -- Pre-reqs : None.
10 -- Parameters :
11 -- IN
12 -- p_api_version_number IN NUMBER Required
13 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
14 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
15 -- p_email_account_id IN NUMBER,
16 -- p_email_cat_id IN NUMBER,
17 -- p_is_repos IN VARCHAR2,
18 --
19 -- OUT
20 -- x_return_status OUT VARCHAR2
21 -- x_msg_count OUT NUMBER
22 -- x_msg_data OUT VARCHAR2
23 --
24 -- Version : 1.0
25 -- Notes :
26 --
27 -- End of comments
28 -- **********************************************************
29
30 PROCEDURE create_item (p_api_version_number IN NUMBER,
31 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
32 p_commit IN VARCHAR2 := FND_API.G_FALSE,
33 p_email_account_id IN NUMBER,
34 p_kb_category_id IN NUMBER,
35 p_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
36 p_CREATION_DATE DATE:=SYSDATE,
37 p_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
38 p_LAST_UPDATE_DATE DATE:=SYSDATE,
39 p_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,
40 p_ATTRIBUTE1 VARCHAR2,
41 p_ATTRIBUTE2 VARCHAR2,
42 p_ATTRIBUTE3 VARCHAR2,
43 p_ATTRIBUTE4 VARCHAR2,
44 p_ATTRIBUTE5 VARCHAR2,
45 p_ATTRIBUTE6 VARCHAR2,
46 p_ATTRIBUTE7 VARCHAR2,
47 p_ATTRIBUTE8 VARCHAR2,
48 p_ATTRIBUTE9 VARCHAR2,
49 p_ATTRIBUTE10 VARCHAR2,
50 p_ATTRIBUTE11 VARCHAR2,
51 p_ATTRIBUTE12 VARCHAR2,
52 p_ATTRIBUTE13 VARCHAR2,
53 p_ATTRIBUTE14 VARCHAR2,
54 p_ATTRIBUTE15 VARCHAR2,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 -- Start of Comments
61 -- API name : delete_item
62 -- Type : Private
63 -- Function : This procedure delete a record in the table IEM_EMAIL_CATEGORY_MAPS
64 -- Pre-reqs : None.
65 -- Parameters :
66 -- IN
67 -- p_api_version_number IN NUMBER Required
68 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
69 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
70 -- p_email_account_id IN NUMBER,
71 -- p_email_cat_id IN NUMBER,
72 -- p_is_repos IN VARCHAR2,
73 --
74 -- OUT
75 -- x_return_status OUT VARCHAR2
76 -- x_msg_count OUT NUMBER
77 -- x_msg_data OUT VARCHAR2
78 --
79 -- Version : 1.0
80 -- Notes :
81 --
82 -- End of comments
83 -- **********************************************************
84
85 PROCEDURE delete_item (p_api_version_number IN NUMBER,
86 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87 p_commit IN VARCHAR2 := FND_API.G_FALSE,
88 p_email_account_id IN NUMBER,
89 p_kb_category_id IN NUMBER,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2
93 );
94
95 END IEM_EMAIL_CATEGORY_MAPS_PVT;