eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_BATCHES

Line 243: FROM ozf_resale_batches

239: l_report_end_date date;
240:
241: CURSOR batch_info_csr (p_id IN NUMBER) IS
242: SELECT report_start_date, report_end_date
243: FROM ozf_resale_batches
244: WHERE resale_batch_id = p_id;
245: -- bugfix
246: CURSOR null_columns_csr (p_start_date IN DATE, p_end_date IN DATE) IS
247: SELECT resale_line_int_id, 'OZF_RESALE_ORD_NUM_MISS', 'ORDER_NUMBER', NULL

Line 655: FROM ozf_resale_batches

651: AND resale_batch_id = p_id;
652:
653: CURSOR header_tolerance_csr(p_id in NUMBER) IS
654: SELECT header_tolerance_operand, header_tolerance_calc_code
655: FROM ozf_resale_batches
656: WHERE resale_batch_id = p_id;
657:
658: CURSOR csr_duplicated_dispute_amount(p_resale_batch_id IN NUMBER) IS
659: SELECT NVL(COUNT(resale_line_int_id), 0)

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 895: FROM ozf_resale_batches

891: l_response_type VARCHAR2(30):= NULL;
892: --
893: CURSOR line_tolerance_csr(p_id in NUMBER) IS
894: SELECT line_tolerance_operand, line_tolerance_calc_code
895: FROM ozf_resale_batches
896: WHERE resale_batch_id = p_id;
897:
898: l_dispute_code VARCHAR2(30) := null;
899: l_net_adjusted_amount NUMBER;

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 1195: , ozf_resale_batches orsb

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
1199: AND orsa.resale_batch_id = orsb.resale_batch_id

Line 1655: FROM ozf_resale_batches

1651: WHERE resale_batch_id = p_id;
1652:
1653: CURSOR batch_count_csr(pc_batch_id NUMBER) IS
1654: SELECT NVL(batch_count,0)
1655: FROM ozf_resale_batches
1656: WHERE resale_batch_id = pc_batch_id;
1657:
1658: CURSOR duplicate_count_csr(p_id NUMBER) IS
1659: SELECT count(1)

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

Line 1904: FROM ozf_resale_batches

1900: , report_date
1901: , report_start_date
1902: , report_end_date
1903: , partner_cust_account_id
1904: FROM ozf_resale_batches
1905: WHERE resale_batch_id = p_resale_batch_id;
1906:
1907: CURSOR int_line_count_csr IS
1908: SELECT count(1)

Line 2214: UPDATE ozf_resale_batches

2210:
2211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: -- SLKRISHN common update
2213: BEGIN
2214: UPDATE ozf_resale_batches
2215: SET status_code= G_BATCH_DISPUTED
2216: WHERE resale_batch_id = p_resale_batch_id;
2217: EXCEPTION
2218: WHEN OTHERS THEN

Line 2955: ozf_resale_batches b,

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
2959: AND b.batch_type = p_batch_type