42: -- Pre-reqs : None.
43: -- Parameters :
44: -- IN : p_api_version IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Optional
46: -- Default = FND_API.G_FALSE
47: -- p_commit IN VARCHAR2 Optional
48: -- Default = FND_API.G_FALSE
49: -- p_validation_level IN NUMBER Optional
50: -- Default = FND_API.G_VALID_LEVEL_FULL
44: -- IN : p_api_version IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Optional
46: -- Default = FND_API.G_FALSE
47: -- p_commit IN VARCHAR2 Optional
48: -- Default = FND_API.G_FALSE
49: -- p_validation_level IN NUMBER Optional
50: -- Default = FND_API.G_VALID_LEVEL_FULL
51: -- p_plan_text IN plan_text_rec_type
52: -- OUT : x_return_status OUT VARCHAR2(1)
46: -- Default = FND_API.G_FALSE
47: -- p_commit IN VARCHAR2 Optional
48: -- Default = FND_API.G_FALSE
49: -- p_validation_level IN NUMBER Optional
50: -- Default = FND_API.G_VALID_LEVEL_FULL
51: -- p_plan_text IN plan_text_rec_type
52: -- OUT : x_return_status OUT VARCHAR2(1)
53: -- x_msg_count OUT NUMBER
54: -- x_msg_data OUT VARCHAR2(2000)
57: --
58: -- End of comments
59: PROCEDURE Create_Plan_Text
60: (p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62: p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64: p_plan_text IN plan_text_rec_type,
65: x_return_status OUT NOCOPY VARCHAR2,
58: -- End of comments
59: PROCEDURE Create_Plan_Text
60: (p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62: p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64: p_plan_text IN plan_text_rec_type,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
59: PROCEDURE Create_Plan_Text
60: (p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62: p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64: p_plan_text IN plan_text_rec_type,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2);
75: -- Pre-reqs : None.
76: -- Parameters :
77: -- IN : p_api_version IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional
79: -- Default = FND_API.G_FALSE
80: -- p_commit IN VARCHAR2 Optional
81: -- Default = FND_API.G_FALSE
82: -- p_validation_level IN NUMBER Optional
83: -- Default = FND_API.G_VALID_LEVEL_FULL
77: -- IN : p_api_version IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional
79: -- Default = FND_API.G_FALSE
80: -- p_commit IN VARCHAR2 Optional
81: -- Default = FND_API.G_FALSE
82: -- p_validation_level IN NUMBER Optional
83: -- Default = FND_API.G_VALID_LEVEL_FULL
84: -- p_plan_text IN plan_text_rec_type
85: -- OUT : x_return_status OUT VARCHAR2(1)
79: -- Default = FND_API.G_FALSE
80: -- p_commit IN VARCHAR2 Optional
81: -- Default = FND_API.G_FALSE
82: -- p_validation_level IN NUMBER Optional
83: -- Default = FND_API.G_VALID_LEVEL_FULL
84: -- p_plan_text IN plan_text_rec_type
85: -- OUT : x_return_status OUT VARCHAR2(1)
86: -- x_msg_count OUT NUMBER
87: -- x_msg_data OUT VARCHAR2(2000)
90: --
91: -- End of comments
92: PROCEDURE Update_Plan_Text
93: (p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97: p_plan_text IN plan_text_rec_type,
98: x_return_status OUT NOCOPY VARCHAR2,
91: -- End of comments
92: PROCEDURE Update_Plan_Text
93: (p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97: p_plan_text IN plan_text_rec_type,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
92: PROCEDURE Update_Plan_Text
93: (p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97: p_plan_text IN plan_text_rec_type,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2 );
108: -- Pre-reqs : None.
109: -- Parameters :
110: -- IN : p_api_version IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional
112: -- Default = FND_API.G_FALSE
113: -- p_commit IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional
116: -- Default = FND_API.G_VALID_LEVEL_FULL
110: -- IN : p_api_version IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional
112: -- Default = FND_API.G_FALSE
113: -- p_commit IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional
116: -- Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_plan_text IN plan_text_rec_type
118: -- OUT : x_return_status OUT VARCHAR2(1)
112: -- Default = FND_API.G_FALSE
113: -- p_commit IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional
116: -- Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_plan_text IN plan_text_rec_type
118: -- OUT : x_return_status OUT VARCHAR2(1)
119: -- x_msg_count OUT NUMBER
120: -- x_msg_data OUT VARCHAR2(2000)
123: --
124: -- End of comments
125: PROCEDURE Delete_Plan_Text
126: (p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128: p_commit IN VARCHAR2 := FND_API.G_FALSE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_plan_text IN plan_text_rec_type,
131: x_return_status OUT NOCOPY VARCHAR2,
124: -- End of comments
125: PROCEDURE Delete_Plan_Text
126: (p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128: p_commit IN VARCHAR2 := FND_API.G_FALSE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_plan_text IN plan_text_rec_type,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
125: PROCEDURE Delete_Plan_Text
126: (p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128: p_commit IN VARCHAR2 := FND_API.G_FALSE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_plan_text IN plan_text_rec_type,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2);
141: -- Pre-reqs : None.
142: -- Parameters :
143: -- IN : p_api_version IN NUMBER Required
144: -- p_init_msg_list IN VARCHAR2 Optional
145: -- Default = FND_API.G_FALSE
146: -- p_commit IN VARCHAR2 Optional
147: -- Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional
149: -- Default = FND_API.G_VALID_LEVEL_FULL
143: -- IN : p_api_version IN NUMBER Required
144: -- p_init_msg_list IN VARCHAR2 Optional
145: -- Default = FND_API.G_FALSE
146: -- p_commit IN VARCHAR2 Optional
147: -- Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional
149: -- Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_role_id IN NUMBER
151: -- p_role_model_id IN NUMBER
145: -- Default = FND_API.G_FALSE
146: -- p_commit IN VARCHAR2 Optional
147: -- Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional
149: -- Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_role_id IN NUMBER
151: -- p_role_model_id IN NUMBER
152: -- OUT : x_return_status OUT VARCHAR2(1)
153: -- x_msg_count OUT NUMBER
159: --
160: -- End of comments
161: PROCEDURE Get_Plan_Texts
162: (p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: p_role_id IN NUMBER,
167: p_role_model_id IN NUMBER,
160: -- End of comments
161: PROCEDURE Get_Plan_Texts
162: (p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: p_role_id IN NUMBER,
167: p_role_model_id IN NUMBER,
168: x_plan_texts OUT NOCOPY plan_text_tbl_type,
161: PROCEDURE Get_Plan_Texts
162: (p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: p_role_id IN NUMBER,
167: p_role_model_id IN NUMBER,
168: x_plan_texts OUT NOCOPY plan_text_tbl_type,
169: x_updatable OUT NOCOPY VARCHAR2,
179: -- Pre-reqs : None.
180: -- Parameters :
181: -- IN : p_api_version IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional
183: -- Default = FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Optional
185: -- Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional
187: -- Default = FND_API.G_VALID_LEVEL_FULL
181: -- IN : p_api_version IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional
183: -- Default = FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Optional
185: -- Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional
187: -- Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_role_id IN NUMBER
189: -- p_role_model_id IN NUMBER
183: -- Default = FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Optional
185: -- Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional
187: -- Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_role_id IN NUMBER
189: -- p_role_model_id IN NUMBER
190: -- OUT : x_return_status OUT VARCHAR2(1)
191: -- x_msg_count OUT NUMBER
196: --
197: -- End of comments
198: PROCEDURE Get_Fixed_Quota_Cates (
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: p_role_id IN NUMBER,
204: p_role_model_id IN NUMBER,
197: -- End of comments
198: PROCEDURE Get_Fixed_Quota_Cates (
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: p_role_id IN NUMBER,
204: p_role_model_id IN NUMBER,
205: x_quota_cates OUT NOCOPY quota_cate_tbl_type,
198: PROCEDURE Get_Fixed_Quota_Cates (
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: p_role_id IN NUMBER,
204: p_role_model_id IN NUMBER,
205: x_quota_cates OUT NOCOPY quota_cate_tbl_type,
206: x_return_status OUT NOCOPY VARCHAR2,
215: -- Pre-reqs : None.
216: -- Parameters :
217: -- IN : p_api_version IN NUMBER Required
218: -- p_init_msg_list IN VARCHAR2 Optional
219: -- Default = FND_API.G_FALSE
220: -- p_commit IN VARCHAR2 Optional
221: -- Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional
223: -- Default = FND_API.G_VALID_LEVEL_FULL
217: -- IN : p_api_version IN NUMBER Required
218: -- p_init_msg_list IN VARCHAR2 Optional
219: -- Default = FND_API.G_FALSE
220: -- p_commit IN VARCHAR2 Optional
221: -- Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional
223: -- Default = FND_API.G_VALID_LEVEL_FULL
224: -- p_role_id IN NUMBER
225: -- p_role_model_id IN NUMBER
219: -- Default = FND_API.G_FALSE
220: -- p_commit IN VARCHAR2 Optional
221: -- Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional
223: -- Default = FND_API.G_VALID_LEVEL_FULL
224: -- p_role_id IN NUMBER
225: -- p_role_model_id IN NUMBER
226: -- OUT : x_return_status OUT VARCHAR2(1)
227: -- x_msg_count OUT NUMBER
232: --
233: -- End of comments
234: PROCEDURE Get_Var_Quota_Cates (
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
237: p_commit IN VARCHAR2 := FND_API.G_FALSE,
238: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
239: p_role_id IN NUMBER,
240: p_role_model_id IN NUMBER,
233: -- End of comments
234: PROCEDURE Get_Var_Quota_Cates (
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
237: p_commit IN VARCHAR2 := FND_API.G_FALSE,
238: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
239: p_role_id IN NUMBER,
240: p_role_model_id IN NUMBER,
241: x_quota_cates OUT NOCOPY quota_cate_tbl_type,
234: PROCEDURE Get_Var_Quota_Cates (
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
237: p_commit IN VARCHAR2 := FND_API.G_FALSE,
238: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
239: p_role_id IN NUMBER,
240: p_role_model_id IN NUMBER,
241: x_quota_cates OUT NOCOPY quota_cate_tbl_type,
242: x_return_status OUT NOCOPY VARCHAR2,
250: -- Pre-reqs : None.
251: -- Parameters :
252: -- IN : p_api_version IN NUMBER Required
253: -- p_init_msg_list IN VARCHAR2 Optional
254: -- Default = FND_API.G_FALSE
255: -- p_commit IN VARCHAR2 Optional
256: -- Default = FND_API.G_FALSE
257: -- p_validation_level IN NUMBER Optional
258: -- Default = FND_API.G_VALID_LEVEL_FULL
252: -- IN : p_api_version IN NUMBER Required
253: -- p_init_msg_list IN VARCHAR2 Optional
254: -- Default = FND_API.G_FALSE
255: -- p_commit IN VARCHAR2 Optional
256: -- Default = FND_API.G_FALSE
257: -- p_validation_level IN NUMBER Optional
258: -- Default = FND_API.G_VALID_LEVEL_FULL
259: -- p_role_id IN NUMBER
260: -- p_role_model_id IN NUMBER
254: -- Default = FND_API.G_FALSE
255: -- p_commit IN VARCHAR2 Optional
256: -- Default = FND_API.G_FALSE
257: -- p_validation_level IN NUMBER Optional
258: -- Default = FND_API.G_VALID_LEVEL_FULL
259: -- p_role_id IN NUMBER
260: -- p_role_model_id IN NUMBER
261: -- OUT : x_return_status OUT VARCHAR2(1)
262: -- x_msg_count OUT NUMBER
267: --
268: -- End of comments
269: PROCEDURE Get_Quota_Cates (
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: p_role_id IN NUMBER,
275: p_role_model_id IN NUMBER,
268: -- End of comments
269: PROCEDURE Get_Quota_Cates (
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: p_role_id IN NUMBER,
275: p_role_model_id IN NUMBER,
276: p_quota_cate_type IN VARCHAR2,
269: PROCEDURE Get_Quota_Cates (
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: p_role_id IN NUMBER,
275: p_role_model_id IN NUMBER,
276: p_quota_cate_type IN VARCHAR2,
277: x_quota_cates OUT NOCOPY quota_cate_tbl_type,
287: -- Pre-reqs : None.
288: -- Parameters :
289: -- IN : p_api_version IN NUMBER Required
290: -- p_init_msg_list IN VARCHAR2 Optional
291: -- Default = FND_API.G_FALSE
292: -- p_commit IN VARCHAR2 Optional
293: -- Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional
295: -- Default = FND_API.G_VALID_LEVEL_FULL
289: -- IN : p_api_version IN NUMBER Required
290: -- p_init_msg_list IN VARCHAR2 Optional
291: -- Default = FND_API.G_FALSE
292: -- p_commit IN VARCHAR2 Optional
293: -- Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional
295: -- Default = FND_API.G_VALID_LEVEL_FULL
296: -- p_role_id IN NUMBER
297: -- p_role_model_id IN NUMBER
291: -- Default = FND_API.G_FALSE
292: -- p_commit IN VARCHAR2 Optional
293: -- Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional
295: -- Default = FND_API.G_VALID_LEVEL_FULL
296: -- p_role_id IN NUMBER
297: -- p_role_model_id IN NUMBER
298: -- OUT : x_return_status OUT VARCHAR2(1)
299: -- x_msg_count OUT NUMBER
304: --
305: -- End of comments
306: PROCEDURE Get_Role_Name
307: (p_api_version IN NUMBER,
308: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE,
310: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
311: p_role_id IN NUMBER,
312: p_role_model_id IN NUMBER,
305: -- End of comments
306: PROCEDURE Get_Role_Name
307: (p_api_version IN NUMBER,
308: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE,
310: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
311: p_role_id IN NUMBER,
312: p_role_model_id IN NUMBER,
313: x_role_name OUT NOCOPY VARCHAR2,
306: PROCEDURE Get_Role_Name
307: (p_api_version IN NUMBER,
308: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE,
310: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
311: p_role_id IN NUMBER,
312: p_role_model_id IN NUMBER,
313: x_role_name OUT NOCOPY VARCHAR2,
314: x_return_status OUT NOCOPY VARCHAR2,