APPS.OZF_WEBADI_INTERFACE_PVT dependencies on OZF_RESALE_BATCHES

Line 879: FROM ozf_resale_batches_all

875:
876: CURSOR c_chk_record_exists(pc_batch_number VARCHAR2)
877: IS
878: SELECT COUNT(batch_number)
879: FROM ozf_resale_batches_all
880: WHERE batch_number = pc_batch_number;
881:
882:
883: CURSOR c_chk_line_exists(pc_batch_number VARCHAR2)

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 933: l_resale_batch_rec ozf_resale_batches_all%rowtype;

929: l_line_status VARCHAR2(30);
930: l_batch_status VARCHAR2(30);
931: l_location_count NUMBER := 0;
932:
933: l_resale_batch_rec ozf_resale_batches_all%rowtype;
934: l_int_line_tbl ozf_pre_process_pvt.resale_line_int_tbl_type := ozf_pre_process_pvt.resale_line_int_tbl_type();
935: l_resale_line_int_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
936: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
937: l_total_claimed_amount NUMBER := 0;

Line 1738: SELECT ozf_resale_batches_all_s.nextval

1734: -- the first time this API call is made. Batch is created when batch count = 0
1735: -- ==============================================================================
1736:
1737: IF l_status_code = 'NEW' AND l_batch_count = 0 THEN
1738: SELECT ozf_resale_batches_all_s.nextval
1739: INTO l_resale_batch_rec.resale_batch_id
1740: FROM DUAL;
1741:
1742: -- ==============================================================================

Line 1761: OZF_RESALE_BATCHES_PKG.INSERT_ROW

1757: */
1758: -- R12 MOAC Enhancement (-)
1759: BEGIN
1760:
1761: OZF_RESALE_BATCHES_PKG.INSERT_ROW
1762: (
1763: px_resale_batch_id => l_resale_batch_rec.resale_batch_id
1764: ,px_object_version_number => l_batch_obj
1765: ,p_last_update_date => SYSDATE

Line 1865: FROM ozf_resale_batches

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
1863: SELECT resale_batch_id
1864: INTO l_int_line_tbl(1).resale_batch_id
1865: FROM ozf_resale_batches
1866: WHERE batch_number = p_batch_number;
1867: ELSE
1868: l_int_line_tbl(1).resale_batch_id := G_RESALE_BATCH_ID;
1869:

Line 2052: p_int_batch_rec IN ozf_resale_batches_all%rowtype,

2048: p_api_version_number IN NUMBER,
2049: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2050: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2051: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2052: p_int_batch_rec IN ozf_resale_batches_all%rowtype,
2053: x_return_status OUT NOCOPY VARCHAR2,
2054: x_msg_count OUT NOCOPY NUMBER,
2055: x_msg_data OUT NOCOPY VARCHAR2
2056: )

Line 2062: l_resale_batch_rec ozf_resale_batches_all%rowtype;

2058:
2059: l_api_name CONSTANT VARCHAR2(30) := 'Update_Resale_Batch';
2060: l_api_version_number CONSTANT NUMBER := 1.0;
2061:
2062: l_resale_batch_rec ozf_resale_batches_all%rowtype;
2063:
2064: CURSOR get_resale_batch (pc_batch_number VARCHAR2)
2065: IS
2066: SELECT last_update_date,

Line 2134: FROM ozf_resale_batches

2130: NVL(p_int_batch_rec.lines_w_tolerance,lines_w_tolerance),
2131: NVL(p_int_batch_rec.lines_disputed,lines_disputed),
2132: NVL(p_int_batch_rec.purge_flag,purge_flag),
2133: NVL(p_int_batch_rec.direct_order_flag,direct_order_flag) -- For Bug#9447673 SSD IDSM
2134: FROM ozf_resale_batches
2135: WHERE batch_number = pc_batch_number;
2136:
2137: BEGIN
2138: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');