1 PACKAGE cn_quota_categories_pub AUTHID CURRENT_USER AS
2 -- $Header: cnpqcats.pls 115.7 2002/11/21 21:05:45 hlchen ship $
3
4 TYPE quota_category_rec_type IS RECORD
5 ( QUOTA_CATEGORY_ID NUMBER(15),
6 NAME VARCHAR2(80),
7 DESCRIPTION VARCHAR2(80),
8 TYPE VARCHAR2(30),
9 TYPE_MEANING VARCHAR2(80),
10 COMPUTE_FLAG VARCHAR2(1),
11 COMPUTED VARCHAR2(80),
12 INTERVAL_TYPE_ID NUMBER(15),
13 QUOTA_UNIT_CODE VARCHAR2(30),
14 OBJECT_VERSION_NUMBER NUMBER);
15
16 TYPE quota_categories_tbl_type IS TABLE OF quota_category_rec_type
17 INDEX BY BINARY_INTEGER;
18
19 -- Start of comments
20 -- API name : Create_Quota_Category
21 -- Pre-reqs : None.
22 -- IN : standard params
23 -- p_rec of table rec type
24 -- OUT : standard params
25 -- x_user_access_id
26 -- Version : 1.0
27 --
28 -- End of comments
29
30 PROCEDURE Create_Quota_Category(
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35 p_rec IN quota_category_rec_type,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 x_quota_category_id OUT NOCOPY NUMBER);
40
41 -- Start of comments
42 -- API name : Update_Quota_Category
43 -- Pre-reqs : None.
44 -- IN : standard params
45 -- p_rec of table rec type
46 -- OUT : standard params
47 -- Version : 1.0
48 --
49 -- End of comments
50
51 PROCEDURE Update_Quota_Category(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_commit IN VARCHAR2 := FND_API.G_FALSE,
55 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56 p_rec IN quota_category_rec_type,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2);
60
61 -- Start of comments
62 -- API name : Delete_Quota_Category
63 -- Pre-reqs : None.
64 -- IN : standard params
65 -- p_user_access_id
66 -- OUT : standard params
67 -- Version : 1.0
68 --
69 -- End of comments
70
71 PROCEDURE Delete_Quota_Category(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74 p_commit IN VARCHAR2 := FND_API.G_FALSE,
75 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76 p_quota_category_id IN NUMBER,
77 p_object_version_number 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 -- API name : Get_Quota_Category_details
83 -- Type : Public.
84 -- Pre-reqs :
85 -- Usage :
86 --
87 -- Desc :
88 --
89 --
90 --
91 -- Parameters :
92 -- IN : p_api_version NUMBER Require
93 -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
94 -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
95 -- OUT : x_return_status VARCHAR2(1)
96 -- x_msg_count NUMBER
97 -- x_msg_data VARCHAR2(2000)
98 -- IN : p_start_record NUMBER,
99 -- p_increment_count NUMBER
100 -- OUT : x_quota_categories_detail_tbl OUT quota_categories_tbl_type,
101 --
102 --
103 -- Version : Current version 1.0
104 -- Initial version 1.0
105 --
106 -- Notes :
107 --
108 -- End of comments
109
110 PROCEDURE Get_Quota_Category_details
111 ( p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118
119 p_start_record IN NUMBER := 1,
120 p_increment_count IN NUMBER := 25,
121
122 p_search_name IN VARCHAR2,
123 p_search_type IN VARCHAR2,
124 p_search_unit IN VARCHAR2,
125
126 x_quota_categories_tbl OUT NOCOPY quota_categories_tbl_type,
127 x_total_records OUT NOCOPY NUMBER
128 );
129
130 END cn_quota_categories_pub;
131