[Home] [Help]
588: IF G_DEBUG THEN
589: ozf_utility_pvt.debug_message ( l_full_name
590: || ': start');
591: END IF;
592: -- Standard Start of API savepoint
593: SAVEPOINT create_act_budgets_pvt;
594:
595: -- Standard call to check for call compatibility.
596: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
591: END IF;
592: -- Standard Start of API savepoint
593: SAVEPOINT create_act_budgets_pvt;
594:
595: -- Standard call to check for call compatibility.
596: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
597: RAISE fnd_api.g_exc_unexpected_error;
598: END IF;
599:
1178: l_act_budgets_rec.request_amount := ozf_utility_pvt.currround(l_act_budgets_rec.request_amount, l_act_budgets_rec.request_currency);
1179: end if;
1180:
1181: INSERT INTO ozf_act_budgets
1182: (activity_budget_id, -- standard who columns
1183: last_update_date
1184: , last_updated_by
1185: , creation_date
1186: ,created_by, last_update_login -- other columns
1218: ,attribute14, attribute15
1219: ,approved_amount_fc
1220: ,src_curr_request_amt
1221: )
1222: VALUES (l_act_budgets_rec.activity_budget_id, -- standard who columns
1223: SYSDATE, fnd_global.user_id, SYSDATE
1224: ,fnd_global.user_id, fnd_global.conc_login_id, 1
1225: , -- object_version_number
1226: l_act_budgets_rec.act_budget_used_by_id
1442: /***** END OF Addition for Partner ********/
1443: --
1444: -- END of API body.
1445: --
1446: -- Standard check of p_commit.
1447: IF fnd_api.to_boolean (p_commit) THEN
1448: COMMIT WORK;
1449: END IF;
1450:
1447: IF fnd_api.to_boolean (p_commit) THEN
1448: COMMIT WORK;
1449: END IF;
1450:
1451: -- Standard call to get message count AND IF count is 1, get message info.
1452: fnd_msg_pub.count_and_get (
1453: p_count=> x_msg_count
1454: ,p_data=> x_msg_data
1455: ,p_encoded=> fnd_api.g_false
2007: FROM gl_ledgers_public_v
2008: WHERE ledger_id = p_ledger_id;
2009:
2010: BEGIN
2011: -- Standard Start of API savepoint
2012: SAVEPOINT update_act_budgets_pvt;
2013:
2014: -- Standard call to check for call compatibility.
2015: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
2010: BEGIN
2011: -- Standard Start of API savepoint
2012: SAVEPOINT update_act_budgets_pvt;
2013:
2014: -- Standard call to check for call compatibility.
2015: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
2016: RAISE fnd_api.g_exc_unexpected_error;
2017: END IF;
2018:
3332: END IF;
3333:
3334: -- END of API body.
3335: --
3336: -- Standard check of p_commit.
3337: IF fnd_api.to_boolean (p_commit) THEN
3338: COMMIT WORK;
3339: END IF;
3340:
3337: IF fnd_api.to_boolean (p_commit) THEN
3338: COMMIT WORK;
3339: END IF;
3340:
3341: -- Standard call to get message count AND IF count is 1, get message info.
3342: fnd_msg_pub.count_and_get (
3343: p_count=> x_msg_count
3344: ,p_data=> x_msg_data
3345: ,p_encoded=> fnd_api.g_false
3414: SELECT status_code
3415: FROM ozf_act_budgets
3416: WHERE activity_budget_id = p_act_budget_id;
3417: BEGIN
3418: -- Standard Start of API savepoint
3419: SAVEPOINT delete_act_budgets_pvt;
3420:
3421: -- Standard call to check for call compatibility.
3422: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
3417: BEGIN
3418: -- Standard Start of API savepoint
3419: SAVEPOINT delete_act_budgets_pvt;
3420:
3421: -- Standard call to check for call compatibility.
3422: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
3423: RAISE fnd_api.g_exc_unexpected_error;
3424: END IF;
3425:
3467:
3468: --
3469: -- END of API body.
3470: --
3471: -- Standard check of p_commit.
3472: IF fnd_api.to_boolean (p_commit) THEN
3473: COMMIT WORK;
3474: END IF;
3475:
3472: IF fnd_api.to_boolean (p_commit) THEN
3473: COMMIT WORK;
3474: END IF;
3475:
3476: -- Standard call to get message count AND IF count is 1, get message info.
3477: fnd_msg_pub.count_and_get (
3478: p_count=> x_msg_count
3479: ,p_data=> x_msg_data
3480: ,p_encoded=> fnd_api.g_false
3547: WHERE activity_budget_id = p_act_budget_id
3548: AND object_version_number = p_object_version
3549: FOR UPDATE OF activity_budget_id NOWAIT;
3550: BEGIN
3551: -- Standard call to check for call compatibility.
3552: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
3553: RAISE fnd_api.g_exc_unexpected_error;
3554: END IF;
3555:
3583: CLOSE c_act_budget;
3584: --
3585: -- END of API body.
3586: --
3587: -- Standard call to get message count AND IF count is 1, get message info.
3588: fnd_msg_pub.count_and_get (
3589: p_count=> x_msg_count
3590: ,p_data=> x_msg_data
3591: ,p_encoded=> fnd_api.g_false
3664: l_return_status VARCHAR2 (1); -- Return value from procedures
3665: l_act_budgets_rec act_budgets_rec_type := p_act_budgets_rec;
3666: l_act_budget_id NUMBER;
3667: BEGIN
3668: -- Standard call to check for call compatibility.
3669: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_package_name) THEN
3670: RAISE fnd_api.g_exc_unexpected_error;
3671: END IF;
3672:
4187: -- sangara - Bug - 4553660 -- changes end
4188:
4189:
4190: BEGIN
4191: -- Standard call to check for call compatibility.
4192: IF NOT fnd_api.compatible_api_call (l_api_version, l_api_version, l_api_name, g_package_name) THEN
4193: RAISE fnd_api.g_exc_unexpected_error;
4194: END IF;
4195: