184: PROCEDURE get_actbudgets(
185: p_object_id IN NUMBER
186: , p_parent_fund_id IN NUMBER := NULL -- set if it is called from child fund
187: , x_non_del_flag OUT NOCOPY BOOLEAN
188: , x_actbudget_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type
189: , x_return_status OUT NOCOPY VARCHAR2
190: , x_msg_count OUT NOCOPY NUMBER
191: , x_msg_data OUT NOCOPY VARCHAR2
192: ) IS
193: l_api_name CONSTANT VARCHAR2(30) := 'get_actbudgets';
194: I NUMBER;
195: l_include_rec BOOLEAN := TRUE;
196: l_child_fund_id NUMBER;
197: l_actbudget_tbl ams_utility_pvt.dependent_objects_tbl_type;
198:
199: CURSOR c_get_actbudget_usedby IS
200: SELECT arc_act_budget_used_by, act_budget_used_by_id, status_code
201: FROM ozf_act_budgets
343: ---------------------------------------------------------------------
344: PROCEDURE get_child_funds(
345: p_object_id IN NUMBER
346: , x_non_del_flag OUT NOCOPY BOOLEAN
347: , x_child_fund_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type
348: , x_return_status OUT NOCOPY VARCHAR2
349: , x_msg_count OUT NOCOPY NUMBER
350: , x_msg_data OUT NOCOPY VARCHAR2
351: ) IS
351: ) IS
352: l_api_name CONSTANT VARCHAR2(30) := 'get_child_funds';
353: l_object_type VARCHAR2(30);
354: l_non_del_flag BOOLEAN;
355: l_actbudget_tbl ams_utility_pvt.dependent_objects_tbl_type;
356: l_child_fund_tbl ams_utility_pvt.dependent_objects_tbl_type;
357: l_grandchild_fund_tbl ams_utility_pvt.dependent_objects_tbl_type;
358: I NUMBER;
359:
352: l_api_name CONSTANT VARCHAR2(30) := 'get_child_funds';
353: l_object_type VARCHAR2(30);
354: l_non_del_flag BOOLEAN;
355: l_actbudget_tbl ams_utility_pvt.dependent_objects_tbl_type;
356: l_child_fund_tbl ams_utility_pvt.dependent_objects_tbl_type;
357: l_grandchild_fund_tbl ams_utility_pvt.dependent_objects_tbl_type;
358: I NUMBER;
359:
360: CURSOR c_get_child_funds IS
353: l_object_type VARCHAR2(30);
354: l_non_del_flag BOOLEAN;
355: l_actbudget_tbl ams_utility_pvt.dependent_objects_tbl_type;
356: l_child_fund_tbl ams_utility_pvt.dependent_objects_tbl_type;
357: l_grandchild_fund_tbl ams_utility_pvt.dependent_objects_tbl_type;
358: I NUMBER;
359:
360: CURSOR c_get_child_funds IS
361: SELECT fund_id, short_name, status_code, owner,
484: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
485: , p_commit IN VARCHAR2 := fnd_api.g_false
486: , p_object_id IN NUMBER
487: , p_object_version_number IN NUMBER
488: , x_dependent_object_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type
489: , x_return_status OUT NOCOPY VARCHAR2
490: , x_msg_count OUT NOCOPY NUMBER
491: , x_msg_data OUT NOCOPY VARCHAR2
492: ) IS
491: , x_msg_data OUT NOCOPY VARCHAR2
492: ) IS
493: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_fund';
494: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
495: l_depend_obj_tbl ams_utility_pvt.dependent_objects_tbl_type;
496: l_actbudget_tbl ams_utility_pvt.dependent_objects_tbl_type;
497: l_fund_status VARCHAR2(30);
498: l_non_del_flag BOOLEAN := FALSE;
499: I NUMBER := 1;
492: ) IS
493: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_fund';
494: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
495: l_depend_obj_tbl ams_utility_pvt.dependent_objects_tbl_type;
496: l_actbudget_tbl ams_utility_pvt.dependent_objects_tbl_type;
497: l_fund_status VARCHAR2(30);
498: l_non_del_flag BOOLEAN := FALSE;
499: I NUMBER := 1;
500: