2807: l_return_status VARCHAR2(30);
2808: l_msg_data VARCHAR2(2000);
2809: l_msg_count NUMBER;
2810:
2811: l_pric_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2812: l_pric_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
2813: l_pric_price_adj_rec ozf_resale_adjustments_all%ROWTYPE;
2814:
2815: l_adjustment_id NUMBER;
2808: l_msg_data VARCHAR2(2000);
2809: l_msg_count NUMBER;
2810:
2811: l_pric_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2812: l_pric_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
2813: l_pric_price_adj_rec ozf_resale_adjustments_all%ROWTYPE;
2814:
2815: l_adjustment_id NUMBER;
2816: l_rate NUMBER;
2871: END IF;
2872:
2873: IF p_batch_type <> G_SPECIAL_PRICING THEN
2874: l_pric_act_budgets_rec.parent_src_curr :=
2875: OZF_ACTBUDGETS_PVT.Get_Object_Currency (
2876: 'FUND'
2877: ,l_pric_act_budgets_rec.parent_source_id
2878: ,l_return_status
2879: );
3056: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
3057: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3058: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3059: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
3060: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
3061: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
3062: ,p_to_create_utilization IN BOOLEAN
3063: ,x_return_status OUT NOCOPY VARCHAR2
3064: ,x_msg_data OUT NOCOPY VARCHAR2
3057: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3058: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3059: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
3060: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
3061: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
3062: ,p_to_create_utilization IN BOOLEAN
3063: ,x_return_status OUT NOCOPY VARCHAR2
3064: ,x_msg_data OUT NOCOPY VARCHAR2
3065: ,x_msg_count OUT NOCOPY NUMBER
3115: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
3116: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3117: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3118: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
3119: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
3120: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
3121: ,p_to_create_utilization IN BOOLEAN
3122: ,x_return_status OUT NOCOPY VARCHAR2
3123: ,x_msg_data OUT NOCOPY VARCHAR2
3116: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3117: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3118: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
3119: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
3120: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
3121: ,p_to_create_utilization IN BOOLEAN
3122: ,x_return_status OUT NOCOPY VARCHAR2
3123: ,x_msg_data OUT NOCOPY VARCHAR2
3124: ,x_msg_count OUT NOCOPY NUMBER
3163: --
3164: -- PARAMETERS
3165: --
3166: -- p_adj_rec IN ozf_chargeback_price_adj_all%rowtype
3167: -- p_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type
3168: -- p_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
3169: -- p_use_fund_staging_tables for staging table impln of chargeback flow
3170: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3171: -- and px_ozf_funds_old_rectype for taking the funds old values
3164: -- PARAMETERS
3165: --
3166: -- p_adj_rec IN ozf_chargeback_price_adj_all%rowtype
3167: -- p_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type
3168: -- p_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
3169: -- p_use_fund_staging_tables for staging table impln of chargeback flow
3170: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3171: -- and px_ozf_funds_old_rectype for taking the funds old values
3172: -- and px_ozf_funds_new_rectype for taking the new values after updation.
3183: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
3184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3185: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3186: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
3187: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
3188: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
3189: ,p_to_create_utilization IN BOOLEAN
3190: ,x_return_status OUT NOCOPY VARCHAR2
3191: ,x_msg_data OUT NOCOPY VARCHAR2
3184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3185: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3186: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
3187: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
3188: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
3189: ,p_to_create_utilization IN BOOLEAN
3190: ,x_return_status OUT NOCOPY VARCHAR2
3191: ,x_msg_data OUT NOCOPY VARCHAR2
3192: ,x_msg_count OUT NOCOPY NUMBER
7911: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
7912: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
7913: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
7914: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
7915: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
7916: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
7917: ,p_resale_line_int_rec IN OUT NOCOPY g_interface_rec_csr%rowtype
7918: ,p_draft_run_id IN NUMBER
7919: ,p_caller_type IN VARCHAR2
7912: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
7913: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
7914: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
7915: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
7916: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
7917: ,p_resale_line_int_rec IN OUT NOCOPY g_interface_rec_csr%rowtype
7918: ,p_draft_run_id IN NUMBER
7919: ,p_caller_type IN VARCHAR2
7920: ,px_draft_accrual_tbl IN OUT NOCOPY OZF_TP_ACCRUAL_PVT.ozf_draft_accrual_tbl_type