eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUND_EXTENSION_PVT dependencies on AMS_UTILITY_PVT

Line 188: , x_actbudget_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type

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

Line 197: l_actbudget_tbl ams_utility_pvt.dependent_objects_tbl_type;

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

Line 347: , x_child_fund_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type

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

Line 355: l_actbudget_tbl ams_utility_pvt.dependent_objects_tbl_type;

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:

Line 356: l_child_fund_tbl ams_utility_pvt.dependent_objects_tbl_type;

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

Line 357: l_grandchild_fund_tbl ams_utility_pvt.dependent_objects_tbl_type;

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,

Line 488: , x_dependent_object_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type

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

Line 495: l_depend_obj_tbl ams_utility_pvt.dependent_objects_tbl_type;

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;

Line 496: l_actbudget_tbl ams_utility_pvt.dependent_objects_tbl_type;

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: