APPS.OZF_RESALE_PVT dependencies on OZF_RESALE_BATCHES

Line 18: FROM ozf_resale_batches_all

14: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
15:
16: CURSOR g_org_id_csr(p_id number) IS
17: SELECT org_id
18: FROM ozf_resale_batches_all
19: WHERE resale_batch_id = p_id;
20:
21:
22: ---------------------------------------------------------------------

Line 354: FROM ozf_resale_batches

350: */
351:
352: CURSOR batch_count_csr(pc_batch_id NUMBER) IS
353: SELECT NVL(batch_count,0)
354: FROM ozf_resale_batches
355: WHERE resale_batch_id = pc_batch_id;
356:
357: CURSOR duplicate_count_csr(p_id NUMBER) IS
358: SELECT count(1)

Line 586: update ozf_resale_batches_all

582: FETCH batch_count_csr into l_batch_count;
583: CLOSE batch_count_csr;
584:
585: IF l_duplicate_count = l_batch_count THEN
586: update ozf_resale_batches_all
587: set status_code = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED
588: where resale_batch_id = p_resale_batch_id;
589: ELSE
590: */

Line 827: FROM ozf_resale_batches

823: l_batch_number VARCHAR2(30);
824:
825: CURSOR csr_batch_number(cv_batch_id IN NUMBER) IS
826: SELECT batch_number
827: FROM ozf_resale_batches
828: WHERE resale_batch_id = cv_batch_id;
829:
830: BEGIN
831:

Line 987: FROM ozf_resale_batches

983: l_end_date date:= p_end_date;
984:
985: CURSOR range_without_customer_csr(p_start_date date, p_end_date date) is
986: SELECT resale_batch_id
987: FROM ozf_resale_batches
988: WHERE report_start_date >= p_start_date
989: AND report_end_date <= p_end_date
990: AND status_code = 'CLOSED';
991:

Line 994: FROM ozf_resale_batches

990: AND status_code = 'CLOSED';
991:
992: CURSOR range_with_customer_csr(p_start_date date, p_end_date date, p_cust_account_id NUMBER) is
993: SELECT resale_batch_id
994: FROM ozf_resale_batches
995: WHERE report_start_date >= p_start_date
996: AND report_end_date <= p_end_date
997: AND partner_cust_account_id = p_cust_account_id
998: AND status_code = 'CLOSED';

Line 1002: FROM ozf_resale_batches

998: AND status_code = 'CLOSED';
999:
1000: CURSOR csr_customer_batches(cv_cust_account_id IN NUMBER) IS
1001: SELECT resale_batch_id
1002: FROM ozf_resale_batches
1003: WHERE partner_cust_account_id = cv_cust_account_id
1004: AND status_code = 'CLOSED';
1005:
1006:

Line 1346: FROM ozf_resale_batches b

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
1348: AND b.status_code = 'CLOSED'
1349: );
1350:

Line 1351: UPDATE ozf_resale_batches

1347: WHERE b.purge_flag IS NULL
1348: AND b.status_code = 'CLOSED'
1349: );
1350:
1351: UPDATE ozf_resale_batches
1352: SET purge_flag = 'T'
1353: WHERE purge_flag IS NULL
1354: AND status_code = 'CLOSED';
1355: EXCEPTION

Line 1365: FROM ozf_resale_batches b

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
1366: WHERE b.purge_flag IS NULL
1367: AND b.status_code = 'CLOSED'
1368: AND b.data_source_code = p_data_source_code
1369: );

Line 1371: UPDATE ozf_resale_batches

1367: AND b.status_code = 'CLOSED'
1368: AND b.data_source_code = p_data_source_code
1369: );
1370:
1371: UPDATE ozf_resale_batches
1372: SET purge_flag = 'T'
1373: WHERE purge_flag IS NULL
1374: AND status_code = 'CLOSED'
1375: AND data_source_code = p_data_source_code;

Line 1389: FROM ozf_resale_batches b

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
1391: AND b.resale_batch_id = p_resale_batch_id
1392: AND b.status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT')
1393: );

Line 1395: DELETE FROM ozf_resale_batches_all

1391: AND b.resale_batch_id = p_resale_batch_id
1392: AND b.status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT')
1393: );
1394:
1395: DELETE FROM ozf_resale_batches_all
1396: WHERE resale_batch_id = p_resale_batch_id
1397: AND status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT');
1398: EXCEPTION
1399: WHEN OTHERS THEN

Line 1408: FROM ozf_resale_batches b

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
1409: WHERE b.purge_flag IS NULL
1410: AND b.data_source_code = p_data_source_code
1411: AND b.resale_batch_id = p_resale_batch_id
1412: );

Line 1414: DELETE FROM ozf_resale_batches_all

1410: AND b.data_source_code = p_data_source_code
1411: AND b.resale_batch_id = p_resale_batch_id
1412: );
1413:
1414: DELETE FROM ozf_resale_batches_all
1415: WHERE resale_batch_id = p_resale_batch_id
1416: AND data_source_code = p_data_source_code
1417: AND status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT');
1418: EXCEPTION