[Home] [Help]
PACKAGE: APPS.IEM_ACT_CATG_PVT
Source
1 PACKAGE IEM_ACT_CATG_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvacas.pls 115.1 2002/12/05 20:09:22 sboorela shipped $*/
3 -- Start of Comments
4 -- API name : create_item
5 -- Type : Private
6 -- Function : This procedure create a record in the table IEM_ACCOUNT_CATEGORIES
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 PROCEDURE create_item (p_api_version_number IN NUMBER,
25 p_init_msg_list IN VARCHAR2 ,
26 p_commit IN VARCHAR2 ,
27 p_email_account_id IN NUMBER,
28 p_cat_tbl IN jtf_varchar2_Table_100,
29 p_CREATED_BY NUMBER,
30 p_CREATION_DATE DATE,
31 p_LAST_UPDATED_BY NUMBER,
32 p_LAST_UPDATE_DATE DATE,
33 p_LAST_UPDATE_LOGIN NUMBER,
34 p_ATTRIBUTE1 VARCHAR2,
35 p_ATTRIBUTE2 VARCHAR2,
36 p_ATTRIBUTE3 VARCHAR2,
37 p_ATTRIBUTE4 VARCHAR2,
38 p_ATTRIBUTE5 VARCHAR2,
39 p_ATTRIBUTE6 VARCHAR2,
40 p_ATTRIBUTE7 VARCHAR2,
41 p_ATTRIBUTE8 VARCHAR2,
42 p_ATTRIBUTE9 VARCHAR2,
43 p_ATTRIBUTE10 VARCHAR2,
44 p_ATTRIBUTE11 VARCHAR2,
45 p_ATTRIBUTE12 VARCHAR2,
46 p_ATTRIBUTE13 VARCHAR2,
47 p_ATTRIBUTE14 VARCHAR2,
48 p_ATTRIBUTE15 VARCHAR2,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 -- Start of Comments
55 -- API name : select_item
56 -- Type : Private
57 -- Function : This procedure selects the category associated with an account
58 -- Pre-reqs : None.
59 -- Parameters :
60 -- IN
61 -- p_api_version_number IN NUMBER Required
62 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
63 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64 -- p_email_account_id in number,
65 -- x_categeory_tbl out jtf_varchar2_TABLE_100,
66
67 -- OUT
68 -- x_return_status OUT VARCHAR2
69 -- x_msg_count OUT NUMBER
70 -- x_msg_data OUT VARCHAR2
71 --
72 -- Version : 1.0
73 -- Notes :
74 --
75 -- End of comments
76 -- **********************************************************
77
78 PROCEDURE select_item (p_api_version_number IN NUMBER,
79 p_init_msg_list IN VARCHAR2 ,
80 p_commit IN VARCHAR2 ,
81 p_email_account_id in number,
82 x_category_tbl OUT NOCOPY jtf_varchar2_TABLE_100,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE create_item_wrap (p_api_version_number IN NUMBER,
89 p_init_msg_list IN VARCHAR2 ,
90 p_commit IN VARCHAR2 ,
91 p_email_account_id IN NUMBER,
92 p_cat_tbl IN jtf_varchar2_Table_100,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2
96 );
97 END IEM_ACT_CATG_PVT;