APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_BATCHES_ALL

Line 795: UPDATE ozf_resale_batches_all

791: CLOSE csr_duplicated_dispute_amount;*/
792: --bug # 6134121 fixed by ateotia(-)
793:
794: BEGIN
795: UPDATE ozf_resale_batches_all
796: SET status_code = l_status_code,
797: allowed_amount =l_total_allowed_amount,
798: accepted_amount = l_total_accepted_amount,
799: disputed_amount = ABS(l_total_disputed_amount) + ABS(l_total_duplicated_amount),

Line 908: FROM ozf_resale_batches_all

904:
905: -- bug 5969118 Ship and Debit return order generates positive claim amount
906: CURSOR c_batch_type(p_batch_id NUMBER) IS
907: SELECT batch_type
908: FROM ozf_resale_batches_all
909: WHERE resale_batch_id = p_batch_id;
910:
911: l_batch_type VARCHAR2(30);
912: l_total_accepted_amount NUMBER;

Line 1192: , ozf_resale_batches_all orsb

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
1196: */

Line 1768: UPDATE ozf_resale_batches_all

1764: IF l_duplicate_count = l_batch_count THEN
1765: -- Reject batch if all lines are duplicates
1766: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED ;
1767: --
1768: UPDATE ozf_resale_batches_all
1769: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED
1770: WHERE resale_batch_id = p_resale_batch_id;
1771: --
1772: --bug # 6134121 fixed by ateotia(+)

Line 1776: UPDATE ozf_resale_batches_all

1772: --bug # 6134121 fixed by ateotia(+)
1773: ELSIF (l_duplicate_count >=1) THEN
1774: --dispute the batch if lines are duplicated within in the same batch
1775: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED ;
1776: UPDATE ozf_resale_batches_all
1777: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
1778: WHERE resale_batch_id = p_resale_batch_id;
1779: --bug # 6134121 fixed by ateotia(-)
1780: ELSE