APPS.OZF_WEBADI_INTERFACE_PVT dependencies on OZF_RESALE_LINES_INT

Line 886: FROM ozf_resale_batches_all a, ozf_resale_lines_int_all b

882:
883: CURSOR c_chk_line_exists(pc_batch_number VARCHAR2)
884: IS
885: SELECT COUNT(b.resale_batch_id),a.status_code
886: FROM ozf_resale_batches_all a, ozf_resale_lines_int_all b
887: WHERE a.resale_batch_id = b.resale_batch_id
888: AND a.batch_number = pc_batch_number
889: GROUP BY a.resale_batch_id, a.status_code;
890:

Line 896: FROM ozf_resale_batches_all a, ozf_resale_lines_int_all b

892: CURSOR c_get_update_record(pc_batch_number VARCHAR2, pc_resale_line_int_id NUMBER)
893: IS
894: SELECT a.resale_batch_id, a.object_version_number,
895: b.object_version_number
896: FROM ozf_resale_batches_all a, ozf_resale_lines_int_all b
897: WHERE a.resale_batch_id = b.resale_batch_id
898: AND a.batch_number = pc_batch_number
899: AND b.resale_line_int_id = pc_resale_line_int_id;
900:

Line 1858: SELECT ozf_resale_lines_int_all_s.nextval

1854: --INTO l_int_line_tbl(1).org_id FROM DUAL;
1855: l_int_line_tbl(1).org_id := l_org_id;
1856: -- Bug 5417666 (-)
1857:
1858: SELECT ozf_resale_lines_int_all_s.nextval
1859: INTO l_int_line_tbl(1).resale_line_int_id
1860: FROM DUAL;
1861: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);
1862: IF G_RESALE_BATCH_ID = 0 OR l_resale_batch_rec.resale_batch_id IS NULL THEN

Line 2621: FROM ozf_resale_lines_int

2617: nvl(p_int_line_tbl(1).supplier_item_cost,supplier_item_cost),
2618: nvl(p_int_line_tbl(1).supplier_item_uom,supplier_item_uom)
2619: -- For Bug#9447673 SSD IDSM ER(-)
2620:
2621: FROM ozf_resale_lines_int
2622: WHERE resale_line_int_id = pc_line_id
2623: AND resale_batch_id = pc_batch_id;
2624:
2625:

Line 2968: OZF_RESALE_LINES_INT_PKG.INSERT_ROW

2964: l_resale_line_int_id := p_int_line_tbl(i).resale_line_int_id;
2965: l_object_version_number := 1;
2966: l_org_id := p_int_line_tbl(i).org_id;
2967:
2968: OZF_RESALE_LINES_INT_PKG.INSERT_ROW
2969: (
2970: px_resale_line_int_id => l_resale_line_int_id,
2971: px_object_version_number => l_object_version_number,
2972: p_last_update_date => sysdate,