APPS.OZF_QUOTA_PUB dependencies on OZF_TIME_ALLOCATIONS

Line 1361: SELECT ozf_time_allocations_s.NEXTVAL

1357: l_api_name CONSTANT VARCHAR2(30) := 'get_time_allocation_id';
1358: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1359:
1360: CURSOR time_seq_csr IS
1361: SELECT ozf_time_allocations_s.NEXTVAL
1362: FROM DUAL;
1363:
1364: CURSOR time_alloc_count_csr(p_time_alloc_id in number) IS
1365: SELECT count(t.time_allocation_id)

Line 1366: FROM ozf_time_allocations t

1362: FROM DUAL;
1363:
1364: CURSOR time_alloc_count_csr(p_time_alloc_id in number) IS
1365: SELECT count(t.time_allocation_id)
1366: FROM ozf_time_allocations t
1367: WHERE t.time_allocation_id = p_time_alloc_id;
1368:
1369: l_count number := -1;
1370: l_time_alloc_id number := -1;

Line 1630: ,p_time_alloc_rec IN ozf_time_allocations%ROWTYPE

1626: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1627: ,x_return_status OUT NOCOPY VARCHAR2
1628: ,x_msg_count OUT NOCOPY NUMBER
1629: ,x_msg_data OUT NOCOPY VARCHAR2
1630: ,p_time_alloc_rec IN ozf_time_allocations%ROWTYPE
1631: ,x_time_allocation_id OUT NOCOPY NUMBER )
1632: IS
1633:
1634: l_api_name VARCHAR(30) := 'Create_Time_Alloc_Record';

Line 1650: Ozf_Time_Allocations_Pkg.Insert_Row(

1646:
1647: l_time_allocation_id := get_time_allocation_id;
1648: -- Call the Insert here
1649:
1650: Ozf_Time_Allocations_Pkg.Insert_Row(
1651: px_time_allocation_id => l_time_allocation_id,
1652: p_allocation_for => p_time_alloc_rec.allocation_for,
1653: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
1654: p_time_id => p_time_alloc_rec.time_id,

Line 1724: l_time_alloc_rec ozf_time_allocations%ROWTYPE;

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;
1728: l_object_version_number NUMBER := 1;

Line 1929: l_time_alloc_rec ozf_time_allocations%ROWTYPE;

1925:
1926: l_account_allocation_id NUMBER;
1927: l_time_allocation_id NUMBER;
1928: l_account_alloc_rec ozf_account_allocations%ROWTYPE;
1929: l_time_alloc_rec ozf_time_allocations%ROWTYPE;
1930:
1931: l_prod_acct_index NUMBER;
1932: l_prod_sprd_index NUMBER ;
1933: l_prod_for_this_acct_tbl quota_products_tbl_type;

Line 2711: FROM ozf_time_allocations

2707:
2708: CURSOR c_chk_time_alloc_id (p_time_allocation_id NUMBER) IS
2709: SELECT time_allocation_id,
2710: object_version_number
2711: FROM ozf_time_allocations
2712: WHERE time_allocation_id = p_time_allocation_id;
2713:
2714: BEGIN
2715: --

Line 2791: UPDATE ozf_time_allocations

2787: --
2788: END IF;
2789:
2790:
2791: UPDATE ozf_time_allocations
2792: SET target = NVL(p_quota_prod_spread_tbl(l_prod_sprd_counter).target, target),
2793: lysp_sales = NVL(p_quota_prod_spread_tbl(l_prod_sprd_counter).lysp_sales, lysp_sales),
2794: object_version_number = l_object_version_number + 1 ,
2795: last_update_date = SYSDATE,

Line 2872: FROM ozf_time_allocations

2868:
2869: CURSOR c_chk_time_alloc_id (p_time_allocation_id NUMBER) IS
2870: SELECT time_allocation_id,
2871: object_version_number
2872: FROM ozf_time_allocations
2873: WHERE time_allocation_id = p_time_allocation_id;
2874:
2875: BEGIN
2876: --

Line 2952: UPDATE ozf_time_allocations

2948: --
2949: END IF;
2950:
2951:
2952: UPDATE ozf_time_allocations
2953: SET target = NVL(p_account_spread_tbl(l_acct_sprd_counter).target, target),
2954: lysp_sales = NVL(p_account_spread_tbl(l_acct_sprd_counter).lysp_sales, lysp_sales),
2955: object_version_number = l_object_version_number + 1 ,
2956: last_update_date = SYSDATE,

Line 3026: delete from ozf_time_allocations

3022:
3023: END LOOP;
3024:
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'

Line 3045: delete from ozf_time_allocations

3041: where allocation_for = 'FUND'
3042: and allocation_for_id = p_quota_id);
3043:
3044:
3045: delete from ozf_time_allocations
3046: where allocation_for = 'CUST'
3047: and allocation_for_id in (select account_allocation_id
3048: from ozf_account_allocations
3049: where allocation_for = 'FUND'

Line 3056: delete from ozf_time_allocations

3052: delete from ozf_account_allocations
3053: where allocation_for = 'FUND'
3054: and allocation_for_id = p_quota_id ;
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'