55: -- Usage : To update the Payment Transaction and Worksheets
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: -- OUT : x_return_status OUT VARCHAR2(1)
65: -- x_msg_count OUT NUMBER
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: -- OUT : x_return_status OUT VARCHAR2(1)
65: -- x_msg_count OUT NUMBER
66: -- x_msg_data OUT VARCHAR2(2000)
67: -- IN : p_payment_transaction_id IN NUMBER
109: -- Usage : To create new records in cn_payment_transactions
110: -- Parameters :
111: -- IN : p_api_version IN NUMBER Require
112: -- p_init_msg_list IN VARCHAR2 Optional
113: -- Default = FND_API.G_FALSE
114: -- p_commit IN VARCHAR2 Optional
115: -- Default = FND_API.G_FALSE
116: -- p_validation_level IN NUMBER Optional
117: -- Default = FND_API.G_VALID_LEVEL_FULL
111: -- IN : p_api_version IN NUMBER Require
112: -- p_init_msg_list IN VARCHAR2 Optional
113: -- Default = FND_API.G_FALSE
114: -- p_commit IN VARCHAR2 Optional
115: -- Default = FND_API.G_FALSE
116: -- p_validation_level IN NUMBER Optional
117: -- Default = FND_API.G_VALID_LEVEL_FULL
118: -- OUT : x_return_status OUT VARCHAR2(1)
119: -- x_msg_count OUT NUMBER
113: -- Default = FND_API.G_FALSE
114: -- p_commit IN VARCHAR2 Optional
115: -- Default = FND_API.G_FALSE
116: -- p_validation_level IN NUMBER Optional
117: -- Default = FND_API.G_VALID_LEVEL_FULL
118: -- OUT : x_return_status OUT VARCHAR2(1)
119: -- x_msg_count OUT NUMBER
120: -- x_msg_data OUT VARCHAR2(2000)
121: -- IN : p_salesrep_id IN NUMBER
159: -- Usage : To delete the cn_payment_transactions only manual pmt
160: -- Parameters :
161: -- IN : p_api_version IN NUMBER Require
162: -- p_init_msg_list IN VARCHAR2 Optional
163: -- Default = FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Optional
165: -- Default = FND_API.G_FALSE
166: -- p_validation_level IN NUMBER Optional
167: -- Default = FND_API.G_VALID_LEVEL_FULL
161: -- IN : p_api_version IN NUMBER Require
162: -- p_init_msg_list IN VARCHAR2 Optional
163: -- Default = FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Optional
165: -- Default = FND_API.G_FALSE
166: -- p_validation_level IN NUMBER Optional
167: -- Default = FND_API.G_VALID_LEVEL_FULL
168: -- OUT : x_return_status OUT VARCHAR2(1)
169: -- x_msg_count OUT NUMBER
163: -- Default = FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Optional
165: -- Default = FND_API.G_FALSE
166: -- p_validation_level IN NUMBER Optional
167: -- Default = FND_API.G_VALID_LEVEL_FULL
168: -- OUT : x_return_status OUT VARCHAR2(1)
169: -- x_msg_count OUT NUMBER
170: -- x_msg_data OUT VARCHAR2(2000)
171: -- IN : p_payment_transaction_id IN NUMBER
201: -- Usage : To release the payment holds at worksheet level.
202: -- Parameters :
203: -- IN : p_api_version IN NUMBER Require
204: -- p_init_msg_list IN VARCHAR2 Optional
205: -- Default = FND_API.G_FALSE
206: -- p_commit IN VARCHAR2 Optional
207: -- Default = FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Optional
209: -- Default = FND_API.G_VALID_LEVEL_FULL
203: -- IN : p_api_version IN NUMBER Require
204: -- p_init_msg_list IN VARCHAR2 Optional
205: -- Default = FND_API.G_FALSE
206: -- p_commit IN VARCHAR2 Optional
207: -- Default = FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Optional
209: -- Default = FND_API.G_VALID_LEVEL_FULL
210: -- OUT : x_return_status OUT VARCHAR2(1)
211: -- x_msg_count OUT NUMBER
205: -- Default = FND_API.G_FALSE
206: -- p_commit IN VARCHAR2 Optional
207: -- Default = FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Optional
209: -- Default = FND_API.G_VALID_LEVEL_FULL
210: -- OUT : x_return_status OUT VARCHAR2(1)
211: -- x_msg_count OUT NUMBER
212: -- x_msg_data OUT VARCHAR2(2000)
213: -- IN : p_payment_worksheet_id IN NUMBER
239: -- Usage : submits the hold all concurrent program.
240: -- Parameters :
241: -- IN : p_api_version IN NUMBER Require
242: -- p_init_msg_list IN VARCHAR2 Optional
243: -- Default = FND_API.G_FALSE
244: -- p_commit IN VARCHAR2 Optional
245: -- Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional
247: -- Default = FND_API.G_VALID_LEVEL_FULL
241: -- IN : p_api_version IN NUMBER Require
242: -- p_init_msg_list IN VARCHAR2 Optional
243: -- Default = FND_API.G_FALSE
244: -- p_commit IN VARCHAR2 Optional
245: -- Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional
247: -- Default = FND_API.G_VALID_LEVEL_FULL
248: -- IN : p_payrun_id IN NUMBER
249: -- IN : p_salesrep_id IN VARCHAR2(01)
243: -- Default = FND_API.G_FALSE
244: -- p_commit IN VARCHAR2 Optional
245: -- Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional
247: -- Default = FND_API.G_VALID_LEVEL_FULL
248: -- IN : p_payrun_id IN NUMBER
249: -- IN : p_salesrep_id IN VARCHAR2(01)
250: -- IN : p_quota_id IN NUMBER
251: -- IN : p_revenue_class_id IN Varchar2(01)
260: -- End of comments
261: --============================================================================
262: PROCEDURE process_pmt_transactions (
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: p_rec IN OUT NOCOPY pmt_process_rec,
268: x_return_status OUT NOCOPY VARCHAR2,
261: --============================================================================
262: PROCEDURE process_pmt_transactions (
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: p_rec IN OUT NOCOPY pmt_process_rec,
268: x_return_status OUT NOCOPY VARCHAR2,
269: x_msg_count OUT NOCOPY NUMBER,
262: PROCEDURE process_pmt_transactions (
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: p_rec IN OUT NOCOPY pmt_process_rec,
268: x_return_status OUT NOCOPY VARCHAR2,
269: x_msg_count OUT NOCOPY NUMBER,
270: x_msg_data OUT NOCOPY VARCHAR2