APPS.OZF_RESALE_PVT dependencies on OZF_RESALE_LINES_INT

Line 348: FROM ozf_resale_lines_int

344: --
345: /*
346: CURSOR open_lines_csr(p_id IN NUMBER) IS
347: SELECT *
348: FROM ozf_resale_lines_int
349: WHERE status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
350: AND resale_batch_id = p_id;
351: */
352:

Line 360: FROM ozf_resale_lines_int

356: WHERE resale_batch_id = pc_batch_id;
357:
358: CURSOR duplicate_count_csr(p_id NUMBER) IS
359: SELECT count(1)
360: FROM ozf_resale_lines_int
361: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED
362: AND resale_batch_id = p_id;
363:
364: CURSOR disputed_count_csr(p_id number) IS

Line 366: FROM ozf_resale_lines_int

362: AND resale_batch_id = p_id;
363:
364: CURSOR disputed_count_csr(p_id number) IS
365: SELECT count(1)
366: FROM ozf_resale_lines_int
367: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED
368: AND resale_batch_id = p_id;
369: --
370: BEGIN

Line 447: update ozf_resale_lines_int

443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;
445:
446: -- set disputed_code to null for the lines to be processed.
447: update ozf_resale_lines_int
448: set dispute_code = null
449: where resale_batch_id = p_resale_batch_id
450: and status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
451:

Line 453: update ozf_resale_lines_int

449: where resale_batch_id = p_resale_batch_id
450: and status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
451:
452: -- update tracing order lines to processed for this order to be processed
453: update ozf_resale_lines_int
454: set status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED
455: where resale_batch_id = p_resale_batch_id
456: and status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
457: and tracing_flag = 'T';

Line 1495: DELETE FROM ozf_resale_lines_int_all a

1491: -- Purge the records that have been successfully processed
1492: IF p_data_source_code IS NULL OR
1493: p_data_source_code = 'ALL' THEN
1494: BEGIN
1495: DELETE FROM ozf_resale_lines_int_all a
1496: WHERE a.resale_batch_id IN (
1497: SELECT b.resale_batch_id
1498: FROM ozf_resale_batches b
1499: WHERE b.purge_flag IS NULL

Line 1513: DELETE FROM ozf_resale_lines_int_all a

1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: END;
1511: ELSE
1512: BEGIN
1513: DELETE FROM ozf_resale_lines_int_all a
1514: WHERE a.data_source_code = p_data_source_code
1515: AND a.resale_batch_id IN (
1516: SELECT b.resale_batch_id
1517: FROM ozf_resale_batches b

Line 1538: DELETE FROM ozf_resale_lines_int_all a

1534: -- Purge the records that have been successfully processed
1535: IF p_data_source_code IS NULL OR
1536: p_data_source_code = 'ALL' THEN
1537: BEGIN
1538: DELETE FROM ozf_resale_lines_int_all a
1539: WHERE a.resale_batch_id IN (
1540: SELECT b.resale_batch_id
1541: FROM ozf_resale_batches b
1542: WHERE b.purge_flag IS NULL

Line 1556: DELETE FROM ozf_resale_lines_int_all a

1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1553: END;
1554: ELSE
1555: BEGIN
1556: DELETE FROM ozf_resale_lines_int_all a
1557: WHERE a.data_source_code = p_data_source_code
1558: AND a.resale_batch_id IN (
1559: SELECT b.resale_batch_id
1560: FROM ozf_resale_batches b