3768: WHERE activity_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID
3769: AND OBJECT_VERSION_NUMBER = l_object_version_number;
3770:
3771: IF (SQL%FOUND) THEN
3772: x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
3773:
3774: ELSE */
3775:
3776: insrt_count := insrt_count + 1;
3822: END IF;
3823:
3824: -- IF insrt_count > 0 THEN
3825: IF p_batch_type = 'CHARGEBACK' THEN
3826: x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE;
3827: ELSE
3828: x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_ACCRUALS;
3829: END IF;
3830: --ELSE
3824: -- IF insrt_count > 0 THEN
3825: IF p_batch_type = 'CHARGEBACK' THEN
3826: x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE;
3827: ELSE
3828: x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_ACCRUALS;
3829: END IF;
3830: --ELSE
3831: -- x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
3832: -- END IF;
3827: ELSE
3828: x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_ACCRUALS;
3829: END IF;
3830: --ELSE
3831: -- x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
3832: -- END IF;
3833:
3834: px_ozf_act_budgets_tbl.delete;
3835:
4247:
4248:
4249: --IF insrt_count > 0 THEN
4250: IF p_batch_type = 'CHARGEBACK' THEN
4251: x_fund_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE;
4252: ELSE
4253: x_fund_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_ACCRUALS;
4254: END IF;
4255: -- ELSE
4249: --IF insrt_count > 0 THEN
4250: IF p_batch_type = 'CHARGEBACK' THEN
4251: x_fund_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE;
4252: ELSE
4253: x_fund_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_ACCRUALS;
4254: END IF;
4255: -- ELSE
4256: --x_fund_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
4257: -- END IF;
4252: ELSE
4253: x_fund_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_ACCRUALS;
4254: END IF;
4255: -- ELSE
4256: --x_fund_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
4257: -- END IF;
4258:
4259: px_ozf_funds_new_tbl.delete;
4260: