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_ALLOCATIONS_PVT dependencies on OZF_FUNDS_ALL_B

Line 182: FROM ozf_funds_all_b

178:
179: -- cursors for budget hierarchy
180: CURSOR c_get_budget_child IS
181: SELECT fund_id
182: FROM ozf_funds_all_b
183: WHERE parent_fund_id = p_node_id
184: AND status_code = 'ACTIVE';
185:
186: BEGIN

Line 307: FROM ozf_funds_all_b f,

303: ,'DD-MM') || '-' || m.basis_year
304: , 'DD-MM-YYYY'
305: ) derived_end_date
306: */
307: FROM ozf_funds_all_b f,
308: ozf_act_metrics_all m
309: WHERE m.activity_metric_id = p_alloc_id
310: AND m.arc_act_metric_used_by = 'FUND'
311: AND m.act_metric_used_by_id = f.fund_id ;

Line 1218: FROM ozf_funds_all_b

1214: l_act_budget_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1215:
1216: CURSOR c_get_fund_owner(p_fund_id NUMBER) IS
1217: SELECT owner, parent_fund_id
1218: FROM ozf_funds_all_b
1219: WHERE fund_id = p_fund_id;
1220:
1221: BEGIN
1222: OPEN c_get_fund_owner(p_child_fund_id);

Line 1332: l_fund_status_code ozf_funds_all_b.status_code%TYPE;

1328: l_fund_org_id NUMBER;
1329: l_fund_ledger_id NUMBER;
1330: l_fund_dept_id NUMBER;
1331: l_fund_short_name ozf_funds_all_tl.short_name%TYPE;
1332: l_fund_status_code ozf_funds_all_b.status_code%TYPE;
1333: l_fund_number ozf_funds_all_b.fund_number%TYPE;
1334: l_fund_category_id NUMBER;
1335: l_fund_cust_setup_id NUMBER;
1336: l_parent_fund_id NUMBER;

Line 1333: l_fund_number ozf_funds_all_b.fund_number%TYPE;

1329: l_fund_ledger_id NUMBER;
1330: l_fund_dept_id NUMBER;
1331: l_fund_short_name ozf_funds_all_tl.short_name%TYPE;
1332: l_fund_status_code ozf_funds_all_b.status_code%TYPE;
1333: l_fund_number ozf_funds_all_b.fund_number%TYPE;
1334: l_fund_category_id NUMBER;
1335: l_fund_cust_setup_id NUMBER;
1336: l_parent_fund_id NUMBER;
1337: l_parent_fund_owner NUMBER;

Line 1705: FROM ozf_funds_all_b

1701:
1702: --asylvia 11-May-2006 bug 5199719 - SQL ID 17778551
1703: CURSOR c_get_fund_amount IS
1704: SELECT ((NVL(original_budget,0)-NVL(holdback_amt,0))+(NVL(transfered_in_amt,0)-NVL(transfered_out_amt,0)))
1705: FROM ozf_funds_all_b
1706: WHERE FUND_id = p_fund_id ;
1707:
1708: BEGIN
1709: x_return_status := fnd_api.g_ret_sts_success;

Line 1989: FROM ozf_funds_all_b

1985: WHERE activity_metric_fact_id = p_fact_id;
1986:
1987: CURSOR c_get_fund_info(l_fact_id IN NUMBER) IS
1988: SELECT fund_id, object_version_number
1989: FROM ozf_funds_all_b
1990: WHERE fund_id = (SELECT act_metric_used_by_id
1991: FROM ozf_act_metric_facts_all
1992: WHERE activity_metric_fact_id = l_fact_id);
1993:

Line 2307: FROM ozf_funds_all_b

2303: WHERE activity_metric_id = p_alloc_id;
2304:
2305: CURSOR c_get_fund_info(l_fact_id IN NUMBER) IS
2306: SELECT fund_id, object_version_number
2307: FROM ozf_funds_all_b
2308: WHERE fund_id = (SELECT act_metric_used_by_id
2309: FROM ozf_act_metric_facts_all
2310: WHERE activity_metric_fact_id = l_fact_id);
2311: BEGIN

Line 2560: l_child_fund_currency ozf_funds_all_b.currency_code_tc%TYPE;

