APPS.OZF_PRE_PROCESS_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 316: , ozf_resale_lines_int_all b

312: CURSOR get_count (pc_batch_id IN NUMBER) IS
313: SELECT COUNT(DECODE(b.status_code, 'DISPUTED', 1, NULL)),
314: COUNT(b.status_code)
315: FROM ozf_resale_batches_all a
316: , ozf_resale_lines_int_all b
317: WHERE a.resale_batch_id = b.resale_batch_id
318: AND a.resale_batch_id = pc_batch_id;
319:
320: CURSOR get_batch_org(cv_resale_batch_id IN NUMBER) IS

Line 404: -- Validates and Updates Ozf_Resale_Lines_Int_All

400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402: --
403: IF l_resale_batch_rec.resale_batch_id IS NOT NULL THEN
404: -- Validates and Updates Ozf_Resale_Lines_Int_All
405: Lines_Update
406: (
407: p_batch_id => p_batch_id,
408: px_batch_record => l_resale_batch_rec,

Line 1853: UPDATE ozf_resale_lines_int_all

1849: ozf_utility_pvt.debug_message('Line Count in line bulk update ' || p_line_record.resale_line_int_id.COUNT);
1850: END IF;
1851:
1852: FORALL i IN 1 .. p_line_record.resale_line_int_id.COUNT
1853: UPDATE ozf_resale_lines_int_all
1854: SET object_version_number = p_line_record.object_version_number(i)
1855: , resale_batch_id = p_line_record.resale_batch_id(i)
1856: , status_code = p_line_record.status_code(i)
1857: , resale_transfer_type = p_line_record.resale_transfer_type(i)