56: --
57: -- Parameters :
58: -- IN : p_api_version IN NUMBER Required
59: -- p_init_msg_list IN VARCHAR2 Optional
60: -- Default = FND_API.G_FALSE
61: -- p_commit IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional
64: -- Default = FND_API.G_VALID_LEVEL_FULL
58: -- IN : p_api_version IN NUMBER Required
59: -- p_init_msg_list IN VARCHAR2 Optional
60: -- Default = FND_API.G_FALSE
61: -- p_commit IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional
64: -- Default = FND_API.G_VALID_LEVEL_FULL
65: -- OUT : x_return_status OUT VARCHAR2(1)
66: -- x_msg_count OUT NUMBER
60: -- Default = FND_API.G_FALSE
61: -- p_commit IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional
64: -- Default = FND_API.G_VALID_LEVEL_FULL
65: -- OUT : x_return_status OUT VARCHAR2(1)
66: -- x_msg_count OUT NUMBER
67: -- x_msg_data OUT VARCHAR2(2000)
68: -- IN : p_worksheet_rec IN Required
101: -- Desc : Procedure to create multiple worksheets
102: -- Parameters :
103: -- IN : p_api_version IN NUMBER Require
104: -- p_init_msg_list IN VARCHAR2 Optional
105: -- Default = FND_API.G_FALSE
106: -- p_commit IN VARCHAR2 Optional
107: -- Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional
109: -- Default = FND_API.G_VALID_LEVEL_FULL
103: -- IN : p_api_version IN NUMBER Require
104: -- p_init_msg_list IN VARCHAR2 Optional
105: -- Default = FND_API.G_FALSE
106: -- p_commit IN VARCHAR2 Optional
107: -- Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional
109: -- Default = FND_API.G_VALID_LEVEL_FULL
110: -- OUT : x_return_status OUT VARCHAR2(1)
111: -- x_msg_count OUT NUMBER
105: -- Default = FND_API.G_FALSE
106: -- p_commit IN VARCHAR2 Optional
107: -- Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional
109: -- Default = FND_API.G_VALID_LEVEL_FULL
110: -- OUT : x_return_status OUT VARCHAR2(1)
111: -- x_msg_count OUT NUMBER
112: -- x_msg_data OUT VARCHAR2(2000)
113: -- IN : p_pay_group_id IN number(15) required
144: -- Desc : Procedure to update a worksheet
145: -- Parameters :
146: -- IN : p_api_version IN NUMBER Require
147: -- p_init_msg_list IN VARCHAR2 Optional
148: -- Default = FND_API.G_FALSE
149: -- p_commit IN VARCHAR2 Optional
150: -- Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional
152: -- Default = FND_API.G_VALID_LEVEL_FULL
146: -- IN : p_api_version IN NUMBER Require
147: -- p_init_msg_list IN VARCHAR2 Optional
148: -- Default = FND_API.G_FALSE
149: -- p_commit IN VARCHAR2 Optional
150: -- Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional
152: -- Default = FND_API.G_VALID_LEVEL_FULL
153: -- OUT : x_return_status OUT VARCHAR2(1)
154: -- x_msg_count OUT NUMBER
148: -- Default = FND_API.G_FALSE
149: -- p_commit IN VARCHAR2 Optional
150: -- Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional
152: -- Default = FND_API.G_VALID_LEVEL_FULL
153: -- OUT : x_return_status OUT VARCHAR2(1)
154: -- x_msg_count OUT NUMBER
155: -- x_msg_data OUT VARCHAR2(2000)
156: -- IN : p_worksheet_rec IN Required
188: -- Desc : Procedure to Delete Worksheet
189: -- Parameters :
190: -- IN : p_api_version IN NUMBER Require
191: -- p_init_msg_list IN VARCHAR2 Optional
192: -- Default = FND_API.G_FALSE
193: -- p_commit IN VARCHAR2 Optional
194: -- Default = FND_API.G_FALSE
195: -- p_validation_level IN NUMBER Optional
196: -- Default = FND_API.G_VALID_LEVEL_FULL
190: -- IN : p_api_version IN NUMBER Require
191: -- p_init_msg_list IN VARCHAR2 Optional
192: -- Default = FND_API.G_FALSE
193: -- p_commit IN VARCHAR2 Optional
194: -- Default = FND_API.G_FALSE
195: -- p_validation_level IN NUMBER Optional
196: -- Default = FND_API.G_VALID_LEVEL_FULL
197: -- OUT : x_return_status OUT VARCHAR2(1)
198: -- x_msg_count OUT NUMBER
192: -- Default = FND_API.G_FALSE
193: -- p_commit IN VARCHAR2 Optional
194: -- Default = FND_API.G_FALSE
195: -- p_validation_level IN NUMBER Optional
196: -- Default = FND_API.G_VALID_LEVEL_FULL
197: -- OUT : x_return_status OUT VARCHAR2(1)
198: -- x_msg_count OUT NUMBER
199: -- x_msg_data OUT VARCHAR2(2000)
200: -- IN : p_payment_worksheet_id IN NUMBER
239: -- due, begin balance values
240: --============================================================================
241: PROCEDURE get_ced_and_bb (
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
244: p_commit IN VARCHAR2 := fnd_api.g_false,
245: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
240: --============================================================================
241: PROCEDURE get_ced_and_bb (
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
244: p_commit IN VARCHAR2 := fnd_api.g_false,
245: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
241: PROCEDURE get_ced_and_bb (
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
244: p_commit IN VARCHAR2 := fnd_api.g_false,
245: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
249: p_worksheet_id IN NUMBER,
260: -- due, begin balance values
261: --============================================================================
262: PROCEDURE set_ced_and_bb (
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_msg_count OUT NOCOPY NUMBER,
261: --============================================================================
262: PROCEDURE set_ced_and_bb (
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_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,
262: PROCEDURE set_ced_and_bb (
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_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,
270: p_worksheet_id IN NUMBER