DBA Data[Home] [Help]

APPS.OZF_CHARGEBACK_PVT dependencies on OZF_FUNDS_ALL_B

Line 145: ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

141: l_use_fund_staging_tables VARCHAR2(1):= 'T';
142:
143: ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
144: l_budget_count NUMBER := 0;
145: ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
146: ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
147: l_partner_site_id NUMBER; --//Bugfix : 10265295
148: l_org_id NUMBER;
149:

Line 318: FROM OZF_FUNDS_ALL_B

314: ROLLUP_EARNED_AMT,
315: ROLLUP_PAID_AMT,
316: UTILIZED_AMT,
317: ROLLUP_UTILIZED_AMT
318: FROM OZF_FUNDS_ALL_B
319: WHERE FUND_ID = p_fund_id;
320:
321: l_accrual_flag VARCHAR2(1);
322: --Bug# 8632964 fixed by anuj and muthu (-)

Line 971: OZF_UTILITY_PVT.UPDATE_OZF_FUNDS_ALL_B(p_resale_batch_id, x_return_status, x_fund_table_status, ozf_funds_new_tbl, 'CHARGEBACK');

967: END IF;
968:
969: -- Call for the update of funds and budgets where the update happens in one shot.
970: IF ozf_funds_new_tbl.COUNT > 0 THEN
971: OZF_UTILITY_PVT.UPDATE_OZF_FUNDS_ALL_B(p_resale_batch_id, x_return_status, x_fund_table_status, ozf_funds_new_tbl, 'CHARGEBACK');
972: IF x_return_status = FND_API.g_ret_sts_error THEN
973: RAISE FND_API.g_exc_error;
974: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
975: RAISE FND_API.g_exc_unexpected_error;