APPS.OZF_QUOTA_PUB dependencies on OZF_ACCOUNT_ALLOCATIONS

Line 1407: SELECT ozf_account_allocations_s.NEXTVAL

1403: l_api_name CONSTANT VARCHAR2(30) := 'get_account_allocation_id';
1404: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1405:
1406: CURSOR account_seq_csr IS
1407: SELECT ozf_account_allocations_s.NEXTVAL
1408: FROM DUAL;
1409:
1410: CURSOR account_alloc_count_csr(p_account_alloc_id in number) IS
1411: SELECT count(account_allocation_id)

Line 1412: FROM ozf_account_allocations

1408: FROM DUAL;
1409:
1410: CURSOR account_alloc_count_csr(p_account_alloc_id in number) IS
1411: SELECT count(account_allocation_id)
1412: FROM ozf_account_allocations
1413: WHERE account_allocation_id = p_account_alloc_id;
1414:
1415: l_count number := -1;
1416: l_account_alloc_id number := -1;

Line 1540: ,p_account_alloc_rec IN ozf_account_allocations%ROWTYPE

1536: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1537: ,x_return_status OUT NOCOPY VARCHAR2
1538: ,x_msg_count OUT NOCOPY NUMBER
1539: ,x_msg_data OUT NOCOPY VARCHAR2
1540: ,p_account_alloc_rec IN ozf_account_allocations%ROWTYPE
1541: ,x_account_allocation_id OUT NOCOPY NUMBER )
1542: IS
1543: l_api_name VARCHAR(30) := 'Create_Account_Alloc_Record';
1544:

Line 1560: Ozf_Account_Allocations_Pkg.Insert_Row(

1556:
1557: -- Call the Insert here
1558: l_account_allocation_id := get_account_allocation_id;
1559:
1560: Ozf_Account_Allocations_Pkg.Insert_Row(
1561: px_Account_allocation_id => l_account_allocation_id,
1562: p_allocation_for => p_account_alloc_rec.allocation_for,
1563: p_allocation_for_id => p_account_alloc_rec.allocation_for_id,
1564: p_cust_account_id => p_account_alloc_rec.cust_account_id,

Line 1928: l_account_alloc_rec ozf_account_allocations%ROWTYPE;

1924: l_acct_prod_spread_tbl acct_prod_spread_tbl_type := p_acct_prod_spread_tbl;
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 ;

Line 2866: FROM ozf_account_allocations

2862:
2863: CURSOR c_chk_acct_alloc_id (p_account_allocation_id NUMBER) IS
2864: SELECT account_allocation_id,
2865: object_version_number
2866: FROM ozf_account_allocations
2867: WHERE account_allocation_id = p_account_allocation_id;
2868:
2869: CURSOR c_chk_time_alloc_id (p_time_allocation_id NUMBER) IS
2870: SELECT time_allocation_id,

Line 2914: UPDATE ozf_account_allocations

2910: --
2911: END IF;
2912:
2913:
2914: UPDATE ozf_account_allocations
2915: SET target = NVL(p_quota_accounts_tbl(l_acct_alloc_counter).target, target),
2916: lysp_sales = NVL(p_quota_accounts_tbl(l_acct_alloc_counter).lysp_sales, lysp_sales),
2917: object_version_number = l_object_version_number + 1 ,
2918: last_update_date = SYSDATE,

Line 3032: from ozf_account_allocations

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'
3034: and allocation_for_id = p_quota_id)
3035: );
3036:

Line 3040: from ozf_account_allocations

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'
3042: and allocation_for_id = p_quota_id);
3043:
3044:

Line 3048: from ozf_account_allocations

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'
3050: and allocation_for_id = p_quota_id ) ;
3051:
3052: delete from ozf_account_allocations

Line 3052: delete from ozf_account_allocations

3048: from ozf_account_allocations
3049: where allocation_for = 'FUND'
3050: and allocation_for_id = p_quota_id ) ;
3051:
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