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_ALL

Line 818: UPDATE ozf_resale_batches_all

814: CLOSE csr_duplicated_dispute_amount;*/
815: --bug # 6134121 fixed by ateotia(-)
816:
817: BEGIN
818: UPDATE ozf_resale_batches_all
819: SET status_code = l_status_code,
820: allowed_amount =l_total_allowed_amount,
821: accepted_amount = l_total_accepted_amount,
822: disputed_amount = ABS(l_total_disputed_amount) + ABS(l_total_duplicated_amount),

Line 929: FROM ozf_resale_batches_all

925: /*
926: -- bug 5969118 Ship and Debit return order generates positive claim amount
927: CURSOR c_batch_type(p_batch_id NUMBER) IS
928: SELECT batch_type
929: FROM ozf_resale_batches_all
930: WHERE resale_batch_id = p_batch_id;
931: l_batch_type VARCHAR2(30);
932: -- bug 5969118 end
933: */

Line 1235: , ozf_resale_batches_all orsb

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

Line 2033: l_batch_number ozf_resale_batches_all.batch_number%TYPE;

2029: --
2030: l_open_lines_tbl number_tbl_type;
2031: l_direct_customer_tbl varchar_tbl_type;
2032: l_claimed_amount_tbl number_tbl_type;
2033: l_batch_number ozf_resale_batches_all.batch_number%TYPE;
2034: --
2035: CURSOR open_lines_csr(p_id IN NUMBER) IS
2036: SELECT resale_line_int_id, direct_customer_flag, claimed_amount
2037: FROM ozf_resale_lines_int

Line 2157: UPDATE ozf_resale_batches_all

2153: IF l_duplicate_count = l_batch_count THEN
2154: -- Reject batch if all lines are duplicates
2155: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED ;
2156: --
2157: UPDATE ozf_resale_batches_all
2158: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED
2159: WHERE resale_batch_id = p_resale_batch_id;
2160: --AMITAMKU, Fix for bug 14685303 - Added code to print the details of rejected batch in output file.
2161: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch# ' || l_batch_number || ' is rejected since all the lines are duplicates.');

Line 2167: UPDATE ozf_resale_batches_all

2163: --bug # 6134121 fixed by ateotia(+)
2164: ELSIF (l_duplicate_count >=1) THEN
2165: --dispute the batch if lines are duplicated within in the same batch
2166: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED ;
2167: UPDATE ozf_resale_batches_all
2168: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
2169: WHERE resale_batch_id = p_resale_batch_id;
2170: --AMITAMKU, Fix for bug 14685303 - Added code to print the details of disputed batch in output file.
2171: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch# ' || l_batch_number || ' is disputed since it has duplicate lines.');

Line 3677: ozf_resale_batches_all orba,

3673: orha.offer_type,
3674: qlha.list_header_id
3675: FROM
3676: ozf_request_headers_all_vl orha,
3677: ozf_resale_batches_all orba,
3678: qp_list_headers_all qlha
3679: WHERE
3680: orha.agreement_number = p_agreement_num
3681: AND orha.status_code = 'APPROVED'

Line 4084: FROM ozf_resale_batches_all

4080:
4081: -- For Bug#9447673 SSD IDSM ER(+)
4082: CURSOR batch_direct_flag_csr (p_id IN NUMBER) IS
4083: SELECT NVL(direct_order_flag,'N')
4084: FROM ozf_resale_batches_all
4085: WHERE resale_batch_id = p_id;
4086: -- For Bug#9447673 SSD IDSM ER(-)
4087:
4088: BEGIN

Line 7316: -- Updating the status of all the batches as CLOSED in ozf_resale_batches_all table.

7312:
7313:
7314: END IF;
7315:
7316: -- Updating the status of all the batches as CLOSED in ozf_resale_batches_all table.
7317: FOR batch_id_int_rec IN batch_id_int_csr(p_batch_type)
7318: LOOP
7319:
7320: ozf_utility_pvt.write_conc_log('updating batch to Closed status - resale_batch_id: ' || batch_id_int_rec.RESALE_BATCH_ID);

Line 7322: UPDATE ozf_resale_batches_all

7318: LOOP
7319:
7320: ozf_utility_pvt.write_conc_log('updating batch to Closed status - resale_batch_id: ' || batch_id_int_rec.RESALE_BATCH_ID);
7321:
7322: UPDATE ozf_resale_batches_all
7323: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,
7324: last_updated_by = NVL(fnd_global.user_id, -1),
7325: last_update_date = SYSDATE
7326: WHERE resale_batch_id = batch_id_int_rec.RESALE_BATCH_ID

Line 7822: -- Updating the status of the batch as CLOSED in ozf_resale_batches_all table.

7818:
7819:
7820: END IF;
7821:
7822: -- Updating the status of the batch as CLOSED in ozf_resale_batches_all table.
7823: ozf_utility_pvt.write_conc_log('Updating the status of the batch as CLOSED for Batch Id='||p_batch_id);
7824:
7825: UPDATE ozf_resale_batches_all
7826: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,

Line 7825: UPDATE ozf_resale_batches_all

7821:
7822: -- Updating the status of the batch as CLOSED in ozf_resale_batches_all table.
7823: ozf_utility_pvt.write_conc_log('Updating the status of the batch as CLOSED for Batch Id='||p_batch_id);
7824:
7825: UPDATE ozf_resale_batches_all
7826: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,
7827: last_updated_by = NVL(fnd_global.user_id, -1),
7828: last_update_date = SYSDATE
7829: WHERE resale_batch_id = p_batch_id;