APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_ADJUSTMENTS

Line 1191: FROM ozf_resale_adjustments_all orsa

1187: IS
1188: SELECT orsa.resale_adjustment_id
1189: , orsa.claimed_amount
1190: -- Bug 4670154 (+)
1191: FROM ozf_resale_adjustments_all orsa
1192: , ozf_resale_batches_all orsb
1193: /*
1194: FROM ozf_resale_adjustments orsa
1195: , ozf_resale_batches orsb

Line 1194: FROM ozf_resale_adjustments orsa

1190: -- Bug 4670154 (+)
1191: FROM ozf_resale_adjustments_all orsa
1192: , ozf_resale_batches_all orsb
1193: /*
1194: FROM ozf_resale_adjustments orsa
1195: , ozf_resale_batches orsb
1196: */
1197: -- Bug 4670154 (-)
1198: WHERE orsa.resale_line_id = p_line_id

Line 2437: l_pric_price_adj_rec ozf_resale_adjustments_all%ROWTYPE;

2433: l_msg_count NUMBER;
2434:
2435: l_pric_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2436: l_pric_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
2437: l_pric_price_adj_rec ozf_resale_adjustments_all%ROWTYPE;
2438:
2439: l_adjustment_id NUMBER;
2440: l_rate NUMBER;
2441: l_exchange_type VARCHAR2(30);

Line 2660: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype

2656: p_api_version IN NUMBER
2657: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
2658: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2659: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2660: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
2661: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
2662: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
2663: ,p_to_create_utilization IN BOOLEAN
2664: ,x_return_status OUT NOCOPY VARCHAR2

Line 2733: OZF_RESALE_ADJUSTMENTS_PKG.Insert_Row(

2729: END IF;
2730:
2731: -- We only need to record for every price adjustment information
2732: BEGIN
2733: OZF_RESALE_ADJUSTMENTS_PKG.Insert_Row(
2734: px_resale_adjustment_id => l_adjustment_id,
2735: px_object_version_number => l_obj_ver_num,
2736: p_last_update_date => sysdate,
2737: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),

Line 2954: FROM ozf_resale_adjustments a,

2950:
2951: CURSOR dup_adj_csr(p_line_id in NUMBER, p_batch_type in VARCHAR2) IS
2952: SELECT a.resale_adjustment_id,
2953: a.total_accepted_amount
2954: FROM ozf_resale_adjustments a,
2955: ozf_resale_batches b,
2956: ozf_resale_lines c
2957: WHERE a.resale_line_id = p_line_id
2958: AND a.resale_batch_id = b.resale_batch_id

Line 2970: FROM ozf_resale_adjustments

2966: -- BUG 4670154 (-)
2967:
2968: CURSOR dup_adj_rec_csr(p_adj_id NUMBER) IS
2969: SELECT *
2970: FROM ozf_resale_adjustments
2971: WHERE resale_adjustment_id = p_adj_id;
2972:
2973: l_dup_adj_rec dup_adj_rec_csr%ROWTYPE;
2974: