129: ,p_budget_used_by_type IN VARCHAR2
130: ,p_currency IN VARCHAR2
131: ,p_cost_tbl IN cost_tbl_type
132: ,p_api_version IN NUMBER
133: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
134: ,p_commit IN VARCHAR2 := fnd_api.g_false
135: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
136: ,x_return_status OUT NOCOPY VARCHAR2
137: ,x_msg_count OUT NOCOPY NUMBER
130: ,p_currency IN VARCHAR2
131: ,p_cost_tbl IN cost_tbl_type
132: ,p_api_version IN NUMBER
133: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
134: ,p_commit IN VARCHAR2 := fnd_api.g_false
135: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
136: ,x_return_status OUT NOCOPY VARCHAR2
137: ,x_msg_count OUT NOCOPY NUMBER
138: ,x_msg_data OUT NOCOPY VARCHAR2);
131: ,p_cost_tbl IN cost_tbl_type
132: ,p_api_version IN NUMBER
133: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
134: ,p_commit IN VARCHAR2 := fnd_api.g_false
135: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
136: ,x_return_status OUT NOCOPY VARCHAR2
137: ,x_msg_count OUT NOCOPY NUMBER
138: ,x_msg_data OUT NOCOPY VARCHAR2);
139:
155: FUNCTION Convert_Currency (
156: p_from_currency IN VARCHAR2,
157: p_to_currency IN VARCHAR2,
158: p_from_amount IN NUMBER,
159: p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR --Added for bug 7030415
160: )RETURN NUMBER;
161:
162: ---------------------------------------------------------------------
163: -- PROCEDURE
325: -- PARAMETERS
326: -- p_offer_id
327: -- p_offer_type
328: -- ,p_api_version IN NUMBER
329: -- ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
330: -- ,p_commit IN VARCHAR2 := fnd_api.g_false
331: -- ,x_msg_count OUT NUMBER
332: -- ,x_msg_data OUT VARCHAR2
333: -- ,x_return_status OUT VARCHAR2)
326: -- p_offer_id
327: -- p_offer_type
328: -- ,p_api_version IN NUMBER
329: -- ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
330: -- ,p_commit IN VARCHAR2 := fnd_api.g_false
331: -- ,x_msg_count OUT NUMBER
332: -- ,x_msg_data OUT VARCHAR2
333: -- ,x_return_status OUT VARCHAR2)
334:
339: PROCEDURE post_utilized_budget (
340: p_offer_id IN NUMBER
341: ,p_offer_type IN VARCHAR2
342: ,p_api_version IN NUMBER
343: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
344: ,p_commit IN VARCHAR2 := fnd_api.g_false
345: ,p_check_date IN VARCHAR2 := fnd_api.g_true -- do date validation
346: ,x_msg_count OUT NOCOPY NUMBER
347: ,x_msg_data OUT NOCOPY VARCHAR2
340: p_offer_id IN NUMBER
341: ,p_offer_type IN VARCHAR2
342: ,p_api_version IN NUMBER
343: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
344: ,p_commit IN VARCHAR2 := fnd_api.g_false
345: ,p_check_date IN VARCHAR2 := fnd_api.g_true -- do date validation
346: ,x_msg_count OUT NOCOPY NUMBER
347: ,x_msg_data OUT NOCOPY VARCHAR2
348: ,x_return_status OUT NOCOPY VARCHAR2
341: ,p_offer_type IN VARCHAR2
342: ,p_api_version IN NUMBER
343: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
344: ,p_commit IN VARCHAR2 := fnd_api.g_false
345: ,p_check_date IN VARCHAR2 := fnd_api.g_true -- do date validation
346: ,x_msg_count OUT NOCOPY NUMBER
347: ,x_msg_data OUT NOCOPY VARCHAR2
348: ,x_return_status OUT NOCOPY VARCHAR2
349: );
366: -- ,p_bill_to_cust_acct_id IN NUMBER
367: -- ,p_bill_to_site_use_id IN NUMBER
368: -- ,p_ship_to_site_use_id IN NUMBER
369: -- ,p_api_version IN NUMBER
370: -- ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
371: -- ,p_commit IN VARCHAR2 := fnd_api.g_false
372: -- ,x_msg_count OUT NUMBER
373: -- ,x_msg_data OUT VARCHAR2
374: -- ,x_return_status OUT VARCHAR2)
367: -- ,p_bill_to_site_use_id IN NUMBER
368: -- ,p_ship_to_site_use_id IN NUMBER
369: -- ,p_api_version IN NUMBER
370: -- ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
371: -- ,p_commit IN VARCHAR2 := fnd_api.g_false
372: -- ,x_msg_count OUT NUMBER
373: -- ,x_msg_data OUT VARCHAR2
374: -- ,x_return_status OUT VARCHAR2)
375:
388: ,p_bill_to_cust_acct_id IN NUMBER
389: ,p_bill_to_site_use_id IN NUMBER
390: ,p_ship_to_site_use_id IN NUMBER
391: ,p_api_version IN NUMBER
392: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
393: ,p_commit IN VARCHAR2 := fnd_api.g_false
394: ,x_msg_count OUT NOCOPY NUMBER
395: ,x_msg_data OUT NOCOPY VARCHAR2
396: ,x_return_status OUT NOCOPY VARCHAR2
389: ,p_bill_to_site_use_id IN NUMBER
390: ,p_ship_to_site_use_id IN NUMBER
391: ,p_api_version IN NUMBER
392: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
393: ,p_commit IN VARCHAR2 := fnd_api.g_false
394: ,x_msg_count OUT NOCOPY NUMBER
395: ,x_msg_data OUT NOCOPY VARCHAR2
396: ,x_return_status OUT NOCOPY VARCHAR2
397: );
412: ,p_budget_used_by_id IN NUMBER
413: ,p_budget_used_by_type IN VARCHAR2
414: ,p_from_parent IN VARCHAR2
415: ,p_api_version IN NUMBER
416: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
417: ,p_commit IN VARCHAR2 := fnd_api.g_false
418: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
419: ,x_return_status OUT NOCOPY VARCHAR2
420: ,x_msg_count OUT NOCOPY NUMBER
413: ,p_budget_used_by_type IN VARCHAR2
414: ,p_from_parent IN VARCHAR2
415: ,p_api_version IN NUMBER
416: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
417: ,p_commit IN VARCHAR2 := fnd_api.g_false
418: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
419: ,x_return_status OUT NOCOPY VARCHAR2
420: ,x_msg_count OUT NOCOPY NUMBER
421: ,x_msg_data OUT NOCOPY VARCHAR2
414: ,p_from_parent IN VARCHAR2
415: ,p_api_version IN NUMBER
416: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
417: ,p_commit IN VARCHAR2 := fnd_api.g_false
418: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
419: ,x_return_status OUT NOCOPY VARCHAR2
420: ,x_msg_count OUT NOCOPY NUMBER
421: ,x_msg_data OUT NOCOPY VARCHAR2
422: );
433: ---------------------------------------------------------------------
434: PROCEDURE post_sf_lumpsum_amount (
435: p_offer_id IN NUMBER
436: ,p_api_version IN NUMBER
437: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
438: ,p_commit IN VARCHAR2 := fnd_api.g_false
439: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
440: ,x_msg_count OUT NOCOPY NUMBER
441: ,x_msg_data OUT NOCOPY VARCHAR2
434: PROCEDURE post_sf_lumpsum_amount (
435: p_offer_id IN NUMBER
436: ,p_api_version IN NUMBER
437: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
438: ,p_commit IN VARCHAR2 := fnd_api.g_false
439: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
440: ,x_msg_count OUT NOCOPY NUMBER
441: ,x_msg_data OUT NOCOPY VARCHAR2
442: ,x_return_status OUT NOCOPY VARCHAR2
435: p_offer_id IN NUMBER
436: ,p_api_version IN NUMBER
437: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
438: ,p_commit IN VARCHAR2 := fnd_api.g_false
439: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
440: ,x_msg_count OUT NOCOPY NUMBER
441: ,x_msg_data OUT NOCOPY VARCHAR2
442: ,x_return_status OUT NOCOPY VARCHAR2
443: );