APPS.CN_SRP_PMT_PLANS_PUB_VUHK dependencies on FND_API

Line 14: -- Default = FND_API.G_FALSE

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

Line 16: -- Default = FND_API.G_FALSE

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

Line 18: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 39: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 59: -- Default = FND_API.G_FALSE

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

Line 61: -- Default = FND_API.G_FALSE

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

Line 63: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 84: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 103: -- Default = FND_API.G_FALSE

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

Line 105: -- Default = FND_API.G_FALSE

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 :

Line 107: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 127: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 146: -- Default = FND_API.G_FALSE

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

Line 148: -- Default = FND_API.G_FALSE

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 :

Line 150: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 170: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 191: -- Default = FND_API.G_FALSE

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

Line 193: -- Default = FND_API.G_FALSE

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 :

Line 195: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 214: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 232: -- Default = FND_API.G_FALSE

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

Line 234: -- Default = FND_API.G_FALSE

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 :

Line 236: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 255: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 256: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 273: -- Default = FND_API.G_FALSE

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

Line 275: -- Default = FND_API.G_FALSE

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

Line 277: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 279: -- 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

Line 281: -- 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

Line 283: -- 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

Line 285: -- Default = FND_API.G_MISS_CHAR

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

Line 299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 300: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 321: -- Default = FND_API.G_FALSE

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

Line 323: -- Default = FND_API.G_FALSE

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

Line 325: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 327: -- 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

Line 329: -- 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

Line 331: -- 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

Line 333: -- Default = FND_API.G_MISS_CHAR

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

Line 347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 348: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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 ,

Line 354: p_salesrep_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

Line 355: p_emp_num IN VARCHAR2 := FND_API.G_MISS_CHAR,

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: );

Line 356: p_role_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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: