APPS.OZF_WEBADI_INTERFACE_PVT dependencies on OZF_RESALE_LINES_INT

Line 643: FROM ozf_resale_batches_all a, ozf_resale_lines_int_all b

639:
640: CURSOR c_chk_line_exists(pc_batch_number VARCHAR2)
641: IS
642: SELECT COUNT(b.resale_batch_id),a.status_code
643: FROM ozf_resale_batches_all a, ozf_resale_lines_int_all b
644: WHERE a.resale_batch_id = b.resale_batch_id
645: AND a.batch_number = pc_batch_number
646: GROUP BY a.resale_batch_id, a.status_code;
647:

Line 653: FROM ozf_resale_batches_all a, ozf_resale_lines_int_all b

649: CURSOR c_get_update_record(pc_batch_number VARCHAR2, pc_resale_line_int_id NUMBER)
650: IS
651: SELECT a.resale_batch_id, a.object_version_number,
652: b.object_version_number
653: FROM ozf_resale_batches_all a, ozf_resale_lines_int_all b
654: WHERE a.resale_batch_id = b.resale_batch_id
655: AND a.batch_number = pc_batch_number
656: AND b.resale_line_int_id = pc_resale_line_int_id;
657:

Line 1467: SELECT ozf_resale_lines_int_all_s.nextval

1463: --INTO l_int_line_tbl(1).org_id FROM DUAL;
1464: l_int_line_tbl(1).org_id := l_org_id;
1465: -- Bug 5417666 (-)
1466:
1467: SELECT ozf_resale_lines_int_all_s.nextval
1468: INTO l_int_line_tbl(1).resale_line_int_id
1469: FROM DUAL;
1470: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);
1471: IF G_RESALE_BATCH_ID = 0 OR l_resale_batch_rec.resale_batch_id IS NULL THEN

Line 2211: FROM ozf_resale_lines_int

2207: nvl(p_int_line_tbl(1).line_attribute13,line_attribute13),
2208: nvl(p_int_line_tbl(1).line_attribute14,line_attribute14),
2209: nvl(p_int_line_tbl(1).line_attribute15,line_attribute15),
2210: nvl(p_int_line_tbl(1).org_id,org_id)
2211: FROM ozf_resale_lines_int
2212: WHERE resale_line_int_id = pc_line_id
2213: AND resale_batch_id = pc_batch_id;
2214:
2215:

Line 2551: OZF_RESALE_LINES_INT_PKG.INSERT_ROW

2547: l_resale_line_int_id := p_int_line_tbl(i).resale_line_int_id;
2548: l_object_version_number := 1;
2549: l_org_id := p_int_line_tbl(i).org_id;
2550:
2551: OZF_RESALE_LINES_INT_PKG.INSERT_ROW
2552: (
2553: px_resale_line_int_id => l_resale_line_int_id,
2554: px_object_version_number => l_object_version_number,
2555: p_last_update_date => sysdate,