APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_PERIOD_TBL_TYPE

Line 7744: l_new_ozf_period_tbl OZF_PERIOD_TBL_TYPE;

7740: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
7741: l_new_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
7742: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
7743:
7744: l_new_ozf_period_tbl OZF_PERIOD_TBL_TYPE;
7745: l_old_ozf_period_tbl OZF_PERIOD_TBL_TYPE;
7746:
7747: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
7748: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;

Line 7745: l_old_ozf_period_tbl OZF_PERIOD_TBL_TYPE;

7741: l_new_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
7742: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
7743:
7744: l_new_ozf_period_tbl OZF_PERIOD_TBL_TYPE;
7745: l_old_ozf_period_tbl OZF_PERIOD_TBL_TYPE;
7746:
7747: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
7748: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
7749: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 8108: ( SELECT * FROM TABLE(CAST(l_new_ozf_period_tbl as OZF_PERIOD_TBL_TYPE))

8104:
8105: BEGIN
8106: SELECT * BULK COLLECT INTO l_period_tbl
8107: FROM
8108: ( SELECT * FROM TABLE(CAST(l_new_ozf_period_tbl as OZF_PERIOD_TBL_TYPE))
8109: MINUS
8110: SELECT * FROM TABLE(CAST(l_old_ozf_period_tbl as OZF_PERIOD_TBL_TYPE))
8111: );
8112: EXCEPTION

Line 8110: SELECT * FROM TABLE(CAST(l_old_ozf_period_tbl as OZF_PERIOD_TBL_TYPE))

8106: SELECT * BULK COLLECT INTO l_period_tbl
8107: FROM
8108: ( SELECT * FROM TABLE(CAST(l_new_ozf_period_tbl as OZF_PERIOD_TBL_TYPE))
8109: MINUS
8110: SELECT * FROM TABLE(CAST(l_old_ozf_period_tbl as OZF_PERIOD_TBL_TYPE))
8111: );
8112: EXCEPTION
8113: WHEN OTHERS THEN
8114: ROLLBACK TO allocate_target_addon;