80: -- Usage : Procedure to create a sales role and comp plan assignment.
81: -- Parameters :
82: -- IN : p_api_version IN NUMBER Require
83: -- : p_init_msg_list IN VARCHAR2 Optional
84: -- Default = FND_API.G_FALSE
85: -- : p_commit IN VARCHAR2 Optional
86: -- Default = FND_API.G_FALSE
87: -- : p_validation_level IN NUMBER Optional
88: -- Default = FND_API.G_VALID_LEVEL_FULL
82: -- IN : p_api_version IN NUMBER Require
83: -- : p_init_msg_list IN VARCHAR2 Optional
84: -- Default = FND_API.G_FALSE
85: -- : p_commit IN VARCHAR2 Optional
86: -- Default = FND_API.G_FALSE
87: -- : p_validation_level IN NUMBER Optional
88: -- Default = FND_API.G_VALID_LEVEL_FULL
89: -- : p_role_plan_rec IN ROLE_PLAN_REC_TYPE
90: -- OUT : x_return_status OUT VARCHAR2(1)
84: -- Default = FND_API.G_FALSE
85: -- : p_commit IN VARCHAR2 Optional
86: -- Default = FND_API.G_FALSE
87: -- : p_validation_level IN NUMBER Optional
88: -- Default = FND_API.G_VALID_LEVEL_FULL
89: -- : p_role_plan_rec IN ROLE_PLAN_REC_TYPE
90: -- OUT : x_return_status OUT VARCHAR2(1)
91: -- : x_msg_count OUT NUMBER
92: -- : x_msg_data OUT VARCHAR2(2000)
127: */
128:
129: PROCEDURE Create_Role_Plan
130: ( p_api_version IN NUMBER ,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
134: x_return_status OUT NOCOPY VARCHAR2 ,
135: x_loading_status OUT NOCOPY VARCHAR2 ,
128:
129: PROCEDURE Create_Role_Plan
130: ( p_api_version IN NUMBER ,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
134: x_return_status OUT NOCOPY VARCHAR2 ,
135: x_loading_status OUT NOCOPY VARCHAR2 ,
136: x_msg_count OUT NOCOPY NUMBER ,
129: PROCEDURE Create_Role_Plan
130: ( p_api_version IN NUMBER ,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
134: x_return_status OUT NOCOPY VARCHAR2 ,
135: x_loading_status OUT NOCOPY VARCHAR2 ,
136: x_msg_count OUT NOCOPY NUMBER ,
137: x_msg_data OUT NOCOPY VARCHAR2 ,
147: -- Usage : Procedure to update a sales role and comp plan assignment.
148: -- Parameters :
149: -- IN : p_api_version IN NUMBER Require
150: -- : p_init_msg_list IN VARCHAR2 Optional
151: -- Default = FND_API.G_FALSE
152: -- : p_commit IN VARCHAR2 Optional
153: -- Default = FND_API.G_FALSE
154: -- : p_validation_level IN NUMBER Optional
155: -- Default = FND_API.G_VALID_LEVEL_FULL
149: -- IN : p_api_version IN NUMBER Require
150: -- : p_init_msg_list IN VARCHAR2 Optional
151: -- Default = FND_API.G_FALSE
152: -- : p_commit IN VARCHAR2 Optional
153: -- Default = FND_API.G_FALSE
154: -- : p_validation_level IN NUMBER Optional
155: -- Default = FND_API.G_VALID_LEVEL_FULL
156: -- : p_role_plan_rec_old IN ROLE_PLAN_REC_TYPE
157: -- : p_role_plan_rec_new IN ROLE_PLAN_REC_TYPE
151: -- Default = FND_API.G_FALSE
152: -- : p_commit IN VARCHAR2 Optional
153: -- Default = FND_API.G_FALSE
154: -- : p_validation_level IN NUMBER Optional
155: -- Default = FND_API.G_VALID_LEVEL_FULL
156: -- : p_role_plan_rec_old IN ROLE_PLAN_REC_TYPE
157: -- : p_role_plan_rec_new IN ROLE_PLAN_REC_TYPE
158: -- OUT : x_return_status OUT VARCHAR2(1)
159: -- : x_msg_count OUT NUMBER
199:
200:
201: PROCEDURE Update_Role_Plan
202: ( p_api_version IN NUMBER ,
203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
204: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: x_return_status OUT NOCOPY VARCHAR2 ,
207: x_loading_status OUT NOCOPY VARCHAR2 ,
200:
201: PROCEDURE Update_Role_Plan
202: ( p_api_version IN NUMBER ,
203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
204: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: x_return_status OUT NOCOPY VARCHAR2 ,
207: x_loading_status OUT NOCOPY VARCHAR2 ,
208: x_msg_count OUT NOCOPY NUMBER ,
201: PROCEDURE Update_Role_Plan
202: ( p_api_version IN NUMBER ,
203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
204: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: x_return_status OUT NOCOPY VARCHAR2 ,
207: x_loading_status OUT NOCOPY VARCHAR2 ,
208: x_msg_count OUT NOCOPY NUMBER ,
209: x_msg_data OUT NOCOPY VARCHAR2 ,
222: -- Usage : Procedure to delete a sales role and comp plan assignment.
223: -- Parameters :
224: -- IN : p_api_version IN NUMBER Require
225: -- : p_init_msg_list IN VARCHAR2 Optional
226: -- Default = FND_API.G_FALSE
227: -- : p_commit IN VARCHAR2 Optional
228: -- Default = FND_API.G_FALSE
229: -- : p_validation_level IN NUMBER Optional
230: -- Default = FND_API.G_VALID_LEVEL_FULL
224: -- IN : p_api_version IN NUMBER Require
225: -- : p_init_msg_list IN VARCHAR2 Optional
226: -- Default = FND_API.G_FALSE
227: -- : p_commit IN VARCHAR2 Optional
228: -- Default = FND_API.G_FALSE
229: -- : p_validation_level IN NUMBER Optional
230: -- Default = FND_API.G_VALID_LEVEL_FULL
231: -- p_role_plan_rec IN ROLE_PLAN_REC_TYPE
232: -- OUT : x_return_status OUT VARCHAR2(1)
226: -- Default = FND_API.G_FALSE
227: -- : p_commit IN VARCHAR2 Optional
228: -- Default = FND_API.G_FALSE
229: -- : p_validation_level IN NUMBER Optional
230: -- Default = FND_API.G_VALID_LEVEL_FULL
231: -- p_role_plan_rec IN ROLE_PLAN_REC_TYPE
232: -- OUT : x_return_status OUT VARCHAR2(1)
233: -- : x_msg_count OUT NUMBER
234: -- : x_msg_data OUT VARCHAR2(2000)
260:
261:
262: PROCEDURE Delete_Role_Plan
263: ( p_api_version IN NUMBER ,
264: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
265: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: x_return_status OUT NOCOPY VARCHAR2 ,
268: x_loading_status OUT NOCOPY VARCHAR2 ,
261:
262: PROCEDURE Delete_Role_Plan
263: ( p_api_version IN NUMBER ,
264: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
265: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: x_return_status OUT NOCOPY VARCHAR2 ,
268: x_loading_status OUT NOCOPY VARCHAR2 ,
269: x_msg_count OUT NOCOPY NUMBER ,
262: PROCEDURE Delete_Role_Plan
263: ( p_api_version IN NUMBER ,
264: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
265: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: x_return_status OUT NOCOPY VARCHAR2 ,
268: x_loading_status OUT NOCOPY VARCHAR2 ,
269: x_msg_count OUT NOCOPY NUMBER ,
270: x_msg_data OUT NOCOPY VARCHAR2 ,