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 250: -- yzhao: R12 update ozf_object_fund_summary table

246: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
247: FROM ozf_sys_parameters_all sob
248: WHERE sob.org_id = p_org_id;
249:
250: -- yzhao: R12 update ozf_object_fund_summary table
251: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS
252: SELECT objfundsum_id
253: , object_version_number
254: , committed_amt

Line 269: FROM ozf_object_fund_summary

265: , univ_curr_recal_committed_amt
266: , univ_curr_utilized_amt
267: , univ_curr_earned_amt
268: , univ_curr_paid_amt
269: FROM ozf_object_fund_summary
270: WHERE object_type = p_object_type
271: AND object_id = p_object_id
272: AND fund_id = p_fund_id;
273:

Line 869: -- R12: yzhao ozf_object_fund_summary

865: IF p_utilization_rec.utilization_type NOT IN ('TRANSFER', 'REQUEST') THEN
866: */
867: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
868:
869: -- R12: yzhao ozf_object_fund_summary
870: l_objfundsum_rec := NULL;
871: OPEN c_get_objfundsum_rec(l_utilization_rec.component_type
872: , l_utilization_rec.component_id
873: , l_utilization_rec.fund_id);

Line 892: -- R12: yzhao END ozf_object_fund_summary

888: , l_objfundsum_rec.univ_curr_utilized_amt
889: , l_objfundsum_rec.univ_curr_earned_amt
890: , l_objfundsum_rec.univ_curr_paid_amt;
891: CLOSE c_get_objfundsum_rec;
892: -- R12: yzhao END ozf_object_fund_summary
893:
894: -- yzhao: 27-JUL-2005 - R12 paid adjustment can be done through public api
895: IF l_utilization_rec.utilization_type = 'ADJUSTMENT' AND
896: NVL(l_utilization_rec.adjustment_type, ' ') IN ('INCREASE_PAID', 'DECREASE_PAID') THEN

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

927: -- 11/06/2003 for manual adjustment, DECREASE_COMM_EARNED, java does not create transfer record for fully accrual budget any more
928: l_fund_rec.committed_amt := NVL (l_committed_amt, 0) + NVL (l_utilization_rec.amount, 0);
929: l_fund_rec.recal_committed := NVL (l_recal_comm_amt, 0) + NVL (l_utilization_rec.amount, 0);
930:
931: -- R12: yzhao ozf_object_fund_summary update utilized/committed amt
932: l_objfundsum_rec.utilized_amt := NVL(l_objfundsum_rec.utilized_amt, 0) + NVL(l_utilization_rec.amount, 0);
933: l_objfundsum_rec.plan_curr_utilized_amt := NVL(l_objfundsum_rec.plan_curr_utilized_amt, 0)
934: + NVL(l_plan_curr_amount, 0);
935: l_objfundsum_rec.univ_curr_utilized_amt := NVL(l_objfundsum_rec.univ_curr_utilized_amt, 0)

Line 948: -- R12: yzhao END ozf_object_fund_summary update

944: l_objfundsum_rec.plan_curr_recal_committed_amt := NVL(l_objfundsum_rec.plan_curr_recal_committed_amt, 0)
945: + NVL(l_plan_curr_amount, 0);
946: l_objfundsum_rec.univ_curr_recal_committed_amt := NVL(l_objfundsum_rec.univ_curr_recal_committed_amt, 0)
947: + NVL(l_univ_curr_amount, 0);
948: -- R12: yzhao END ozf_object_fund_summary update
949:
950: -- 10/14/2003 update ozf_act_budgets REQUEST between fully accrual budget and its offer when accrual happens
951: OPEN c_accrual_budget_reqeust(l_utilization_rec.fund_id, l_plan_id);
952: FETCH c_accrual_budget_reqeust INTO l_act_budget_id, l_act_budget_objver;

Line 1045: -- R12: yzhao ozf_object_fund_summary update utilized_amt

1041: END IF;
1042:
1043: ELSE -- for fixed budget
1044: l_fund_rec.utilized_amt := NVL (l_utilized_amt, 0) + NVL (l_utilization_rec.amount, 0);
1045: -- R12: yzhao ozf_object_fund_summary update utilized_amt
1046: l_objfundsum_rec.utilized_amt := NVL(l_objfundsum_rec.utilized_amt, 0) + NVL(l_utilization_rec.amount, 0);
1047: l_objfundsum_rec.plan_curr_utilized_amt := NVL(l_objfundsum_rec.plan_curr_utilized_amt, 0)
1048: + NVL(l_plan_curr_amount, 0);
1049: l_objfundsum_rec.univ_curr_utilized_amt := NVL(l_objfundsum_rec.univ_curr_utilized_amt, 0)

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

1063: l_utilization_rec.gl_posted_flag := ozf_accrual_engine.G_GL_FLAG_NULL; -- null
1064: l_utilization_rec.amount_remaining := NULL; -- no amount remaining for off-invoice utilization/adjustment
1065: l_fund_rec.earned_amt := NVL (l_earned_amt, 0) + NVL (l_utilization_rec.amount, 0);
1066: l_fund_rec.paid_amt := NVL (l_paid_amt, 0) + NVL (l_utilization_rec.amount, 0);
1067: -- R12: yzhao ozf_object_fund_summary update earned and paid amt
1068: l_objfundsum_rec.earned_amt := NVL(l_objfundsum_rec.earned_amt, 0) + NVL(l_utilization_rec.amount, 0);
1069: l_objfundsum_rec.plan_curr_earned_amt := NVL(l_objfundsum_rec.plan_curr_earned_amt, 0)
1070: + NVL(l_plan_curr_amount, 0);
1071: l_objfundsum_rec.univ_curr_earned_amt := NVL(l_objfundsum_rec.univ_curr_earned_amt, 0)

Line 1078: -- R12: yzhao END ozf_object_fund_summary update

1074: l_objfundsum_rec.plan_curr_paid_amt := NVL(l_objfundsum_rec.plan_curr_paid_amt, 0)
1075: + NVL(l_plan_curr_amount, 0);
1076: l_objfundsum_rec.univ_curr_paid_amt := NVL(l_objfundsum_rec.univ_curr_paid_amt, 0)
1077: + NVL(l_univ_curr_amount, 0);
1078: -- R12: yzhao END ozf_object_fund_summary update
1079: END IF; -- end of PRIC type
1080:
1081: ELSE -- offer utilization
1082: IF p_utilization_rec.utilization_type IN ('ADJUSTMENT', 'LEAD_ADJUSTMENT') THEN

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

1156: CLOSE c_offinvoice_gl_post_flag;
1157: IF (l_offinvoice_gl_post_flag = 'F') THEN
1158: l_utilization_rec.gl_posted_flag := ozf_accrual_engine.G_GL_FLAG_NULL; -- null
1159: l_fund_rec.earned_amt := NVL (l_earned_amt, 0) + NVL (l_utilization_rec.amount, 0);
1160: -- R12: yzhao ozf_object_fund_summary update earned and paid amt
1161: l_objfundsum_rec.earned_amt := NVL(l_objfundsum_rec.earned_amt, 0) + NVL(l_utilization_rec.amount, 0);
1162: l_objfundsum_rec.plan_curr_earned_amt := NVL(l_objfundsum_rec.plan_curr_earned_amt, 0)
1163: + NVL(l_plan_curr_amount, 0);
1164: l_objfundsum_rec.univ_curr_earned_amt := NVL(l_objfundsum_rec.univ_curr_earned_amt, 0)

Line 1166: -- R12: yzhao END ozf_object_fund_summary update

1162: l_objfundsum_rec.plan_curr_earned_amt := NVL(l_objfundsum_rec.plan_curr_earned_amt, 0)
1163: + NVL(l_plan_curr_amount, 0);
1164: l_objfundsum_rec.univ_curr_earned_amt := NVL(l_objfundsum_rec.univ_curr_earned_amt, 0)
1165: + NVL(l_univ_curr_amount, 0);
1166: -- R12: yzhao END ozf_object_fund_summary update
1167: -- yzhao: fix bug 3741127 do not update paid amount for off-invoice offer adjustment
1168: IF p_utilization_rec.utilization_type NOT IN ('ADJUSTMENT', 'LEAD_ADJUSTMENT') THEN -- 'UTILIZED'
1169: l_fund_rec.paid_amt := NVL (l_paid_amt, 0) + NVL (l_utilization_rec.amount, 0);
1170: -- R12: yzhao

Line 1724: -- R12: yzhao ozf_object_fund_summary update amount

1720: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1721: RAISE fnd_api.g_exc_unexpected_error;
1722: END IF;
1723:
1724: -- R12: yzhao ozf_object_fund_summary update amount
1725: IF l_objfundsum_rec.objfundsum_id IS NULL THEN
1726: l_objfundsum_rec.fund_id := l_utilization_rec.fund_id;
1727: l_objfundsum_rec.fund_currency := l_utilization_rec.currency_code;
1728: l_objfundsum_rec.object_type := l_utilization_rec.component_type;

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

1773: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1774: RAISE fnd_api.g_exc_error;
1775: END IF;
1776: END IF;
1777: -- R12: yzhao END ozf_object_fund_summary update amount
1778:
1779: /* yzhao: 09/29/2005 R12 no TRANSFER/REQUEST in utilization table
1780: END IF; -- end IF p_utilization_rec.utilization_type NOT IN ('TRANSFER', 'REQUEST') THEN
1781: */

Line 2972: FROM ozf_object_fund_summary

2968: WHERE parent_source = p_fund_src_id
2969: GROUP BY parent_source);
2970: */
2971: SELECT SUM(NVL(committed_amt,0)-NVL(utilized_amt,0)) total_amount
2972: FROM ozf_object_fund_summary
2973: WHERE object_id =p_object_id
2974: AND object_type = p_object_type
2975: and fund_id = p_fund_src_id;
2976: