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

Line 179: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

175: ,p_mode IN VARCHAR2 :='UPDATE'-- added by mpande 12/27/2001
176: ,p_resale_batch_id IN NUMBER DEFAULT NULL
177: ,p_batch_type IN VARCHAR2
178: ,p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F'
179: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
180: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
181: );
182: /*****************************************************************************************/
183: -- Start of Comments

Line 348: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

344: l_utilized_amount NUMBER;
345: l_resale_batch_id NUMBER;
346: l_use_fund_staging_tables VARCHAR2(1) := 'F';
347: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
348: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
349: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
350: l_batch_type VARCHAR2(30);
351: BEGIN
352:

Line 396: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

392: l_utilized_amount NUMBER;
393: l_resale_batch_id NUMBER;
394: l_use_fund_staging_tables VARCHAR2(1) := 'F';
395: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
396: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
397: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
398: l_batch_type VARCHAR2(30);
399: BEGIN
400: create_act_budgets (

Line 464: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

460: ,p_resale_batch_id IN NUMBER
461: ,p_batch_type IN VARCHAR2
462: ,p_use_fund_staging_tables IN VARCHAR2
463: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
464: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
465: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
466: ) IS
467: l_utilization_id NUMBER;
468: BEGIN

Line 510: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

506: ,p_resale_batch_id IN NUMBER
507: ,p_batch_type IN VARCHAR2
508: ,p_use_fund_staging_tables IN VARCHAR2
509: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
510: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
511: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
512: ,x_utilization_id OUT NOCOPY NUMBER --nirprasa added for bug 9383565
513: ) IS
514: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Act_Budgets';

Line 549: FROM ozf_funds_all_b

545: WHERE activity_budget_id = p_id;
546:
547: CURSOR c_check_quota (p_type IN VARCHAR2, p_fund_id IN NUMBER) IS
548: SELECT 1
549: FROM ozf_funds_all_b
550: WHERE 'FUND' = p_type
551: AND fund_type = 'QUOTA'
552: AND fund_id = p_fund_id;
553:

Line 1754: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

1750:
1751: l_old_act_budgets_rec act_budgets_rec_type;
1752: l_use_fund_staging_tables VARCHAR2(1) := 'F';
1753: l_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
1754: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
1755: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
1756: l_batch_type VARCHAR2(30);
1757:
1758: BEGIN

Line 1829: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

1825: ,x_utilized_amount OUT NOCOPY NUMBER -- yzhao: 06/21/2004 added to return actual utilized amount
1826: ,p_batch_type IN VARCHAR2
1827: ,p_use_fund_staging_tables IN VARCHAR2
1828: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
1829: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
1830: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
1831: ) IS
1832: l_utilization_id NUMBER; --nirprasa - added for Bug 9383565
1833: BEGIN

Line 1884: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

1880: ,x_utilized_amount OUT NOCOPY NUMBER -- yzhao: 06/21/2004 added to return actual utilized amount
1881: ,p_batch_type IN VARCHAR2
1882: ,p_use_fund_staging_tables IN VARCHAR2
1883: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
1884: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
1885: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
1886: ,x_utilization_id OUT NOCOPY NUMBER --nirprasa - added for Bug 9383565
1887: ) IS
1888: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Act_Budgets';

Line 1934: FROM ozf_funds_all_b

1930: -- approval and rejection. the committed_amt will only
1931: -- be used in the approval.
1932: CURSOR c_fund (l_fund_id IN NUMBER) IS
1933: SELECT object_version_number, currency_code_tc, planned_amt
1934: FROM ozf_funds_all_b
1935: WHERE fund_id = l_fund_id;
1936:
1937: CURSOR c_check_quota (p_type IN VARCHAR2, p_fund_id IN NUMBER) IS
1938: SELECT 1

Line 1939: FROM ozf_funds_all_b

1935: WHERE fund_id = l_fund_id;
1936:
1937: CURSOR c_check_quota (p_type IN VARCHAR2, p_fund_id IN NUMBER) IS
1938: SELECT 1
1939: FROM ozf_funds_all_b
1940: WHERE 'FUND' = p_type
1941: AND fund_type = 'QUOTA'
1942: AND fund_id = p_fund_id;
1943:

Line 3967: l_table_name := 'OZF_FUNDS_ALL_B';

3963: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'CSCH' THEN
3964: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';
3965: l_pk_name := 'SCHEDULE_ID';
3966: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'FUND' THEN
3967: l_table_name := 'OZF_FUNDS_ALL_B';
3968: l_pk_name := 'FUND_ID';
3969: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'SOFT_FUND' THEN
3970: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3971: l_pk_name := 'REQUEST_HEADER_ID';

