DBA Data[Home] [Help]

APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_TIME_ALLOCATIONS_PKG

Line 1344: Ozf_Time_Allocations_Pkg.Insert_Row(

1340: p_time_alloc_rec.target := NVL(l_time_quota, 0);
1341: p_time_alloc_rec.lysp_sales := NVL(l_lysp_sales, 0);
1342:
1343:
1344: Ozf_Time_Allocations_Pkg.Insert_Row(
1345: px_time_allocation_id => l_time_allocation_id,
1346: p_allocation_for => p_time_alloc_rec.allocation_for,
1347: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
1348: p_time_id => p_time_alloc_rec.time_id,

Line 2067: Ozf_Time_Allocations_Pkg.Insert_Row(

2063: p_time_alloc_rec.target := 0; --------NVL(l_time_quota, 0);
2064: p_time_alloc_rec.lysp_sales := NVL(l_lysp_sales, 0);
2065:
2066:
2067: Ozf_Time_Allocations_Pkg.Insert_Row(
2068: px_time_allocation_id => l_time_allocation_id,
2069: p_allocation_for => p_time_alloc_rec.allocation_for,
2070: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
2071: p_time_id => p_time_alloc_rec.time_id,

Line 2805: Ozf_Time_Allocations_Pkg.Insert_Row(

2801: p_time_alloc_rec.target := 0;
2802: p_time_alloc_rec.lysp_sales := l_lysp_sales;
2803:
2804:
2805: Ozf_Time_Allocations_Pkg.Insert_Row(
2806: px_time_allocation_id => l_time_allocation_id,
2807: p_allocation_for => p_time_alloc_rec.allocation_for,
2808: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
2809: p_time_id => p_time_alloc_rec.time_id,

Line 2942: Ozf_Time_Allocations_Pkg.Insert_Row(

2938: p_time_alloc_rec.target := 0;
2939: p_time_alloc_rec.lysp_sales := l_lysp_sales;
2940:
2941:
2942: Ozf_Time_Allocations_Pkg.Insert_Row(
2943: px_time_allocation_id => l_time_allocation_id,
2944: p_allocation_for => p_time_alloc_rec.allocation_for,
2945: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
2946: p_time_id => p_time_alloc_rec.time_id,

Line 3073: Ozf_Time_Allocations_Pkg.Insert_Row(

3069: p_time_alloc_rec.target := 0;
3070: p_time_alloc_rec.lysp_sales := l_lysp_sales;
3071:
3072:
3073: Ozf_Time_Allocations_Pkg.Insert_Row(
3074: px_time_allocation_id => l_time_allocation_id,
3075: p_allocation_for => p_time_alloc_rec.allocation_for,
3076: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
3077: p_time_id => p_time_alloc_rec.time_id,

Line 4329: Ozf_Time_Allocations_Pkg.Insert_Row(

4325: p_time_alloc_rec.target := 0;
4326: p_time_alloc_rec.lysp_sales := l_lysp_sales;
4327:
4328:
4329: Ozf_Time_Allocations_Pkg.Insert_Row(
4330: px_time_allocation_id => l_time_allocation_id,
4331: p_allocation_for => p_time_alloc_rec.allocation_for,
4332: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
4333: p_time_id => p_time_alloc_rec.time_id,

Line 5547: Ozf_Time_Allocations_Pkg.Insert_Row(

5543: p_time_alloc_rec.lysp_sales := l_account_sales;
5544:
5545: l_time_allocation_id := get_time_allocation_id;
5546:
5547: Ozf_Time_Allocations_Pkg.Insert_Row(
5548: px_time_allocation_id => l_time_allocation_id,
5549: p_allocation_for => p_time_alloc_rec.allocation_for,
5550: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
5551: p_time_id => p_time_alloc_rec.time_id,

Line 5713: Ozf_Time_Allocations_Pkg.Insert_Row(

5709: p_time_alloc_rec.lysp_sales := l_product_sales;
5710:
5711: l_time_allocation_id := get_time_allocation_id;
5712:
5713: Ozf_Time_Allocations_Pkg.Insert_Row(
5714: px_time_allocation_id => l_time_allocation_id,
5715: p_allocation_for => p_time_alloc_rec.allocation_for,
5716: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
5717: p_time_id => p_time_alloc_rec.time_id,

Line 5865: Ozf_Time_Allocations_Pkg.Insert_Row(

5861: p_time_alloc_rec.lysp_sales := 0;
5862:
5863: l_time_allocation_id := get_time_allocation_id;
5864:
5865: Ozf_Time_Allocations_Pkg.Insert_Row(
5866: px_time_allocation_id => l_time_allocation_id,
5867: p_allocation_for => p_time_alloc_rec.allocation_for,
5868: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
5869: p_time_id => p_time_alloc_rec.time_id,

Line 6659: Ozf_Time_Allocations_Pkg.Insert_Row(

6655: p_time_alloc_rec.lysp_sales := l_account_sales;
6656:
6657: l_time_allocation_id := get_time_allocation_id;
6658:
6659: Ozf_Time_Allocations_Pkg.Insert_Row(
6660: px_time_allocation_id => l_time_allocation_id,
6661: p_allocation_for => p_time_alloc_rec.allocation_for,
6662: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
6663: p_time_id => p_time_alloc_rec.time_id,

Line 6870: Ozf_Time_Allocations_Pkg.Insert_Row(

6866: p_time_alloc_rec.lysp_sales := l_product_sales;
6867:
6868: l_time_allocation_id := get_time_allocation_id;
6869:
6870: Ozf_Time_Allocations_Pkg.Insert_Row(
6871: px_time_allocation_id => l_time_allocation_id,
6872: p_allocation_for => p_time_alloc_rec.allocation_for,
6873: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
6874: p_time_id => p_time_alloc_rec.time_id,

Line 7292: Ozf_Time_Allocations_Pkg.Insert_Row(

7288: p_time_alloc_rec.lysp_sales := 0;
7289:
7290: l_time_allocation_id := get_time_allocation_id;
7291:
7292: Ozf_Time_Allocations_Pkg.Insert_Row(
7293: px_time_allocation_id => l_time_allocation_id,
7294: p_allocation_for => p_time_alloc_rec.allocation_for,
7295: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
7296: p_time_id => p_time_alloc_rec.time_id,

Line 8297: Ozf_Time_Allocations_Pkg.Insert_Row(

8293: p_time_alloc_rec.lysp_sales := NVL(l_account_sales, 0);
8294:
8295: l_time_allocation_id := get_time_allocation_id;
8296:
8297: Ozf_Time_Allocations_Pkg.Insert_Row(
8298: px_time_allocation_id => l_time_allocation_id,
8299: p_allocation_for => p_time_alloc_rec.allocation_for,
8300: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
8301: p_time_id => p_time_alloc_rec.time_id,

Line 8425: Ozf_Time_Allocations_Pkg.Insert_Row(

8421: p_time_alloc_rec.lysp_sales := NVL(l_product_sales, 0);
8422:
8423: l_time_allocation_id := get_time_allocation_id;
8424:
8425: Ozf_Time_Allocations_Pkg.Insert_Row(
8426: px_time_allocation_id => l_time_allocation_id,
8427: p_allocation_for => p_time_alloc_rec.allocation_for,
8428: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
8429: p_time_id => p_time_alloc_rec.time_id,

Line 8517: Ozf_Time_Allocations_Pkg.Insert_Row(

8513: p_time_alloc_rec.lysp_sales := 0;
8514:
8515: l_time_allocation_id := get_time_allocation_id;
8516:
8517: Ozf_Time_Allocations_Pkg.Insert_Row(
8518: px_time_allocation_id => l_time_allocation_id,
8519: p_allocation_for => p_time_alloc_rec.allocation_for,
8520: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
8521: p_time_id => p_time_alloc_rec.time_id,

Line 9764: Ozf_Time_Allocations_Pkg.Insert_Row(

9760:
9761: FOR p_time_alloc_rec IN corr_time_alloc_rec (p_acct_alloc_rec.account_allocation_id)
9762: LOOP
9763: l_time_allocation_id := get_time_allocation_id;
9764: Ozf_Time_Allocations_Pkg.Insert_Row(
9765: px_time_allocation_id => l_time_allocation_id,
9766: p_allocation_for => p_time_alloc_rec.allocation_for,
9767: p_allocation_for_id => l_account_allocation_id,
9768: p_time_id => p_time_alloc_rec.time_id,

Line 9985: Ozf_Time_Allocations_Pkg.Insert_Row(

9981: -- 9. CREATING SHIPTOs Product Spread - TIME Records ....
9982: FOR p_time_alloc_rec IN corr_prod_time_alloc_rec (p_prod_alloc_rec.product_allocation_id)
9983: LOOP
9984: l_time_allocation_id := get_time_allocation_id;
9985: Ozf_Time_Allocations_Pkg.Insert_Row(
9986: px_time_allocation_id => l_time_allocation_id,
9987: p_allocation_for => p_time_alloc_rec.allocation_for,
9988: p_allocation_for_id => l_product_allocation_id,
9989: p_time_id => p_time_alloc_rec.time_id,

Line 10170: Ozf_Time_Allocations_Pkg.Insert_Row(

10166: p_time_alloc_rec.lysp_sales := l_product_sales;
10167:
10168: l_time_allocation_id := get_time_allocation_id;
10169:
10170: Ozf_Time_Allocations_Pkg.Insert_Row(
10171: px_time_allocation_id => l_time_allocation_id,
10172: p_allocation_for => p_time_alloc_rec.allocation_for,
10173: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
10174: p_time_id => p_time_alloc_rec.time_id,