DBA Data[Home] [Help]

APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_TIME_ALLOCATIONS_PKG

Line 1323: Ozf_Time_Allocations_Pkg.Insert_Row(

1319: p_time_alloc_rec.target := NVL(l_time_quota, 0);
1320: p_time_alloc_rec.lysp_sales := NVL(l_lysp_sales, 0);
1321:
1322:
1323: Ozf_Time_Allocations_Pkg.Insert_Row(
1324: px_time_allocation_id => l_time_allocation_id,
1325: p_allocation_for => p_time_alloc_rec.allocation_for,
1326: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
1327: p_time_id => p_time_alloc_rec.time_id,

Line 2044: Ozf_Time_Allocations_Pkg.Insert_Row(

2040: p_time_alloc_rec.target := 0; --------NVL(l_time_quota, 0);
2041: p_time_alloc_rec.lysp_sales := NVL(l_lysp_sales, 0);
2042:
2043:
2044: Ozf_Time_Allocations_Pkg.Insert_Row(
2045: px_time_allocation_id => l_time_allocation_id,
2046: p_allocation_for => p_time_alloc_rec.allocation_for,
2047: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
2048: p_time_id => p_time_alloc_rec.time_id,

Line 2780: Ozf_Time_Allocations_Pkg.Insert_Row(

2776: p_time_alloc_rec.target := 0;
2777: p_time_alloc_rec.lysp_sales := l_lysp_sales;
2778:
2779:
2780: Ozf_Time_Allocations_Pkg.Insert_Row(
2781: px_time_allocation_id => l_time_allocation_id,
2782: p_allocation_for => p_time_alloc_rec.allocation_for,
2783: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
2784: p_time_id => p_time_alloc_rec.time_id,

Line 2917: Ozf_Time_Allocations_Pkg.Insert_Row(

2913: p_time_alloc_rec.target := 0;
2914: p_time_alloc_rec.lysp_sales := l_lysp_sales;
2915:
2916:
2917: Ozf_Time_Allocations_Pkg.Insert_Row(
2918: px_time_allocation_id => l_time_allocation_id,
2919: p_allocation_for => p_time_alloc_rec.allocation_for,
2920: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
2921: p_time_id => p_time_alloc_rec.time_id,

Line 3048: Ozf_Time_Allocations_Pkg.Insert_Row(

3044: p_time_alloc_rec.target := 0;
3045: p_time_alloc_rec.lysp_sales := l_lysp_sales;
3046:
3047:
3048: Ozf_Time_Allocations_Pkg.Insert_Row(
3049: px_time_allocation_id => l_time_allocation_id,
3050: p_allocation_for => p_time_alloc_rec.allocation_for,
3051: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
3052: p_time_id => p_time_alloc_rec.time_id,

Line 4302: Ozf_Time_Allocations_Pkg.Insert_Row(

4298: p_time_alloc_rec.target := 0;
4299: p_time_alloc_rec.lysp_sales := l_lysp_sales;
4300:
4301:
4302: Ozf_Time_Allocations_Pkg.Insert_Row(
4303: px_time_allocation_id => l_time_allocation_id,
4304: p_allocation_for => p_time_alloc_rec.allocation_for,
4305: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
4306: p_time_id => p_time_alloc_rec.time_id,

Line 5518: Ozf_Time_Allocations_Pkg.Insert_Row(

5514: p_time_alloc_rec.lysp_sales := l_account_sales;
5515:
5516: l_time_allocation_id := get_time_allocation_id;
5517:
5518: Ozf_Time_Allocations_Pkg.Insert_Row(
5519: px_time_allocation_id => l_time_allocation_id,
5520: p_allocation_for => p_time_alloc_rec.allocation_for,
5521: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
5522: p_time_id => p_time_alloc_rec.time_id,

Line 5684: Ozf_Time_Allocations_Pkg.Insert_Row(

5680: p_time_alloc_rec.lysp_sales := l_product_sales;
5681:
5682: l_time_allocation_id := get_time_allocation_id;
5683:
5684: Ozf_Time_Allocations_Pkg.Insert_Row(
5685: px_time_allocation_id => l_time_allocation_id,
5686: p_allocation_for => p_time_alloc_rec.allocation_for,
5687: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
5688: p_time_id => p_time_alloc_rec.time_id,

Line 5836: Ozf_Time_Allocations_Pkg.Insert_Row(

5832: p_time_alloc_rec.lysp_sales := 0;
5833:
5834: l_time_allocation_id := get_time_allocation_id;
5835:
5836: Ozf_Time_Allocations_Pkg.Insert_Row(
5837: px_time_allocation_id => l_time_allocation_id,
5838: p_allocation_for => p_time_alloc_rec.allocation_for,
5839: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
5840: p_time_id => p_time_alloc_rec.time_id,

Line 6628: Ozf_Time_Allocations_Pkg.Insert_Row(

6624: p_time_alloc_rec.lysp_sales := l_account_sales;
6625:
6626: l_time_allocation_id := get_time_allocation_id;
6627:
6628: Ozf_Time_Allocations_Pkg.Insert_Row(
6629: px_time_allocation_id => l_time_allocation_id,
6630: p_allocation_for => p_time_alloc_rec.allocation_for,
6631: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
6632: p_time_id => p_time_alloc_rec.time_id,

Line 6839: Ozf_Time_Allocations_Pkg.Insert_Row(

6835: p_time_alloc_rec.lysp_sales := l_product_sales;
6836:
6837: l_time_allocation_id := get_time_allocation_id;
6838:
6839: Ozf_Time_Allocations_Pkg.Insert_Row(
6840: px_time_allocation_id => l_time_allocation_id,
6841: p_allocation_for => p_time_alloc_rec.allocation_for,
6842: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
6843: p_time_id => p_time_alloc_rec.time_id,

Line 7261: Ozf_Time_Allocations_Pkg.Insert_Row(

7257: p_time_alloc_rec.lysp_sales := 0;
7258:
7259: l_time_allocation_id := get_time_allocation_id;
7260:
7261: Ozf_Time_Allocations_Pkg.Insert_Row(
7262: px_time_allocation_id => l_time_allocation_id,
7263: p_allocation_for => p_time_alloc_rec.allocation_for,
7264: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
7265: p_time_id => p_time_alloc_rec.time_id,

Line 8264: Ozf_Time_Allocations_Pkg.Insert_Row(

8260: p_time_alloc_rec.lysp_sales := NVL(l_account_sales, 0);
8261:
8262: l_time_allocation_id := get_time_allocation_id;
8263:
8264: Ozf_Time_Allocations_Pkg.Insert_Row(
8265: px_time_allocation_id => l_time_allocation_id,
8266: p_allocation_for => p_time_alloc_rec.allocation_for,
8267: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
8268: p_time_id => p_time_alloc_rec.time_id,

Line 8392: Ozf_Time_Allocations_Pkg.Insert_Row(

8388: p_time_alloc_rec.lysp_sales := NVL(l_product_sales, 0);
8389:
8390: l_time_allocation_id := get_time_allocation_id;
8391:
8392: Ozf_Time_Allocations_Pkg.Insert_Row(
8393: px_time_allocation_id => l_time_allocation_id,
8394: p_allocation_for => p_time_alloc_rec.allocation_for,
8395: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
8396: p_time_id => p_time_alloc_rec.time_id,

Line 8484: Ozf_Time_Allocations_Pkg.Insert_Row(

8480: p_time_alloc_rec.lysp_sales := 0;
8481:
8482: l_time_allocation_id := get_time_allocation_id;
8483:
8484: Ozf_Time_Allocations_Pkg.Insert_Row(
8485: px_time_allocation_id => l_time_allocation_id,
8486: p_allocation_for => p_time_alloc_rec.allocation_for,
8487: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
8488: p_time_id => p_time_alloc_rec.time_id,

Line 9729: Ozf_Time_Allocations_Pkg.Insert_Row(

9725:
9726: FOR p_time_alloc_rec IN corr_time_alloc_rec (p_acct_alloc_rec.account_allocation_id)
9727: LOOP
9728: l_time_allocation_id := get_time_allocation_id;
9729: Ozf_Time_Allocations_Pkg.Insert_Row(
9730: px_time_allocation_id => l_time_allocation_id,
9731: p_allocation_for => p_time_alloc_rec.allocation_for,
9732: p_allocation_for_id => l_account_allocation_id,
9733: p_time_id => p_time_alloc_rec.time_id,

Line 9950: Ozf_Time_Allocations_Pkg.Insert_Row(

9946: -- 9. CREATING SHIPTOs Product Spread - TIME Records ....
9947: FOR p_time_alloc_rec IN corr_prod_time_alloc_rec (p_prod_alloc_rec.product_allocation_id)
9948: LOOP
9949: l_time_allocation_id := get_time_allocation_id;
9950: Ozf_Time_Allocations_Pkg.Insert_Row(
9951: px_time_allocation_id => l_time_allocation_id,
9952: p_allocation_for => p_time_alloc_rec.allocation_for,
9953: p_allocation_for_id => l_product_allocation_id,
9954: p_time_id => p_time_alloc_rec.time_id,

Line 10135: Ozf_Time_Allocations_Pkg.Insert_Row(

10131: p_time_alloc_rec.lysp_sales := l_product_sales;
10132:
10133: l_time_allocation_id := get_time_allocation_id;
10134:
10135: Ozf_Time_Allocations_Pkg.Insert_Row(
10136: px_time_allocation_id => l_time_allocation_id,
10137: p_allocation_for => p_time_alloc_rec.allocation_for,
10138: p_allocation_for_id => p_time_alloc_rec.allocation_for_id,
10139: p_time_id => p_time_alloc_rec.time_id,