APPS.OZF_RESALE_PVT dependencies on OZF_RESALE_BATCHES

Line 19: FROM ozf_resale_batches_all

15: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
16:
17: CURSOR g_org_id_csr(p_id number) IS
18: SELECT org_id
19: FROM ozf_resale_batches_all
20: WHERE resale_batch_id = p_id;
21:
22:
23: ---------------------------------------------------------------------

Line 355: FROM ozf_resale_batches

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

Line 587: update ozf_resale_batches_all

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

Line 871: FROM ozf_resale_batches

867: l_batch_number VARCHAR2(30);
868:
869: CURSOR csr_batch_number(cv_batch_id IN NUMBER) IS
870: SELECT batch_number
871: FROM ozf_resale_batches
872: WHERE resale_batch_id = cv_batch_id;
873:
874: BEGIN
875:

Line 1032: FROM ozf_resale_batches

1028: x_batch_status varchar2(30);
1029:
1030: CURSOR range_without_customer_csr(p_start_date date, p_end_date date) is
1031: SELECT resale_batch_id
1032: FROM ozf_resale_batches
1033: WHERE report_start_date >= p_start_date
1034: AND report_end_date <= p_end_date
1035: AND status_code = 'CLOSED';
1036:

Line 1039: FROM ozf_resale_batches

1035: AND status_code = 'CLOSED';
1036:
1037: CURSOR range_with_customer_csr(p_start_date date, p_end_date date, p_cust_account_id NUMBER) is
1038: SELECT resale_batch_id
1039: FROM ozf_resale_batches
1040: WHERE report_start_date >= p_start_date
1041: AND report_end_date <= p_end_date
1042: AND partner_cust_account_id = p_cust_account_id
1043: AND status_code = 'CLOSED';

Line 1047: FROM ozf_resale_batches

1043: AND status_code = 'CLOSED';
1044:
1045: CURSOR csr_customer_batches(cv_cust_account_id IN NUMBER) IS
1046: SELECT resale_batch_id
1047: FROM ozf_resale_batches
1048: WHERE partner_cust_account_id = cv_cust_account_id
1049: AND status_code = 'CLOSED';
1050:
1051:

Line 1163: UPDATE ozf_resale_batches_all

1159: END IF;
1160:
1161: -- For TPA Parallel Execution ER - 9614703 (+)
1162: IF x_batch_status = 'CLOSED' THEN
1163: UPDATE ozf_resale_batches_all
1164: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED
1165: WHERE resale_batch_id = l_batch_id_tbl(j);
1166: ELSIF x_batch_status = 'PENDING_ACCRUALS' THEN
1167: UPDATE ozf_resale_batches_all

Line 1167: UPDATE ozf_resale_batches_all

1163: UPDATE ozf_resale_batches_all
1164: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED
1165: WHERE resale_batch_id = l_batch_id_tbl(j);
1166: ELSIF x_batch_status = 'PENDING_ACCRUALS' THEN
1167: UPDATE ozf_resale_batches_all
1168: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_ACCRUALS
1169: WHERE resale_batch_id = l_batch_id_tbl(j);
1170: END IF;
1171: -- For TPA Parallel Execution ER - 9614703 (-)

Line 1498: FROM ozf_resale_batches b

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
1500: AND b.status_code = 'CLOSED'
1501: );
1502:

Line 1503: UPDATE ozf_resale_batches

1499: WHERE b.purge_flag IS NULL
1500: AND b.status_code = 'CLOSED'
1501: );
1502:
1503: UPDATE ozf_resale_batches
1504: SET purge_flag = 'T'
1505: WHERE purge_flag IS NULL
1506: AND status_code = 'CLOSED';
1507: EXCEPTION

Line 1517: FROM ozf_resale_batches b

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
1518: WHERE b.purge_flag IS NULL
1519: AND b.status_code = 'CLOSED'
1520: AND b.data_source_code = p_data_source_code
1521: );

Line 1523: UPDATE ozf_resale_batches

1519: AND b.status_code = 'CLOSED'
1520: AND b.data_source_code = p_data_source_code
1521: );
1522:
1523: UPDATE ozf_resale_batches
1524: SET purge_flag = 'T'
1525: WHERE purge_flag IS NULL
1526: AND status_code = 'CLOSED'
1527: AND data_source_code = p_data_source_code;

Line 1541: FROM ozf_resale_batches b

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

Line 1547: DELETE FROM ozf_resale_batches_all

1543: AND b.resale_batch_id = p_resale_batch_id
1544: AND b.status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT')
1545: );
1546:
1547: DELETE FROM ozf_resale_batches_all
1548: WHERE resale_batch_id = p_resale_batch_id
1549: AND status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT');
1550: EXCEPTION
1551: WHEN OTHERS THEN

Line 1560: FROM ozf_resale_batches b

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
1561: WHERE b.purge_flag IS NULL
1562: AND b.data_source_code = p_data_source_code
1563: AND b.resale_batch_id = p_resale_batch_id
1564: );

Line 1566: DELETE FROM ozf_resale_batches_all

1562: AND b.data_source_code = p_data_source_code
1563: AND b.resale_batch_id = p_resale_batch_id
1564: );
1565:
1566: DELETE FROM ozf_resale_batches_all
1567: WHERE resale_batch_id = p_resale_batch_id
1568: AND data_source_code = p_data_source_code
1569: AND status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT');
1570: EXCEPTION