2556: l_child_fund_id NUMBER;
2557: l_child_fund_obj_ver NUMBER;
2558: l_child_fund_owner NUMBER;
2559: l_child_fund_name ozf_funds_all_tl.short_name%TYPE;
2560: l_child_fund_currency ozf_funds_all_b.currency_code_tc%TYPE;
2561: l_child_requested_total NUMBER;
2562: l_notif_subject VARCHAR2(400);
2563: l_notif_body VARCHAR2(4000);
2564: l_return_id NUMBER;

Line 2743: FROM ozf_funds_all_b fu

2739: WHERE activity_metric_id = p_alloc_id;
2740:
2741: CURSOR c_get_fund_info(p_fund_id NUMBER) IS
2742: SELECT fu.status_code, fu.fund_type
2743: FROM ozf_funds_all_b fu
2744: WHERE fund_id = p_fund_id;
2745:
2746: CURSOR c_get_alloc_topnode IS
2747: SELECT m.activity_metric_fact_id, m.object_version_number

Line 2914: l_fund_obj_ver ozf_funds_all_b.object_version_number%TYPE;

2910: l_alloc_creator NUMBER;
2911: l_alloc_old_status VARCHAR2(30);
2912: l_alloc_action_code VARCHAR2(30);
2913: l_root_fund_id NUMBER;
2914: l_fund_obj_ver ozf_funds_all_b.object_version_number%TYPE;
2915: l_fund_owner ozf_funds_all_b.owner%TYPE;
2916: l_fund_name ozf_funds_all_tl.short_name%TYPE;
2917: l_notif_subject VARCHAR2(400);
2918: l_notif_body VARCHAR2(4000);

Line 2915: l_fund_owner ozf_funds_all_b.owner%TYPE;

2911: l_alloc_old_status VARCHAR2(30);
2912: l_alloc_action_code VARCHAR2(30);
2913: l_root_fund_id NUMBER;
2914: l_fund_obj_ver ozf_funds_all_b.object_version_number%TYPE;
2915: l_fund_owner ozf_funds_all_b.owner%TYPE;
2916: l_fund_name ozf_funds_all_tl.short_name%TYPE;
2917: l_notif_subject VARCHAR2(400);
2918: l_notif_body VARCHAR2(4000);
2919: l_return_id NUMBER;

Line 3427: l_currency_code ozf_funds_all_b.currency_code_tc%TYPE;

3423: l_alloc_id NUMBER;
3424: l_parent_fact_id NUMBER;
3425: l_parent_budget_owner NUMBER;
3426: l_fund_name ozf_funds_all_tl.short_name%TYPE;
3427: l_currency_code ozf_funds_all_b.currency_code_tc%TYPE;
3428: l_request_total NUMBER;
3429: l_request_hb NUMBER;
3430: l_return_status VARCHAR2(2);
3431: l_notif_subject VARCHAR2(400);

Line 3448: FROM ozf_funds_all_b

3444: AND fact.act_metric_used_by_id = fund.fund_id;
3445:
3446: CURSOR c_get_fact_budget_owner(p_lfact_id NUMBER) IS
3447: SELECT owner, currency_code_tc
3448: FROM ozf_funds_all_b
3449: WHERE fund_id = (SELECT act_metric_used_by_id
3450: FROM ozf_act_metric_facts_all
3451: WHERE activity_metric_fact_id = p_lfact_id
3452: AND arc_act_metric_used_by = 'FUND');

Line 3456: FROM ozf_funds_all_b

3452: AND arc_act_metric_used_by = 'FUND');
3453:
3454: CURSOR c_get_alloc_budget_owner(p_lalloc_id NUMBER) IS
3455: SELECT owner, currency_code_tc
3456: FROM ozf_funds_all_b
3457: WHERE fund_id = (SELECT act_metric_used_by_id
3458: FROM ozf_act_metrics_all
3459: WHERE activity_metric_id = p_lalloc_id
3460: AND arc_act_metric_used_by = 'FUND');

Line 3617: l_budget_currency ozf_funds_all_b.currency_code_tc%TYPE;

3613: x_msg_data OUT NOCOPY VARCHAR2)
3614: IS
3615: l_budget_owner NUMBER;
3616: l_budget_name ozf_funds_all_tl.short_name%TYPE;
3617: l_budget_currency ozf_funds_all_b.currency_code_tc%TYPE;
3618: l_alloc_id NUMBER;
3619: l_fact_old_status VARCHAR2(30);
3620: l_request_total NUMBER;
3621: l_request_hb NUMBER;