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_UTILIZED_PVT dependencies on OZF_OBJECT_FUND_SUMMARY

Line 355: -- yzhao: R12 update ozf_object_fund_summary table

351: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
352: FROM ozf_sys_parameters_all sob
353: WHERE sob.org_id = p_org_id;
354:
355: -- yzhao: R12 update ozf_object_fund_summary table
356: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS
357: SELECT objfundsum_id
358: , object_version_number
359: , committed_amt

Line 374: FROM ozf_object_fund_summary

370: , univ_curr_recal_committed_amt
371: , univ_curr_utilized_amt
372: , univ_curr_earned_amt
373: , univ_curr_paid_amt
374: FROM ozf_object_fund_summary
375: WHERE object_type = p_object_type
376: AND object_id = p_object_id
377: AND fund_id = p_fund_id;
378:

Line 1076: -- R12: yzhao ozf_object_fund_summary

1072: IF p_utilization_rec.utilization_type NOT IN ('TRANSFER', 'REQUEST') THEN
1073: */
1074: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
1075:
1076: -- R12: yzhao ozf_object_fund_summary
1077: l_objfundsum_rec := NULL;
1078: OPEN c_get_objfundsum_rec(l_utilization_rec.component_type
1079: , l_utilization_rec.component_id
1080: , l_utilization_rec.fund_id);

Line 1099: -- R12: yzhao END ozf_object_fund_summary

1095: , l_objfundsum_rec.univ_curr_utilized_amt
1096: , l_objfundsum_rec.univ_curr_earned_amt
1097: , l_objfundsum_rec.univ_curr_paid_amt;
1098: CLOSE c_get_objfundsum_rec;
1099: -- R12: yzhao END ozf_object_fund_summary
1100:
1101: -- yzhao: 27-JUL-2005 - R12 paid adjustment can be done through public api
1102: IF l_utilization_rec.utilization_type = 'ADJUSTMENT' AND
1103: NVL(l_utilization_rec.adjustment_type, ' ') IN ('INCREASE_PAID', 'DECREASE_PAID') THEN

Line 1138: -- R12: yzhao ozf_object_fund_summary update utilized/committed amt

1134: -- 11/06/2003 for manual adjustment, DECREASE_COMM_EARNED, java does not create transfer record for fully accrual budget any more
1135: l_fund_rec.committed_amt := NVL (l_committed_amt, 0) + NVL (l_utilization_rec.amount, 0);
1136: l_fund_rec.recal_committed := NVL (l_recal_comm_amt, 0) + NVL (l_utilization_rec.amount, 0);
1137:
1138: -- R12: yzhao ozf_object_fund_summary update utilized/committed amt
1139: l_objfundsum_rec.utilized_amt := NVL(l_objfundsum_rec.utilized_amt, 0) + NVL(l_utilization_rec.amount, 0);
1140: l_objfundsum_rec.plan_curr_utilized_amt := NVL(l_objfundsum_rec.plan_curr_utilized_amt, 0)
1141: + NVL(l_utilization_rec.fund_request_amount, 0);
1142: l_objfundsum_rec.univ_curr_utilized_amt := NVL(l_objfundsum_rec.univ_curr_utilized_amt, 0)

Line 1155: -- R12: yzhao END ozf_object_fund_summary update

1151: l_objfundsum_rec.plan_curr_recal_committed_amt := NVL(l_objfundsum_rec.plan_curr_recal_committed_amt, 0)
1152: + NVL(l_plan_curr_amount, 0);
1153: l_objfundsum_rec.univ_curr_recal_committed_amt := NVL(l_objfundsum_rec.univ_curr_recal_committed_amt, 0)
1154: + NVL(l_univ_curr_amount, 0);
1155: -- R12: yzhao END ozf_object_fund_summary update
1156:
1157: -- 10/14/2003 update ozf_act_budgets REQUEST between fully accrual budget and its offer when accrual happens
1158: OPEN c_accrual_budget_reqeust(l_utilization_rec.fund_id, l_plan_id);
1159: FETCH c_accrual_budget_reqeust INTO l_act_budget_id, l_act_budget_objver;

Line 1320: -- R12: yzhao ozf_object_fund_summary update utilized_amt

1316: END IF;
1317:
1318: ELSE -- for fixed budget
1319: l_fund_rec.utilized_amt := NVL (l_utilized_amt, 0) + NVL (l_utilization_rec.amount, 0);
1320: -- R12: yzhao ozf_object_fund_summary update utilized_amt
1321: l_objfundsum_rec.utilized_amt := NVL(l_objfundsum_rec.utilized_amt, 0) + NVL(l_utilization_rec.amount, 0);
1322: l_objfundsum_rec.plan_curr_utilized_amt := NVL(l_objfundsum_rec.plan_curr_utilized_amt, 0)
1323: + NVL(l_utilization_rec.fund_request_amount, 0);
1324: l_objfundsum_rec.univ_curr_utilized_amt := NVL(l_objfundsum_rec.univ_curr_utilized_amt, 0)

Line 1342: -- R12: yzhao ozf_object_fund_summary update earned and paid amt

1338: l_utilization_rec.gl_posted_flag := ozf_accrual_engine.G_GL_FLAG_NULL; -- null
1339: l_utilization_rec.amount_remaining := NULL; -- no amount remaining for off-invoice utilization/adjustment
1340: l_fund_rec.earned_amt := NVL (l_earned_amt, 0) + NVL (l_utilization_rec.amount, 0);
1341: l_fund_rec.paid_amt := NVL (l_paid_amt, 0) + NVL (l_utilization_rec.amount, 0);
1342: -- R12: yzhao ozf_object_fund_summary update earned and paid amt
1343: l_objfundsum_rec.earned_amt := NVL(l_objfundsum_rec.earned_amt, 0) + NVL(l_utilization_rec.amount, 0);
1344: l_objfundsum_rec.plan_curr_earned_amt := NVL(l_objfundsum_rec.plan_curr_earned_amt, 0)
1345: + NVL(l_utilization_rec.fund_request_amount, 0);
1346: l_objfundsum_rec.univ_curr_earned_amt := NVL(l_objfundsum_rec.univ_curr_earned_amt, 0)

Line 1353: -- R12: yzhao END ozf_object_fund_summary update

1349: l_objfundsum_rec.plan_curr_paid_amt := NVL(l_objfundsum_rec.plan_curr_paid_amt, 0)
1350: + NVL(l_utilization_rec.fund_request_amount, 0);
1351: l_objfundsum_rec.univ_curr_paid_amt := NVL(l_objfundsum_rec.univ_curr_paid_amt, 0)
1352: + NVL(l_univ_curr_amount, 0);
1353: -- R12: yzhao END ozf_object_fund_summary update
1354: END IF; -- end of PRIC type
1355:
1356: ELSE -- offer utilization
1357: IF p_utilization_rec.utilization_type IN ('ADJUSTMENT', 'LEAD_ADJUSTMENT') THEN

Line 1441: -- R12: yzhao ozf_object_fund_summary update earned and paid amt

1437: CLOSE c_offinvoice_gl_post_flag;
1438: IF (l_offinvoice_gl_post_flag = 'F') THEN
1439: l_utilization_rec.gl_posted_flag := ozf_accrual_engine.G_GL_FLAG_NULL; -- null
1440: l_fund_rec.earned_amt := NVL (l_earned_amt, 0) + NVL (l_utilization_rec.amount, 0);
1441: -- R12: yzhao ozf_object_fund_summary update earned and paid amt
1442: l_objfundsum_rec.earned_amt := NVL(l_objfundsum_rec.earned_amt, 0) + NVL(l_utilization_rec.amount, 0);
1443: l_objfundsum_rec.plan_curr_earned_amt := NVL(l_objfundsum_rec.plan_curr_earned_amt, 0)
1444: + NVL(l_plan_curr_amount, 0);
1445: l_objfundsum_rec.univ_curr_earned_amt := NVL(l_objfundsum_rec.univ_curr_earned_amt, 0)

Line 1447: -- R12: yzhao END ozf_object_fund_summary update

1443: l_objfundsum_rec.plan_curr_earned_amt := NVL(l_objfundsum_rec.plan_curr_earned_amt, 0)
1444: + NVL(l_plan_curr_amount, 0);
1445: l_objfundsum_rec.univ_curr_earned_amt := NVL(l_objfundsum_rec.univ_curr_earned_amt, 0)
1446: + NVL(l_univ_curr_amount, 0);
1447: -- R12: yzhao END ozf_object_fund_summary update
1448: -- yzhao: fix bug 3741127 do not update paid amount for off-invoice offer adjustment
1449: IF p_utilization_rec.utilization_type NOT IN ('ADJUSTMENT', 'LEAD_ADJUSTMENT') THEN -- 'UTILIZED'
1450: l_fund_rec.paid_amt := NVL (l_paid_amt, 0) + NVL (l_utilization_rec.amount, 0);
1451: -- R12: yzhao

Line 2167: -- R12: yzhao ozf_object_fund_summary update amount

2163: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2164: RAISE fnd_api.g_exc_unexpected_error;
2165: END IF;
2166:
2167: -- R12: yzhao ozf_object_fund_summary update amount
2168: IF l_objfundsum_rec.objfundsum_id IS NULL THEN
2169: l_objfundsum_rec.fund_id := l_utilization_rec.fund_id;
2170: l_objfundsum_rec.fund_currency := l_utilization_rec.currency_code;
2171: l_objfundsum_rec.object_type := l_utilization_rec.component_type;

Line 2229: -- R12: yzhao END ozf_object_fund_summary update amount

2225: END IF;
2226: END IF;
2227:
2228: END IF;
2229: -- R12: yzhao END ozf_object_fund_summary update amount
2230:
2231: /* yzhao: 09/29/2005 R12 no TRANSFER/REQUEST in utilization table
2232: END IF; -- end IF p_utilization_rec.utilization_type NOT IN ('TRANSFER', 'REQUEST') THEN
2233: */

Line 3434: FROM ozf_object_fund_summary

3430: WHERE parent_source = p_fund_src_id
3431: GROUP BY parent_source);
3432: */
3433: SELECT SUM(NVL(committed_amt,0)-NVL(utilized_amt,0)) total_amount
3434: FROM ozf_object_fund_summary
3435: WHERE object_id =p_object_id
3436: AND object_type = p_object_type
3437: and fund_id = p_fund_src_id;
3438: