60: -- Usage : Procedure to create a sales role and pmt plan assignment.
61: -- Parameters :
62: -- IN : p_api_version IN NUMBER Require
63: -- : p_init_msg_list IN VARCHAR2 Optional
64: -- Default = FND_API.G_FALSE
65: -- : p_commit IN VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- : p_validation_level IN NUMBER Optional
68: -- Default = FND_API.G_VALID_LEVEL_FULL
62: -- IN : p_api_version IN NUMBER Require
63: -- : p_init_msg_list IN VARCHAR2 Optional
64: -- Default = FND_API.G_FALSE
65: -- : p_commit IN VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- : p_validation_level IN NUMBER Optional
68: -- Default = FND_API.G_VALID_LEVEL_FULL
69: -- : p_role_pmt_plan_rec IN ROLE_PMT_PLAN_REC_TYPE
70: -- OUT : x_return_status OUT VARCHAR2(1)
64: -- Default = FND_API.G_FALSE
65: -- : p_commit IN VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- : p_validation_level IN NUMBER Optional
68: -- Default = FND_API.G_VALID_LEVEL_FULL
69: -- : p_role_pmt_plan_rec IN ROLE_PMT_PLAN_REC_TYPE
70: -- OUT : x_return_status OUT VARCHAR2(1)
71: -- : x_msg_count OUT NUMBER
72: -- : x_msg_data OUT VARCHAR2(2000)
93:
94:
95: PROCEDURE Create_Role_Pmt_Plan
96: ( p_api_version IN NUMBER ,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
99: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
100: x_return_status OUT NOCOPY VARCHAR2 ,
101: x_loading_status OUT NOCOPY VARCHAR2 ,
94:
95: PROCEDURE Create_Role_Pmt_Plan
96: ( p_api_version IN NUMBER ,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
99: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
100: x_return_status OUT NOCOPY VARCHAR2 ,
101: x_loading_status OUT NOCOPY VARCHAR2 ,
102: x_msg_count OUT NOCOPY NUMBER ,
95: PROCEDURE Create_Role_Pmt_Plan
96: ( p_api_version IN NUMBER ,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
99: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
100: x_return_status OUT NOCOPY VARCHAR2 ,
101: x_loading_status OUT NOCOPY VARCHAR2 ,
102: x_msg_count OUT NOCOPY NUMBER ,
103: x_msg_data OUT NOCOPY VARCHAR2 ,
111: -- Usage : Procedure to update a sales role and pmt plan assignment.
112: -- Parameters :
113: -- IN : p_api_version IN NUMBER Require
114: -- : p_init_msg_list IN VARCHAR2 Optional
115: -- Default = FND_API.G_FALSE
116: -- : p_commit IN VARCHAR2 Optional
117: -- Default = FND_API.G_FALSE
118: -- : p_validation_level IN NUMBER Optional
119: -- Default = FND_API.G_VALID_LEVEL_FULL
113: -- IN : p_api_version IN NUMBER Require
114: -- : p_init_msg_list IN VARCHAR2 Optional
115: -- Default = FND_API.G_FALSE
116: -- : p_commit IN VARCHAR2 Optional
117: -- Default = FND_API.G_FALSE
118: -- : p_validation_level IN NUMBER Optional
119: -- Default = FND_API.G_VALID_LEVEL_FULL
120: -- : p_role_pmt_plan_rec_old IN ROLE_PMT_PLAN_REC_TYPE
121: -- : p_role_pmt_plan_rec_new IN ROLE_PMT_PLAN_REC_TYPE
115: -- Default = FND_API.G_FALSE
116: -- : p_commit IN VARCHAR2 Optional
117: -- Default = FND_API.G_FALSE
118: -- : p_validation_level IN NUMBER Optional
119: -- Default = FND_API.G_VALID_LEVEL_FULL
120: -- : p_role_pmt_plan_rec_old IN ROLE_PMT_PLAN_REC_TYPE
121: -- : p_role_pmt_plan_rec_new IN ROLE_PMT_PLAN_REC_TYPE
122: -- OUT : x_return_status OUT VARCHAR2(1)
123: -- : x_msg_count OUT NUMBER
146:
147:
148: PROCEDURE Update_Role_Pmt_Plan
149: ( p_api_version IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2 ,
154: x_loading_status OUT NOCOPY VARCHAR2 ,
147:
148: PROCEDURE Update_Role_Pmt_Plan
149: ( p_api_version IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2 ,
154: x_loading_status OUT NOCOPY VARCHAR2 ,
155: x_msg_count OUT NOCOPY NUMBER ,
148: PROCEDURE Update_Role_Pmt_Plan
149: ( p_api_version IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2 ,
154: x_loading_status OUT NOCOPY VARCHAR2 ,
155: x_msg_count OUT NOCOPY NUMBER ,
156: x_msg_data OUT NOCOPY VARCHAR2 ,
168: -- Usage : Procedure to delete a sales role and pmt plan assignment.
169: -- Parameters :
170: -- IN : p_api_version IN NUMBER Require
171: -- : p_init_msg_list IN VARCHAR2 Optional
172: -- Default = FND_API.G_FALSE
173: -- : p_commit IN VARCHAR2 Optional
174: -- Default = FND_API.G_FALSE
175: -- : p_validation_level IN NUMBER Optional
176: -- Default = FND_API.G_VALID_LEVEL_FULL
170: -- IN : p_api_version IN NUMBER Require
171: -- : p_init_msg_list IN VARCHAR2 Optional
172: -- Default = FND_API.G_FALSE
173: -- : p_commit IN VARCHAR2 Optional
174: -- Default = FND_API.G_FALSE
175: -- : p_validation_level IN NUMBER Optional
176: -- Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_role_pmt_plan_rec IN ROLE_PMT_PLAN_REC_TYPE
178: -- OUT : x_return_status OUT VARCHAR2(1)
172: -- Default = FND_API.G_FALSE
173: -- : p_commit IN VARCHAR2 Optional
174: -- Default = FND_API.G_FALSE
175: -- : p_validation_level IN NUMBER Optional
176: -- Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_role_pmt_plan_rec IN ROLE_PMT_PLAN_REC_TYPE
178: -- OUT : x_return_status OUT VARCHAR2(1)
179: -- : x_msg_count OUT NUMBER
180: -- : x_msg_data OUT VARCHAR2(2000)
191:
192:
193: PROCEDURE Delete_Role_Pmt_Plan
194: ( p_api_version IN NUMBER ,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2 ,
199: x_loading_status OUT NOCOPY VARCHAR2 ,
192:
193: PROCEDURE Delete_Role_Pmt_Plan
194: ( p_api_version IN NUMBER ,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2 ,
199: x_loading_status OUT NOCOPY VARCHAR2 ,
200: x_msg_count OUT NOCOPY NUMBER ,
193: PROCEDURE Delete_Role_Pmt_Plan
194: ( p_api_version IN NUMBER ,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2 ,
199: x_loading_status OUT NOCOPY VARCHAR2 ,
200: x_msg_count OUT NOCOPY NUMBER ,
201: x_msg_data OUT NOCOPY VARCHAR2 ,