APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_PERIOD_TBL_TYPE

Line 7775: l_new_ozf_period_tbl OZF_PERIOD_TBL_TYPE;

7771: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
7772: l_new_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
7773: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
7774:
7775: l_new_ozf_period_tbl OZF_PERIOD_TBL_TYPE;
7776: l_old_ozf_period_tbl OZF_PERIOD_TBL_TYPE;
7777:
7778: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
7779: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;

Line 7776: l_old_ozf_period_tbl OZF_PERIOD_TBL_TYPE;

7772: l_new_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
7773: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
7774:
7775: l_new_ozf_period_tbl OZF_PERIOD_TBL_TYPE;
7776: l_old_ozf_period_tbl OZF_PERIOD_TBL_TYPE;
7777:
7778: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
7779: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
7780: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

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

8137:
8138: BEGIN
8139: SELECT * BULK COLLECT INTO l_period_tbl
8140: FROM
8141: ( SELECT * FROM TABLE(CAST(l_new_ozf_period_tbl as OZF_PERIOD_TBL_TYPE))
8142: MINUS
8143: SELECT * FROM TABLE(CAST(l_old_ozf_period_tbl as OZF_PERIOD_TBL_TYPE))
8144: );
8145: EXCEPTION

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

8139: SELECT * BULK COLLECT INTO l_period_tbl
8140: FROM
8141: ( SELECT * FROM TABLE(CAST(l_new_ozf_period_tbl as OZF_PERIOD_TBL_TYPE))
8142: MINUS
8143: SELECT * FROM TABLE(CAST(l_old_ozf_period_tbl as OZF_PERIOD_TBL_TYPE))
8144: );
8145: EXCEPTION
8146: WHEN OTHERS THEN
8147: ROLLBACK TO allocate_target_addon;