[Home] [Help]
382: IF G_DEBUG THEN
383: ozf_utility_pvt.debug_message ( l_full_name
384: || ': start');
385: END IF;
386: -- Standard Start of API savepoint
387: SAVEPOINT create_act_budgets_pvt;
388:
389: -- Standard call to check for call compatibility.
390: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
385: END IF;
386: -- Standard Start of API savepoint
387: SAVEPOINT create_act_budgets_pvt;
388:
389: -- Standard call to check for call compatibility.
390: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
391: RAISE fnd_api.g_exc_unexpected_error;
392: END IF;
393:
838: END IF;
839: END IF;
840:
841: INSERT INTO ozf_act_budgets
842: (activity_budget_id, -- standard who columns
843: last_update_date
844: , last_updated_by
845: , creation_date
846: ,created_by, last_update_login -- other columns
878: ,attribute14, attribute15
879: ,approved_amount_fc
880: ,src_curr_request_amt
881: )
882: VALUES (l_act_budgets_rec.activity_budget_id, -- standard who columns
883: SYSDATE, fnd_global.user_id, SYSDATE
884: ,fnd_global.user_id, fnd_global.conc_login_id, 1
885: , -- object_version_number
886: l_act_budgets_rec.act_budget_used_by_id
1068: /***** END OF Addition for Partner ********/
1069: --
1070: -- END of API body.
1071: --
1072: -- Standard check of p_commit.
1073: IF fnd_api.to_boolean (p_commit) THEN
1074: COMMIT WORK;
1075: END IF;
1076:
1073: IF fnd_api.to_boolean (p_commit) THEN
1074: COMMIT WORK;
1075: END IF;
1076:
1077: -- Standard call to get message count AND IF count is 1, get message info.
1078: fnd_msg_pub.count_and_get (
1079: p_count=> x_msg_count
1080: ,p_data=> x_msg_data
1081: ,p_encoded=> fnd_api.g_false
1441: WHERE org_id = p_org_id;
1442:
1443:
1444: BEGIN
1445: -- Standard Start of API savepoint
1446: SAVEPOINT update_act_budgets_pvt;
1447:
1448: -- Standard call to check for call compatibility.
1449: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
1444: BEGIN
1445: -- Standard Start of API savepoint
1446: SAVEPOINT update_act_budgets_pvt;
1447:
1448: -- Standard call to check for call compatibility.
1449: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
1450: RAISE fnd_api.g_exc_unexpected_error;
1451: END IF;
1452:
2515: END IF;
2516:
2517: -- END of API body.
2518: --
2519: -- Standard check of p_commit.
2520: IF fnd_api.to_boolean (p_commit) THEN
2521: COMMIT WORK;
2522: END IF;
2523:
2520: IF fnd_api.to_boolean (p_commit) THEN
2521: COMMIT WORK;
2522: END IF;
2523:
2524: -- Standard call to get message count AND IF count is 1, get message info.
2525: fnd_msg_pub.count_and_get (
2526: p_count=> x_msg_count
2527: ,p_data=> x_msg_data
2528: ,p_encoded=> fnd_api.g_false
2597: SELECT status_code
2598: FROM ozf_act_budgets
2599: WHERE activity_budget_id = p_act_budget_id;
2600: BEGIN
2601: -- Standard Start of API savepoint
2602: SAVEPOINT delete_act_budgets_pvt;
2603:
2604: -- Standard call to check for call compatibility.
2605: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
2600: BEGIN
2601: -- Standard Start of API savepoint
2602: SAVEPOINT delete_act_budgets_pvt;
2603:
2604: -- Standard call to check for call compatibility.
2605: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
2606: RAISE fnd_api.g_exc_unexpected_error;
2607: END IF;
2608:
2650:
2651: --
2652: -- END of API body.
2653: --
2654: -- Standard check of p_commit.
2655: IF fnd_api.to_boolean (p_commit) THEN
2656: COMMIT WORK;
2657: END IF;
2658:
2655: IF fnd_api.to_boolean (p_commit) THEN
2656: COMMIT WORK;
2657: END IF;
2658:
2659: -- Standard call to get message count AND IF count is 1, get message info.
2660: fnd_msg_pub.count_and_get (
2661: p_count=> x_msg_count
2662: ,p_data=> x_msg_data
2663: ,p_encoded=> fnd_api.g_false
2730: WHERE activity_budget_id = p_act_budget_id
2731: AND object_version_number = p_object_version
2732: FOR UPDATE OF activity_budget_id NOWAIT;
2733: BEGIN
2734: -- Standard call to check for call compatibility.
2735: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
2736: RAISE fnd_api.g_exc_unexpected_error;
2737: END IF;
2738:
2766: CLOSE c_act_budget;
2767: --
2768: -- END of API body.
2769: --
2770: -- Standard call to get message count AND IF count is 1, get message info.
2771: fnd_msg_pub.count_and_get (
2772: p_count=> x_msg_count
2773: ,p_data=> x_msg_data
2774: ,p_encoded=> fnd_api.g_false
2847: l_return_status VARCHAR2 (1); -- Return value from procedures
2848: l_act_budgets_rec act_budgets_rec_type := p_act_budgets_rec;
2849: l_act_budget_id NUMBER;
2850: BEGIN
2851: -- Standard call to check for call compatibility.
2852: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
2853: RAISE fnd_api.g_exc_unexpected_error;
2854: END IF;
2855:
3370: -- sangara - Bug - 4553660 -- changes end
3371:
3372:
3373: BEGIN
3374: -- Standard call to check for call compatibility.
3375: IF NOT fnd_api.compatible_api_call (l_api_version, l_api_version, l_api_name, g_package_name) THEN
3376: RAISE fnd_api.g_exc_unexpected_error;
3377: END IF;
3378: