eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_TIME_API_PVT

Line 846: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

842: l_diff_target NUMBER;
843: l_diff_target_1 NUMBER;
844: l_diff_target_2 NUMBER;
845:
846: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
847: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
848:
849: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
850: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 847: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

843: l_diff_target_1 NUMBER;
844: l_diff_target_2 NUMBER;
845:
846: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
847: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
848:
849: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
850: p_time_alloc_rec ozf_time_allocations%ROWTYPE;
851:

Line 1123: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

1119: THEN
1120: RAISE OZF_TP_BLANK_PERIOD_TBL;
1121: END IF;
1122:
1123: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
1124: (l_start_date,
1125: l_end_date,
1126: l_period_type_id);
1127:

Line 1141: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);

1137: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
1138: LOOP
1139: IF l_period_tbl.exists(l_idx) THEN
1140:
1141: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
1142:
1143: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
1144: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
1145: OZF_UTILITY_PVT.debug_message(SubStr('l_lysp_period_tbl('||TO_CHAR(l_idx)||') = '

Line 1555: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

1551: l_diff_target NUMBER;
1552: l_diff_target_1 NUMBER;
1553: l_diff_target_2 NUMBER;
1554:
1555: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
1556: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
1557:
1558: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
1559: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 1556: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

1552: l_diff_target_1 NUMBER;
1553: l_diff_target_2 NUMBER;
1554:
1555: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
1556: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
1557:
1558: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
1559: p_time_alloc_rec ozf_time_allocations%ROWTYPE;
1560:

Line 1835: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

1831: THEN
1832: RAISE OZF_TP_BLANK_PERIOD_TBL;
1833: END IF;
1834:
1835: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
1836: (l_start_date,
1837: l_end_date,
1838: l_period_type_id);
1839:

Line 1853: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);

1849: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
1850: LOOP
1851: IF l_period_tbl.exists(l_idx) THEN
1852:
1853: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
1854:
1855: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
1856: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
1857: OZF_UTILITY_PVT.debug_message(SubStr('l_lysp_period_tbl('||TO_CHAR(l_idx)||') = '

Line 2406: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

2402: l_diff_target NUMBER;
2403: l_diff_target_1 NUMBER;
2404: l_diff_target_2 NUMBER;
2405:
2406: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
2407: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
2408:
2409: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
2410: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 2407: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

2403: l_diff_target_1 NUMBER;
2404: l_diff_target_2 NUMBER;
2405:
2406: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
2407: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
2408:
2409: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
2410: p_time_alloc_rec ozf_time_allocations%ROWTYPE;
2411:

Line 2644: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

2640: THEN
2641: RAISE OZF_TP_BLANK_PERIOD_TBL;
2642: END IF;
2643:
2644: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
2645: (l_start_date,
2646: l_end_date,
2647: l_period_type_id);
2648:

Line 2661: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);

2657: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
2658: LOOP
2659: IF l_period_tbl.exists(l_idx) THEN
2660:
2661: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
2662:
2663: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
2664: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
2665: OZF_UTILITY_PVT.debug_message(SubStr('l_lysp_period_tbl('||TO_CHAR(l_idx)||') = '

Line 4271: l_lysp_time_id := OZF_TIME_API_PVT.get_lysp_id(time_alloc_rec.time_id, time_alloc_rec.period_type_id);

4267: FOR time_alloc_rec IN time_alloc_csr(l_prod_alloc_rec.product_allocation_id)
4268: LOOP
4269: p_time_alloc_rec := NULL;
4270:
4271: l_lysp_time_id := OZF_TIME_API_PVT.get_lysp_id(time_alloc_rec.time_id, time_alloc_rec.period_type_id);
4272:
4273: l_lysp_sales := 0;
4274: IF l_item_type = 'PRICING_ATTRIBUTE1' THEN
4275: OPEN product_lysp_sales_csr(l_item_id,

Line 4958: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

4954: l_diff_target NUMBER;
4955: l_diff_target_1 NUMBER;
4956: l_diff_target_2 NUMBER;
4957:
4958: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
4959: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
4960:
4961: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
4962: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;

Line 4959: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

4955: l_diff_target_1 NUMBER;
4956: l_diff_target_2 NUMBER;
4957:
4958: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
4959: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
4960:
4961: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
4962: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
4963: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 5315: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

5311: THEN
5312: RAISE OZF_TP_BLANK_PERIOD_TBL;
5313: END IF;
5314:
5315: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
5316: (l_start_date,
5317: l_end_date,
5318: l_period_type_id);
5319:

Line 5332: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);

5328: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
5329: LOOP
5330: IF l_period_tbl.exists(l_idx) THEN
5331:
5332: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
5333:
5334: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
5335: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
5336: END IF;

Line 6067: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

6063:
6064: l_temp_account_allocation_id NUMBER;
6065: l_temp_product_allocation_id NUMBER;
6066:
6067: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
6068: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
6069:
6070: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
6071: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;

Line 6068: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

6064: l_temp_account_allocation_id NUMBER;
6065: l_temp_product_allocation_id NUMBER;
6066:
6067: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
6068: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
6069:
6070: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
6071: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
6072: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 6425: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

6421: THEN
6422: RAISE OZF_TP_BLANK_PERIOD_TBL;
6423: END IF;
6424:
6425: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
6426: (l_start_date,
6427: l_end_date,
6428: l_period_type_id);
6429:

Line 6442: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);

6438: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
6439: LOOP
6440: IF l_period_tbl.exists(l_idx) THEN
6441:
6442: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
6443:
6444: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
6445: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
6446: END IF;

Line 7740: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

7736: l_total_target_unalloc NUMBER;
7737: l_time_target_unalloc NUMBER;
7738: l_fund_product_rec_exists BOOLEAN;
7739:
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;

Line 7741: l_new_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

7737: l_time_target_unalloc NUMBER;
7738: l_fund_product_rec_exists BOOLEAN;
7739:
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;

Line 7742: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

7738: l_fund_product_rec_exists BOOLEAN;
7739:
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:

Line 8087: l_new_period_tbl := OZF_TIME_API_PVT.get_period_tbl

8083: OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name ||
8084: ': Begin - Getting ADDON Time_ids Between '
8085: ||l_start_date||' AND '||l_end_date||' ; ');
8086:
8087: l_new_period_tbl := OZF_TIME_API_PVT.get_period_tbl
8088: (l_start_date,
8089: l_end_date,
8090: l_period_type_id);
8091: FOR i IN l_new_period_tbl.FIRST..l_new_period_tbl.LAST

Line 8144: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);

8140: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
8141: LOOP
8142: IF l_period_tbl.exists(l_idx) THEN
8143:
8144: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
8145:
8146: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
8147: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
8148: END IF;

Line 9345: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

9341: l_account_allocation_id NUMBER;
9342: l_product_allocation_id NUMBER;
9343: l_time_allocation_id NUMBER;
9344:
9345: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
9346: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
9347:
9348: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
9349: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;

Line 9346: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

9342: l_product_allocation_id NUMBER;
9343: l_time_allocation_id NUMBER;
9344:
9345: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
9346: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
9347:
9348: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
9349: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
9350: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 9559: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

9555: THEN
9556: RAISE OZF_TP_BLANK_PERIOD_TBL;
9557: END IF;
9558:
9559: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
9560: (l_start_date,
9561: l_end_date,
9562: l_period_type_id);
9563:

Line 9576: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);

9572: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
9573: LOOP
9574: IF l_period_tbl.exists(l_idx) THEN
9575:
9576: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
9577:
9578: Ozf_Utility_pvt.write_conc_log(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
9579: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
9580: END IF;

Line 9861: AND bsmv.time_id = OZF_TIME_API_PVT.get_lysp_id(tt.time_id, tt.period_type_id)

9857: tt.lysp_sales = (
9858: SELECT SUM(bsmv.sales)
9859: FROM ozf_order_sales_v bsmv
9860: WHERE bsmv.ship_to_site_use_id = p_ship_to_site_use_id
9861: AND bsmv.time_id = OZF_TIME_API_PVT.get_lysp_id(tt.time_id, tt.period_type_id)
9862: )
9863: WHERE tt.allocation_for = 'CUST'
9864: AND tt.allocation_for_id = l_account_allocation_id;
9865: