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_WF_PVT dependencies on OZF_RESALE_BATCHES_ALL

Line 126: FROM ozf_resale_batches_all

122:
123: CURSOR batch_status_csr(p_id number) IS
124: SELECT status_code
125: --FROM ozf_resale_batches
126: FROM ozf_resale_batches_all
127: WHERE resale_batch_id = p_id;
128:
129: l_batch_org_id NUMBER;
130:

Line 589: FROM ozf_resale_batches_all

585:
586: CURSOR batch_status_csr(p_id number) IS
587: SELECT status_code
588: --FROM ozf_resale_batches
589: FROM ozf_resale_batches_all
590: WHERE resale_batch_id = p_id;
591:
592: l_batch_org_id NUMBER;
593: BEGIN

Line 861: FROM ozf_resale_batches_all

857: SELECT batch_number
858: , batch_type
859: , last_updated_by
860: , org_id
861: FROM ozf_resale_batches_all
862: WHERE resale_batch_id = p_id;
863:
864: /*
865: CURSOR emp_infor_csr(p_res_id NUMBER) IS

Line 2072: FROM ozf_resale_batches_all

2068: CURSOR batch_status_csr(p_id number) IS
2069: SELECT status_code
2070: , lines_disputed
2071: --FROM ozf_resale_batches
2072: FROM ozf_resale_batches_all
2073: WHERE resale_batch_id = p_id;
2074: --
2075: BEGIN
2076: IF OZF_DEBUG_HIGH_ON THEN

Line 2104: UPDATE ozf_resale_batches_all

2100:
2101: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING THEN
2102: IF l_lines_disputed = 0 THEN
2103: -- update status to Processed
2104: UPDATE ozf_resale_batches_all
2105: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_OPEN
2106: WHERE resale_batch_id = l_resale_batch_id;
2107: ELSE
2108: -- update status to Disputed

Line 2109: UPDATE ozf_resale_batches_all

2105: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_OPEN
2106: WHERE resale_batch_id = l_resale_batch_id;
2107: ELSE
2108: -- update status to Disputed
2109: UPDATE ozf_resale_batches_all
2110: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
2111: WHERE resale_batch_id = l_resale_batch_id;
2112: END IF;
2113: ELSIF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN

Line 2117: UPDATE ozf_resale_batches_all

2113: ELSIF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN
2114:
2115: IF l_lines_disputed = 0 THEN
2116: -- update status to Processed
2117: UPDATE ozf_resale_batches_all
2118: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED
2119: WHERE resale_batch_id = l_resale_batch_id;
2120: ELSE
2121: -- update status to Disputed

Line 2122: UPDATE ozf_resale_batches_all

2118: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED
2119: WHERE resale_batch_id = l_resale_batch_id;
2120: ELSE
2121: -- update status to Disputed
2122: UPDATE ozf_resale_batches_all
2123: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
2124: WHERE resale_batch_id = l_resale_batch_id;
2125: END IF;
2126: END IF;

Line 2225: FROM ozf_resale_batches_all

2221: CURSOR batch_status_csr(p_id number) IS
2222: SELECT last_updated_by
2223: , status_code
2224: --FROM ozf_resale_batches
2225: FROM ozf_resale_batches_all
2226: WHERE resale_batch_id = p_id;
2227:
2228: CURSOR emp_infor_csr(p_res_id NUMBER) IS
2229: -- BUBG 4953233 (+)

Line 2327: UPDATE ozf_resale_batches_all

2323: IF l_batch_status IN (OZF_RESALE_COMMON_PVT.G_BATCH_OPEN,
2324: OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED) THEN
2325: l_batch_next_status := OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING;
2326:
2327: UPDATE ozf_resale_batches_all
2328: SET status_code = l_batch_next_status
2329: WHERE resale_batch_id = l_resale_batch_id;
2330:
2331: ELSE

Line 2464: UPDATE ozf_resale_batches_all

2460: itemtype => itemtype,
2461: itemkey => itemkey,
2462: aname => G_WF_ATTR_BATCH_ID);
2463:
2464: UPDATE ozf_resale_batches_all
2465: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT
2466: WHERE resale_batch_id = l_resale_batch_id;
2467:
2468: l_resultout := 'COMPLETE';

Line 2571: FROM ozf_resale_batches_all

2567: last_update_date,
2568: partner_party_id,
2569: partner_cust_account_id
2570: --FROM ozf_resale_batches
2571: FROM ozf_resale_batches_all
2572: WHERE resale_batch_id = p_batch_id;
2573:
2574: CURSOR header_tolerance_sys_csr IS
2575: SELECT header_tolerance_operand,

Line 2703: UPDATE ozf_resale_batches_all

2699: END IF;
2700:
2701: END IF;
2702:
2703: UPDATE ozf_resale_batches_all
2704: SET header_tolerance_operand = l_header_tolerance_operand,
2705: header_tolerance_calc_code = l_header_tolerance_calc_code,
2706: line_tolerance_operand = l_line_tolerance_operand,
2707: line_tolerance_calc_code = l_line_tolerance_calc_code

Line 3510: FROM ozf_resale_batches_all

3506: SELECT status_code
3507: , last_updated_by
3508: , batch_type
3509: , batch_number
3510: FROM ozf_resale_batches_all
3511: WHERE resale_batch_id = p_resale_batch_id;
3512:
3513: CURSOR emp_infor_csr(p_res_id NUMBER) IS
3514: -- BUBG 4953233 (+)

Line 3540: UPDATE ozf_resale_batches_all

3536: FETCH get_batch_info INTO l_batch_info;
3537: CLOSE get_batch_info;
3538:
3539: IF l_batch_info.status_code IN ('OPEN', 'DISPUTED') THEN
3540: UPDATE ozf_resale_batches_all
3541: SET status_code = 'PROCESSING'
3542: WHERE resale_batch_id = p_resale_batch_id;
3543: END IF;
3544: --Bugfix: 6510872

Line 3648: FROM ozf_resale_batches_all

3644: SELECT status_code
3645: , last_updated_by
3646: , batch_type
3647: , batch_number
3648: FROM ozf_resale_batches_all
3649: WHERE resale_batch_id = p_resale_batch_id;
3650:
3651: CURSOR emp_infor_csr(p_res_id NUMBER) IS
3652: -- BUBG 4953233 (+)

Line 3676: UPDATE ozf_resale_batches_all

3672: FETCH get_batch_info INTO l_batch_info;
3673: CLOSE get_batch_info;
3674:
3675: IF l_batch_info.status_code IN ('OPEN', 'DISPUTED', 'PROCESSED') THEN
3676: UPDATE ozf_resale_batches_all
3677: SET status_code = 'PENDING_PAYMENT'
3678: WHERE resale_batch_id = p_resale_batch_id;
3679: END IF;
3680: --Bugfix: 6510872