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 865: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

861: l_diff_target NUMBER;
862: l_diff_target_1 NUMBER;
863: l_diff_target_2 NUMBER;
864:
865: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
866: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
867:
868: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
869: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 866: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

862: l_diff_target_1 NUMBER;
863: l_diff_target_2 NUMBER;
864:
865: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
866: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
867:
868: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
869: p_time_alloc_rec ozf_time_allocations%ROWTYPE;
870:

Line 1144: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

1140: THEN
1141: RAISE OZF_TP_BLANK_PERIOD_TBL;
1142: END IF;
1143:
1144: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
1145: (l_start_date,
1146: l_end_date,
1147: l_period_type_id);
1148:

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

1158: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
1159: LOOP
1160: IF l_period_tbl.exists(l_idx) THEN
1161:
1162: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
1163:
1164: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
1165: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
1166: OZF_UTILITY_PVT.debug_message(SubStr('l_lysp_period_tbl('||TO_CHAR(l_idx)||') = '

Line 1576: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

1572: l_diff_target NUMBER;
1573: l_diff_target_1 NUMBER;
1574: l_diff_target_2 NUMBER;
1575:
1576: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
1577: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
1578:
1579: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
1580: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 1577: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

1573: l_diff_target_1 NUMBER;
1574: l_diff_target_2 NUMBER;
1575:
1576: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
1577: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
1578:
1579: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
1580: p_time_alloc_rec ozf_time_allocations%ROWTYPE;
1581:

Line 1858: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

1854: THEN
1855: RAISE OZF_TP_BLANK_PERIOD_TBL;
1856: END IF;
1857:
1858: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
1859: (l_start_date,
1860: l_end_date,
1861: l_period_type_id);
1862:

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

1872: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
1873: LOOP
1874: IF l_period_tbl.exists(l_idx) THEN
1875:
1876: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
1877:
1878: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
1879: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
1880: OZF_UTILITY_PVT.debug_message(SubStr('l_lysp_period_tbl('||TO_CHAR(l_idx)||') = '

Line 2429: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

2425: l_diff_target NUMBER;
2426: l_diff_target_1 NUMBER;
2427: l_diff_target_2 NUMBER;
2428:
2429: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
2430: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
2431:
2432: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
2433: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 2430: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

2426: l_diff_target_1 NUMBER;
2427: l_diff_target_2 NUMBER;
2428:
2429: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
2430: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
2431:
2432: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
2433: p_time_alloc_rec ozf_time_allocations%ROWTYPE;
2434:

Line 2669: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

2665: THEN
2666: RAISE OZF_TP_BLANK_PERIOD_TBL;
2667: END IF;
2668:
2669: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
2670: (l_start_date,
2671: l_end_date,
2672: l_period_type_id);
2673:

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

2682: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
2683: LOOP
2684: IF l_period_tbl.exists(l_idx) THEN
2685:
2686: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
2687:
2688: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
2689: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
2690: OZF_UTILITY_PVT.debug_message(SubStr('l_lysp_period_tbl('||TO_CHAR(l_idx)||') = '

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

4294: FOR time_alloc_rec IN time_alloc_csr(l_prod_alloc_rec.product_allocation_id)
4295: LOOP
4296: p_time_alloc_rec := NULL;
4297:
4298: l_lysp_time_id := OZF_TIME_API_PVT.get_lysp_id(time_alloc_rec.time_id, time_alloc_rec.period_type_id);
4299:
4300: l_lysp_sales := 0;
4301: IF l_item_type = 'PRICING_ATTRIBUTE1' THEN
4302: OPEN product_lysp_sales_csr(l_item_id,

Line 4985: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

4981: l_diff_target NUMBER;
4982: l_diff_target_1 NUMBER;
4983: l_diff_target_2 NUMBER;
4984:
4985: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
4986: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
4987:
4988: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
4989: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;

Line 4986: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

4982: l_diff_target_1 NUMBER;
4983: l_diff_target_2 NUMBER;
4984:
4985: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
4986: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
4987:
4988: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
4989: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
4990: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 5344: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

5340: THEN
5341: RAISE OZF_TP_BLANK_PERIOD_TBL;
5342: END IF;
5343:
5344: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
5345: (l_start_date,
5346: l_end_date,
5347: l_period_type_id);
5348:

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

5357: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
5358: LOOP
5359: IF l_period_tbl.exists(l_idx) THEN
5360:
5361: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
5362:
5363: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
5364: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
5365: END IF;

Line 6096: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

6092:
6093: l_temp_account_allocation_id NUMBER;
6094: l_temp_product_allocation_id NUMBER;
6095:
6096: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
6097: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
6098:
6099: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
6100: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;

Line 6097: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

6093: l_temp_account_allocation_id NUMBER;
6094: l_temp_product_allocation_id NUMBER;
6095:
6096: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
6097: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
6098:
6099: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
6100: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
6101: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 6456: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

6452: THEN
6453: RAISE OZF_TP_BLANK_PERIOD_TBL;
6454: END IF;
6455:
6456: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
6457: (l_start_date,
6458: l_end_date,
6459: l_period_type_id);
6460:

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

6469: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
6470: LOOP
6471: IF l_period_tbl.exists(l_idx) THEN
6472:
6473: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
6474:
6475: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
6476: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
6477: END IF;

Line 7771: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

7767: l_total_target_unalloc NUMBER;
7768: l_time_target_unalloc NUMBER;
7769: l_fund_product_rec_exists BOOLEAN;
7770:
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;

Line 7772: l_new_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

7768: l_time_target_unalloc NUMBER;
7769: l_fund_product_rec_exists BOOLEAN;
7770:
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;

Line 7773: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

7769: l_fund_product_rec_exists BOOLEAN;
7770:
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:

Line 8120: l_new_period_tbl := OZF_TIME_API_PVT.get_period_tbl

8116: OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name ||
8117: ': Begin - Getting ADDON Time_ids Between '
8118: ||l_start_date||' AND '||l_end_date||' ; ');
8119:
8120: l_new_period_tbl := OZF_TIME_API_PVT.get_period_tbl
8121: (l_start_date,
8122: l_end_date,
8123: l_period_type_id);
8124: FOR i IN l_new_period_tbl.FIRST..l_new_period_tbl.LAST

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

8173: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
8174: LOOP
8175: IF l_period_tbl.exists(l_idx) THEN
8176:
8177: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
8178:
8179: OZF_UTILITY_PVT.debug_message(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
8180: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
8181: END IF;

Line 9378: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

9374: l_account_allocation_id NUMBER;
9375: l_product_allocation_id NUMBER;
9376: l_time_allocation_id NUMBER;
9377:
9378: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
9379: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
9380:
9381: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
9382: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;

Line 9379: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;

9375: l_product_allocation_id NUMBER;
9376: l_time_allocation_id NUMBER;
9377:
9378: l_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
9379: l_lysp_period_tbl OZF_TIME_API_PVT.G_period_tbl_type;
9380:
9381: p_acct_alloc_rec ozf_account_allocations%ROWTYPE;
9382: p_prod_alloc_rec ozf_product_allocations%ROWTYPE;
9383: p_time_alloc_rec ozf_time_allocations%ROWTYPE;

Line 9594: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl

9590: THEN
9591: RAISE OZF_TP_BLANK_PERIOD_TBL;
9592: END IF;
9593:
9594: l_period_tbl := OZF_TIME_API_PVT.get_period_tbl
9595: (l_start_date,
9596: l_end_date,
9597: l_period_type_id);
9598:

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

9607: FOR l_idx IN l_period_tbl.first..l_period_tbl.last
9608: LOOP
9609: IF l_period_tbl.exists(l_idx) THEN
9610:
9611: l_lysp_period_tbl(l_idx) := OZF_TIME_API_PVT.get_lysp_id (l_period_tbl(l_idx), l_period_type_id);
9612:
9613: Ozf_Utility_pvt.write_conc_log(SubStr('l_period_tbl('||TO_CHAR(l_idx)||') = '
9614: ||TO_CHAR(l_period_tbl(l_idx)), 1,255));
9615: END IF;

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

9892: tt.lysp_sales = (
9893: SELECT SUM(bsmv.sales)
9894: FROM ozf_order_sales_v bsmv
9895: WHERE bsmv.ship_to_site_use_id = p_ship_to_site_use_id
9896: AND bsmv.time_id = OZF_TIME_API_PVT.get_lysp_id(tt.time_id, tt.period_type_id)
9897: )
9898: WHERE tt.allocation_for = 'CUST'
9899: AND tt.allocation_for_id = l_account_allocation_id;
9900: