7: -- PURPOSE
8: --
9: -- PARAMETERS
10: -- p_object_type IN VARCHAR2
11: -- p_object_status IN VARCHAR2 :=FND_API.G_MISS_CHAR
12: -- p_object_code IN VARCHAR2 :=fnd_api.G_MISS_CHAR
13: -- p_object_end_date IN DATE := FND_API.G_MISS_DATE
14: -- x_errbuf OUT VARCHAR2 STANDARD OUT PARAMETER
15: -- x_retcode OUT NUMBER STANDARD OUT PARAMETER
8: --
9: -- PARAMETERS
10: -- p_object_type IN VARCHAR2
11: -- p_object_status IN VARCHAR2 :=FND_API.G_MISS_CHAR
12: -- p_object_code IN VARCHAR2 :=fnd_api.G_MISS_CHAR
13: -- p_object_end_date IN DATE := FND_API.G_MISS_DATE
14: -- x_errbuf OUT VARCHAR2 STANDARD OUT PARAMETER
15: -- x_retcode OUT NUMBER STANDARD OUT PARAMETER
16: -- NOTES
9: -- PARAMETERS
10: -- p_object_type IN VARCHAR2
11: -- p_object_status IN VARCHAR2 :=FND_API.G_MISS_CHAR
12: -- p_object_code IN VARCHAR2 :=fnd_api.G_MISS_CHAR
13: -- p_object_end_date IN DATE := FND_API.G_MISS_DATE
14: -- x_errbuf OUT VARCHAR2 STANDARD OUT PARAMETER
15: -- x_retcode OUT NUMBER STANDARD OUT PARAMETER
16: -- NOTES
17: -- This API will release the un-paid and committed amounts.
28: ,p_object_code IN VARCHAR2 :=null
29: ,p_object_end_date IN VARCHAR2 := null
30: ,p_util_paid IN VARCHAR2 := null
31: /* ,p_api_version IN NUMBER
32: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
33: ,p_commit IN VARCHAR2 := fnd_api.g_false
34: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
35: ,x_return_status OUT NOCOPY VARCHAR2
36: ,x_msg_count OUT NOCOPY NUMBER
29: ,p_object_end_date IN VARCHAR2 := null
30: ,p_util_paid IN VARCHAR2 := null
31: /* ,p_api_version IN NUMBER
32: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
33: ,p_commit IN VARCHAR2 := fnd_api.g_false
34: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
35: ,x_return_status OUT NOCOPY VARCHAR2
36: ,x_msg_count OUT NOCOPY NUMBER
37: ,x_msg_data OUT NOCOPY VARCHAR2 */
30: ,p_util_paid IN VARCHAR2 := null
31: /* ,p_api_version IN NUMBER
32: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
33: ,p_commit IN VARCHAR2 := fnd_api.g_false
34: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
35: ,x_return_status OUT NOCOPY VARCHAR2
36: ,x_msg_count OUT NOCOPY NUMBER
37: ,x_msg_data OUT NOCOPY VARCHAR2 */
38: );
56: ,p_budget_used_by_type IN VARCHAR2
57: ,p_object_currency IN VARCHAR2
58: ,p_from_paid IN VARCHAR2
59: ,p_api_version IN NUMBER
60: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
61: ,p_commit IN VARCHAR2 := fnd_api.g_false
62: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
63: ,x_return_status OUT NOCOPY VARCHAR2
64: ,x_msg_count OUT NOCOPY NUMBER
57: ,p_object_currency IN VARCHAR2
58: ,p_from_paid IN VARCHAR2
59: ,p_api_version IN NUMBER
60: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
61: ,p_commit IN VARCHAR2 := fnd_api.g_false
62: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
63: ,x_return_status OUT NOCOPY VARCHAR2
64: ,x_msg_count OUT NOCOPY NUMBER
65: ,x_msg_data OUT NOCOPY VARCHAR2
58: ,p_from_paid IN VARCHAR2
59: ,p_api_version IN NUMBER
60: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
61: ,p_commit IN VARCHAR2 := fnd_api.g_false
62: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
63: ,x_return_status OUT NOCOPY VARCHAR2
64: ,x_msg_count OUT NOCOPY NUMBER
65: ,x_msg_data OUT NOCOPY VARCHAR2
66: );
81: p_budget_used_by_id IN NUMBER
82: ,p_budget_used_by_type IN VARCHAR2
83: ,p_object_currency IN VARCHAR2
84: ,p_api_version IN NUMBER
85: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
86: ,p_commit IN VARCHAR2 := fnd_api.g_false
87: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
88: ,x_return_status OUT NOCOPY VARCHAR2
89: ,x_msg_count OUT NOCOPY NUMBER
82: ,p_budget_used_by_type IN VARCHAR2
83: ,p_object_currency IN VARCHAR2
84: ,p_api_version IN NUMBER
85: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
86: ,p_commit IN VARCHAR2 := fnd_api.g_false
87: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
88: ,x_return_status OUT NOCOPY VARCHAR2
89: ,x_msg_count OUT NOCOPY NUMBER
90: ,x_msg_data OUT NOCOPY VARCHAR2);
83: ,p_object_currency IN VARCHAR2
84: ,p_api_version IN NUMBER
85: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
86: ,p_commit IN VARCHAR2 := fnd_api.g_false
87: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
88: ,x_return_status OUT NOCOPY VARCHAR2
89: ,x_msg_count OUT NOCOPY NUMBER
90: ,x_msg_data OUT NOCOPY VARCHAR2);
91:
110: p_budget_used_by_id IN NUMBER
111: ,p_budget_used_by_type IN VARCHAR2
112: ,p_object_currency IN VARCHAR2
113: ,p_api_version IN NUMBER
114: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
115: ,p_commit IN VARCHAR2 := fnd_api.g_false
116: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
117: ,x_return_status OUT NOCOPY VARCHAR2
118: ,x_msg_count OUT NOCOPY NUMBER
111: ,p_budget_used_by_type IN VARCHAR2
112: ,p_object_currency IN VARCHAR2
113: ,p_api_version IN NUMBER
114: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
115: ,p_commit IN VARCHAR2 := fnd_api.g_false
116: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
117: ,x_return_status OUT NOCOPY VARCHAR2
118: ,x_msg_count OUT NOCOPY NUMBER
119: ,x_msg_data OUT NOCOPY VARCHAR2
112: ,p_object_currency IN VARCHAR2
113: ,p_api_version IN NUMBER
114: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
115: ,p_commit IN VARCHAR2 := fnd_api.g_false
116: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
117: ,x_return_status OUT NOCOPY VARCHAR2
118: ,x_msg_count OUT NOCOPY NUMBER
119: ,x_msg_data OUT NOCOPY VARCHAR2
120: );
143: x_errbuf OUT NOCOPY VARCHAR2
144: ,x_retcode OUT NOCOPY NUMBER
145: /*
146: p_api_version IN NUMBER
147: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
148: ,p_commit IN VARCHAR2 := fnd_api.g_false
149: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
150: ,x_return_status OUT NOCOPY VARCHAR2
151: ,x_msg_count OUT NOCOPY NUMBER
144: ,x_retcode OUT NOCOPY NUMBER
145: /*
146: p_api_version IN NUMBER
147: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
148: ,p_commit IN VARCHAR2 := fnd_api.g_false
149: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
150: ,x_return_status OUT NOCOPY VARCHAR2
151: ,x_msg_count OUT NOCOPY NUMBER
152: ,x_msg_data OUT NOCOPY VARCHAR2 */
145: /*
146: p_api_version IN NUMBER
147: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
148: ,p_commit IN VARCHAR2 := fnd_api.g_false
149: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
150: ,x_return_status OUT NOCOPY VARCHAR2
151: ,x_msg_count OUT NOCOPY NUMBER
152: ,x_msg_data OUT NOCOPY VARCHAR2 */
153: );
161: ---during certain period
162: -- and creating request or transfer records.
163: -- PARAMETERS
164: p_api_version IN NUMBER
165: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
166: ,p_commit IN VARCHAR2 := fnd_api.g_false
167: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
168: ,x_return_status OUT NOCOPY VARCHAR2
169: ,x_msg_count OUT NOCOPY NUMBER
162: -- and creating request or transfer records.
163: -- PARAMETERS
164: p_api_version IN NUMBER
165: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
166: ,p_commit IN VARCHAR2 := fnd_api.g_false
167: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
168: ,x_return_status OUT NOCOPY VARCHAR2
169: ,x_msg_count OUT NOCOPY NUMBER
170: ,x_msg_data OUT NOCOPY VARCHAR2
163: -- PARAMETERS
164: p_api_version IN NUMBER
165: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
166: ,p_commit IN VARCHAR2 := fnd_api.g_false
167: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
168: ,x_return_status OUT NOCOPY VARCHAR2
169: ,x_msg_count OUT NOCOPY NUMBER
170: ,x_msg_data OUT NOCOPY VARCHAR2
171: