DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on OZF_RESALE_COMMON_PVT

Line 3772: x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;

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;

Line 3826: x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE;

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

Line 3828: x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_ACCRUALS;

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;

Line 3831: -- x_budget_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;

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:

Line 4251: x_fund_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE;

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

Line 4253: x_fund_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_ACCRUALS;

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;

Line 4256: --x_fund_update_status := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;

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: