DBA Data[Home] [Help]

APPS.OZF_TRACING_ORDER_PVT dependencies on OZF_RESALE_BATCHES_ALL

Line 67: FROM ozf_resale_batches_all

63: batch_number,
64: last_updated_by,
65: NVL(direct_order_flag,'N'), --For Bug#9447673 SSD IDSM
66: org_id
67: FROM ozf_resale_batches_all
68: WHERE resale_batch_id = p_id;
69: l_batch_status VARCHAR2(30);
70: l_batch_type VARCHAR2(30);
71: l_partner_cust_account_id NUMBER;

Line 733: UPDATE ozf_resale_batches_all

729: --Bug# 8414563 fixed by ateotia(-)
730: --AND duplicated_adjustment_id <> -1;
731:
732: -- UPDATE batch status to CLOSEd -- might change later.
733: UPDATE ozf_resale_batches_all
734: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED
735: WHERE resale_batch_id = p_resale_batch_id;
736: EXCEPTION
737: WHEN OTHERS THEN

Line 1280: UPDATE ozf_resale_batches_all

1276: END IF;
1277:
1278: -- Lastly, I will UPDATE the batch
1279: BEGIN
1280: UPDATE ozf_resale_batches_all
1281: SET status_code = l_status_code,
1282: --Bug# 8414563 fixed by ateotia(+)
1283: --lines_disputed = l_lines_disputed,
1284: lines_disputed = l_lines_disputed + l_lines_duplicated,