APPS.OZF_PRE_PROCESS_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 329: , ozf_resale_lines_int_all b

325: CURSOR get_count (pc_batch_id IN NUMBER) IS
326: SELECT COUNT(DECODE(b.status_code, 'DISPUTED', 1, NULL)),
327: COUNT(b.status_code)
328: FROM ozf_resale_batches_all a
329: , ozf_resale_lines_int_all b
330: WHERE a.resale_batch_id = b.resale_batch_id
331: AND a.resale_batch_id = pc_batch_id;
332:
333: CURSOR get_batch_org(cv_resale_batch_id IN NUMBER) IS

Line 418: -- Validates and Updates Ozf_Resale_Lines_Int_All

414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END IF;
416: --
417: IF l_resale_batch_rec.resale_batch_id IS NOT NULL THEN
418: -- Validates and Updates Ozf_Resale_Lines_Int_All
419: Lines_Update
420: (
421: p_batch_id => p_batch_id,
422: px_batch_record => l_resale_batch_rec,

Line 1886: UPDATE ozf_resale_lines_int_all

1882: ozf_utility_pvt.debug_message('Line Count in line bulk update ' || p_line_record.resale_line_int_id.COUNT);
1883: END IF;
1884:
1885: FORALL i IN 1 .. p_line_record.resale_line_int_id.COUNT
1886: UPDATE ozf_resale_lines_int_all
1887: SET object_version_number = p_line_record.object_version_number(i)
1888: , resale_batch_id = p_line_record.resale_batch_id(i)
1889: , status_code = p_line_record.status_code(i)
1890: , resale_transfer_type = p_line_record.resale_transfer_type(i)