Line 4020: l_table_name := 'OZF_FUNDS_ALL_B';

4016: l_pk_name := 'REQUEST_HEADER_ID';
4017: ELSIF p_act_budgets_rec.budget_source_type = 'FUND' THEN
4018: -- 31-Jan-2001 mpande Removed access from ozf_fund_details_V to ozf_funds_all_vl for cross organzation validation.
4019: -- l_table_name := 'AMS_FUND_DETAILS_V';
4020: l_table_name := 'OZF_FUNDS_ALL_B';
4021: l_pk_name := 'FUND_ID';
4022: ELSIF p_act_budgets_rec.budget_source_type = 'PTNR' THEN
4023: l_table_name := 'PV_PARTNERS_V';
4024: -- 09/05/2001 mpande changed as per partners new functioanlity

Line 4166: FROM ozf_funds_all_b ozf

4162: -- An offer not autogenerated from a budget should not be allow to make a negative request from a fully accrued budget.
4163:
4164: CURSOR c_fund_type (p_fund_id IN NUMBER , p_list_header_id IN NUMBER) IS
4165: SELECT 'X'
4166: FROM ozf_funds_all_b ozf
4167: WHERE ozf.fund_type = 'FULLY_ACCRUED' and ozf.fund_id = p_fund_id
4168: and ozf.plan_id = p_list_header_id;
4169:
4170: -- sangara - Bug - 4553660

Line 4183: FROM ozf_funds_all_b

4179: l_offerLedgerName VARCHAR2(30);
4180:
4181: CURSOR c_get_budget_ledger_id (p_fund_id IN NUMBER) IS
4182: SELECT NVL(ledger_id,0)
4183: FROM ozf_funds_all_b
4184: WHERE fund_id = p_fund_id;
4185:
4186: l_budgetLedger NUMBER;
4187: -- sangara - Bug - 4553660 -- changes end

Line 4948: FROM ozf_funds_all_b

4944: CURSOR c_source_fund_owner(
4945: p_source_fund_id NUMBER)
4946: IS
4947: SELECT owner
4948: FROM ozf_funds_all_b
4949: WHERE fund_id = p_source_fund_id;
4950:
4951: CURSOR c_offer_info(p_object_id IN NUMBER) IS
4952: SELECT custom_setup_id

Line 5223: FROM ozf_funds_all_b

5219: WHERE deliverable_id = p_object_id;
5220:
5221: CURSOR c_fund IS
5222: SELECT currency_code_tc
5223: FROM ozf_funds_all_b
5224: WHERE fund_id = p_object_id;
5225:
5226: CURSOR c_offer IS
5227: SELECT nvl(transaction_currency_code, fund_request_curr_code)

Line 5470: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

5466: ,p_mode IN VARCHAR2 :='UPDATE'-- added by mpande 12/27/2001
5467: ) IS
5468: l_resale_batch_id NUMBER;
5469: l_use_fund_staging_tables VARCHAR2(1) := 'F';
5470: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
5471: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
5472: l_batch_type VARCHAR2(30);
5473: BEGIN
5474: process_approval (

Line 5520: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

5516: ,p_mode IN VARCHAR2 :='UPDATE'-- added by mpande 12/27/2001
5517: ,p_resale_batch_id IN NUMBER
5518: ,p_batch_type IN VARCHAR2
5519: ,p_use_fund_staging_tables IN VARCHAR2
5520: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
5521: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER Bug#9614703
5522: ) IS
5523: l_api_name CONSTANT VARCHAR2 (30) := 'Process_Approval';
5524: l_return_status VARCHAR2 (1);

Line 5544: FROM ozf_funds_all_b

5540: l_act_bud_cst_msg VARCHAR2(4000);
5541:
5542: CURSOR c_fund (l_fund_id IN NUMBER) IS
5543: SELECT object_version_number, currency_code_tc, planned_amt, committed_amt, recal_committed
5544: FROM ozf_funds_all_b
5545: WHERE fund_id = l_fund_id;
5546:
5547: -- yzhao: R12 update ozf_object_fund_summary table
5548: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS

Line 6337: FROM ozf_funds_all_b

6333: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;
6334:
6335: CURSOR c_fund (l_fund_id IN NUMBER) IS
6336: SELECT object_version_number, currency_code_tc, planned_amt
6337: FROM ozf_funds_all_b
6338: WHERE fund_id = l_fund_id;
6339:
6340: -- yzhao: R12 update ozf_object_fund_summary table
6341: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS