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_OBJECT_FUND_SUMMARY

Line 1982: -- yzhao: R12 insert/update ozf_object_fund_summary table

1978: SELECT status_code
1979: FROM ozf_offers
1980: WHERE qp_list_header_id = l_qp_header_id;
1981:
1982: -- yzhao: R12 insert/update ozf_object_fund_summary table
1983: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS
1984: SELECT objfundsum_id
1985: , object_version_number
1986: , planned_amt

Line 1989: FROM ozf_object_fund_summary

1985: , object_version_number
1986: , planned_amt
1987: , plan_curr_planned_amt
1988: , univ_curr_planned_amt
1989: FROM ozf_object_fund_summary
1990: WHERE object_type = p_object_type
1991: AND object_id = p_object_id
1992: AND fund_id = p_fund_id;
1993:

Line 2264: -- R12: yzhao BEGIN ozf_object_fund_summary decrease planned_amount

2260: RAISE fnd_api.g_exc_error;
2261: END IF;
2262: END IF;
2263:
2264: -- R12: yzhao BEGIN ozf_object_fund_summary decrease planned_amount
2265: IF g_universal_currency = l_act_budgets_rec.request_currency THEN
2266: l_univ_amount := l_act_budgets_rec.request_amount;
2267: ELSIF g_universal_currency = l_fund_currency_tc THEN
2268: l_univ_amount := l_fund_rec.planned_amt;

Line 2323: -- R12: yzhao END ozf_object_fund_summary decrease planned_amount

2319: RAISE fnd_api.g_exc_unexpected_error;
2320: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2321: RAISE fnd_api.g_exc_error;
2322: END IF;
2323: -- R12: yzhao END ozf_object_fund_summary decrease planned_amount
2324: END IF;
2325:
2326: -- subtract the request amount, l_fund_rec.planned_amt, to the
2327: -- fund's planned amount, l_fund_planned_amount.

Line 2427: -- R12: yzhao BEGIN ozf_object_fund_summary increase planned_amount

2423: RAISE fnd_api.g_exc_error;
2424: END IF;
2425: END IF;
2426:
2427: -- R12: yzhao BEGIN ozf_object_fund_summary increase planned_amount
2428: IF g_universal_currency = l_act_budgets_rec.request_currency THEN
2429: l_univ_amount := l_act_budgets_rec.request_amount;
2430: ELSIF g_universal_currency = l_fund_currency_tc THEN
2431: l_univ_amount := l_fund_rec.planned_amt;

Line 2496: -- R12: yzhao END insert/update ozf_object_fund_summary table for planned_amount

2492: RAISE fnd_api.g_exc_unexpected_error;
2493: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2494: RAISE fnd_api.g_exc_error;
2495: END IF;
2496: -- R12: yzhao END insert/update ozf_object_fund_summary table for planned_amount
2497: END IF;
2498:
2499: -- increase fund's planned amount by the new request amount
2500: l_fund_rec.planned_amt :=

Line 5547: -- yzhao: R12 update ozf_object_fund_summary table

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
5549: SELECT objfundsum_id
5550: , object_version_number
5551: , planned_amt

Line 5560: FROM ozf_object_fund_summary

5556: , plan_curr_recal_committed_amt
5557: , univ_curr_planned_amt
5558: , univ_curr_committed_amt
5559: , univ_curr_recal_committed_amt
5560: FROM ozf_object_fund_summary
5561: WHERE object_type = p_object_type
5562: AND object_id = p_object_id
5563: AND fund_id = p_fund_id;
5564:

Line 5792: -- R12: yzhao ozf_object_fund_summary

5788: ,l_fund_recal_committed_amount;
5789: CLOSE c_fund;
5790: l_fund_rec.fund_id := l_temp_rec.budget_source_id;
5791:
5792: -- R12: yzhao ozf_object_fund_summary
5793:
5794: OPEN c_get_objfundsum_rec(l_temp_rec.arc_act_budget_used_by
5795: , l_temp_rec.act_budget_used_by_id
5796: , l_temp_rec.budget_source_id);

Line 5807: -- R12: yzhao ozf_object_fund_summary

5803: ,l_fund_committed_amount
5804: ,l_fund_recal_committed_amount;
5805: CLOSE c_fund;
5806: l_fund_rec.fund_id := l_temp_rec.act_budget_used_by_id;
5807: -- R12: yzhao ozf_object_fund_summary
5808:
5809: OPEN c_get_objfundsum_rec(l_temp_rec.budget_source_type
5810: , l_temp_rec.budget_source_id
5811: , l_temp_rec.act_budget_used_by_id);

Line 5836: -- R12: yzhao END ozf_object_fund_summary

5832: , l_objfundsum_rec.univ_curr_planned_amt
5833: , l_objfundsum_rec.univ_curr_committed_amt
5834: , l_objfundsum_rec.univ_curr_recal_committed_amt;
5835: CLOSE c_get_objfundsum_rec;
5836: -- R12: yzhao END ozf_object_fund_summary
5837:
5838:
5839: l_fund_rec.object_version_number := l_fund_object_version_number;
5840:

Line 5939: -- R12: yzhao ozf_object_fund_summary

5935:
5936: --Since the conversion given below is used in case
5937: --of transfer_type='REQUEST'/'TRANSFER'. hence
5938: --So this part will not be executed in case of transfer_type='UTILIZED'.
5939: -- R12: yzhao ozf_object_fund_summary
5940: IF g_universal_currency = l_temp_rec.request_currency THEN
5941: l_univ_planned_amount := l_temp_rec.request_amount;
5942: l_univ_committed_amount := l_temp_rec.approved_amount;
5943: ELSIF g_universal_currency = l_fund_currency_tc THEN

Line 6054: -- R12: yzhao END ozf_object_fund_summary

6050: || ' l_univ_planned_amount=' || l_univ_planned_amount
6051: || ' l_univ_committed_amount=' || l_univ_committed_amount
6052: );
6053: END IF;
6054: -- R12: yzhao END ozf_object_fund_summary
6055:
6056: IF p_mode = 'UPDATE' THEN
6057: IF l_temp_rec.transfer_type = 'REQUEST' THEN
6058: -- R12: yzhao ozf_object_fund_summary decrease planned amount

Line 6058: -- R12: yzhao ozf_object_fund_summary decrease planned amount

6054: -- R12: yzhao END ozf_object_fund_summary
6055:
6056: IF p_mode = 'UPDATE' THEN
6057: IF l_temp_rec.transfer_type = 'REQUEST' THEN
6058: -- R12: yzhao ozf_object_fund_summary decrease planned amount
6059: l_objfundsum_rec.planned_amt := NVL(l_objfundsum_rec.planned_amt, 0) - NVL (l_fund_rec.planned_amt, 0);
6060: l_objfundsum_rec.plan_curr_planned_amt := NVL(l_objfundsum_rec.plan_curr_planned_amt, 0)
6061: - NVL(l_temp_rec.request_amount, 0);
6062: l_objfundsum_rec.univ_curr_planned_amt := NVL(l_objfundsum_rec.univ_curr_planned_amt, 0)

Line 6064: -- R12: yzhao END ozf_object_fund_summary decrease planned amount

6060: l_objfundsum_rec.plan_curr_planned_amt := NVL(l_objfundsum_rec.plan_curr_planned_amt, 0)
6061: - NVL(l_temp_rec.request_amount, 0);
6062: l_objfundsum_rec.univ_curr_planned_amt := NVL(l_objfundsum_rec.univ_curr_planned_amt, 0)
6063: - NVL(l_univ_planned_amount, 0);
6064: -- R12: yzhao END ozf_object_fund_summary decrease planned amount
6065: l_fund_rec.planned_amt := l_fund_planned_amount
6066: - l_fund_rec.planned_amt;
6067: ELSE
6068: l_fund_rec.planned_amt := l_fund_planned_amount;

Line 6083: -- R12: yzhao ozf_object_fund_summary increase committed amount

6079: IF NVL(p_act_budget_rec.recal_flag,'N') = 'N' THEN
6080: l_fund_rec.committed_amt :=
6081: NVL (l_fund_committed_amount, 0)
6082: + NVL (l_fund_rec.committed_amt, 0);
6083: -- R12: yzhao ozf_object_fund_summary increase committed amount
6084: l_objfundsum_rec.committed_amt := NVL(l_objfundsum_rec.committed_amt, 0)
6085: + NVL (l_temp_rec.approved_original_amount, 0);
6086: l_objfundsum_rec.plan_curr_committed_amt := NVL(l_objfundsum_rec.plan_curr_committed_amt, 0)
6087: + NVL(l_temp_rec.approved_amount, 0);

Line 6090: -- R12: yzhao END ozf_object_fund_summary increase committed amount

6086: l_objfundsum_rec.plan_curr_committed_amt := NVL(l_objfundsum_rec.plan_curr_committed_amt, 0)
6087: + NVL(l_temp_rec.approved_amount, 0);
6088: l_objfundsum_rec.univ_curr_committed_amt := NVL(l_objfundsum_rec.univ_curr_committed_amt, 0)
6089: + NVL(l_univ_committed_amount, 0);
6090: -- R12: yzhao END ozf_object_fund_summary increase committed amount
6091: ELSE
6092: l_fund_rec.committed_amt :=
6093: NVL (l_fund_committed_amount, 0);
6094: END IF;

Line 6113: -- R12: yzhao ozf_object_fund_summary decrease committed amount

6109:
6110: l_fund_rec.committed_amt :=
6111: NVL (l_fund_committed_amount, 0)
6112: - NVL (l_fund_rec.committed_amt, 0);
6113: -- R12: yzhao ozf_object_fund_summary decrease committed amount
6114: IF G_DEBUG THEN
6115: ozf_utility_pvt.debug_message('******************************************************************');
6116: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);
6117: ozf_utility_pvt.debug_message('approved_amount '||l_temp_rec.approved_amount);

Line 6137: -- R12: yzhao ozf_object_fund_summary decrease recal-committed amount

6133: END IF;
6134: l_fund_rec.recal_committed :=
6135: NVL (l_fund_recal_committed_amount, 0)
6136: - NVL (l_temp_rec.approved_amount, 0);
6137: -- R12: yzhao ozf_object_fund_summary decrease recal-committed amount
6138: l_objfundsum_rec.recal_committed_amt := NVL(l_objfundsum_rec.recal_committed_amt, 0)
6139: - NVL (l_temp_rec.approved_amount, 0);
6140: l_objfundsum_rec.plan_curr_recal_committed_amt := NVL(l_objfundsum_rec.plan_curr_recal_committed_amt, 0)
6141: - NVL(l_temp_rec.approved_original_amount, 0);

Line 6144: -- R12: yzhao END ozf_object_fund_summary decrease committed amount

6140: l_objfundsum_rec.plan_curr_recal_committed_amt := NVL(l_objfundsum_rec.plan_curr_recal_committed_amt, 0)
6141: - NVL(l_temp_rec.approved_original_amount, 0);
6142: l_objfundsum_rec.univ_curr_recal_committed_amt := NVL(l_objfundsum_rec.univ_curr_recal_committed_amt, 0)
6143: - NVL(l_univ_committed_amount, 0);
6144: -- R12: yzhao END ozf_object_fund_summary decrease committed amount
6145: END IF;
6146:
6147: IF G_DEBUG THEN
6148: ozf_utility_pvt.debug_message ('bef update fund ');

Line 6192: -- R12: yzhao ozf_object_fund_summary update planned_amount/committed_amount

6188: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6189: RAISE fnd_api.g_exc_error;
6190: END IF;
6191:
6192: -- R12: yzhao ozf_object_fund_summary update planned_amount/committed_amount
6193:
6194:
6195: IF l_objfundsum_rec.objfundsum_id IS NULL THEN
6196: l_objfundsum_rec.fund_id := l_temp_rec.budget_source_id;

Line 6290: -- R12: yzhao END ozf_object_fund_summary decrease planned_amount/committed_amount

6286: RAISE fnd_api.g_exc_unexpected_error;
6287: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6288: RAISE fnd_api.g_exc_error;
6289: END IF;
6290: -- R12: yzhao END ozf_object_fund_summary decrease planned_amount/committed_amount
6291:
6292: END IF; -- end for fund check
6293: ELSE
6294: NULL;

Line 6340: -- yzhao: R12 update ozf_object_fund_summary table

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
6342: SELECT objfundsum_id
6343: , object_version_number
6344: , planned_amt

Line 6347: FROM ozf_object_fund_summary

6343: , object_version_number
6344: , planned_amt
6345: , plan_curr_planned_amt
6346: , univ_curr_planned_amt
6347: FROM ozf_object_fund_summary
6348: WHERE object_type = p_object_type
6349: AND object_id = p_object_id
6350: AND fund_id = p_fund_id;
6351:

Line 6394: -- R12: yzhao ozf_object_fund_summary decrease planned_amt

6390: RAISE fnd_api.g_exc_error;
6391: END IF;
6392: END IF;
6393:
6394: -- R12: yzhao ozf_object_fund_summary decrease planned_amt
6395: OPEN c_get_objfundsum_rec(l_temp_rec.arc_act_budget_used_by
6396: , l_temp_rec.act_budget_used_by_id
6397: , l_temp_rec.budget_source_id);
6398: FETCH c_get_objfundsum_rec INTO l_objfundsum_rec.objfundsum_id

Line 6452: -- R12: yzhao END ozf_object_fund_summary decrease planned amount

6448: RAISE fnd_api.g_exc_unexpected_error;
6449: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6450: RAISE fnd_api.g_exc_error;
6451: END IF;
6452: -- R12: yzhao END ozf_object_fund_summary decrease planned amount
6453: END IF;
6454:
6455: -- subtract the request amount, l_fund_rec.planned_amt, from the
6456: -- fund's planned amount, l_fund_planned_amount.

Line 6541: FROM ozf_object_fund_summary

6537: SELECT fund_id
6538: ,fund_currency
6539: ,NVL(committed_amt,0)-NVL(utilized_amt,0) total_amount
6540: ,NVL(univ_curr_committed_amt,0) total_acctd_amount
6541: FROM ozf_object_fund_summary
6542: WHERE object_id =p_object_id
6543: AND object_type = p_obj_type;
6544:
6545: CURSOR c_total_acct_amt (p_object_id IN NUMBER, p_obj_type IN VARCHAR2) IS

Line 6547: FROM ozf_object_fund_summary

6543: AND object_type = p_obj_type;
6544:
6545: CURSOR c_total_acct_amt (p_object_id IN NUMBER, p_obj_type IN VARCHAR2) IS
6546: SELECT SUM(NVL(univ_curr_committed_amt,0))
6547: FROM ozf_object_fund_summary
6548: WHERE object_id =p_object_id
6549: AND object_type = p_obj_type;
6550:
6551: BEGIN

Line 7103: UPDATE ozf_object_fund_summary

7099: IF (G_DEBUG) THEN
7100: ozf_utility_pvt.debug_message(l_full_name ||': update object fund summary Table');
7101: END IF;
7102:
7103: UPDATE ozf_object_fund_summary
7104: SET object_version_number= object_version_number + 1,
7105: last_update_date = SYSDATE,
7106: last_updated_by = Fnd_Global.User_ID,
7107: last_update_login = Fnd_Global.Conc_Login_ID,