APPS.OZF_QUOTA_PUB dependencies on OZF_PRODUCT_ALLOCATIONS

Line 1315: SELECT ozf_product_allocations_s.NEXTVAL

1311: l_api_name CONSTANT VARCHAR2(30) := 'get_product_allocation_id';
1312: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1313:
1314: CURSOR product_seq_csr IS
1315: SELECT ozf_product_allocations_s.NEXTVAL
1316: FROM DUAL;
1317:
1318: CURSOR product_alloc_count_csr(p_product_alloc_id in number) IS
1319: SELECT count(p.product_allocation_id)

Line 1320: FROM ozf_product_allocations p

1316: FROM DUAL;
1317:
1318: CURSOR product_alloc_count_csr(p_product_alloc_id in number) IS
1319: SELECT count(p.product_allocation_id)
1320: FROM ozf_product_allocations p
1321: WHERE p.product_allocation_id = p_product_alloc_id;
1322:
1323: l_count number := -1;
1324: l_product_alloc_id number := -1;

Line 1456: ,p_product_alloc_rec IN ozf_product_allocations%ROWTYPE

1452: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1453: ,x_return_status OUT NOCOPY VARCHAR2
1454: ,x_msg_count OUT NOCOPY NUMBER
1455: ,x_msg_data OUT NOCOPY VARCHAR2
1456: ,p_product_alloc_rec IN ozf_product_allocations%ROWTYPE
1457: ,x_product_allocation_id OUT NOCOPY NUMBER )
1458: IS
1459:
1460: l_api_name VARCHAR(30) := 'Create_Product_Alloc_Record';

Line 1477: Ozf_Product_Allocations_Pkg.Insert_Row(

1473:
1474: l_product_allocation_id := get_product_allocation_id;
1475:
1476: -- Call the Insert here
1477: Ozf_Product_Allocations_Pkg.Insert_Row(
1478: px_product_allocation_id => l_product_allocation_id,
1479: p_allocation_for => p_product_alloc_rec.allocation_for,
1480: p_allocation_for_id => p_product_alloc_rec.allocation_for_id,
1481: p_fund_id => p_product_alloc_rec.fund_id,

Line 1723: l_product_alloc_rec ozf_product_allocations%ROWTYPE;

1719: ,p_quota_prod_spread_tbl IN quota_prod_spread_tbl_type )
1720: IS
1721:
1722: l_api_name VARCHAR(30) := 'create_quota_product_spread';
1723: l_product_alloc_rec ozf_product_allocations%ROWTYPE;
1724: l_time_alloc_rec ozf_time_allocations%ROWTYPE;
1725:
1726: l_product_allocation_id NUMBER;
1727: l_time_allocation_id NUMBER;

Line 1754: -- Insert record into ozf_product_allocations

1750: END IF;
1751:
1752: FOR l_product_counter IN 1..p_quota_products_tbl.count
1753: LOOP
1754: -- Insert record into ozf_product_allocations
1755: l_product_alloc_rec := NULL;
1756:
1757: IF p_allocation_for IS NOT NULL
1758: THEN

Line 2705: FROM ozf_product_allocations

2701:
2702: CURSOR c_chk_prod_alloc_id (p_product_allocation_id NUMBER) IS
2703: SELECT product_allocation_id,
2704: object_version_number
2705: FROM ozf_product_allocations
2706: WHERE product_allocation_id = p_product_allocation_id;
2707:
2708: CURSOR c_chk_time_alloc_id (p_time_allocation_id NUMBER) IS
2709: SELECT time_allocation_id,

Line 2753: UPDATE ozf_product_allocations

2749: --
2750: END IF;
2751:
2752:
2753: UPDATE ozf_product_allocations
2754: SET target = NVL(p_quota_products_tbl(l_prod_alloc_counter).target, target),
2755: lysp_sales = NVL(p_quota_products_tbl(l_prod_alloc_counter).lysp_sales, lysp_sales),
2756: object_version_number = l_object_version_number + 1 ,
2757: last_update_date = SYSDATE,

Line 3029: from ozf_product_allocations

3025:
3026: delete from ozf_time_allocations
3027: where allocation_for = 'PROD'
3028: and allocation_for_id in ( select product_allocation_id
3029: from ozf_product_allocations
3030: where allocation_for = 'CUST'
3031: and allocation_for_id in ( select account_allocation_id
3032: from ozf_account_allocations
3033: where allocation_for = 'FUND'

Line 3037: delete from ozf_product_allocations

3033: where allocation_for = 'FUND'
3034: and allocation_for_id = p_quota_id)
3035: );
3036:
3037: delete from ozf_product_allocations
3038: where allocation_for = 'CUST'
3039: and allocation_for_id in ( select account_allocation_id
3040: from ozf_account_allocations
3041: where allocation_for = 'FUND'

Line 3059: from ozf_product_allocations

3055:
3056: delete from ozf_time_allocations
3057: where allocation_for = 'PROD'
3058: and allocation_for_id in (select product_allocation_id
3059: from ozf_product_allocations
3060: where allocation_for = 'FUND'
3061: and allocation_for_id = p_quota_id ) ;
3062:
3063: delete from ozf_product_allocations

Line 3063: delete from ozf_product_allocations

3059: from ozf_product_allocations
3060: where allocation_for = 'FUND'
3061: and allocation_for_id = p_quota_id ) ;
3062:
3063: delete from ozf_product_allocations
3064: where allocation_for = 'FUND'
3065: and allocation_for_id = p_quota_id;
3066:
3067: END;

Line 3352: FROM ozf_product_allocations

3348: l_spread_exists NUMBER := NULL;
3349:
3350: CURSOR c_product_spread_exists (p_quota_id IN NUMBER) IS
3351: SELECT 1
3352: FROM ozf_product_allocations
3353: WHERE fund_id = p_quota_id;
3354:
3355: BEGIN
3356: