[Home] [Help]
1230: IS
1231: SELECT orsa.resale_adjustment_id
1232: , orsa.claimed_amount
1233: -- Bug 4670154 (+)
1234: FROM ozf_resale_adjustments_all orsa
1235: , ozf_resale_batches_all orsb
1236: /*
1237: FROM ozf_resale_adjustments orsa
1238: , ozf_resale_batches orsb
1233: -- Bug 4670154 (+)
1234: FROM ozf_resale_adjustments_all orsa
1235: , ozf_resale_batches_all orsb
1236: /*
1237: FROM ozf_resale_adjustments orsa
1238: , ozf_resale_batches orsb
1239: */
1240: -- Bug 4670154 (-)
1241: WHERE orsa.resale_line_id = p_line_id
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;
2817: l_exchange_type VARCHAR2(30);
3055: p_api_version IN NUMBER
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
3114: p_api_version IN 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
3182: p_api_version IN NUMBER
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
3264: END IF;
3265:
3266: -- We only need to record for every price adjustment information
3267: BEGIN
3268: OZF_RESALE_ADJUSTMENTS_PKG.Insert_Row(
3269: px_resale_adjustment_id => l_adjustment_id,
3270: px_object_version_number => l_obj_ver_num,
3271: p_last_update_date => sysdate,
3272: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3633:
3634: CURSOR dup_adj_csr(p_line_id in NUMBER, p_batch_type in VARCHAR2) IS
3635: SELECT a.resale_adjustment_id,
3636: a.total_accepted_amount
3637: FROM ozf_resale_adjustments a,
3638: ozf_resale_batches b,
3639: ozf_resale_lines c
3640: WHERE a.resale_line_id = p_line_id
3641: AND a.resale_batch_id = b.resale_batch_id
3649: -- BUG 4670154 (-)
3650:
3651: CURSOR dup_adj_rec_csr(p_adj_id NUMBER) IS
3652: SELECT *
3653: FROM ozf_resale_adjustments
3654: WHERE resale_adjustment_id = p_adj_id;
3655:
3656: l_dup_adj_rec dup_adj_rec_csr%ROWTYPE;
3657:
7910: p_api_version IN 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