[Home] [Help]
PACKAGE: APPS.CN_QUOTA_ASSIGN_PVT
Source
1 PACKAGE CN_QUOTA_ASSIGN_PVT AUTHID CURRENT_USER AS
2 /*$Header: cnvpnags.pls 120.5 2006/05/11 06:02:29 kjayapau ship $*/
3
4 -- quota assign
5 TYPE quota_assign_rec_type IS RECORD
6 (
7 QUOTA_ASSIGN_ID CN_QUOTA_ASSIGNS.QUOTA_ASSIGN_ID%TYPE := CN_API.G_MISS_ID,
8 QUOTA_ID CN_QUOTA_ASSIGNS.QUOTA_ID%TYPE := CN_API.G_MISS_ID,
9 COMP_PLAN_ID CN_QUOTA_ASSIGNS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
10 NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,
11 DESCRIPTION CN_QUOTAS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
12 START_DATE CN_QUOTAS.START_DATE%TYPE := FND_API.G_MISS_DATE,
13 END_DATE CN_QUOTAS.END_DATE%TYPE := FND_API.G_MISS_DATE,
14 QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
15 OBJECT_VERSION_NUMBER CN_QUOTA_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE := NULL,
16 ORG_ID CN_QUOTA_ASSIGNS.ORG_ID%TYPE := NULL,
17 IDQ_FLAG varchar(10) := NULL
18 ) ;
19
20 TYPE quota_assign_tbl_type IS
21 TABLE OF quota_assign_rec_type INDEX BY BINARY_INTEGER ;
22
23 -- Global variable that represent missing values.
24
25 G_MISS_QUOTA_ASSIGN_REC quota_assign_rec_type;
26 G_MISS_QUOTA_ASSIGN_REC_TB quota_assign_tbl_type;
27
28
29 -- Start of comments
30 -- API name : Create_Quota_Assign
31 -- Type : Private.
32 -- Function :
33 -- Pre-reqs : None.
34 -- Parameters :
35 -- IN : p_api_version IN NUMBER Required
36 -- p_init_msg_list IN VARCHAR2 Optional
37 -- Default = FND_API.G_FALSE
38 -- p_commit IN VARCHAR2 Optional
39 -- Default = FND_API.G_FALSE
40 -- p_validation_level IN NUMBER Optional
41 -- Default = FND_API.G_VALID_LEVEL_FULL
42 -- p_quota_assign IN quota_assign_rec_type
43 -- OUT : x_return_status OUT VARCHAR2(1)
44 -- x_msg_count OUT NUMBER
45 -- x_msg_data OUT VARCHAR2(2000)
46 -- Version : Current version 1.0
47 -- Notes : Note text
48 --
49 -- End of comments
50 PROCEDURE Create_Quota_Assign
51 (p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53 p_commit IN VARCHAR2 := FND_API.G_FALSE,
54 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55 p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2);
59
60 -- Start of comments
61 -- API name : Update_Quota_Assign
62 -- Type : Private.
63 -- Function :
64 -- Pre-reqs : None.
65 -- Parameters :
66 -- IN : p_api_version IN NUMBER Required
67 -- p_init_msg_list IN VARCHAR2 Optional
68 -- Default = FND_API.G_FALSE
69 -- p_commit IN VARCHAR2 Optional
70 -- Default = FND_API.G_FALSE
71 -- p_validation_level IN NUMBER Optional
72 -- Default = FND_API.G_VALID_LEVEL_FULL
73 -- p_quota_assign IN quota_assign_rec_type
74 -- OUT : x_return_status OUT VARCHAR2(1)
75 -- x_msg_count OUT NUMBER
76 -- x_msg_data OUT VARCHAR2(2000)
77 -- Version : Current version 1.0
78 -- Notes : Note text
79 --
80 -- End of comments
81 PROCEDURE Update_Quota_Assign
82 (p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84 p_commit IN VARCHAR2 := FND_API.G_FALSE,
85 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86 p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2 );
90
91 -- Start of comments
92 -- API name : Delete_Quota_Assign
93 -- Type : Private.
94 -- Function :
95 -- Pre-reqs : None.
96 -- Parameters :
97 -- IN : p_api_version IN NUMBER Required
98 -- p_init_msg_list IN VARCHAR2 Optional
99 -- Default = FND_API.G_FALSE
100 -- p_commit IN VARCHAR2 Optional
101 -- Default = FND_API.G_FALSE
102 -- p_validation_level IN NUMBER Optional
103 -- Default = FND_API.G_VALID_LEVEL_FULL
104 -- p_quota_assign IN quota_assign_rec_type
105 -- OUT : x_return_status OUT VARCHAR2(1)
106 -- x_msg_count OUT NUMBER
107 -- x_msg_data OUT VARCHAR2(2000)
108 -- Version : Current version 1.0
109 -- Notes : Note text
110 --
111 -- End of comments
112 PROCEDURE Delete_Quota_Assign
113 (p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115 p_commit IN VARCHAR2 := FND_API.G_FALSE,
116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117 p_quota_assign IN quota_assign_rec_type,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2);
121
122
123 -- Start of comments
127 -- Pre-reqs : None.
124 -- API name : Get_Quota_Assign
125 -- Type : Private.
126 -- Function :
128 -- Parameters :
129 -- IN : p_api_version IN NUMBER Required
130 -- p_init_msg_list IN VARCHAR2 Optional
131 -- Default = FND_API.G_FALSE
132 -- p_commit IN VARCHAR2 Optional
133 -- Default = FND_API.G_FALSE
134 -- p_validation_level IN NUMBER Optional
135 -- Default = FND_API.G_VALID_LEVEL_FULL
139 -- x_msg_data OUT VARCHAR2(2000)
136 -- p_comp_plan_id IN NUMBER
137 -- OUT : x_return_status OUT VARCHAR2(1)
138 -- x_msg_count OUT NUMBER
140 -- x_quota_assign OUT quota_assign_tbl_type
141 -- Version : Current version 1.0
142 -- Notes : Note text
143 --
144 -- End of comments
145 PROCEDURE Get_Quota_Assign
146 (p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148 p_commit IN VARCHAR2 := FND_API.G_FALSE,
149 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150 p_comp_plan_id IN NUMBER,
151 x_quota_assign OUT NOCOPY quota_assign_tbl_type,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2);
155
156
157 END CN_QUOTA_ASSIGN_PVT;