APPS.OZF_RESALE_PVT dependencies on OZF_RESALE_LINES_INT

Line 347: FROM ozf_resale_lines_int

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

Line 359: FROM ozf_resale_lines_int

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

Line 365: FROM ozf_resale_lines_int

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

Line 446: update ozf_resale_lines_int

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

Line 452: update ozf_resale_lines_int

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

Line 1343: DELETE FROM ozf_resale_lines_int_all a

1339: -- Purge the records that have been successfully processed
1340: IF p_data_source_code IS NULL OR
1341: p_data_source_code = 'ALL' THEN
1342: BEGIN
1343: DELETE FROM ozf_resale_lines_int_all a
1344: WHERE a.resale_batch_id IN (
1345: SELECT b.resale_batch_id
1346: FROM ozf_resale_batches b
1347: WHERE b.purge_flag IS NULL

Line 1361: DELETE FROM ozf_resale_lines_int_all a

1357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1358: END;
1359: ELSE
1360: BEGIN
1361: DELETE FROM ozf_resale_lines_int_all a
1362: WHERE a.data_source_code = p_data_source_code
1363: AND a.resale_batch_id IN (
1364: SELECT b.resale_batch_id
1365: FROM ozf_resale_batches b

Line 1386: DELETE FROM ozf_resale_lines_int_all a

1382: -- Purge the records that have been successfully processed
1383: IF p_data_source_code IS NULL OR
1384: p_data_source_code = 'ALL' THEN
1385: BEGIN
1386: DELETE FROM ozf_resale_lines_int_all a
1387: WHERE a.resale_batch_id IN (
1388: SELECT b.resale_batch_id
1389: FROM ozf_resale_batches b
1390: WHERE b.purge_flag IS NULL

Line 1404: DELETE FROM ozf_resale_lines_int_all a

1400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1401: END;
1402: ELSE
1403: BEGIN
1404: DELETE FROM ozf_resale_lines_int_all a
1405: WHERE a.data_source_code = p_data_source_code
1406: AND a.resale_batch_id IN (
1407: SELECT b.resale_batch_id
1408: FROM ozf_resale_batches b