APPS.OZF_RESALE_WF_PVT dependencies on OZF_RESALE_BATCHES_ALL

Line 183: FROM ozf_resale_batches_all

179:
180: CURSOR batch_status_csr(p_id number) IS
181: SELECT status_code
182: --FROM ozf_resale_batches
183: FROM ozf_resale_batches_all
184: WHERE resale_batch_id = p_id;
185:
186: l_batch_org_id NUMBER;
187:

Line 661: FROM ozf_resale_batches_all

657:
658: CURSOR batch_status_csr(p_id number) IS
659: SELECT status_code
660: --FROM ozf_resale_batches
661: FROM ozf_resale_batches_all
662: WHERE resale_batch_id = p_id;
663:
664: l_batch_org_id NUMBER;
665: BEGIN

Line 935: FROM ozf_resale_batches_all

931: SELECT batch_number
932: , batch_type
933: , last_updated_by
934: , org_id
935: FROM ozf_resale_batches_all
936: WHERE resale_batch_id = p_id;
937:
938: /*
939: CURSOR emp_infor_csr(p_res_id NUMBER) IS

Line 1245: FROM ozf_resale_batches_all

1241: , last_updated_by
1242: , batch_type
1243: , batch_number
1244: , org_id
1245: FROM ozf_resale_batches_all
1246: WHERE resale_batch_id = p_resale_batch_id;
1247:
1248: l_batch_info get_batch_info%ROWTYPE;
1249:

Line 2195: FROM ozf_resale_batches_all

2191: CURSOR batch_status_csr(p_id number) IS
2192: SELECT status_code
2193: , lines_disputed
2194: --FROM ozf_resale_batches
2195: FROM ozf_resale_batches_all
2196: WHERE resale_batch_id = p_id;
2197: --
2198: BEGIN
2199: IF OZF_DEBUG_HIGH_ON THEN

Line 2227: UPDATE ozf_resale_batches_all

2223:
2224: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING THEN
2225: IF l_lines_disputed = 0 THEN
2226: -- update status to Processed
2227: UPDATE ozf_resale_batches_all
2228: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_OPEN
2229: WHERE resale_batch_id = l_resale_batch_id;
2230: ELSE
2231: -- update status to Disputed

Line 2232: UPDATE ozf_resale_batches_all

2228: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_OPEN
2229: WHERE resale_batch_id = l_resale_batch_id;
2230: ELSE
2231: -- update status to Disputed
2232: UPDATE ozf_resale_batches_all
2233: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
2234: WHERE resale_batch_id = l_resale_batch_id;
2235: END IF;
2236: ELSIF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN

Line 2240: UPDATE ozf_resale_batches_all

2236: ELSIF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN
2237:
2238: IF l_lines_disputed = 0 THEN
2239: -- update status to Processed
2240: UPDATE ozf_resale_batches_all
2241: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED
2242: WHERE resale_batch_id = l_resale_batch_id;
2243: ELSE
2244: -- update status to Disputed

Line 2245: UPDATE ozf_resale_batches_all

2241: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED
2242: WHERE resale_batch_id = l_resale_batch_id;
2243: ELSE
2244: -- update status to Disputed
2245: UPDATE ozf_resale_batches_all
2246: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
2247: WHERE resale_batch_id = l_resale_batch_id;
2248: END IF;
2249: END IF;

Line 2348: FROM ozf_resale_batches_all

2344: CURSOR batch_status_csr(p_id number) IS
2345: SELECT last_updated_by
2346: , status_code
2347: --FROM ozf_resale_batches
2348: FROM ozf_resale_batches_all
2349: WHERE resale_batch_id = p_id;
2350:
2351: CURSOR emp_infor_csr(p_res_id NUMBER) IS
2352: -- BUBG 4953233 (+)

Line 2532: UPDATE ozf_resale_batches_all

2528: IF l_batch_status IN (OZF_RESALE_COMMON_PVT.G_BATCH_OPEN,
2529: OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED) THEN
2530: l_batch_next_status := OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING;
2531:
2532: UPDATE ozf_resale_batches_all
2533: SET status_code = l_batch_next_status
2534: WHERE resale_batch_id = l_resale_batch_id;
2535:
2536: ELSE

Line 2670: UPDATE ozf_resale_batches_all

2666: itemtype => itemtype,
2667: itemkey => itemkey,
2668: aname => G_WF_ATTR_BATCH_ID);
2669:
2670: UPDATE ozf_resale_batches_all
2671: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT
2672: WHERE resale_batch_id = l_resale_batch_id;
2673:
2674: l_resultout := 'COMPLETE';

Line 2777: FROM ozf_resale_batches_all

2773: last_update_date,
2774: partner_party_id,
2775: partner_cust_account_id
2776: --FROM ozf_resale_batches
2777: FROM ozf_resale_batches_all
2778: WHERE resale_batch_id = p_batch_id;
2779:
2780: CURSOR header_tolerance_sys_csr IS
2781: SELECT header_tolerance_operand,

Line 2910: UPDATE ozf_resale_batches_all

2906: END IF;
2907:
2908: END IF;
2909:
2910: UPDATE ozf_resale_batches_all
2911: SET header_tolerance_operand = l_header_tolerance_operand,
2912: header_tolerance_calc_code = l_header_tolerance_calc_code,
2913: line_tolerance_operand = l_line_tolerance_operand,
2914: line_tolerance_calc_code = l_line_tolerance_calc_code

Line 3722: FROM ozf_resale_batches_all

3718: , last_updated_by
3719: , batch_type
3720: , batch_number
3721: , org_id -- nepanda : Fix for Bug 13819601
3722: FROM ozf_resale_batches_all
3723: WHERE resale_batch_id = p_resale_batch_id;
3724:
3725: CURSOR emp_infor_csr(p_res_id NUMBER) IS
3726: -- BUBG 4953233 (+)

Line 3779: UPDATE ozf_resale_batches_all

3775: FETCH get_batch_info INTO l_batch_info;
3776: CLOSE get_batch_info;
3777:
3778: IF l_batch_info.status_code IN ('OPEN', 'DISPUTED') THEN
3779: UPDATE ozf_resale_batches_all
3780: SET status_code = 'PROCESSING'
3781: WHERE resale_batch_id = p_resale_batch_id;
3782: END IF;
3783: --Bugfix: 6510872

Line 3979: FROM ozf_resale_batches_all

3975: , last_updated_by
3976: , batch_type
3977: , batch_number
3978: , org_id -- nepanda : Fix for Bug 13819601
3979: FROM ozf_resale_batches_all
3980: WHERE resale_batch_id = p_resale_batch_id;
3981:
3982: CURSOR emp_infor_csr(p_res_id NUMBER) IS
3983: -- BUBG 4953233 (+)

Line 4030: UPDATE ozf_resale_batches_all

4026: FETCH get_batch_info INTO l_batch_info;
4027: CLOSE get_batch_info;
4028:
4029: IF l_batch_info.status_code IN ('OPEN', 'DISPUTED', 'PROCESSED') THEN
4030: UPDATE ozf_resale_batches_all
4031: SET status_code = 'PENDING_PAYMENT'
4032: WHERE resale_batch_id = p_resale_batch_id;
4033: END IF;
4034: --Bugfix: 6510872