1 PACKAGE CN_QUOTA_ASSIGN_PUB AUTHID CURRENT_USER AS
2 /*$Header: cnpqtass.pls 120.3 2005/11/08 03:23:17 kjayapau noship $*/
3
4 TYPE quota_assign_rec_type IS RECORD
5 (
6 COMP_PLAN_NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,
7 QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,
8 QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
9 ORG_ID CN_QUOTAS.ORG_ID%TYPE,
10 OLD_QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR
11 );
12
13 -- Start of comments
14 -- API name : Create_Quota_Assign
15 -- Type : Public
16 -- Function :
17 -- Pre-reqs : None.
18 -- Parameters :
19 -- IN : p_api_version IN NUMBER Required
20 -- p_init_msg_list IN VARCHAR2 Optional
21 -- Default = FND_API.G_FALSE
22 -- p_commit IN VARCHAR2 Optional
23 -- Default = FND_API.G_FALSE
24 -- p_validation_level IN NUMBER Optional
25 -- Default = FND_API.G_VALID_LEVEL_FULL
26 -- p_quota_assign_rec IN quota_assign_rec_type
27 -- OUT : x_return_status OUT VARCHAR2(1)
28 -- x_msg_count OUT NUMBER
29 -- x_msg_data OUT VARCHAR2(2000)
30 -- Version : Current version 1.0
31 -- Initial version 1.0
32 --
33 -- Notes : None
34 --
35 -- End of comments
36 PROCEDURE Create_Quota_Assign
37 (p_api_version IN NUMBER ,
38 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
39 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
40 p_validation_level IN NUMBER :=
41 FND_API.G_VALID_LEVEL_FULL ,
42 p_quota_assign_rec IN quota_assign_rec_type ,
43 x_return_status OUT NOCOPY VARCHAR2 ,
44 x_msg_count OUT NOCOPY NUMBER ,
45 x_msg_data OUT NOCOPY VARCHAR2 );
46
47 -- Start of comments
48 -- API name : Update_Quota_Assign
49 -- Type : Public
50 -- Function :
51 -- Pre-reqs : None.
52 -- Parameters :
53 -- IN : p_api_version IN NUMBER Required
54 -- p_init_msg_list IN VARCHAR2 Optional
55 -- Default = FND_API.G_FALSE
56 -- p_commit IN VARCHAR2 Optional
57 -- Default = FND_API.G_FALSE
58 -- p_validation_level IN NUMBER Optional
59 -- Default = FND_API.G_VALID_LEVEL_FULL
60 -- p_quota_assign_rec IN quota_assign_rec_type
61 -- OUT : x_return_status OUT VARCHAR2(1)
62 -- x_msg_count OUT NUMBER
63 -- x_msg_data OUT VARCHAR2(2000)
64 -- Version : Current version 1.0
65 -- Initial version 1.0
66 --
67 -- Notes : Note text
68 --
69 -- End of comments
70 PROCEDURE Update_Quota_Assign
71 (p_api_version IN NUMBER ,
72 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
73 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
74 p_validation_level IN NUMBER :=
75 FND_API.G_VALID_LEVEL_FULL ,
76 p_quota_assign_rec IN quota_assign_rec_type ,
77 x_return_status OUT NOCOPY VARCHAR2 ,
78 x_msg_count OUT NOCOPY NUMBER ,
79 x_msg_data OUT NOCOPY VARCHAR2 );
80
81 -- Start of comments
82 -- API name : Delete_Quota_Assign
83 -- Type : Public
84 -- Function :
85 -- Pre-reqs : None.
86 -- Parameters :
87 -- IN : p_api_version IN NUMBER Required
88 -- p_init_msg_list IN VARCHAR2 Optional
89 -- Default = FND_API.G_FALSE
90 -- p_commit IN VARCHAR2 Optional
91 -- Default = FND_API.G_FALSE
92 -- p_validation_level IN NUMBER Optional
93 -- Default = FND_API.G_VALID_LEVEL_FULL
94 -- p_quota_assign_rec IN quota_assign_rec_type
95 -- OUT : x_return_status OUT VARCHAR2(1)
96 -- x_msg_count OUT NUMBER
97 -- x_msg_data OUT VARCHAR2(2000)
98 -- Version : Current version 1.0
99 -- Initial version 1.0
100 --
101 -- Notes : Note text
102 --
103 -- End of comments
104 PROCEDURE Delete_Quota_Assign
105 (p_api_version IN NUMBER ,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
107 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
108 p_validation_level IN NUMBER :=
109 FND_API.G_VALID_LEVEL_FULL ,
110 p_quota_assign_rec IN quota_assign_rec_type ,
111 x_return_status OUT NOCOPY VARCHAR2 ,
112 x_msg_count OUT NOCOPY NUMBER ,
113 x_msg_data OUT NOCOPY VARCHAR2 );
114
115 END CN_QUOTA_ASSIGN_PUB;