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

253: l_report_end_date date;
254:
255: CURSOR batch_info_csr (p_id IN NUMBER) IS
256: SELECT report_start_date, report_end_date
257: FROM ozf_resale_batches
258: WHERE resale_batch_id = p_id;
259: -- bugfix
260: CURSOR null_columns_csr (p_start_date IN DATE, p_end_date IN DATE) IS
261: SELECT resale_line_int_id, 'OZF_RESALE_ORD_NUM_MISS', 'ORDER_NUMBER', NULL

Line 669: FROM ozf_resale_batches

665: AND resale_batch_id = p_id;
666:
667: CURSOR header_tolerance_csr(p_id in NUMBER) IS
668: SELECT header_tolerance_operand, header_tolerance_calc_code
669: FROM ozf_resale_batches
670: WHERE resale_batch_id = p_id;
671:
672: CURSOR csr_duplicated_dispute_amount(p_resale_batch_id IN NUMBER) IS
673: SELECT NVL(COUNT(resale_line_int_id), 0)

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

914: l_total_allowed_amount NUMBER;
915:
916: CURSOR line_tolerance_csr(p_id in NUMBER) IS
917: SELECT line_tolerance_operand, line_tolerance_calc_code
918: FROM ozf_resale_batches
919: WHERE resale_batch_id = p_id;
920:
921: CURSOR allowed_or_claimed_csr IS
922: SELECT ship_debit_calc_type

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

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

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

2040: AND status_code <> OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED;
2041:
2042: CURSOR batch_count_csr(pc_batch_id NUMBER) IS
2043: SELECT NVL(batch_count,0), batch_number
2044: FROM ozf_resale_batches
2045: WHERE resale_batch_id = pc_batch_id;
2046:
2047: CURSOR duplicate_count_csr(p_id NUMBER) IS
2048: SELECT count(1)

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

2267: , report_date
2268: , report_start_date
2269: , report_end_date
2270: , partner_cust_account_id
2271: FROM ozf_resale_batches
2272: WHERE resale_batch_id = p_resale_batch_id;
2273:
2274: CURSOR int_line_count_csr IS
2275: SELECT count(1)

Line 2581: UPDATE ozf_resale_batches

2577:
2578: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2579: -- SLKRISHN common update
2580: BEGIN
2581: UPDATE ozf_resale_batches
2582: SET status_code= G_BATCH_DISPUTED
2583: WHERE resale_batch_id = p_resale_batch_id;
2584: EXCEPTION
2585: WHEN OTHERS THEN

Line 3638: ozf_resale_batches b,

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

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;