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

Line 48: FROM ozf_funds_all_b

44: l_org_id number := NULL;
45:
46: CURSOR get_fund_org_csr(p_id in number) IS
47: SELECT org_id
48: FROM ozf_funds_all_b
49: WHERE fund_id = p_actbudget_id;
50:
51: BEGIN
52:

Line 654: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

650: ,x_utilized_amount OUT NOCOPY NUMBER
651: ) IS
652: l_use_fund_staging_tables VARCHAR2(1):= 'F';
653: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
654: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
655: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
656: l_batch_type VARCHAR2(30);
657: BEGIN
658: create_fund_utilization (

Line 685: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

681: ,x_utilization_id OUT NOCOPY NUMBER
682: ) IS
683: l_use_fund_staging_tables VARCHAR2(1):= 'F';
684: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
685: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
686: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
687: l_batch_type VARCHAR2(30);
688: BEGIN
689: create_fund_utilization (

Line 716: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

712: ,x_utilized_amount OUT NOCOPY NUMBER
713: ,p_batch_type IN VARCHAR2
714: ,p_use_fund_staging_tables IN VARCHAR2
715: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
716: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
717: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
718: ) IS
719: l_utilization_id NUMBER;
720: BEGIN

Line 769: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

765: ,x_utilized_amount OUT NOCOPY NUMBER
766: ,p_batch_type IN VARCHAR2
767: ,p_use_fund_staging_tables IN VARCHAR2
768: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
769: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
770: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
771: ,x_utilization_id OUT NOCOPY NUMBER
772: ) IS
773: l_api_version CONSTANT NUMBER := 1.0;

Line 825: FROM ozf_funds_all_b

821:
822: CURSOR c_funds (p_ofr_fund_id IN NUMBER) IS
823: SELECT fund_type
824: ,accrual_basis,plan_id
825: FROM ozf_funds_all_b
826: WHERE fund_id = p_ofr_fund_id;
827: -- 6/13/2002 mpande added for deal type ofer
828: CURSOR c_accrual_flag (p_price_adjustment_id IN NUMBER) IS
829: SELECT NVL(accrual_flag,'N')

Line 836: FROM ozf_funds_all_b

832:
833: -- 07/30/03 feliu added for accrual budget.
834: CURSOR c_fund_plan (p_plan_id IN NUMBER) IS
835: SELECT fund_id , currency_code_tc, accrual_basis
836: FROM ozf_funds_all_b
837: WHERE plan_id = p_plan_id;
838:
839: -- 18-JAN-05 kdass get the cust_account_id from cust_acct_site_id
840: -- rimehrot for R12, added bill_to_site_use_id

Line 1751: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,

1747: x_utilized_amount OUT NOCOPY NUMBER, -- added yzhao Jun 21, 2004
1748: p_batch_type IN VARCHAR2,
1749: p_use_fund_staging_tables IN VARCHAR2,
1750: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,
1751: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,
1752: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
1753: ) IS
1754: l_utilization_id NUMBER;
1755: BEGIN

Line 1786: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,

1782: x_utilized_amount OUT NOCOPY NUMBER, -- added yzhao Jun 21, 2004
1783: p_batch_type IN VARCHAR2,
1784: p_use_fund_staging_tables IN VARCHAR2,
1785: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,
1786: px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype,
1787: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table,
1788: x_utilization_id OUT NOCOPY NUMBER
1789: ) IS
1790: CURSOR c_act_util_rec (p_used_by_id IN NUMBER, p_used_by_type IN VARCHAR2) IS

Line 2234: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

2230: x_act_budget_id OUT NOCOPY NUMBER,
2231: x_utilized_amount OUT NOCOPY NUMBER
2232: ) IS
2233: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
2234: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
2235: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
2236: l_batch_type VARCHAR2(30);
2237: BEGIN
2238: process_act_budgets (

Line 2265: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

2261: x_utilized_amount OUT NOCOPY NUMBER,
2262: x_utilization_id OUT NOCOPY NUMBER
2263: ) IS
2264: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
2265: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
2266: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
2267: l_batch_type VARCHAR2(30);
2268: BEGIN
2269: process_act_budgets (

Line 3608: FROM ozf_funds_all_b

3604: CURSOR c_budget_data(p_fund_id IN NUMBER) IS
3605: SELECT (NVL(original_budget, 0) - NVL(holdback_amt, 0)
3606: + NVL(transfered_in_amt, 0) - NVL(transfered_out_amt, 0)) available_budget,
3607: fund_id,currency_code_tc
3608: FROM ozf_funds_all_b
3609: WHERE fund_id = p_fund_id;
3610:
3611:
3612: --get un_utilized budget.