10: -- Desc :
11: -- Parameters :
12: -- IN : p_api_version IN NUMBER Require
13: -- p_init_msg_list IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL
12: -- IN : p_api_version IN NUMBER Require
13: -- p_init_msg_list IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL
19: -- p_srp_pmt_plans_rec IN OUT NOCOPY
20: -- cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type
14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL
19: -- p_srp_pmt_plans_rec IN OUT NOCOPY
20: -- cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type
21: -- Required input :
22: -- PMT_PLAN_NAME payment plan name
34:
35: PROCEDURE Create_Srp_Pmt_Plan_Pre
36: (
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 := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
35: PROCEDURE Create_Srp_Pmt_Plan_Pre
36: (
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 := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
36: (
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 := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_srp_pmt_plans_rec IN OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type,
55: -- Desc :
56: -- Parameters :
57: -- IN : p_api_version IN NUMBER Require
58: -- p_init_msg_list IN VARCHAR2 Optional
59: -- Default = FND_API.G_FALSE
60: -- p_commit IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_validation_level IN NUMBER Optional
63: -- Default = FND_API.G_VALID_LEVEL_FULL
57: -- IN : p_api_version IN NUMBER Require
58: -- p_init_msg_list IN VARCHAR2 Optional
59: -- Default = FND_API.G_FALSE
60: -- p_commit IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_validation_level IN NUMBER Optional
63: -- Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_srp_pmt_plans_rec IN
65: -- cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type
59: -- Default = FND_API.G_FALSE
60: -- p_commit IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_validation_level IN NUMBER Optional
63: -- Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_srp_pmt_plans_rec IN
65: -- cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type
66: -- Required input :
67: -- PMT_PLAN_NAME payment plan name
79:
80: PROCEDURE Create_Srp_Pmt_Plan_Post
81: (
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: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
80: PROCEDURE Create_Srp_Pmt_Plan_Post
81: (
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: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
81: (
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: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_srp_pmt_plans_rec IN cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type,
99: -- Desc : Procedure to update pmt plan assignment of an salesrep
100: -- Parameters :
101: -- IN : p_api_version IN NUMBER Require
102: -- p_init_msg_list IN VARCHAR2 Optional
103: -- Default = FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Optional
105: -- Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional
107: -- Default = FND_API.G_VALID_LEVEL_FULL
101: -- IN : p_api_version IN NUMBER Require
102: -- p_init_msg_list IN VARCHAR2 Optional
103: -- Default = FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Optional
105: -- Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional
107: -- Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
109: -- Required input :
103: -- Default = FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Optional
105: -- Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional
107: -- Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
109: -- Required input :
110: -- PMT_PLAN_NAME payment plan name
111: -- SALESREP_TYPE,EMP_NUM use to get salesrep info
122:
123: PROCEDURE Update_Srp_Pmt_Plan_Pre
124: (
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
123: PROCEDURE Update_Srp_Pmt_Plan_Pre
124: (
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
124: (
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_old_srp_pmt_plans_rec IN OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type,
142: -- Desc : Procedure to update pmt plan assignment of an salesrep
143: -- Parameters :
144: -- IN : p_api_version IN NUMBER Require
145: -- p_init_msg_list IN VARCHAR2 Optional
146: -- Default = FND_API.G_FALSE
147: -- p_commit IN VARCHAR2 Optional
148: -- Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional
150: -- Default = FND_API.G_VALID_LEVEL_FULL
144: -- IN : p_api_version IN NUMBER Require
145: -- p_init_msg_list IN VARCHAR2 Optional
146: -- Default = FND_API.G_FALSE
147: -- p_commit IN VARCHAR2 Optional
148: -- Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional
150: -- Default = FND_API.G_VALID_LEVEL_FULL
151: -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
152: -- Required input :
146: -- Default = FND_API.G_FALSE
147: -- p_commit IN VARCHAR2 Optional
148: -- Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional
150: -- Default = FND_API.G_VALID_LEVEL_FULL
151: -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
152: -- Required input :
153: -- PMT_PLAN_NAME payment plan name
154: -- SALESREP_TYPE,EMP_NUM use to get salesrep info
165:
166: PROCEDURE Update_Srp_Pmt_Plan_Post
167: (
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
166: PROCEDURE Update_Srp_Pmt_Plan_Post
167: (
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
167: (
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_old_srp_pmt_plans_rec IN cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type
187: -- Desc : Procedure to delete a payment plan assignment to salesrep
188: -- Parameters :
189: -- IN : p_api_version IN NUMBER Require
190: -- p_init_msg_list IN VARCHAR2 Optional
191: -- Default = FND_API.G_FALSE
192: -- p_commit IN VARCHAR2 Optional
193: -- Default = FND_API.G_FALSE
194: -- p_validation_level IN NUMBER Optional
195: -- Default = FND_API.G_VALID_LEVEL_FULL
189: -- IN : p_api_version IN NUMBER Require
190: -- p_init_msg_list IN VARCHAR2 Optional
191: -- Default = FND_API.G_FALSE
192: -- p_commit IN VARCHAR2 Optional
193: -- Default = FND_API.G_FALSE
194: -- p_validation_level IN NUMBER Optional
195: -- Default = FND_API.G_VALID_LEVEL_FULL
196: -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
197: -- Required input :
191: -- Default = FND_API.G_FALSE
192: -- p_commit IN VARCHAR2 Optional
193: -- Default = FND_API.G_FALSE
194: -- p_validation_level IN NUMBER Optional
195: -- Default = FND_API.G_VALID_LEVEL_FULL
196: -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
197: -- Required input :
198: -- PMT_PLAN_NAME payment plan name
199: -- SALESREP_TYPE,EMP_NUM use to get salesrep info
209:
210: PROCEDURE Delete_Srp_Pmt_Plan_Pre
211: (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
210: PROCEDURE Delete_Srp_Pmt_Plan_Pre
211: (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
211: (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_srp_pmt_plans_rec IN OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type,
228: -- Desc : Procedure to delete a payment plan assignment to salesrep
229: -- Parameters :
230: -- IN : p_api_version IN NUMBER Require
231: -- p_init_msg_list IN VARCHAR2 Optional
232: -- Default = FND_API.G_FALSE
233: -- p_commit IN VARCHAR2 Optional
234: -- Default = FND_API.G_FALSE
235: -- p_validation_level IN NUMBER Optional
236: -- Default = FND_API.G_VALID_LEVEL_FULL
230: -- IN : p_api_version IN NUMBER Require
231: -- p_init_msg_list IN VARCHAR2 Optional
232: -- Default = FND_API.G_FALSE
233: -- p_commit IN VARCHAR2 Optional
234: -- Default = FND_API.G_FALSE
235: -- p_validation_level IN NUMBER Optional
236: -- Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
238: -- Required input :
232: -- Default = FND_API.G_FALSE
233: -- p_commit IN VARCHAR2 Optional
234: -- Default = FND_API.G_FALSE
235: -- p_validation_level IN NUMBER Optional
236: -- Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
238: -- Required input :
239: -- PMT_PLAN_NAME payment plan name
240: -- SALESREP_TYPE,EMP_NUM use to get salesrep info
250:
251: PROCEDURE Delete_Srp_Pmt_Plan_Post
252: (
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255: p_commit IN VARCHAR2 := FND_API.G_FALSE,
256: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_msg_count OUT NOCOPY NUMBER,
251: PROCEDURE Delete_Srp_Pmt_Plan_Post
252: (
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255: p_commit IN VARCHAR2 := FND_API.G_FALSE,
256: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_msg_count OUT NOCOPY NUMBER,
259: x_msg_data OUT NOCOPY VARCHAR2,
252: (
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255: p_commit IN VARCHAR2 := FND_API.G_FALSE,
256: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_msg_count OUT NOCOPY NUMBER,
259: x_msg_data OUT NOCOPY VARCHAR2,
260: p_srp_pmt_plans_rec IN cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type
269: -- Desc : Procedure to payment plan assignment from db
270: -- Parameters :
271: -- IN : p_api_version IN NUMBER Require
272: -- p_init_msg_list IN VARCHAR2 Optional
273: -- Default = FND_API.G_FALSE
274: -- p_commit IN VARCHAR2 Optional
275: -- Default = FND_API.G_FALSE
276: -- p_validation_level IN NUMBER Optional
277: -- Default = FND_API.G_VALID_LEVEL_FULL
271: -- IN : p_api_version IN NUMBER Require
272: -- p_init_msg_list IN VARCHAR2 Optional
273: -- Default = FND_API.G_FALSE
274: -- p_commit IN VARCHAR2 Optional
275: -- Default = FND_API.G_FALSE
276: -- p_validation_level IN NUMBER Optional
277: -- Default = FND_API.G_VALID_LEVEL_FULL
278: -- p_pmt_plan_name IN VARCHAR2 Optional
279: -- Default = FND_API.G_MISS_CHAR
273: -- Default = FND_API.G_FALSE
274: -- p_commit IN VARCHAR2 Optional
275: -- Default = FND_API.G_FALSE
276: -- p_validation_level IN NUMBER Optional
277: -- Default = FND_API.G_VALID_LEVEL_FULL
278: -- p_pmt_plan_name IN VARCHAR2 Optional
279: -- Default = FND_API.G_MISS_CHAR
280: -- p_salesrep_type IN VARCHAR2 Optional
281: -- Default = FND_API.G_MISS_CHAR
275: -- Default = FND_API.G_FALSE
276: -- p_validation_level IN NUMBER Optional
277: -- Default = FND_API.G_VALID_LEVEL_FULL
278: -- p_pmt_plan_name IN VARCHAR2 Optional
279: -- Default = FND_API.G_MISS_CHAR
280: -- p_salesrep_type IN VARCHAR2 Optional
281: -- Default = FND_API.G_MISS_CHAR
282: -- p_emp_num IN VARCHAR2 Optional
283: -- Default = FND_API.G_MISS_CHAR
277: -- Default = FND_API.G_VALID_LEVEL_FULL
278: -- p_pmt_plan_name IN VARCHAR2 Optional
279: -- Default = FND_API.G_MISS_CHAR
280: -- p_salesrep_type IN VARCHAR2 Optional
281: -- Default = FND_API.G_MISS_CHAR
282: -- p_emp_num IN VARCHAR2 Optional
283: -- Default = FND_API.G_MISS_CHAR
284: -- p_role_name IN VARCHAR2 Optional
285: -- Default = FND_API.G_MISS_CHAR
279: -- Default = FND_API.G_MISS_CHAR
280: -- p_salesrep_type IN VARCHAR2 Optional
281: -- Default = FND_API.G_MISS_CHAR
282: -- p_emp_num IN VARCHAR2 Optional
283: -- Default = FND_API.G_MISS_CHAR
284: -- p_role_name IN VARCHAR2 Optional
285: -- Default = FND_API.G_MISS_CHAR
286: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
287: -- x_msg_count OUT NOCOPY NUMBER
281: -- Default = FND_API.G_MISS_CHAR
282: -- p_emp_num IN VARCHAR2 Optional
283: -- Default = FND_API.G_MISS_CHAR
284: -- p_role_name IN VARCHAR2 Optional
285: -- Default = FND_API.G_MISS_CHAR
286: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
287: -- x_msg_count OUT NOCOPY NUMBER
288: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
289: -- x_srp_pmt_plans_rec_tbl OUT NOCOPY srp_pmt_plans_tbl_type
295:
296: PROCEDURE Get_Srp_Pmt_Plan_Pre
297: (
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
296: PROCEDURE Get_Srp_Pmt_Plan_Pre
297: (
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
297: (
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: p_pmt_plan_name IN OUT NOCOPY VARCHAR2,
317: -- Desc : Procedure to payment plan assignment from db
318: -- Parameters :
319: -- IN : p_api_version IN NUMBER Require
320: -- p_init_msg_list IN VARCHAR2 Optional
321: -- Default = FND_API.G_FALSE
322: -- p_commit IN VARCHAR2 Optional
323: -- Default = FND_API.G_FALSE
324: -- p_validation_level IN NUMBER Optional
325: -- Default = FND_API.G_VALID_LEVEL_FULL
319: -- IN : p_api_version IN NUMBER Require
320: -- p_init_msg_list IN VARCHAR2 Optional
321: -- Default = FND_API.G_FALSE
322: -- p_commit IN VARCHAR2 Optional
323: -- Default = FND_API.G_FALSE
324: -- p_validation_level IN NUMBER Optional
325: -- Default = FND_API.G_VALID_LEVEL_FULL
326: -- p_pmt_plan_name IN VARCHAR2 Optional
327: -- Default = FND_API.G_MISS_CHAR
321: -- Default = FND_API.G_FALSE
322: -- p_commit IN VARCHAR2 Optional
323: -- Default = FND_API.G_FALSE
324: -- p_validation_level IN NUMBER Optional
325: -- Default = FND_API.G_VALID_LEVEL_FULL
326: -- p_pmt_plan_name IN VARCHAR2 Optional
327: -- Default = FND_API.G_MISS_CHAR
328: -- p_salesrep_type IN VARCHAR2 Optional
329: -- Default = FND_API.G_MISS_CHAR
323: -- Default = FND_API.G_FALSE
324: -- p_validation_level IN NUMBER Optional
325: -- Default = FND_API.G_VALID_LEVEL_FULL
326: -- p_pmt_plan_name IN VARCHAR2 Optional
327: -- Default = FND_API.G_MISS_CHAR
328: -- p_salesrep_type IN VARCHAR2 Optional
329: -- Default = FND_API.G_MISS_CHAR
330: -- p_emp_num IN VARCHAR2 Optional
331: -- Default = FND_API.G_MISS_CHAR
325: -- Default = FND_API.G_VALID_LEVEL_FULL
326: -- p_pmt_plan_name IN VARCHAR2 Optional
327: -- Default = FND_API.G_MISS_CHAR
328: -- p_salesrep_type IN VARCHAR2 Optional
329: -- Default = FND_API.G_MISS_CHAR
330: -- p_emp_num IN VARCHAR2 Optional
331: -- Default = FND_API.G_MISS_CHAR
332: -- p_role_name IN VARCHAR2 Optional
333: -- Default = FND_API.G_MISS_CHAR
327: -- Default = FND_API.G_MISS_CHAR
328: -- p_salesrep_type IN VARCHAR2 Optional
329: -- Default = FND_API.G_MISS_CHAR
330: -- p_emp_num IN VARCHAR2 Optional
331: -- Default = FND_API.G_MISS_CHAR
332: -- p_role_name IN VARCHAR2 Optional
333: -- Default = FND_API.G_MISS_CHAR
334: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
335: -- x_msg_count OUT NOCOPY NUMBER
329: -- Default = FND_API.G_MISS_CHAR
330: -- p_emp_num IN VARCHAR2 Optional
331: -- Default = FND_API.G_MISS_CHAR
332: -- p_role_name IN VARCHAR2 Optional
333: -- Default = FND_API.G_MISS_CHAR
334: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
335: -- x_msg_count OUT NOCOPY NUMBER
336: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
337: -- x_srp_pmt_plans_rec_tbl OUT NOCOPY srp_pmt_plans_tbl_type
343:
344: PROCEDURE Get_Srp_Pmt_Plan_Post
345: (
346: p_api_version IN NUMBER,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
344: PROCEDURE Get_Srp_Pmt_Plan_Post
345: (
346: p_api_version IN NUMBER,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
345: (
346: p_api_version IN NUMBER,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
353: p_pmt_plan_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
353: p_pmt_plan_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
354: p_salesrep_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_emp_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_role_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: x_srp_pmt_plans_rec_tbl OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_tbl_type ,
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
353: p_pmt_plan_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
354: p_salesrep_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_emp_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_role_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: x_srp_pmt_plans_rec_tbl OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_tbl_type ,
358: x_loading_status OUT NOCOPY VARCHAR2
351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
353: p_pmt_plan_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
354: p_salesrep_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_emp_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_role_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: x_srp_pmt_plans_rec_tbl OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_tbl_type ,
358: x_loading_status OUT NOCOPY VARCHAR2
359: );
352: x_msg_data OUT NOCOPY VARCHAR2,
353: p_pmt_plan_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
354: p_salesrep_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_emp_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_role_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: x_srp_pmt_plans_rec_tbl OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_tbl_type ,
358: x_loading_status OUT NOCOPY VARCHAR2
359: );
360: