APPS.OZF_TRACING_ORDER_PVT dependencies on OZF_RESALE_BATCHES

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 561: UPDATE ozf_resale_batches

557: response_code = 'N'
558: WHERE resale_line_int_id = l_line_int_rec.resale_line_int_id;
559:
560: -- SET Batch as DISPUTED
561: UPDATE ozf_resale_batches
562: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
563: WHERE resale_batch_id = l_line_int_rec.resale_batch_id;
564:
565: GOTO END_ORDER_LINE;

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

1017: SELECT partner_party_id,
1018: report_start_date,
1019: report_end_date,
1020: NVL(direct_order_flag,'N') -- For Bug#9447673 SSD IDSM
1021: FROM ozf_resale_batches
1022: WHERE resale_batch_id = p_id;
1023:
1024: l_status_code VARCHAR2(30);
1025: l_inventory_level_valid boolean;

Line 1222: UPDATE ozf_resale_batches

1218: response_code = 'N'
1219: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id;
1220:
1221: -- SET Batch as DISPUTED
1222: UPDATE ozf_resale_batches
1223: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
1224: WHERE resale_batch_id = p_resale_batch_id;
1225:
1226: GOTO END_ORDER_LINE;

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,