APPS.OZF_PRE_PROCESS_PVT dependencies on OZF_RESALE_LINES_INT

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 1477: FROM ozf_resale_lines_int

1473: , invoice_line_number
1474: , order_line_number
1475: , supplier_item_cost
1476: , supplier_item_uom
1477: FROM ozf_resale_lines_int
1478: WHERE resale_batch_id = cv_batch_id
1479: -- AND status_code IN ('NEW', 'OPEN', 'DUPLICATED', 'DISPUTED', 'PROCESSED')
1480: --------------------------------------------------------------
1481: -- We're going to process all the lines regardless of the status

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)

Line 7549: OZF_RESALE_LINES_INT_PKG.Update_Row(

7545: IF OZF_DEBUG_LOW_ON THEN
7546: ozf_utility_pvt.debug_message('p_int_line_tbl(l_count).resale_line_int_id ' || p_int_line_tbl(l_count).resale_line_int_id );
7547: END IF;
7548:
7549: OZF_RESALE_LINES_INT_PKG.Update_Row(
7550: p_resale_line_int_id => p_int_line_tbl(l_count).resale_line_int_id,
7551: p_object_version_number => p_int_line_tbl(l_count).object_version_number,
7552: p_last_update_date => p_int_line_tbl(l_count).last_update_date,
7553: p_last_updated_by => p_int_line_tbl(l_count).last_updated_by,