73: ,p_budget_used_by_type IN VARCHAR2
74: ,p_currency IN VARCHAR2
75: ,p_cost_tbl IN cost_tbl_type
76: ,p_api_version IN NUMBER
77: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
78: ,p_commit IN VARCHAR2 := fnd_api.g_false
79: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
80: ,x_return_status OUT NOCOPY VARCHAR2
81: ,x_msg_count OUT NOCOPY NUMBER
74: ,p_currency IN VARCHAR2
75: ,p_cost_tbl IN cost_tbl_type
76: ,p_api_version IN NUMBER
77: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
78: ,p_commit IN VARCHAR2 := fnd_api.g_false
79: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
80: ,x_return_status OUT NOCOPY VARCHAR2
81: ,x_msg_count OUT NOCOPY NUMBER
82: ,x_msg_data OUT NOCOPY VARCHAR2);
75: ,p_cost_tbl IN cost_tbl_type
76: ,p_api_version IN NUMBER
77: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
78: ,p_commit IN VARCHAR2 := fnd_api.g_false
79: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
80: ,x_return_status OUT NOCOPY VARCHAR2
81: ,x_msg_count OUT NOCOPY NUMBER
82: ,x_msg_data OUT NOCOPY VARCHAR2);
83:
99: FUNCTION Convert_Currency (
100: p_from_currency IN VARCHAR2,
101: p_to_currency IN VARCHAR2,
102: p_from_amount IN NUMBER,
103: p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR --Added for bug 7030415
104: )RETURN NUMBER;
105:
106: ---------------------------------------------------------------------
107: -- PROCEDURE
202: -- PARAMETERS
203: -- p_offer_id
204: -- p_offer_type
205: -- ,p_api_version IN NUMBER
206: -- ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
207: -- ,p_commit IN VARCHAR2 := fnd_api.g_false
208: -- ,x_msg_count OUT NUMBER
209: -- ,x_msg_data OUT VARCHAR2
210: -- ,x_return_status OUT VARCHAR2)
203: -- p_offer_id
204: -- p_offer_type
205: -- ,p_api_version IN NUMBER
206: -- ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
207: -- ,p_commit IN VARCHAR2 := fnd_api.g_false
208: -- ,x_msg_count OUT NUMBER
209: -- ,x_msg_data OUT VARCHAR2
210: -- ,x_return_status OUT VARCHAR2)
211:
216: PROCEDURE post_utilized_budget (
217: p_offer_id IN NUMBER
218: ,p_offer_type IN VARCHAR2
219: ,p_api_version IN NUMBER
220: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
221: ,p_commit IN VARCHAR2 := fnd_api.g_false
222: ,p_check_date IN VARCHAR2 := fnd_api.g_true -- do date validation
223: ,x_msg_count OUT NOCOPY NUMBER
224: ,x_msg_data OUT NOCOPY VARCHAR2
217: p_offer_id IN NUMBER
218: ,p_offer_type IN VARCHAR2
219: ,p_api_version IN NUMBER
220: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
221: ,p_commit IN VARCHAR2 := fnd_api.g_false
222: ,p_check_date IN VARCHAR2 := fnd_api.g_true -- do date validation
223: ,x_msg_count OUT NOCOPY NUMBER
224: ,x_msg_data OUT NOCOPY VARCHAR2
225: ,x_return_status OUT NOCOPY VARCHAR2
218: ,p_offer_type IN VARCHAR2
219: ,p_api_version IN NUMBER
220: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
221: ,p_commit IN VARCHAR2 := fnd_api.g_false
222: ,p_check_date IN VARCHAR2 := fnd_api.g_true -- do date validation
223: ,x_msg_count OUT NOCOPY NUMBER
224: ,x_msg_data OUT NOCOPY VARCHAR2
225: ,x_return_status OUT NOCOPY VARCHAR2
226: );
243: -- ,p_bill_to_cust_acct_id IN NUMBER
244: -- ,p_bill_to_site_use_id IN NUMBER
245: -- ,p_ship_to_site_use_id IN NUMBER
246: -- ,p_api_version IN NUMBER
247: -- ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
248: -- ,p_commit IN VARCHAR2 := fnd_api.g_false
249: -- ,x_msg_count OUT NUMBER
250: -- ,x_msg_data OUT VARCHAR2
251: -- ,x_return_status OUT VARCHAR2)
244: -- ,p_bill_to_site_use_id IN NUMBER
245: -- ,p_ship_to_site_use_id IN NUMBER
246: -- ,p_api_version IN NUMBER
247: -- ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
248: -- ,p_commit IN VARCHAR2 := fnd_api.g_false
249: -- ,x_msg_count OUT NUMBER
250: -- ,x_msg_data OUT VARCHAR2
251: -- ,x_return_status OUT VARCHAR2)
252:
265: ,p_bill_to_cust_acct_id IN NUMBER
266: ,p_bill_to_site_use_id IN NUMBER
267: ,p_ship_to_site_use_id IN NUMBER
268: ,p_api_version IN NUMBER
269: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
270: ,p_commit IN VARCHAR2 := fnd_api.g_false
271: ,x_msg_count OUT NOCOPY NUMBER
272: ,x_msg_data OUT NOCOPY VARCHAR2
273: ,x_return_status OUT NOCOPY VARCHAR2
266: ,p_bill_to_site_use_id IN NUMBER
267: ,p_ship_to_site_use_id IN NUMBER
268: ,p_api_version IN NUMBER
269: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
270: ,p_commit IN VARCHAR2 := fnd_api.g_false
271: ,x_msg_count OUT NOCOPY NUMBER
272: ,x_msg_data OUT NOCOPY VARCHAR2
273: ,x_return_status OUT NOCOPY VARCHAR2
274: );
289: ,p_budget_used_by_id IN NUMBER
290: ,p_budget_used_by_type IN VARCHAR2
291: ,p_from_parent IN VARCHAR2
292: ,p_api_version IN NUMBER
293: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
294: ,p_commit IN VARCHAR2 := fnd_api.g_false
295: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
296: ,x_return_status OUT NOCOPY VARCHAR2
297: ,x_msg_count OUT NOCOPY NUMBER
290: ,p_budget_used_by_type IN VARCHAR2
291: ,p_from_parent IN VARCHAR2
292: ,p_api_version IN NUMBER
293: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
294: ,p_commit IN VARCHAR2 := fnd_api.g_false
295: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
296: ,x_return_status OUT NOCOPY VARCHAR2
297: ,x_msg_count OUT NOCOPY NUMBER
298: ,x_msg_data OUT NOCOPY VARCHAR2
291: ,p_from_parent IN VARCHAR2
292: ,p_api_version IN NUMBER
293: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
294: ,p_commit IN VARCHAR2 := fnd_api.g_false
295: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
296: ,x_return_status OUT NOCOPY VARCHAR2
297: ,x_msg_count OUT NOCOPY NUMBER
298: ,x_msg_data OUT NOCOPY VARCHAR2
299: );
310: ---------------------------------------------------------------------
311: PROCEDURE post_sf_lumpsum_amount (
312: p_offer_id IN NUMBER
313: ,p_api_version IN NUMBER
314: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
315: ,p_commit IN VARCHAR2 := fnd_api.g_false
316: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: ,x_msg_count OUT NOCOPY NUMBER
318: ,x_msg_data OUT NOCOPY VARCHAR2
311: PROCEDURE post_sf_lumpsum_amount (
312: p_offer_id IN NUMBER
313: ,p_api_version IN NUMBER
314: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
315: ,p_commit IN VARCHAR2 := fnd_api.g_false
316: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: ,x_msg_count OUT NOCOPY NUMBER
318: ,x_msg_data OUT NOCOPY VARCHAR2
319: ,x_return_status OUT NOCOPY VARCHAR2
312: p_offer_id IN NUMBER
313: ,p_api_version IN NUMBER
314: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
315: ,p_commit IN VARCHAR2 := fnd_api.g_false
316: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: ,x_msg_count OUT NOCOPY NUMBER
318: ,x_msg_data OUT NOCOPY VARCHAR2
319: ,x_return_status OUT NOCOPY VARCHAR2
320: );