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 FND_GLOBAL

Line 672: t.last_updated_by = FND_GLOBAL.USER_ID,

668: UPDATE OZF_TIME_ALLOCATIONS t
669: SET t.TARGET = t.TARGET + l_diff_target,
670: t.object_version_number = t.object_version_number + 1,
671: t.last_update_date = SYSDATE,
672: t.last_updated_by = FND_GLOBAL.USER_ID,
673: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
674: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
675: FROM OZF_TIME_ALLOCATIONS x
676: WHERE x.allocation_for = 'PROD'

Line 673: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

669: SET t.TARGET = t.TARGET + l_diff_target,
670: t.object_version_number = t.object_version_number + 1,
671: t.last_update_date = SYSDATE,
672: t.last_updated_by = FND_GLOBAL.USER_ID,
673: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
674: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
675: FROM OZF_TIME_ALLOCATIONS x
676: WHERE x.allocation_for = 'PROD'
677: AND x.allocation_for_id IN ( SELECT max(p.product_allocation_id)

Line 724: p.last_updated_by = FND_GLOBAL.USER_ID,

720: UPDATE OZF_PRODUCT_ALLOCATIONS p
721: SET p.TARGET = p.TARGET + l_diff_target,
722: p.object_version_number = p.object_version_number + 1,
723: p.last_update_date = SYSDATE,
724: p.last_updated_by = FND_GLOBAL.USER_ID,
725: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
726: WHERE p.product_allocation_id = l_temp_product_allocation_id;
727:
728: IF (SQL%NOTFOUND) THEN

Line 725: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

721: SET p.TARGET = p.TARGET + l_diff_target,
722: p.object_version_number = p.object_version_number + 1,
723: p.last_update_date = SYSDATE,
724: p.last_updated_by = FND_GLOBAL.USER_ID,
725: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
726: WHERE p.product_allocation_id = l_temp_product_allocation_id;
727:
728: IF (SQL%NOTFOUND) THEN
729: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 743: t.last_updated_by = FND_GLOBAL.USER_ID,

739: UPDATE OZF_TIME_ALLOCATIONS t
740: SET t.TARGET = t.TARGET + l_diff_target,
741: t.object_version_number = t.object_version_number + 1,
742: t.last_update_date = SYSDATE,
743: t.last_updated_by = FND_GLOBAL.USER_ID,
744: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
745: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
746: WHERE x.allocation_for = 'PROD'
747: AND x.allocation_for_id IN ( SELECT p.product_allocation_id

Line 744: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

740: SET t.TARGET = t.TARGET + l_diff_target,
741: t.object_version_number = t.object_version_number + 1,
742: t.last_update_date = SYSDATE,
743: t.last_updated_by = FND_GLOBAL.USER_ID,
744: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
745: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
746: WHERE x.allocation_for = 'PROD'
747: AND x.allocation_for_id IN ( SELECT p.product_allocation_id
748: FROM OZF_PRODUCT_ALLOCATIONS p

Line 767: p.last_updated_by = FND_GLOBAL.USER_ID,

763: UPDATE OZF_PRODUCT_ALLOCATIONS p
764: SET p.TARGET = p.TARGET + l_diff_target,
765: p.object_version_number = p.object_version_number + 1,
766: p.last_update_date = SYSDATE,
767: p.last_updated_by = FND_GLOBAL.USER_ID,
768: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
769: WHERE p.allocation_for = 'CUST'
770: AND p.allocation_for_id = l_account_allocation_id
771: AND p.item_id = -9999;

Line 768: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

764: SET p.TARGET = p.TARGET + l_diff_target,
765: p.object_version_number = p.object_version_number + 1,
766: p.last_update_date = SYSDATE,
767: p.last_updated_by = FND_GLOBAL.USER_ID,
768: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
769: WHERE p.allocation_for = 'CUST'
770: AND p.allocation_for_id = l_account_allocation_id
771: AND p.item_id = -9999;
772:

Line 1240: p_created_by => FND_GLOBAL.USER_ID,

1236: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
1237: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
1238: px_object_version_number => l_object_version_number,
1239: p_creation_date => SYSDATE,
1240: p_created_by => FND_GLOBAL.USER_ID,
1241: p_last_update_date => SYSDATE,
1242: p_last_updated_by => FND_GLOBAL.USER_ID,
1243: p_last_update_login => FND_GLOBAL.conc_login_id,
1244: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 1242: p_last_updated_by => FND_GLOBAL.USER_ID,

1238: px_object_version_number => l_object_version_number,
1239: p_creation_date => SYSDATE,
1240: p_created_by => FND_GLOBAL.USER_ID,
1241: p_last_update_date => SYSDATE,
1242: p_last_updated_by => FND_GLOBAL.USER_ID,
1243: p_last_update_login => FND_GLOBAL.conc_login_id,
1244: p_attribute_category => p_prod_alloc_rec.attribute_category,
1245: p_attribute1 => p_prod_alloc_rec.attribute1,
1246: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 1243: p_last_update_login => FND_GLOBAL.conc_login_id,

1239: p_creation_date => SYSDATE,
1240: p_created_by => FND_GLOBAL.USER_ID,
1241: p_last_update_date => SYSDATE,
1242: p_last_updated_by => FND_GLOBAL.USER_ID,
1243: p_last_update_login => FND_GLOBAL.conc_login_id,
1244: p_attribute_category => p_prod_alloc_rec.attribute_category,
1245: p_attribute1 => p_prod_alloc_rec.attribute1,
1246: p_attribute2 => p_prod_alloc_rec.attribute2,
1247: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 1333: p_created_by => FND_GLOBAL.USER_ID,

1329: p_target => NVL(p_time_alloc_rec.target, 0),
1330: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
1331: px_object_version_number => l_object_version_number,
1332: p_creation_date => SYSDATE,
1333: p_created_by => FND_GLOBAL.USER_ID,
1334: p_last_update_date => SYSDATE,
1335: p_last_updated_by => FND_GLOBAL.USER_ID,
1336: p_last_update_login => FND_GLOBAL.conc_login_id,
1337: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 1335: p_last_updated_by => FND_GLOBAL.USER_ID,

1331: px_object_version_number => l_object_version_number,
1332: p_creation_date => SYSDATE,
1333: p_created_by => FND_GLOBAL.USER_ID,
1334: p_last_update_date => SYSDATE,
1335: p_last_updated_by => FND_GLOBAL.USER_ID,
1336: p_last_update_login => FND_GLOBAL.conc_login_id,
1337: p_attribute_category => p_time_alloc_rec.attribute_category,
1338: p_attribute1 => p_time_alloc_rec.attribute1,
1339: p_attribute2 => p_time_alloc_rec.attribute2,

Line 1336: p_last_update_login => FND_GLOBAL.conc_login_id,

1332: p_creation_date => SYSDATE,
1333: p_created_by => FND_GLOBAL.USER_ID,
1334: p_last_update_date => SYSDATE,
1335: p_last_updated_by => FND_GLOBAL.USER_ID,
1336: p_last_update_login => FND_GLOBAL.conc_login_id,
1337: p_attribute_category => p_time_alloc_rec.attribute_category,
1338: p_attribute1 => p_time_alloc_rec.attribute1,
1339: p_attribute2 => p_time_alloc_rec.attribute2,
1340: p_attribute3 => p_time_alloc_rec.attribute3,

Line 1365: p.last_updated_by = FND_GLOBAL.USER_ID,

1361: SET p.lysp_sales = l_total_lysp_sales,
1362: p.target = ROUND( l_total_quota, 0),
1363: p.object_version_number = p.object_version_number + 1,
1364: p.last_update_date = SYSDATE,
1365: p.last_updated_by = FND_GLOBAL.USER_ID,
1366: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1367: WHERE p.product_allocation_id = l_product_allocation_id;
1368:
1369: END LOOP;

Line 1366: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

1362: p.target = ROUND( l_total_quota, 0),
1363: p.object_version_number = p.object_version_number + 1,
1364: p.last_update_date = SYSDATE,
1365: p.last_updated_by = FND_GLOBAL.USER_ID,
1366: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1367: WHERE p.product_allocation_id = l_product_allocation_id;
1368:
1369: END LOOP;
1370:

Line 1398: t.last_updated_by = FND_GLOBAL.USER_ID,

1394: UPDATE OZF_TIME_ALLOCATIONS t
1395: SET t.TARGET = t.TARGET + l_diff_target,
1396: t.object_version_number = t.object_version_number + 1,
1397: t.last_update_date = SYSDATE,
1398: t.last_updated_by = FND_GLOBAL.USER_ID,
1399: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1400: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
1401: WHERE x.allocation_for = 'PROD'
1402: AND x.allocation_for_id IN ( SELECT p.product_allocation_id

Line 1399: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

1395: SET t.TARGET = t.TARGET + l_diff_target,
1396: t.object_version_number = t.object_version_number + 1,
1397: t.last_update_date = SYSDATE,
1398: t.last_updated_by = FND_GLOBAL.USER_ID,
1399: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1400: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
1401: WHERE x.allocation_for = 'PROD'
1402: AND x.allocation_for_id IN ( SELECT p.product_allocation_id
1403: FROM OZF_PRODUCT_ALLOCATIONS p

Line 1424: p.last_updated_by = FND_GLOBAL.USER_ID,

1420: UPDATE OZF_PRODUCT_ALLOCATIONS p
1421: SET p.TARGET = p.TARGET + l_diff_target,
1422: p.object_version_number = p.object_version_number + 1,
1423: p.last_update_date = SYSDATE,
1424: p.last_updated_by = FND_GLOBAL.USER_ID,
1425: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1426: WHERE p.allocation_for = 'FACT'
1427: AND p.allocation_for_id = l_fact_id
1428: AND p.item_id = -9999;

Line 1425: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

1421: SET p.TARGET = p.TARGET + l_diff_target,
1422: p.object_version_number = p.object_version_number + 1,
1423: p.last_update_date = SYSDATE,
1424: p.last_updated_by = FND_GLOBAL.USER_ID,
1425: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1426: WHERE p.allocation_for = 'FACT'
1427: AND p.allocation_for_id = l_fact_id
1428: AND p.item_id = -9999;
1429:

Line 1957: p_created_by => FND_GLOBAL.USER_ID,

1953: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
1954: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
1955: px_object_version_number => l_object_version_number,
1956: p_creation_date => SYSDATE,
1957: p_created_by => FND_GLOBAL.USER_ID,
1958: p_last_update_date => SYSDATE,
1959: p_last_updated_by => FND_GLOBAL.USER_ID,
1960: p_last_update_login => FND_GLOBAL.conc_login_id,
1961: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 1959: p_last_updated_by => FND_GLOBAL.USER_ID,

1955: px_object_version_number => l_object_version_number,
1956: p_creation_date => SYSDATE,
1957: p_created_by => FND_GLOBAL.USER_ID,
1958: p_last_update_date => SYSDATE,
1959: p_last_updated_by => FND_GLOBAL.USER_ID,
1960: p_last_update_login => FND_GLOBAL.conc_login_id,
1961: p_attribute_category => p_prod_alloc_rec.attribute_category,
1962: p_attribute1 => p_prod_alloc_rec.attribute1,
1963: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 1960: p_last_update_login => FND_GLOBAL.conc_login_id,

1956: p_creation_date => SYSDATE,
1957: p_created_by => FND_GLOBAL.USER_ID,
1958: p_last_update_date => SYSDATE,
1959: p_last_updated_by => FND_GLOBAL.USER_ID,
1960: p_last_update_login => FND_GLOBAL.conc_login_id,
1961: p_attribute_category => p_prod_alloc_rec.attribute_category,
1962: p_attribute1 => p_prod_alloc_rec.attribute1,
1963: p_attribute2 => p_prod_alloc_rec.attribute2,
1964: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 2054: p_created_by => FND_GLOBAL.USER_ID,

2050: p_target => NVL(p_time_alloc_rec.target, 0),
2051: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
2052: px_object_version_number => l_object_version_number,
2053: p_creation_date => SYSDATE,
2054: p_created_by => FND_GLOBAL.USER_ID,
2055: p_last_update_date => SYSDATE,
2056: p_last_updated_by => FND_GLOBAL.USER_ID,
2057: p_last_update_login => FND_GLOBAL.conc_login_id,
2058: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 2056: p_last_updated_by => FND_GLOBAL.USER_ID,

2052: px_object_version_number => l_object_version_number,
2053: p_creation_date => SYSDATE,
2054: p_created_by => FND_GLOBAL.USER_ID,
2055: p_last_update_date => SYSDATE,
2056: p_last_updated_by => FND_GLOBAL.USER_ID,
2057: p_last_update_login => FND_GLOBAL.conc_login_id,
2058: p_attribute_category => p_time_alloc_rec.attribute_category,
2059: p_attribute1 => p_time_alloc_rec.attribute1,
2060: p_attribute2 => p_time_alloc_rec.attribute2,

Line 2057: p_last_update_login => FND_GLOBAL.conc_login_id,

2053: p_creation_date => SYSDATE,
2054: p_created_by => FND_GLOBAL.USER_ID,
2055: p_last_update_date => SYSDATE,
2056: p_last_updated_by => FND_GLOBAL.USER_ID,
2057: p_last_update_login => FND_GLOBAL.conc_login_id,
2058: p_attribute_category => p_time_alloc_rec.attribute_category,
2059: p_attribute1 => p_time_alloc_rec.attribute1,
2060: p_attribute2 => p_time_alloc_rec.attribute2,
2061: p_attribute3 => p_time_alloc_rec.attribute3,

Line 2085: p.last_updated_by = FND_GLOBAL.USER_ID,

2081: UPDATE OZF_PRODUCT_ALLOCATIONS p
2082: SET p.lysp_sales = l_total_lysp_sales,
2083: p.object_version_number = p.object_version_number + 1,
2084: p.last_update_date = SYSDATE,
2085: p.last_updated_by = FND_GLOBAL.USER_ID,
2086: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2087: WHERE p.product_allocation_id = l_product_allocation_id;
2088:
2089: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;

Line 2086: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2082: SET p.lysp_sales = l_total_lysp_sales,
2083: p.object_version_number = p.object_version_number + 1,
2084: p.last_update_date = SYSDATE,
2085: p.last_updated_by = FND_GLOBAL.USER_ID,
2086: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2087: WHERE p.product_allocation_id = l_product_allocation_id;
2088:
2089: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;
2090:

Line 2109: t.last_updated_by = FND_GLOBAL.USER_ID,

2105: UPDATE OZF_TIME_ALLOCATIONS t
2106: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_multiplying_factor), 0),
2107: t.object_version_number = t.object_version_number + 1,
2108: t.last_update_date = SYSDATE,
2109: t.last_updated_by = FND_GLOBAL.USER_ID,
2110: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2111: WHERE t.allocation_for = 'PROD'
2112: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
2113: FROM OZF_PRODUCT_ALLOCATIONS p

Line 2110: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2106: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_multiplying_factor), 0),
2107: t.object_version_number = t.object_version_number + 1,
2108: t.last_update_date = SYSDATE,
2109: t.last_updated_by = FND_GLOBAL.USER_ID,
2110: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2111: WHERE t.allocation_for = 'PROD'
2112: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
2113: FROM OZF_PRODUCT_ALLOCATIONS p
2114: WHERE p.allocation_for = 'FACT'

Line 2133: p.last_updated_by = FND_GLOBAL.USER_ID,

2129: WHERE ti.ALLOCATION_FOR = 'PROD'
2130: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
2131: p.object_version_number = p.object_version_number + 1,
2132: p.last_update_date = SYSDATE,
2133: p.last_updated_by = FND_GLOBAL.USER_ID,
2134: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2135: WHERE p.allocation_for = 'FACT'
2136: AND p.allocation_for_id = l_fact_id;
2137:

Line 2134: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2130: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
2131: p.object_version_number = p.object_version_number + 1,
2132: p.last_update_date = SYSDATE,
2133: p.last_updated_by = FND_GLOBAL.USER_ID,
2134: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2135: WHERE p.allocation_for = 'FACT'
2136: AND p.allocation_for_id = l_fact_id;
2137:
2138: IF (SQL%NOTFOUND) THEN

Line 2162: p.last_updated_by = FND_GLOBAL.USER_ID,

2158: UPDATE OZF_PRODUCT_ALLOCATIONS p
2159: SET p.TARGET = ROUND(NVL(l_fact_rec.recommend_total_amount, 0),0),
2160: p.object_version_number = p.object_version_number + 1,
2161: p.last_update_date = SYSDATE,
2162: p.last_updated_by = FND_GLOBAL.USER_ID,
2163: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2164: WHERE p.allocation_for = 'FACT'
2165: AND p.allocation_for_id = l_fact_id
2166: AND p.item_id = -9999;

Line 2163: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2159: SET p.TARGET = ROUND(NVL(l_fact_rec.recommend_total_amount, 0),0),
2160: p.object_version_number = p.object_version_number + 1,
2161: p.last_update_date = SYSDATE,
2162: p.last_updated_by = FND_GLOBAL.USER_ID,
2163: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2164: WHERE p.allocation_for = 'FACT'
2165: AND p.allocation_for_id = l_fact_id
2166: AND p.item_id = -9999;
2167:

Line 2181: t.last_updated_by = FND_GLOBAL.USER_ID,

2177: UPDATE OZF_TIME_ALLOCATIONS t
2178: SET t.TARGET = ROUND((NVL(l_fact_rec.recommend_total_amount, 0) / l_denominator), 0),
2179: t.object_version_number = t.object_version_number + 1,
2180: t.last_update_date = SYSDATE,
2181: t.last_updated_by = FND_GLOBAL.USER_ID,
2182: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2183: WHERE t.allocation_for = 'PROD'
2184: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
2185: FROM OZF_PRODUCT_ALLOCATIONS p

Line 2182: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2178: SET t.TARGET = ROUND((NVL(l_fact_rec.recommend_total_amount, 0) / l_denominator), 0),
2179: t.object_version_number = t.object_version_number + 1,
2180: t.last_update_date = SYSDATE,
2181: t.last_updated_by = FND_GLOBAL.USER_ID,
2182: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2183: WHERE t.allocation_for = 'PROD'
2184: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
2185: FROM OZF_PRODUCT_ALLOCATIONS p
2186: WHERE p.allocation_for = 'FACT'

Line 2205: p.last_updated_by = FND_GLOBAL.USER_ID,

2201: WHERE ti.ALLOCATION_FOR = 'PROD'
2202: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
2203: p.object_version_number = p.object_version_number + 1,
2204: p.last_update_date = SYSDATE,
2205: p.last_updated_by = FND_GLOBAL.USER_ID,
2206: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2207: WHERE p.allocation_for = 'FACT'
2208: AND p.allocation_for_id = l_fact_id
2209: AND p.item_id = -9999;

Line 2206: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2202: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
2203: p.object_version_number = p.object_version_number + 1,
2204: p.last_update_date = SYSDATE,
2205: p.last_updated_by = FND_GLOBAL.USER_ID,
2206: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2207: WHERE p.allocation_for = 'FACT'
2208: AND p.allocation_for_id = l_fact_id
2209: AND p.item_id = -9999;
2210:

Line 2259: t.last_updated_by = FND_GLOBAL.USER_ID,

2255: UPDATE OZF_TIME_ALLOCATIONS t
2256: SET t.TARGET = t.TARGET + l_diff_target,
2257: t.object_version_number = t.object_version_number + 1,
2258: t.last_update_date = SYSDATE,
2259: t.last_updated_by = FND_GLOBAL.USER_ID,
2260: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2261: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
2262: WHERE x.allocation_for = 'PROD'
2263: AND x.allocation_for_id IN ( SELECT p.product_allocation_id

Line 2260: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2256: SET t.TARGET = t.TARGET + l_diff_target,
2257: t.object_version_number = t.object_version_number + 1,
2258: t.last_update_date = SYSDATE,
2259: t.last_updated_by = FND_GLOBAL.USER_ID,
2260: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2261: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
2262: WHERE x.allocation_for = 'PROD'
2263: AND x.allocation_for_id IN ( SELECT p.product_allocation_id
2264: FROM OZF_PRODUCT_ALLOCATIONS p

Line 2283: p.last_updated_by = FND_GLOBAL.USER_ID,

2279: UPDATE OZF_PRODUCT_ALLOCATIONS p
2280: SET p.TARGET = p.TARGET + l_diff_target,
2281: p.object_version_number = p.object_version_number + 1,
2282: p.last_update_date = SYSDATE,
2283: p.last_updated_by = FND_GLOBAL.USER_ID,
2284: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2285: WHERE p.allocation_for = 'FACT'
2286: AND p.allocation_for_id = l_fact_id
2287: AND p.item_id = -9999;

Line 2284: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2280: SET p.TARGET = p.TARGET + l_diff_target,
2281: p.object_version_number = p.object_version_number + 1,
2282: p.last_update_date = SYSDATE,
2283: p.last_updated_by = FND_GLOBAL.USER_ID,
2284: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2285: WHERE p.allocation_for = 'FACT'
2286: AND p.allocation_for_id = l_fact_id
2287: AND p.item_id = -9999;
2288:

Line 2726: p_created_by => FND_GLOBAL.USER_ID,

2722: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
2723: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
2724: px_object_version_number => l_object_version_number,
2725: p_creation_date => SYSDATE,
2726: p_created_by => FND_GLOBAL.USER_ID,
2727: p_last_update_date => SYSDATE,
2728: p_last_updated_by => FND_GLOBAL.USER_ID,
2729: p_last_update_login => FND_GLOBAL.conc_login_id,
2730: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 2728: p_last_updated_by => FND_GLOBAL.USER_ID,

2724: px_object_version_number => l_object_version_number,
2725: p_creation_date => SYSDATE,
2726: p_created_by => FND_GLOBAL.USER_ID,
2727: p_last_update_date => SYSDATE,
2728: p_last_updated_by => FND_GLOBAL.USER_ID,
2729: p_last_update_login => FND_GLOBAL.conc_login_id,
2730: p_attribute_category => p_prod_alloc_rec.attribute_category,
2731: p_attribute1 => p_prod_alloc_rec.attribute1,
2732: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 2729: p_last_update_login => FND_GLOBAL.conc_login_id,

2725: p_creation_date => SYSDATE,
2726: p_created_by => FND_GLOBAL.USER_ID,
2727: p_last_update_date => SYSDATE,
2728: p_last_updated_by => FND_GLOBAL.USER_ID,
2729: p_last_update_login => FND_GLOBAL.conc_login_id,
2730: p_attribute_category => p_prod_alloc_rec.attribute_category,
2731: p_attribute1 => p_prod_alloc_rec.attribute1,
2732: p_attribute2 => p_prod_alloc_rec.attribute2,
2733: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 2790: p_created_by => FND_GLOBAL.USER_ID,

2786: p_target =>NVL( p_time_alloc_rec.target, 0),
2787: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
2788: px_object_version_number => l_object_version_number,
2789: p_creation_date => SYSDATE,
2790: p_created_by => FND_GLOBAL.USER_ID,
2791: p_last_update_date => SYSDATE,
2792: p_last_updated_by => FND_GLOBAL.USER_ID,
2793: p_last_update_login => FND_GLOBAL.conc_login_id,
2794: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 2792: p_last_updated_by => FND_GLOBAL.USER_ID,

2788: px_object_version_number => l_object_version_number,
2789: p_creation_date => SYSDATE,
2790: p_created_by => FND_GLOBAL.USER_ID,
2791: p_last_update_date => SYSDATE,
2792: p_last_updated_by => FND_GLOBAL.USER_ID,
2793: p_last_update_login => FND_GLOBAL.conc_login_id,
2794: p_attribute_category => p_time_alloc_rec.attribute_category,
2795: p_attribute1 => p_time_alloc_rec.attribute1,
2796: p_attribute2 => p_time_alloc_rec.attribute2,

Line 2793: p_last_update_login => FND_GLOBAL.conc_login_id,

2789: p_creation_date => SYSDATE,
2790: p_created_by => FND_GLOBAL.USER_ID,
2791: p_last_update_date => SYSDATE,
2792: p_last_updated_by => FND_GLOBAL.USER_ID,
2793: p_last_update_login => FND_GLOBAL.conc_login_id,
2794: p_attribute_category => p_time_alloc_rec.attribute_category,
2795: p_attribute1 => p_time_alloc_rec.attribute1,
2796: p_attribute2 => p_time_alloc_rec.attribute2,
2797: p_attribute3 => p_time_alloc_rec.attribute3,

Line 2821: p.last_updated_by = FND_GLOBAL.USER_ID,

2817: UPDATE OZF_PRODUCT_ALLOCATIONS p
2818: SET p.lysp_sales = NVL(l_total_lysp_sales,0),
2819: p.object_version_number = p.object_version_number + 1,
2820: p.last_update_date = SYSDATE,
2821: p.last_updated_by = FND_GLOBAL.USER_ID,
2822: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2823: WHERE p.product_allocation_id = l_product_allocation_id;
2824:
2825: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;

Line 2822: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2818: SET p.lysp_sales = NVL(l_total_lysp_sales,0),
2819: p.object_version_number = p.object_version_number + 1,
2820: p.last_update_date = SYSDATE,
2821: p.last_updated_by = FND_GLOBAL.USER_ID,
2822: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2823: WHERE p.product_allocation_id = l_product_allocation_id;
2824:
2825: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;
2826: END LOOP;

Line 2863: p_created_by => FND_GLOBAL.USER_ID,

2859: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
2860: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
2861: px_object_version_number => l_object_version_number,
2862: p_creation_date => SYSDATE,
2863: p_created_by => FND_GLOBAL.USER_ID,
2864: p_last_update_date => SYSDATE,
2865: p_last_updated_by => FND_GLOBAL.USER_ID,
2866: p_last_update_login => FND_GLOBAL.conc_login_id,
2867: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 2865: p_last_updated_by => FND_GLOBAL.USER_ID,

2861: px_object_version_number => l_object_version_number,
2862: p_creation_date => SYSDATE,
2863: p_created_by => FND_GLOBAL.USER_ID,
2864: p_last_update_date => SYSDATE,
2865: p_last_updated_by => FND_GLOBAL.USER_ID,
2866: p_last_update_login => FND_GLOBAL.conc_login_id,
2867: p_attribute_category => p_prod_alloc_rec.attribute_category,
2868: p_attribute1 => p_prod_alloc_rec.attribute1,
2869: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 2866: p_last_update_login => FND_GLOBAL.conc_login_id,

2862: p_creation_date => SYSDATE,
2863: p_created_by => FND_GLOBAL.USER_ID,
2864: p_last_update_date => SYSDATE,
2865: p_last_updated_by => FND_GLOBAL.USER_ID,
2866: p_last_update_login => FND_GLOBAL.conc_login_id,
2867: p_attribute_category => p_prod_alloc_rec.attribute_category,
2868: p_attribute1 => p_prod_alloc_rec.attribute1,
2869: p_attribute2 => p_prod_alloc_rec.attribute2,
2870: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 2927: p_created_by => FND_GLOBAL.USER_ID,

2923: p_target => NVL(p_time_alloc_rec.target, 0),
2924: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
2925: px_object_version_number => l_object_version_number,
2926: p_creation_date => SYSDATE,
2927: p_created_by => FND_GLOBAL.USER_ID,
2928: p_last_update_date => SYSDATE,
2929: p_last_updated_by => FND_GLOBAL.USER_ID,
2930: p_last_update_login => FND_GLOBAL.conc_login_id,
2931: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 2929: p_last_updated_by => FND_GLOBAL.USER_ID,

2925: px_object_version_number => l_object_version_number,
2926: p_creation_date => SYSDATE,
2927: p_created_by => FND_GLOBAL.USER_ID,
2928: p_last_update_date => SYSDATE,
2929: p_last_updated_by => FND_GLOBAL.USER_ID,
2930: p_last_update_login => FND_GLOBAL.conc_login_id,
2931: p_attribute_category => p_time_alloc_rec.attribute_category,
2932: p_attribute1 => p_time_alloc_rec.attribute1,
2933: p_attribute2 => p_time_alloc_rec.attribute2,

Line 2930: p_last_update_login => FND_GLOBAL.conc_login_id,

2926: p_creation_date => SYSDATE,
2927: p_created_by => FND_GLOBAL.USER_ID,
2928: p_last_update_date => SYSDATE,
2929: p_last_updated_by => FND_GLOBAL.USER_ID,
2930: p_last_update_login => FND_GLOBAL.conc_login_id,
2931: p_attribute_category => p_time_alloc_rec.attribute_category,
2932: p_attribute1 => p_time_alloc_rec.attribute1,
2933: p_attribute2 => p_time_alloc_rec.attribute2,
2934: p_attribute3 => p_time_alloc_rec.attribute3,

Line 2958: p.last_updated_by = FND_GLOBAL.USER_ID,

2954: UPDATE OZF_PRODUCT_ALLOCATIONS p
2955: SET p.lysp_sales = NVL(l_total_lysp_sales, 0),
2956: p.object_version_number = p.object_version_number + 1,
2957: p.last_update_date = SYSDATE,
2958: p.last_updated_by = FND_GLOBAL.USER_ID,
2959: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2960: WHERE p.product_allocation_id = l_product_allocation_id;
2961:
2962: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;

Line 2959: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2955: SET p.lysp_sales = NVL(l_total_lysp_sales, 0),
2956: p.object_version_number = p.object_version_number + 1,
2957: p.last_update_date = SYSDATE,
2958: p.last_updated_by = FND_GLOBAL.USER_ID,
2959: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2960: WHERE p.product_allocation_id = l_product_allocation_id;
2961:
2962: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;
2963: END LOOP;

Line 2996: p_created_by => FND_GLOBAL.USER_ID,

2992: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
2993: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
2994: px_object_version_number => l_object_version_number,
2995: p_creation_date => SYSDATE,
2996: p_created_by => FND_GLOBAL.USER_ID,
2997: p_last_update_date => SYSDATE,
2998: p_last_updated_by => FND_GLOBAL.USER_ID,
2999: p_last_update_login => FND_GLOBAL.conc_login_id,
3000: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 2998: p_last_updated_by => FND_GLOBAL.USER_ID,

2994: px_object_version_number => l_object_version_number,
2995: p_creation_date => SYSDATE,
2996: p_created_by => FND_GLOBAL.USER_ID,
2997: p_last_update_date => SYSDATE,
2998: p_last_updated_by => FND_GLOBAL.USER_ID,
2999: p_last_update_login => FND_GLOBAL.conc_login_id,
3000: p_attribute_category => p_prod_alloc_rec.attribute_category,
3001: p_attribute1 => p_prod_alloc_rec.attribute1,
3002: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 2999: p_last_update_login => FND_GLOBAL.conc_login_id,

2995: p_creation_date => SYSDATE,
2996: p_created_by => FND_GLOBAL.USER_ID,
2997: p_last_update_date => SYSDATE,
2998: p_last_updated_by => FND_GLOBAL.USER_ID,
2999: p_last_update_login => FND_GLOBAL.conc_login_id,
3000: p_attribute_category => p_prod_alloc_rec.attribute_category,
3001: p_attribute1 => p_prod_alloc_rec.attribute1,
3002: p_attribute2 => p_prod_alloc_rec.attribute2,
3003: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 3058: p_created_by => FND_GLOBAL.USER_ID,

3054: p_target => NVL(p_time_alloc_rec.target, 0),
3055: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
3056: px_object_version_number => l_object_version_number,
3057: p_creation_date => SYSDATE,
3058: p_created_by => FND_GLOBAL.USER_ID,
3059: p_last_update_date => SYSDATE,
3060: p_last_updated_by => FND_GLOBAL.USER_ID,
3061: p_last_update_login => FND_GLOBAL.conc_login_id,
3062: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 3060: p_last_updated_by => FND_GLOBAL.USER_ID,

3056: px_object_version_number => l_object_version_number,
3057: p_creation_date => SYSDATE,
3058: p_created_by => FND_GLOBAL.USER_ID,
3059: p_last_update_date => SYSDATE,
3060: p_last_updated_by => FND_GLOBAL.USER_ID,
3061: p_last_update_login => FND_GLOBAL.conc_login_id,
3062: p_attribute_category => p_time_alloc_rec.attribute_category,
3063: p_attribute1 => p_time_alloc_rec.attribute1,
3064: p_attribute2 => p_time_alloc_rec.attribute2,

Line 3061: p_last_update_login => FND_GLOBAL.conc_login_id,

3057: p_creation_date => SYSDATE,
3058: p_created_by => FND_GLOBAL.USER_ID,
3059: p_last_update_date => SYSDATE,
3060: p_last_updated_by => FND_GLOBAL.USER_ID,
3061: p_last_update_login => FND_GLOBAL.conc_login_id,
3062: p_attribute_category => p_time_alloc_rec.attribute_category,
3063: p_attribute1 => p_time_alloc_rec.attribute1,
3064: p_attribute2 => p_time_alloc_rec.attribute2,
3065: p_attribute3 => p_time_alloc_rec.attribute3,

Line 3089: p.last_updated_by = FND_GLOBAL.USER_ID,

3085: UPDATE OZF_PRODUCT_ALLOCATIONS p
3086: SET p.lysp_sales = NVL(l_total_lysp_sales, 0),
3087: p.object_version_number = p.object_version_number + 1,
3088: p.last_update_date = SYSDATE,
3089: p.last_updated_by = FND_GLOBAL.USER_ID,
3090: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3091: WHERE p.product_allocation_id = l_product_allocation_id;
3092:
3093: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;

Line 3090: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3086: SET p.lysp_sales = NVL(l_total_lysp_sales, 0),
3087: p.object_version_number = p.object_version_number + 1,
3088: p.last_update_date = SYSDATE,
3089: p.last_updated_by = FND_GLOBAL.USER_ID,
3090: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3091: WHERE p.product_allocation_id = l_product_allocation_id;
3092:
3093: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;
3094:

Line 3124: p.last_updated_by = FND_GLOBAL.USER_ID,

3120: UPDATE OZF_PRODUCT_ALLOCATIONS p
3121: SET p.TARGET = ROUND( (NVL(p.LYSP_SALES, 0) * l_multiplying_factor), 0),
3122: p.object_version_number = p.object_version_number + 1,
3123: p.last_update_date = SYSDATE,
3124: p.last_updated_by = FND_GLOBAL.USER_ID,
3125: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3126: WHERE p.allocation_for = 'FUND'
3127: AND p.allocation_for_id = l_fund_id;
3128:

Line 3125: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3121: SET p.TARGET = ROUND( (NVL(p.LYSP_SALES, 0) * l_multiplying_factor), 0),
3122: p.object_version_number = p.object_version_number + 1,
3123: p.last_update_date = SYSDATE,
3124: p.last_updated_by = FND_GLOBAL.USER_ID,
3125: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3126: WHERE p.allocation_for = 'FUND'
3127: AND p.allocation_for_id = l_fund_id;
3128:
3129: IF (SQL%NOTFOUND) THEN

Line 3143: t.last_updated_by = FND_GLOBAL.USER_ID,

3139: UPDATE OZF_TIME_ALLOCATIONS t
3140: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_multiplying_factor), 0),
3141: t.object_version_number = t.object_version_number + 1,
3142: t.last_update_date = SYSDATE,
3143: t.last_updated_by = FND_GLOBAL.USER_ID,
3144: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3145: WHERE t.allocation_for = 'PROD'
3146: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
3147: FROM OZF_PRODUCT_ALLOCATIONS p

Line 3144: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3140: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_multiplying_factor), 0),
3141: t.object_version_number = t.object_version_number + 1,
3142: t.last_update_date = SYSDATE,
3143: t.last_updated_by = FND_GLOBAL.USER_ID,
3144: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3145: WHERE t.allocation_for = 'PROD'
3146: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
3147: FROM OZF_PRODUCT_ALLOCATIONS p
3148: WHERE p.allocation_for = 'FUND'

Line 3168: p.last_updated_by = FND_GLOBAL.USER_ID,

3164: WHERE ti.ALLOCATION_FOR = 'PROD'
3165: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
3166: p.object_version_number = p.object_version_number + 1,
3167: p.last_update_date = SYSDATE,
3168: p.last_updated_by = FND_GLOBAL.USER_ID,
3169: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3170: WHERE p.allocation_for = 'FUND'
3171: AND p.allocation_for_id = l_fund_id;
3172:

Line 3169: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3165: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
3166: p.object_version_number = p.object_version_number + 1,
3167: p.last_update_date = SYSDATE,
3168: p.last_updated_by = FND_GLOBAL.USER_ID,
3169: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3170: WHERE p.allocation_for = 'FUND'
3171: AND p.allocation_for_id = l_fund_id;
3172:
3173: IF (SQL%NOTFOUND) THEN

Line 3198: p.last_updated_by = FND_GLOBAL.USER_ID,

3194: UPDATE OZF_PRODUCT_ALLOCATIONS p
3195: SET p.TARGET = ROUND( l_total_root_quota, 0),
3196: p.object_version_number = p.object_version_number + 1,
3197: p.last_update_date = SYSDATE,
3198: p.last_updated_by = FND_GLOBAL.USER_ID,
3199: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3200: WHERE p.allocation_for = 'FUND'
3201: AND p.allocation_for_id = l_fund_id
3202: AND p.item_id = -9999;

Line 3199: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3195: SET p.TARGET = ROUND( l_total_root_quota, 0),
3196: p.object_version_number = p.object_version_number + 1,
3197: p.last_update_date = SYSDATE,
3198: p.last_updated_by = FND_GLOBAL.USER_ID,
3199: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3200: WHERE p.allocation_for = 'FUND'
3201: AND p.allocation_for_id = l_fund_id
3202: AND p.item_id = -9999;
3203:

Line 3217: t.last_updated_by = FND_GLOBAL.USER_ID,

3213: UPDATE OZF_TIME_ALLOCATIONS t
3214: SET t.TARGET = ROUND((l_total_root_quota / l_denominator), 0),
3215: t.object_version_number = t.object_version_number + 1,
3216: t.last_update_date = SYSDATE,
3217: t.last_updated_by = FND_GLOBAL.USER_ID,
3218: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3219: WHERE t.allocation_for = 'PROD'
3220: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
3221: FROM OZF_PRODUCT_ALLOCATIONS p

Line 3218: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3214: SET t.TARGET = ROUND((l_total_root_quota / l_denominator), 0),
3215: t.object_version_number = t.object_version_number + 1,
3216: t.last_update_date = SYSDATE,
3217: t.last_updated_by = FND_GLOBAL.USER_ID,
3218: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3219: WHERE t.allocation_for = 'PROD'
3220: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
3221: FROM OZF_PRODUCT_ALLOCATIONS p
3222: WHERE p.allocation_for = 'FUND'

Line 3242: p.last_updated_by = FND_GLOBAL.USER_ID,

3238: WHERE ti.ALLOCATION_FOR = 'PROD'
3239: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
3240: p.object_version_number = p.object_version_number + 1,
3241: p.last_update_date = SYSDATE,
3242: p.last_updated_by = FND_GLOBAL.USER_ID,
3243: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3244: WHERE p.allocation_for = 'FUND'
3245: AND p.allocation_for_id = l_fund_id
3246: AND p.item_id = -9999;

Line 3243: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3239: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
3240: p.object_version_number = p.object_version_number + 1,
3241: p.last_update_date = SYSDATE,
3242: p.last_updated_by = FND_GLOBAL.USER_ID,
3243: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3244: WHERE p.allocation_for = 'FUND'
3245: AND p.allocation_for_id = l_fund_id
3246: AND p.item_id = -9999;
3247:

Line 3397: t.last_updated_by = FND_GLOBAL.USER_ID,

3393: UPDATE OZF_TIME_ALLOCATIONS t
3394: SET t.TARGET = t.TARGET + l_diff_target,
3395: t.object_version_number = t.object_version_number + 1,
3396: t.last_update_date = SYSDATE,
3397: t.last_updated_by = FND_GLOBAL.USER_ID,
3398: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3399: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
3400: WHERE x.allocation_for = 'PROD'
3401: AND x.allocation_for_id IN ( SELECT p.product_allocation_id

Line 3398: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3394: SET t.TARGET = t.TARGET + l_diff_target,
3395: t.object_version_number = t.object_version_number + 1,
3396: t.last_update_date = SYSDATE,
3397: t.last_updated_by = FND_GLOBAL.USER_ID,
3398: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3399: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
3400: WHERE x.allocation_for = 'PROD'
3401: AND x.allocation_for_id IN ( SELECT p.product_allocation_id
3402: FROM OZF_PRODUCT_ALLOCATIONS p

Line 3573: p.last_updated_by = FND_GLOBAL.USER_ID,

3569: UPDATE ozf_product_allocations p
3570: SET p.fund_id = l_fund_id,
3571: p.object_version_number = p.object_version_number + 1,
3572: p.last_update_date = SYSDATE,
3573: p.last_updated_by = FND_GLOBAL.USER_ID,
3574: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3575: WHERE p.allocation_for = 'FACT'
3576: AND p.allocation_for_id = l_fact_id;
3577:

Line 3574: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3570: SET p.fund_id = l_fund_id,
3571: p.object_version_number = p.object_version_number + 1,
3572: p.last_update_date = SYSDATE,
3573: p.last_updated_by = FND_GLOBAL.USER_ID,
3574: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3575: WHERE p.allocation_for = 'FACT'
3576: AND p.allocation_for_id = l_fact_id;
3577:
3578:

Line 4241: p_created_by => FND_GLOBAL.USER_ID,

4237: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
4238: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
4239: px_object_version_number => l_object_version_number,
4240: p_creation_date => SYSDATE,
4241: p_created_by => FND_GLOBAL.USER_ID,
4242: p_last_update_date => SYSDATE,
4243: p_last_updated_by => FND_GLOBAL.USER_ID,
4244: p_last_update_login => FND_GLOBAL.conc_login_id,
4245: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 4243: p_last_updated_by => FND_GLOBAL.USER_ID,

4239: px_object_version_number => l_object_version_number,
4240: p_creation_date => SYSDATE,
4241: p_created_by => FND_GLOBAL.USER_ID,
4242: p_last_update_date => SYSDATE,
4243: p_last_updated_by => FND_GLOBAL.USER_ID,
4244: p_last_update_login => FND_GLOBAL.conc_login_id,
4245: p_attribute_category => p_prod_alloc_rec.attribute_category,
4246: p_attribute1 => p_prod_alloc_rec.attribute1,
4247: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 4244: p_last_update_login => FND_GLOBAL.conc_login_id,

4240: p_creation_date => SYSDATE,
4241: p_created_by => FND_GLOBAL.USER_ID,
4242: p_last_update_date => SYSDATE,
4243: p_last_updated_by => FND_GLOBAL.USER_ID,
4244: p_last_update_login => FND_GLOBAL.conc_login_id,
4245: p_attribute_category => p_prod_alloc_rec.attribute_category,
4246: p_attribute1 => p_prod_alloc_rec.attribute1,
4247: p_attribute2 => p_prod_alloc_rec.attribute2,
4248: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 4312: p_created_by => FND_GLOBAL.USER_ID,

4308: p_target => NVL(p_time_alloc_rec.target, 0),
4309: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
4310: px_object_version_number => l_object_version_number,
4311: p_creation_date => SYSDATE,
4312: p_created_by => FND_GLOBAL.USER_ID,
4313: p_last_update_date => SYSDATE,
4314: p_last_updated_by => FND_GLOBAL.USER_ID,
4315: p_last_update_login => FND_GLOBAL.conc_login_id,
4316: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 4314: p_last_updated_by => FND_GLOBAL.USER_ID,

4310: px_object_version_number => l_object_version_number,
4311: p_creation_date => SYSDATE,
4312: p_created_by => FND_GLOBAL.USER_ID,
4313: p_last_update_date => SYSDATE,
4314: p_last_updated_by => FND_GLOBAL.USER_ID,
4315: p_last_update_login => FND_GLOBAL.conc_login_id,
4316: p_attribute_category => p_time_alloc_rec.attribute_category,
4317: p_attribute1 => p_time_alloc_rec.attribute1,
4318: p_attribute2 => p_time_alloc_rec.attribute2,

Line 4315: p_last_update_login => FND_GLOBAL.conc_login_id,

4311: p_creation_date => SYSDATE,
4312: p_created_by => FND_GLOBAL.USER_ID,
4313: p_last_update_date => SYSDATE,
4314: p_last_updated_by => FND_GLOBAL.USER_ID,
4315: p_last_update_login => FND_GLOBAL.conc_login_id,
4316: p_attribute_category => p_time_alloc_rec.attribute_category,
4317: p_attribute1 => p_time_alloc_rec.attribute1,
4318: p_attribute2 => p_time_alloc_rec.attribute2,
4319: p_attribute3 => p_time_alloc_rec.attribute3,

Line 4342: p.last_updated_by = FND_GLOBAL.USER_ID,

4338: UPDATE OZF_PRODUCT_ALLOCATIONS p
4339: SET p.lysp_sales = l_total_lysp_sales,
4340: p.object_version_number = p.object_version_number + 1,
4341: p.last_update_date = SYSDATE,
4342: p.last_updated_by = FND_GLOBAL.USER_ID,
4343: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4344: WHERE p.product_allocation_id = l_product_allocation_id;
4345:
4346: OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ': End - Adding Product and Time Allocations Records'

Line 4343: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

4339: SET p.lysp_sales = l_total_lysp_sales,
4340: p.object_version_number = p.object_version_number + 1,
4341: p.last_update_date = SYSDATE,
4342: p.last_updated_by = FND_GLOBAL.USER_ID,
4343: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4344: WHERE p.product_allocation_id = l_product_allocation_id;
4345:
4346: OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ': End - Adding Product and Time Allocations Records'
4347: || 'FOR Fact_ID = '|| l_fact_id || ' ; ');

Line 4674: t.last_updated_by = FND_GLOBAL.USER_ID,

4670: UPDATE ozf_time_allocations t -- Update Others Quota for Jul03, Aug03, Sep03 etc
4671: SET t.target = t.target + NVL(time_alloc_rec.target, 0),
4672: t.object_version_number = t.object_version_number + 1,
4673: t.last_update_date = SYSDATE,
4674: t.last_updated_by = FND_GLOBAL.USER_ID,
4675: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4676: WHERE
4677: t.time_id = time_alloc_rec.time_id
4678: AND t.allocation_for_id = l_others_prod_alloc_rec.product_allocation_id

Line 4675: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

4671: SET t.target = t.target + NVL(time_alloc_rec.target, 0),
4672: t.object_version_number = t.object_version_number + 1,
4673: t.last_update_date = SYSDATE,
4674: t.last_updated_by = FND_GLOBAL.USER_ID,
4675: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4676: WHERE
4677: t.time_id = time_alloc_rec.time_id
4678: AND t.allocation_for_id = l_others_prod_alloc_rec.product_allocation_id
4679: AND t.allocation_for = 'PROD';

Line 4687: p.last_updated_by = FND_GLOBAL.USER_ID,

4683: UPDATE ozf_product_allocations p -- Update Others Quota for Q3-03 etc
4684: SET p.target = p.target + NVL(l_prod_alloc_rec.target, 0),
4685: p.object_version_number = p.object_version_number + 1,
4686: p.last_update_date = SYSDATE,
4687: p.last_updated_by = FND_GLOBAL.USER_ID,
4688: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4689: WHERE p.product_allocation_id = l_others_prod_alloc_rec.product_allocation_id;
4690:
4691:

Line 4688: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

4684: SET p.target = p.target + NVL(l_prod_alloc_rec.target, 0),
4685: p.object_version_number = p.object_version_number + 1,
4686: p.last_update_date = SYSDATE,
4687: p.last_updated_by = FND_GLOBAL.USER_ID,
4688: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4689: WHERE p.product_allocation_id = l_others_prod_alloc_rec.product_allocation_id;
4690:
4691:
4692: OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ': End - Updating OTHERS Product and Time Allocations Records'

Line 5470: p_created_by => FND_GLOBAL.USER_ID,

5466: p_lysp_sales => p_acct_alloc_rec.lysp_sales,
5467: p_parent_Account_allocation_id => p_acct_alloc_rec.parent_Account_allocation_id,
5468: px_object_version_number => l_object_version_number,
5469: p_creation_date => SYSDATE,
5470: p_created_by => FND_GLOBAL.USER_ID,
5471: p_last_update_date => SYSDATE,
5472: p_last_updated_by => FND_GLOBAL.USER_ID,
5473: p_last_update_login => FND_GLOBAL.conc_login_id,
5474: p_attribute_category => p_acct_alloc_rec.attribute_category,

Line 5472: p_last_updated_by => FND_GLOBAL.USER_ID,

5468: px_object_version_number => l_object_version_number,
5469: p_creation_date => SYSDATE,
5470: p_created_by => FND_GLOBAL.USER_ID,
5471: p_last_update_date => SYSDATE,
5472: p_last_updated_by => FND_GLOBAL.USER_ID,
5473: p_last_update_login => FND_GLOBAL.conc_login_id,
5474: p_attribute_category => p_acct_alloc_rec.attribute_category,
5475: p_attribute1 => p_acct_alloc_rec.attribute1,
5476: p_attribute2 => p_acct_alloc_rec.attribute2,

Line 5473: p_last_update_login => FND_GLOBAL.conc_login_id,

5469: p_creation_date => SYSDATE,
5470: p_created_by => FND_GLOBAL.USER_ID,
5471: p_last_update_date => SYSDATE,
5472: p_last_updated_by => FND_GLOBAL.USER_ID,
5473: p_last_update_login => FND_GLOBAL.conc_login_id,
5474: p_attribute_category => p_acct_alloc_rec.attribute_category,
5475: p_attribute1 => p_acct_alloc_rec.attribute1,
5476: p_attribute2 => p_acct_alloc_rec.attribute2,
5477: p_attribute3 => p_acct_alloc_rec.attribute3,

Line 5528: p_created_by => FND_GLOBAL.USER_ID,

5524: p_target => p_time_alloc_rec.target,
5525: p_lysp_sales => p_time_alloc_rec.lysp_sales,
5526: px_object_version_number => l_object_version_number,
5527: p_creation_date => SYSDATE,
5528: p_created_by => FND_GLOBAL.USER_ID,
5529: p_last_update_date => SYSDATE,
5530: p_last_updated_by => FND_GLOBAL.USER_ID,
5531: p_last_update_login => FND_GLOBAL.conc_login_id,
5532: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 5530: p_last_updated_by => FND_GLOBAL.USER_ID,

5526: px_object_version_number => l_object_version_number,
5527: p_creation_date => SYSDATE,
5528: p_created_by => FND_GLOBAL.USER_ID,
5529: p_last_update_date => SYSDATE,
5530: p_last_updated_by => FND_GLOBAL.USER_ID,
5531: p_last_update_login => FND_GLOBAL.conc_login_id,
5532: p_attribute_category => p_time_alloc_rec.attribute_category,
5533: p_attribute1 => p_time_alloc_rec.attribute1,
5534: p_attribute2 => p_time_alloc_rec.attribute2,

Line 5531: p_last_update_login => FND_GLOBAL.conc_login_id,

5527: p_creation_date => SYSDATE,
5528: p_created_by => FND_GLOBAL.USER_ID,
5529: p_last_update_date => SYSDATE,
5530: p_last_updated_by => FND_GLOBAL.USER_ID,
5531: p_last_update_login => FND_GLOBAL.conc_login_id,
5532: p_attribute_category => p_time_alloc_rec.attribute_category,
5533: p_attribute1 => p_time_alloc_rec.attribute1,
5534: p_attribute2 => p_time_alloc_rec.attribute2,
5535: p_attribute3 => p_time_alloc_rec.attribute3,

Line 5601: p_created_by => FND_GLOBAL.USER_ID,

5597: p_lysp_sales => p_prod_alloc_rec.lysp_sales,
5598: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
5599: px_object_version_number => l_object_version_number,
5600: p_creation_date => SYSDATE,
5601: p_created_by => FND_GLOBAL.USER_ID,
5602: p_last_update_date => SYSDATE,
5603: p_last_updated_by => FND_GLOBAL.USER_ID,
5604: p_last_update_login => FND_GLOBAL.conc_login_id,
5605: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 5603: p_last_updated_by => FND_GLOBAL.USER_ID,

5599: px_object_version_number => l_object_version_number,
5600: p_creation_date => SYSDATE,
5601: p_created_by => FND_GLOBAL.USER_ID,
5602: p_last_update_date => SYSDATE,
5603: p_last_updated_by => FND_GLOBAL.USER_ID,
5604: p_last_update_login => FND_GLOBAL.conc_login_id,
5605: p_attribute_category => p_prod_alloc_rec.attribute_category,
5606: p_attribute1 => p_prod_alloc_rec.attribute1,
5607: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 5604: p_last_update_login => FND_GLOBAL.conc_login_id,

5600: p_creation_date => SYSDATE,
5601: p_created_by => FND_GLOBAL.USER_ID,
5602: p_last_update_date => SYSDATE,
5603: p_last_updated_by => FND_GLOBAL.USER_ID,
5604: p_last_update_login => FND_GLOBAL.conc_login_id,
5605: p_attribute_category => p_prod_alloc_rec.attribute_category,
5606: p_attribute1 => p_prod_alloc_rec.attribute1,
5607: p_attribute2 => p_prod_alloc_rec.attribute2,
5608: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 5694: p_created_by => FND_GLOBAL.USER_ID,

5690: p_target => p_time_alloc_rec.target,
5691: p_lysp_sales => p_time_alloc_rec.lysp_sales,
5692: px_object_version_number => l_object_version_number,
5693: p_creation_date => SYSDATE,
5694: p_created_by => FND_GLOBAL.USER_ID,
5695: p_last_update_date => SYSDATE,
5696: p_last_updated_by => FND_GLOBAL.USER_ID,
5697: p_last_update_login => FND_GLOBAL.conc_login_id,
5698: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 5696: p_last_updated_by => FND_GLOBAL.USER_ID,

5692: px_object_version_number => l_object_version_number,
5693: p_creation_date => SYSDATE,
5694: p_created_by => FND_GLOBAL.USER_ID,
5695: p_last_update_date => SYSDATE,
5696: p_last_updated_by => FND_GLOBAL.USER_ID,
5697: p_last_update_login => FND_GLOBAL.conc_login_id,
5698: p_attribute_category => p_time_alloc_rec.attribute_category,
5699: p_attribute1 => p_time_alloc_rec.attribute1,
5700: p_attribute2 => p_time_alloc_rec.attribute2,

Line 5697: p_last_update_login => FND_GLOBAL.conc_login_id,

5693: p_creation_date => SYSDATE,
5694: p_created_by => FND_GLOBAL.USER_ID,
5695: p_last_update_date => SYSDATE,
5696: p_last_updated_by => FND_GLOBAL.USER_ID,
5697: p_last_update_login => FND_GLOBAL.conc_login_id,
5698: p_attribute_category => p_time_alloc_rec.attribute_category,
5699: p_attribute1 => p_time_alloc_rec.attribute1,
5700: p_attribute2 => p_time_alloc_rec.attribute2,
5701: p_attribute3 => p_time_alloc_rec.attribute3,

Line 5725: p.last_updated_by = FND_GLOBAL.USER_ID,

5721: UPDATE OZF_PRODUCT_ALLOCATIONS p
5722: SET p.lysp_sales = l_total_product_sales,
5723: p.object_version_number = p.object_version_number + 1,
5724: p.last_update_date = SYSDATE,
5725: p.last_updated_by = FND_GLOBAL.USER_ID,
5726: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
5727: WHERE p.product_allocation_id = l_product_allocation_id;
5728:
5729: END LOOP account_product_loop;

Line 5726: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

5722: SET p.lysp_sales = l_total_product_sales,
5723: p.object_version_number = p.object_version_number + 1,
5724: p.last_update_date = SYSDATE,
5725: p.last_updated_by = FND_GLOBAL.USER_ID,
5726: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
5727: WHERE p.product_allocation_id = l_product_allocation_id;
5728:
5729: END LOOP account_product_loop;
5730:

Line 5797: p_created_by => FND_GLOBAL.USER_ID,

5793: p_lysp_sales => p_acct_alloc_rec.lysp_sales,
5794: p_parent_Account_allocation_id => p_acct_alloc_rec.parent_Account_allocation_id,
5795: px_object_version_number => l_object_version_number,
5796: p_creation_date => SYSDATE,
5797: p_created_by => FND_GLOBAL.USER_ID,
5798: p_last_update_date => SYSDATE,
5799: p_last_updated_by => FND_GLOBAL.USER_ID,
5800: p_last_update_login => FND_GLOBAL.conc_login_id,
5801: p_attribute_category => p_acct_alloc_rec.attribute_category,

Line 5799: p_last_updated_by => FND_GLOBAL.USER_ID,

5795: px_object_version_number => l_object_version_number,
5796: p_creation_date => SYSDATE,
5797: p_created_by => FND_GLOBAL.USER_ID,
5798: p_last_update_date => SYSDATE,
5799: p_last_updated_by => FND_GLOBAL.USER_ID,
5800: p_last_update_login => FND_GLOBAL.conc_login_id,
5801: p_attribute_category => p_acct_alloc_rec.attribute_category,
5802: p_attribute1 => p_acct_alloc_rec.attribute1,
5803: p_attribute2 => p_acct_alloc_rec.attribute2,

Line 5800: p_last_update_login => FND_GLOBAL.conc_login_id,

5796: p_creation_date => SYSDATE,
5797: p_created_by => FND_GLOBAL.USER_ID,
5798: p_last_update_date => SYSDATE,
5799: p_last_updated_by => FND_GLOBAL.USER_ID,
5800: p_last_update_login => FND_GLOBAL.conc_login_id,
5801: p_attribute_category => p_acct_alloc_rec.attribute_category,
5802: p_attribute1 => p_acct_alloc_rec.attribute1,
5803: p_attribute2 => p_acct_alloc_rec.attribute2,
5804: p_attribute3 => p_acct_alloc_rec.attribute3,

Line 5846: p_created_by => FND_GLOBAL.USER_ID,

5842: p_target => p_time_alloc_rec.target,
5843: p_lysp_sales => p_time_alloc_rec.lysp_sales,
5844: px_object_version_number => l_object_version_number,
5845: p_creation_date => SYSDATE,
5846: p_created_by => FND_GLOBAL.USER_ID,
5847: p_last_update_date => SYSDATE,
5848: p_last_updated_by => FND_GLOBAL.USER_ID,
5849: p_last_update_login => FND_GLOBAL.conc_login_id,
5850: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 5848: p_last_updated_by => FND_GLOBAL.USER_ID,

5844: px_object_version_number => l_object_version_number,
5845: p_creation_date => SYSDATE,
5846: p_created_by => FND_GLOBAL.USER_ID,
5847: p_last_update_date => SYSDATE,
5848: p_last_updated_by => FND_GLOBAL.USER_ID,
5849: p_last_update_login => FND_GLOBAL.conc_login_id,
5850: p_attribute_category => p_time_alloc_rec.attribute_category,
5851: p_attribute1 => p_time_alloc_rec.attribute1,
5852: p_attribute2 => p_time_alloc_rec.attribute2,

Line 5849: p_last_update_login => FND_GLOBAL.conc_login_id,

5845: p_creation_date => SYSDATE,
5846: p_created_by => FND_GLOBAL.USER_ID,
5847: p_last_update_date => SYSDATE,
5848: p_last_updated_by => FND_GLOBAL.USER_ID,
5849: p_last_update_login => FND_GLOBAL.conc_login_id,
5850: p_attribute_category => p_time_alloc_rec.attribute_category,
5851: p_attribute1 => p_time_alloc_rec.attribute1,
5852: p_attribute2 => p_time_alloc_rec.attribute2,
5853: p_attribute3 => p_time_alloc_rec.attribute3,

Line 5910: t.last_updated_by = FND_GLOBAL.USER_ID,

5906: UPDATE OZF_TIME_ALLOCATIONS t
5907: SET t.TARGET = t.TARGET + l_diff_target,
5908: t.object_version_number = t.object_version_number + 1,
5909: t.last_update_date = SYSDATE,
5910: t.last_updated_by = FND_GLOBAL.USER_ID,
5911: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
5912: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
5913: WHERE x.allocation_for = 'CUST'
5914: AND x.allocation_for_id IN ( SELECT a.account_allocation_id

Line 5911: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

5907: SET t.TARGET = t.TARGET + l_diff_target,
5908: t.object_version_number = t.object_version_number + 1,
5909: t.last_update_date = SYSDATE,
5910: t.last_updated_by = FND_GLOBAL.USER_ID,
5911: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
5912: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
5913: WHERE x.allocation_for = 'CUST'
5914: AND x.allocation_for_id IN ( SELECT a.account_allocation_id
5915: FROM OZF_ACCOUNT_ALLOCATIONS a

Line 6580: p_created_by => FND_GLOBAL.USER_ID,

6576: p_lysp_sales => p_acct_alloc_rec.lysp_sales,
6577: p_parent_Account_allocation_id => p_acct_alloc_rec.parent_Account_allocation_id,
6578: px_object_version_number => l_object_version_number,
6579: p_creation_date => SYSDATE,
6580: p_created_by => FND_GLOBAL.USER_ID,
6581: p_last_update_date => SYSDATE,
6582: p_last_updated_by => FND_GLOBAL.USER_ID,
6583: p_last_update_login => FND_GLOBAL.conc_login_id,
6584: p_attribute_category => p_acct_alloc_rec.attribute_category,

Line 6582: p_last_updated_by => FND_GLOBAL.USER_ID,

6578: px_object_version_number => l_object_version_number,
6579: p_creation_date => SYSDATE,
6580: p_created_by => FND_GLOBAL.USER_ID,
6581: p_last_update_date => SYSDATE,
6582: p_last_updated_by => FND_GLOBAL.USER_ID,
6583: p_last_update_login => FND_GLOBAL.conc_login_id,
6584: p_attribute_category => p_acct_alloc_rec.attribute_category,
6585: p_attribute1 => p_acct_alloc_rec.attribute1,
6586: p_attribute2 => p_acct_alloc_rec.attribute2,

Line 6583: p_last_update_login => FND_GLOBAL.conc_login_id,

6579: p_creation_date => SYSDATE,
6580: p_created_by => FND_GLOBAL.USER_ID,
6581: p_last_update_date => SYSDATE,
6582: p_last_updated_by => FND_GLOBAL.USER_ID,
6583: p_last_update_login => FND_GLOBAL.conc_login_id,
6584: p_attribute_category => p_acct_alloc_rec.attribute_category,
6585: p_attribute1 => p_acct_alloc_rec.attribute1,
6586: p_attribute2 => p_acct_alloc_rec.attribute2,
6587: p_attribute3 => p_acct_alloc_rec.attribute3,

Line 6638: p_created_by => FND_GLOBAL.USER_ID,

6634: p_target => p_time_alloc_rec.target,
6635: p_lysp_sales => p_time_alloc_rec.lysp_sales,
6636: px_object_version_number => l_object_version_number,
6637: p_creation_date => SYSDATE,
6638: p_created_by => FND_GLOBAL.USER_ID,
6639: p_last_update_date => SYSDATE,
6640: p_last_updated_by => FND_GLOBAL.USER_ID,
6641: p_last_update_login => FND_GLOBAL.conc_login_id,
6642: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 6640: p_last_updated_by => FND_GLOBAL.USER_ID,

6636: px_object_version_number => l_object_version_number,
6637: p_creation_date => SYSDATE,
6638: p_created_by => FND_GLOBAL.USER_ID,
6639: p_last_update_date => SYSDATE,
6640: p_last_updated_by => FND_GLOBAL.USER_ID,
6641: p_last_update_login => FND_GLOBAL.conc_login_id,
6642: p_attribute_category => p_time_alloc_rec.attribute_category,
6643: p_attribute1 => p_time_alloc_rec.attribute1,
6644: p_attribute2 => p_time_alloc_rec.attribute2,

Line 6641: p_last_update_login => FND_GLOBAL.conc_login_id,

6637: p_creation_date => SYSDATE,
6638: p_created_by => FND_GLOBAL.USER_ID,
6639: p_last_update_date => SYSDATE,
6640: p_last_updated_by => FND_GLOBAL.USER_ID,
6641: p_last_update_login => FND_GLOBAL.conc_login_id,
6642: p_attribute_category => p_time_alloc_rec.attribute_category,
6643: p_attribute1 => p_time_alloc_rec.attribute1,
6644: p_attribute2 => p_time_alloc_rec.attribute2,
6645: p_attribute3 => p_time_alloc_rec.attribute3,

Line 6680: a.last_updated_by = FND_GLOBAL.USER_ID,

6676: UPDATE OZF_ACCOUNT_ALLOCATIONS a
6677: SET a.TARGET = l_total_account_target,
6678: a.object_version_number = a.object_version_number + 1,
6679: a.last_update_date = SYSDATE,
6680: a.last_updated_by = FND_GLOBAL.USER_ID,
6681: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6682: WHERE a.account_allocation_id = l_account_allocation_id;
6683:
6684: IF (SQL%NOTFOUND) THEN

Line 6681: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6677: SET a.TARGET = l_total_account_target,
6678: a.object_version_number = a.object_version_number + 1,
6679: a.last_update_date = SYSDATE,
6680: a.last_updated_by = FND_GLOBAL.USER_ID,
6681: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6682: WHERE a.account_allocation_id = l_account_allocation_id;
6683:
6684: IF (SQL%NOTFOUND) THEN
6685: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 6753: p_created_by => FND_GLOBAL.USER_ID,

6749: p_lysp_sales => p_prod_alloc_rec.lysp_sales,
6750: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
6751: px_object_version_number => l_object_version_number,
6752: p_creation_date => SYSDATE,
6753: p_created_by => FND_GLOBAL.USER_ID,
6754: p_last_update_date => SYSDATE,
6755: p_last_updated_by => FND_GLOBAL.USER_ID,
6756: p_last_update_login => FND_GLOBAL.conc_login_id,
6757: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 6755: p_last_updated_by => FND_GLOBAL.USER_ID,

6751: px_object_version_number => l_object_version_number,
6752: p_creation_date => SYSDATE,
6753: p_created_by => FND_GLOBAL.USER_ID,
6754: p_last_update_date => SYSDATE,
6755: p_last_updated_by => FND_GLOBAL.USER_ID,
6756: p_last_update_login => FND_GLOBAL.conc_login_id,
6757: p_attribute_category => p_prod_alloc_rec.attribute_category,
6758: p_attribute1 => p_prod_alloc_rec.attribute1,
6759: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 6756: p_last_update_login => FND_GLOBAL.conc_login_id,

6752: p_creation_date => SYSDATE,
6753: p_created_by => FND_GLOBAL.USER_ID,
6754: p_last_update_date => SYSDATE,
6755: p_last_updated_by => FND_GLOBAL.USER_ID,
6756: p_last_update_login => FND_GLOBAL.conc_login_id,
6757: p_attribute_category => p_prod_alloc_rec.attribute_category,
6758: p_attribute1 => p_prod_alloc_rec.attribute1,
6759: p_attribute2 => p_prod_alloc_rec.attribute2,
6760: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 6849: p_created_by => FND_GLOBAL.USER_ID,

6845: p_target => p_time_alloc_rec.target,
6846: p_lysp_sales => p_time_alloc_rec.lysp_sales,
6847: px_object_version_number => l_object_version_number,
6848: p_creation_date => SYSDATE,
6849: p_created_by => FND_GLOBAL.USER_ID,
6850: p_last_update_date => SYSDATE,
6851: p_last_updated_by => FND_GLOBAL.USER_ID,
6852: p_last_update_login => FND_GLOBAL.conc_login_id,
6853: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 6851: p_last_updated_by => FND_GLOBAL.USER_ID,

6847: px_object_version_number => l_object_version_number,
6848: p_creation_date => SYSDATE,
6849: p_created_by => FND_GLOBAL.USER_ID,
6850: p_last_update_date => SYSDATE,
6851: p_last_updated_by => FND_GLOBAL.USER_ID,
6852: p_last_update_login => FND_GLOBAL.conc_login_id,
6853: p_attribute_category => p_time_alloc_rec.attribute_category,
6854: p_attribute1 => p_time_alloc_rec.attribute1,
6855: p_attribute2 => p_time_alloc_rec.attribute2,

Line 6852: p_last_update_login => FND_GLOBAL.conc_login_id,

6848: p_creation_date => SYSDATE,
6849: p_created_by => FND_GLOBAL.USER_ID,
6850: p_last_update_date => SYSDATE,
6851: p_last_updated_by => FND_GLOBAL.USER_ID,
6852: p_last_update_login => FND_GLOBAL.conc_login_id,
6853: p_attribute_category => p_time_alloc_rec.attribute_category,
6854: p_attribute1 => p_time_alloc_rec.attribute1,
6855: p_attribute2 => p_time_alloc_rec.attribute2,
6856: p_attribute3 => p_time_alloc_rec.attribute3,

Line 6880: p.last_updated_by = FND_GLOBAL.USER_ID,

6876: UPDATE OZF_PRODUCT_ALLOCATIONS p
6877: SET p.lysp_sales = l_total_product_sales,
6878: p.object_version_number = p.object_version_number + 1,
6879: p.last_update_date = SYSDATE,
6880: p.last_updated_by = FND_GLOBAL.USER_ID,
6881: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6882: WHERE p.product_allocation_id = l_product_allocation_id;
6883:
6884: l_p_grand_total_lysp_sales := l_p_grand_total_lysp_sales + l_total_product_sales;

Line 6881: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6877: SET p.lysp_sales = l_total_product_sales,
6878: p.object_version_number = p.object_version_number + 1,
6879: p.last_update_date = SYSDATE,
6880: p.last_updated_by = FND_GLOBAL.USER_ID,
6881: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6882: WHERE p.product_allocation_id = l_product_allocation_id;
6883:
6884: l_p_grand_total_lysp_sales := l_p_grand_total_lysp_sales + l_total_product_sales;
6885:

Line 6907: t.last_updated_by = FND_GLOBAL.USER_ID,

6903: UPDATE OZF_TIME_ALLOCATIONS t
6904: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_prod_mltply_factor), 0),
6905: t.object_version_number = t.object_version_number + 1,
6906: t.last_update_date = SYSDATE,
6907: t.last_updated_by = FND_GLOBAL.USER_ID,
6908: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6909: WHERE t.allocation_for = 'PROD'
6910: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
6911: FROM OZF_PRODUCT_ALLOCATIONS p

Line 6908: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6904: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_prod_mltply_factor), 0),
6905: t.object_version_number = t.object_version_number + 1,
6906: t.last_update_date = SYSDATE,
6907: t.last_updated_by = FND_GLOBAL.USER_ID,
6908: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6909: WHERE t.allocation_for = 'PROD'
6910: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
6911: FROM OZF_PRODUCT_ALLOCATIONS p
6912: WHERE p.allocation_for = 'CUST'

Line 6931: p.last_updated_by = FND_GLOBAL.USER_ID,

6927: WHERE ti.ALLOCATION_FOR = 'PROD'
6928: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
6929: p.object_version_number = p.object_version_number + 1,
6930: p.last_update_date = SYSDATE,
6931: p.last_updated_by = FND_GLOBAL.USER_ID,
6932: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6933: WHERE p.allocation_for = 'CUST'
6934: AND p.allocation_for_id = l_account_allocation_id;
6935:

Line 6932: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6928: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
6929: p.object_version_number = p.object_version_number + 1,
6930: p.last_update_date = SYSDATE,
6931: p.last_updated_by = FND_GLOBAL.USER_ID,
6932: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6933: WHERE p.allocation_for = 'CUST'
6934: AND p.allocation_for_id = l_account_allocation_id;
6935:
6936: IF (SQL%NOTFOUND) THEN

Line 6960: p.last_updated_by = FND_GLOBAL.USER_ID,

6956: UPDATE OZF_PRODUCT_ALLOCATIONS p
6957: SET p.TARGET = ROUND(NVL(l_total_account_target, 0),0),
6958: p.object_version_number = p.object_version_number + 1,
6959: p.last_update_date = SYSDATE,
6960: p.last_updated_by = FND_GLOBAL.USER_ID,
6961: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6962: WHERE p.allocation_for = 'CUST'
6963: AND p.allocation_for_id = l_account_allocation_id
6964: AND p.item_id = -9999;

Line 6961: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6957: SET p.TARGET = ROUND(NVL(l_total_account_target, 0),0),
6958: p.object_version_number = p.object_version_number + 1,
6959: p.last_update_date = SYSDATE,
6960: p.last_updated_by = FND_GLOBAL.USER_ID,
6961: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6962: WHERE p.allocation_for = 'CUST'
6963: AND p.allocation_for_id = l_account_allocation_id
6964: AND p.item_id = -9999;
6965:

Line 6980: t.last_updated_by = FND_GLOBAL.USER_ID,

6976: UPDATE OZF_TIME_ALLOCATIONS t
6977: SET t.TARGET = ROUND((NVL(l_total_account_target, 0) / l_p_denominator), 0),
6978: t.object_version_number = t.object_version_number + 1,
6979: t.last_update_date = SYSDATE,
6980: t.last_updated_by = FND_GLOBAL.USER_ID,
6981: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6982: WHERE t.allocation_for = 'PROD'
6983: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
6984: FROM OZF_PRODUCT_ALLOCATIONS p

Line 6981: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6977: SET t.TARGET = ROUND((NVL(l_total_account_target, 0) / l_p_denominator), 0),
6978: t.object_version_number = t.object_version_number + 1,
6979: t.last_update_date = SYSDATE,
6980: t.last_updated_by = FND_GLOBAL.USER_ID,
6981: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6982: WHERE t.allocation_for = 'PROD'
6983: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
6984: FROM OZF_PRODUCT_ALLOCATIONS p
6985: WHERE p.allocation_for = 'CUST'

Line 7004: p.last_updated_by = FND_GLOBAL.USER_ID,

7000: WHERE ti.ALLOCATION_FOR = 'PROD'
7001: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
7002: p.object_version_number = p.object_version_number + 1,
7003: p.last_update_date = SYSDATE,
7004: p.last_updated_by = FND_GLOBAL.USER_ID,
7005: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7006: WHERE p.allocation_for = 'CUST'
7007: AND p.allocation_for_id = l_account_allocation_id
7008: AND p.item_id = -9999;

Line 7005: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7001: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
7002: p.object_version_number = p.object_version_number + 1,
7003: p.last_update_date = SYSDATE,
7004: p.last_updated_by = FND_GLOBAL.USER_ID,
7005: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7006: WHERE p.allocation_for = 'CUST'
7007: AND p.allocation_for_id = l_account_allocation_id
7008: AND p.item_id = -9999;
7009:

Line 7064: t.last_updated_by = FND_GLOBAL.USER_ID,

7060: UPDATE OZF_TIME_ALLOCATIONS t
7061: SET t.TARGET = t.TARGET + l_diff_target,
7062: t.object_version_number = t.object_version_number + 1,
7063: t.last_update_date = SYSDATE,
7064: t.last_updated_by = FND_GLOBAL.USER_ID,
7065: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7066: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
7067: FROM OZF_TIME_ALLOCATIONS x
7068: WHERE x.allocation_for = 'PROD'

Line 7065: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7061: SET t.TARGET = t.TARGET + l_diff_target,
7062: t.object_version_number = t.object_version_number + 1,
7063: t.last_update_date = SYSDATE,
7064: t.last_updated_by = FND_GLOBAL.USER_ID,
7065: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7066: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
7067: FROM OZF_TIME_ALLOCATIONS x
7068: WHERE x.allocation_for = 'PROD'
7069: AND x.allocation_for_id IN ( SELECT max(p.product_allocation_id)

Line 7114: p.last_updated_by = FND_GLOBAL.USER_ID,

7110: UPDATE OZF_PRODUCT_ALLOCATIONS p
7111: SET p.TARGET = p.TARGET + l_diff_target,
7112: p.object_version_number = p.object_version_number + 1,
7113: p.last_update_date = SYSDATE,
7114: p.last_updated_by = FND_GLOBAL.USER_ID,
7115: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7116: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7117:
7118: IF (SQL%NOTFOUND) THEN

Line 7115: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7111: SET p.TARGET = p.TARGET + l_diff_target,
7112: p.object_version_number = p.object_version_number + 1,
7113: p.last_update_date = SYSDATE,
7114: p.last_updated_by = FND_GLOBAL.USER_ID,
7115: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7116: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7117:
7118: IF (SQL%NOTFOUND) THEN
7119: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 7133: t.last_updated_by = FND_GLOBAL.USER_ID,

7129: UPDATE OZF_TIME_ALLOCATIONS t
7130: SET t.TARGET = t.TARGET + l_diff_target,
7131: t.object_version_number = t.object_version_number + 1,
7132: t.last_update_date = SYSDATE,
7133: t.last_updated_by = FND_GLOBAL.USER_ID,
7134: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7135: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7136: WHERE x.allocation_for = 'PROD'
7137: AND x.allocation_for_id IN ( SELECT p.product_allocation_id

Line 7134: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7130: SET t.TARGET = t.TARGET + l_diff_target,
7131: t.object_version_number = t.object_version_number + 1,
7132: t.last_update_date = SYSDATE,
7133: t.last_updated_by = FND_GLOBAL.USER_ID,
7134: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7135: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7136: WHERE x.allocation_for = 'PROD'
7137: AND x.allocation_for_id IN ( SELECT p.product_allocation_id
7138: FROM OZF_PRODUCT_ALLOCATIONS p

Line 7157: p.last_updated_by = FND_GLOBAL.USER_ID,

7153: UPDATE OZF_PRODUCT_ALLOCATIONS p
7154: SET p.TARGET = p.TARGET + l_diff_target,
7155: p.object_version_number = p.object_version_number + 1,
7156: p.last_update_date = SYSDATE,
7157: p.last_updated_by = FND_GLOBAL.USER_ID,
7158: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7159: WHERE p.allocation_for = 'CUST'
7160: AND p.allocation_for_id = l_account_allocation_id
7161: AND p.item_id = -9999;

Line 7158: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7154: SET p.TARGET = p.TARGET + l_diff_target,
7155: p.object_version_number = p.object_version_number + 1,
7156: p.last_update_date = SYSDATE,
7157: p.last_updated_by = FND_GLOBAL.USER_ID,
7158: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7159: WHERE p.allocation_for = 'CUST'
7160: AND p.allocation_for_id = l_account_allocation_id
7161: AND p.item_id = -9999;
7162:

Line 7222: p_created_by => FND_GLOBAL.USER_ID,

7218: p_lysp_sales => p_acct_alloc_rec.lysp_sales,
7219: p_parent_Account_allocation_id => p_acct_alloc_rec.parent_Account_allocation_id,
7220: px_object_version_number => l_object_version_number,
7221: p_creation_date => SYSDATE,
7222: p_created_by => FND_GLOBAL.USER_ID,
7223: p_last_update_date => SYSDATE,
7224: p_last_updated_by => FND_GLOBAL.USER_ID,
7225: p_last_update_login => FND_GLOBAL.conc_login_id,
7226: p_attribute_category => p_acct_alloc_rec.attribute_category,

Line 7224: p_last_updated_by => FND_GLOBAL.USER_ID,

7220: px_object_version_number => l_object_version_number,
7221: p_creation_date => SYSDATE,
7222: p_created_by => FND_GLOBAL.USER_ID,
7223: p_last_update_date => SYSDATE,
7224: p_last_updated_by => FND_GLOBAL.USER_ID,
7225: p_last_update_login => FND_GLOBAL.conc_login_id,
7226: p_attribute_category => p_acct_alloc_rec.attribute_category,
7227: p_attribute1 => p_acct_alloc_rec.attribute1,
7228: p_attribute2 => p_acct_alloc_rec.attribute2,

Line 7225: p_last_update_login => FND_GLOBAL.conc_login_id,

7221: p_creation_date => SYSDATE,
7222: p_created_by => FND_GLOBAL.USER_ID,
7223: p_last_update_date => SYSDATE,
7224: p_last_updated_by => FND_GLOBAL.USER_ID,
7225: p_last_update_login => FND_GLOBAL.conc_login_id,
7226: p_attribute_category => p_acct_alloc_rec.attribute_category,
7227: p_attribute1 => p_acct_alloc_rec.attribute1,
7228: p_attribute2 => p_acct_alloc_rec.attribute2,
7229: p_attribute3 => p_acct_alloc_rec.attribute3,

Line 7271: p_created_by => FND_GLOBAL.USER_ID,

7267: p_target => p_time_alloc_rec.target,
7268: p_lysp_sales => p_time_alloc_rec.lysp_sales,
7269: px_object_version_number => l_object_version_number,
7270: p_creation_date => SYSDATE,
7271: p_created_by => FND_GLOBAL.USER_ID,
7272: p_last_update_date => SYSDATE,
7273: p_last_updated_by => FND_GLOBAL.USER_ID,
7274: p_last_update_login => FND_GLOBAL.conc_login_id,
7275: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 7273: p_last_updated_by => FND_GLOBAL.USER_ID,

7269: px_object_version_number => l_object_version_number,
7270: p_creation_date => SYSDATE,
7271: p_created_by => FND_GLOBAL.USER_ID,
7272: p_last_update_date => SYSDATE,
7273: p_last_updated_by => FND_GLOBAL.USER_ID,
7274: p_last_update_login => FND_GLOBAL.conc_login_id,
7275: p_attribute_category => p_time_alloc_rec.attribute_category,
7276: p_attribute1 => p_time_alloc_rec.attribute1,
7277: p_attribute2 => p_time_alloc_rec.attribute2,

Line 7274: p_last_update_login => FND_GLOBAL.conc_login_id,

7270: p_creation_date => SYSDATE,
7271: p_created_by => FND_GLOBAL.USER_ID,
7272: p_last_update_date => SYSDATE,
7273: p_last_updated_by => FND_GLOBAL.USER_ID,
7274: p_last_update_login => FND_GLOBAL.conc_login_id,
7275: p_attribute_category => p_time_alloc_rec.attribute_category,
7276: p_attribute1 => p_time_alloc_rec.attribute1,
7277: p_attribute2 => p_time_alloc_rec.attribute2,
7278: p_attribute3 => p_time_alloc_rec.attribute3,

Line 7343: t.last_updated_by = FND_GLOBAL.USER_ID,

7339: UPDATE OZF_TIME_ALLOCATIONS t
7340: SET t.TARGET = t.TARGET + l_diff_target,
7341: t.object_version_number = t.object_version_number + 1,
7342: t.last_update_date = SYSDATE,
7343: t.last_updated_by = FND_GLOBAL.USER_ID,
7344: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7345: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7346: WHERE x.allocation_for = 'CUST'
7347: AND x.allocation_for_id IN ( SELECT a.account_allocation_id

Line 7344: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7340: SET t.TARGET = t.TARGET + l_diff_target,
7341: t.object_version_number = t.object_version_number + 1,
7342: t.last_update_date = SYSDATE,
7343: t.last_updated_by = FND_GLOBAL.USER_ID,
7344: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7345: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7346: WHERE x.allocation_for = 'CUST'
7347: AND x.allocation_for_id IN ( SELECT a.account_allocation_id
7348: FROM OZF_ACCOUNT_ALLOCATIONS a

Line 7405: t.last_updated_by = FND_GLOBAL.USER_ID,

7401: UPDATE OZF_TIME_ALLOCATIONS t
7402: SET t.TARGET = t.TARGET + l_diff_target,
7403: t.object_version_number = t.object_version_number + 1,
7404: t.last_update_date = SYSDATE,
7405: t.last_updated_by = FND_GLOBAL.USER_ID,
7406: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7407: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7408: WHERE x.allocation_for = 'CUST'
7409: AND x.allocation_for_id IN ( SELECT a.account_allocation_id

Line 7406: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7402: SET t.TARGET = t.TARGET + l_diff_target,
7403: t.object_version_number = t.object_version_number + 1,
7404: t.last_update_date = SYSDATE,
7405: t.last_updated_by = FND_GLOBAL.USER_ID,
7406: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7407: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7408: WHERE x.allocation_for = 'CUST'
7409: AND x.allocation_for_id IN ( SELECT a.account_allocation_id
7410: FROM OZF_ACCOUNT_ALLOCATIONS a

Line 7429: a.last_updated_by = FND_GLOBAL.USER_ID,

7425: UPDATE OZF_ACCOUNT_ALLOCATIONS a
7426: SET a.TARGET = a.TARGET + l_diff_target,
7427: a.object_version_number = a.object_version_number + 1,
7428: a.last_update_date = SYSDATE,
7429: a.last_updated_by = FND_GLOBAL.USER_ID,
7430: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7431: WHERE a.allocation_for = 'FUND'
7432: AND a.allocation_for_id = l_fund_id
7433: AND a.parent_party_id = -9999;

Line 7430: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7426: SET a.TARGET = a.TARGET + l_diff_target,
7427: a.object_version_number = a.object_version_number + 1,
7428: a.last_update_date = SYSDATE,
7429: a.last_updated_by = FND_GLOBAL.USER_ID,
7430: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7431: WHERE a.allocation_for = 'FUND'
7432: AND a.allocation_for_id = l_fund_id
7433: AND a.parent_party_id = -9999;
7434:

Line 7463: t.last_updated_by = FND_GLOBAL.USER_ID,

7459: UPDATE OZF_TIME_ALLOCATIONS t
7460: SET t.TARGET = t.TARGET + l_diff_target,
7461: t.object_version_number = t.object_version_number + 1,
7462: t.last_update_date = SYSDATE,
7463: t.last_updated_by = FND_GLOBAL.USER_ID,
7464: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7465: WHERE t.time_allocation_id = (SELECT MAX(x.time_allocation_id)
7466: FROM OZF_TIME_ALLOCATIONS x
7467: WHERE x.allocation_for = 'CUST'

Line 7464: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7460: SET t.TARGET = t.TARGET + l_diff_target,
7461: t.object_version_number = t.object_version_number + 1,
7462: t.last_update_date = SYSDATE,
7463: t.last_updated_by = FND_GLOBAL.USER_ID,
7464: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7465: WHERE t.time_allocation_id = (SELECT MAX(x.time_allocation_id)
7466: FROM OZF_TIME_ALLOCATIONS x
7467: WHERE x.allocation_for = 'CUST'
7468: AND x.allocation_for_id IN ( SELECT MAX(a.account_allocation_id)

Line 7512: a.last_updated_by = FND_GLOBAL.USER_ID,

7508: UPDATE OZF_ACCOUNT_ALLOCATIONS a
7509: SET a.TARGET = a.TARGET + l_diff_target,
7510: a.object_version_number = a.object_version_number + 1,
7511: a.last_update_date = SYSDATE,
7512: a.last_updated_by = FND_GLOBAL.USER_ID,
7513: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7514: WHERE a.account_allocation_id = l_temp_account_allocation_id;
7515:
7516: IF (SQL%NOTFOUND) THEN

Line 7513: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7509: SET a.TARGET = a.TARGET + l_diff_target,
7510: a.object_version_number = a.object_version_number + 1,
7511: a.last_update_date = SYSDATE,
7512: a.last_updated_by = FND_GLOBAL.USER_ID,
7513: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7514: WHERE a.account_allocation_id = l_temp_account_allocation_id;
7515:
7516: IF (SQL%NOTFOUND) THEN
7517: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 7540: t.last_updated_by = FND_GLOBAL.USER_ID,

7536: UPDATE OZF_TIME_ALLOCATIONS t
7537: SET t.TARGET = t.TARGET + l_diff_target,
7538: t.object_version_number = t.object_version_number + 1,
7539: t.last_update_date = SYSDATE,
7540: t.last_updated_by = FND_GLOBAL.USER_ID,
7541: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7542: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
7543: FROM OZF_TIME_ALLOCATIONS x
7544: WHERE x.allocation_for = 'PROD'

Line 7541: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7537: SET t.TARGET = t.TARGET + l_diff_target,
7538: t.object_version_number = t.object_version_number + 1,
7539: t.last_update_date = SYSDATE,
7540: t.last_updated_by = FND_GLOBAL.USER_ID,
7541: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7542: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
7543: FROM OZF_TIME_ALLOCATIONS x
7544: WHERE x.allocation_for = 'PROD'
7545: AND x.allocation_for_id IN ( SELECT max(p.product_allocation_id)

Line 7590: p.last_updated_by = FND_GLOBAL.USER_ID,

7586: UPDATE OZF_PRODUCT_ALLOCATIONS p
7587: SET p.TARGET = p.TARGET + l_diff_target,
7588: p.object_version_number = p.object_version_number + 1,
7589: p.last_update_date = SYSDATE,
7590: p.last_updated_by = FND_GLOBAL.USER_ID,
7591: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7592: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7593:
7594: IF (SQL%NOTFOUND) THEN

Line 7591: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7587: SET p.TARGET = p.TARGET + l_diff_target,
7588: p.object_version_number = p.object_version_number + 1,
7589: p.last_update_date = SYSDATE,
7590: p.last_updated_by = FND_GLOBAL.USER_ID,
7591: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7592: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7593:
7594: IF (SQL%NOTFOUND) THEN
7595: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 8237: a.last_updated_by = FND_GLOBAL.USER_ID,

8233: SET a.target = a.target + l_total_account_target,
8234: a.lysp_sales = a.lysp_sales + l_total_account_sales,
8235: a.object_version_number = a.object_version_number + 1,
8236: a.last_update_date = SYSDATE,
8237: a.last_updated_by = FND_GLOBAL.USER_ID,
8238: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8239: WHERE a.account_allocation_id = l_account_allocation_id;
8240:
8241: <>

Line 8238: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

8234: a.lysp_sales = a.lysp_sales + l_total_account_sales,
8235: a.object_version_number = a.object_version_number + 1,
8236: a.last_update_date = SYSDATE,
8237: a.last_updated_by = FND_GLOBAL.USER_ID,
8238: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8239: WHERE a.account_allocation_id = l_account_allocation_id;
8240:
8241: <>
8242: FOR l_idx IN l_period_tbl.first..l_period_tbl.last

Line 8274: p_created_by => FND_GLOBAL.USER_ID,

8270: p_target => p_time_alloc_rec.target,
8271: p_lysp_sales => p_time_alloc_rec.lysp_sales,
8272: px_object_version_number => l_object_version_number,
8273: p_creation_date => SYSDATE,
8274: p_created_by => FND_GLOBAL.USER_ID,
8275: p_last_update_date => SYSDATE,
8276: p_last_updated_by => FND_GLOBAL.USER_ID,
8277: p_last_update_login => FND_GLOBAL.conc_login_id,
8278: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 8276: p_last_updated_by => FND_GLOBAL.USER_ID,

8272: px_object_version_number => l_object_version_number,
8273: p_creation_date => SYSDATE,
8274: p_created_by => FND_GLOBAL.USER_ID,
8275: p_last_update_date => SYSDATE,
8276: p_last_updated_by => FND_GLOBAL.USER_ID,
8277: p_last_update_login => FND_GLOBAL.conc_login_id,
8278: p_attribute_category => p_time_alloc_rec.attribute_category,
8279: p_attribute1 => p_time_alloc_rec.attribute1,
8280: p_attribute2 => p_time_alloc_rec.attribute2,

Line 8277: p_last_update_login => FND_GLOBAL.conc_login_id,

8273: p_creation_date => SYSDATE,
8274: p_created_by => FND_GLOBAL.USER_ID,
8275: p_last_update_date => SYSDATE,
8276: p_last_updated_by => FND_GLOBAL.USER_ID,
8277: p_last_update_login => FND_GLOBAL.conc_login_id,
8278: p_attribute_category => p_time_alloc_rec.attribute_category,
8279: p_attribute1 => p_time_alloc_rec.attribute1,
8280: p_attribute2 => p_time_alloc_rec.attribute2,
8281: p_attribute3 => p_time_alloc_rec.attribute3,

Line 8402: p_created_by => FND_GLOBAL.USER_ID,

8398: p_target => p_time_alloc_rec.target,
8399: p_lysp_sales => p_time_alloc_rec.lysp_sales,
8400: px_object_version_number => l_object_version_number,
8401: p_creation_date => SYSDATE,
8402: p_created_by => FND_GLOBAL.USER_ID,
8403: p_last_update_date => SYSDATE,
8404: p_last_updated_by => FND_GLOBAL.USER_ID,
8405: p_last_update_login => FND_GLOBAL.conc_login_id,
8406: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 8404: p_last_updated_by => FND_GLOBAL.USER_ID,

8400: px_object_version_number => l_object_version_number,
8401: p_creation_date => SYSDATE,
8402: p_created_by => FND_GLOBAL.USER_ID,
8403: p_last_update_date => SYSDATE,
8404: p_last_updated_by => FND_GLOBAL.USER_ID,
8405: p_last_update_login => FND_GLOBAL.conc_login_id,
8406: p_attribute_category => p_time_alloc_rec.attribute_category,
8407: p_attribute1 => p_time_alloc_rec.attribute1,
8408: p_attribute2 => p_time_alloc_rec.attribute2,

Line 8405: p_last_update_login => FND_GLOBAL.conc_login_id,

8401: p_creation_date => SYSDATE,
8402: p_created_by => FND_GLOBAL.USER_ID,
8403: p_last_update_date => SYSDATE,
8404: p_last_updated_by => FND_GLOBAL.USER_ID,
8405: p_last_update_login => FND_GLOBAL.conc_login_id,
8406: p_attribute_category => p_time_alloc_rec.attribute_category,
8407: p_attribute1 => p_time_alloc_rec.attribute1,
8408: p_attribute2 => p_time_alloc_rec.attribute2,
8409: p_attribute3 => p_time_alloc_rec.attribute3,

Line 8434: p.last_updated_by = FND_GLOBAL.USER_ID,

8430: SET p.lysp_sales = p.lysp_sales + l_total_product_sales,
8431: p.target = p.target + l_total_product_target,
8432: p.object_version_number = p.object_version_number + 1,
8433: p.last_update_date = SYSDATE,
8434: p.last_updated_by = FND_GLOBAL.USER_ID,
8435: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8436: WHERE p.product_allocation_id = l_product_allocation_id;
8437:
8438: END LOOP account_product_loop;

Line 8435: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

8431: p.target = p.target + l_total_product_target,
8432: p.object_version_number = p.object_version_number + 1,
8433: p.last_update_date = SYSDATE,
8434: p.last_updated_by = FND_GLOBAL.USER_ID,
8435: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8436: WHERE p.product_allocation_id = l_product_allocation_id;
8437:
8438: END LOOP account_product_loop;
8439:

Line 8461: a.last_updated_by = FND_GLOBAL.USER_ID,

8457: UPDATE ozf_account_allocations a
8458: SET a.target = a.target + l_total_target_unalloc,
8459: a.object_version_number = a.object_version_number + 1,
8460: a.last_update_date = SYSDATE,
8461: a.last_updated_by = FND_GLOBAL.USER_ID,
8462: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8463: WHERE a.allocation_for = 'FUND'
8464: AND a.allocation_for_id = l_fund_id
8465: AND a.site_use_id = -9999

Line 8462: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

8458: SET a.target = a.target + l_total_target_unalloc,
8459: a.object_version_number = a.object_version_number + 1,
8460: a.last_update_date = SYSDATE,
8461: a.last_updated_by = FND_GLOBAL.USER_ID,
8462: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8463: WHERE a.allocation_for = 'FUND'
8464: AND a.allocation_for_id = l_fund_id
8465: AND a.site_use_id = -9999
8466: RETURNING account_allocation_id INTO l_account_allocation_id;

Line 8494: p_created_by => FND_GLOBAL.USER_ID,

8490: p_target => p_time_alloc_rec.target,
8491: p_lysp_sales => p_time_alloc_rec.lysp_sales,
8492: px_object_version_number => l_object_version_number,
8493: p_creation_date => SYSDATE,
8494: p_created_by => FND_GLOBAL.USER_ID,
8495: p_last_update_date => SYSDATE,
8496: p_last_updated_by => FND_GLOBAL.USER_ID,
8497: p_last_update_login => FND_GLOBAL.conc_login_id,
8498: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 8496: p_last_updated_by => FND_GLOBAL.USER_ID,

8492: px_object_version_number => l_object_version_number,
8493: p_creation_date => SYSDATE,
8494: p_created_by => FND_GLOBAL.USER_ID,
8495: p_last_update_date => SYSDATE,
8496: p_last_updated_by => FND_GLOBAL.USER_ID,
8497: p_last_update_login => FND_GLOBAL.conc_login_id,
8498: p_attribute_category => p_time_alloc_rec.attribute_category,
8499: p_attribute1 => p_time_alloc_rec.attribute1,
8500: p_attribute2 => p_time_alloc_rec.attribute2,

Line 8497: p_last_update_login => FND_GLOBAL.conc_login_id,

8493: p_creation_date => SYSDATE,
8494: p_created_by => FND_GLOBAL.USER_ID,
8495: p_last_update_date => SYSDATE,
8496: p_last_updated_by => FND_GLOBAL.USER_ID,
8497: p_last_update_login => FND_GLOBAL.conc_login_id,
8498: p_attribute_category => p_time_alloc_rec.attribute_category,
8499: p_attribute1 => p_time_alloc_rec.attribute1,
8500: p_attribute2 => p_time_alloc_rec.attribute2,
8501: p_attribute3 => p_time_alloc_rec.attribute3,

Line 9700: p_created_by => FND_GLOBAL.USER_ID,

9696: p_lysp_sales => p_acct_alloc_rec.lysp_sales,
9697: p_parent_Account_allocation_id => p_acct_alloc_rec.parent_account_allocation_id,
9698: px_object_version_number => l_object_version_number,
9699: p_creation_date => SYSDATE,
9700: p_created_by => FND_GLOBAL.USER_ID,
9701: p_last_update_date => SYSDATE,
9702: p_last_updated_by => FND_GLOBAL.USER_ID,
9703: p_last_update_login => FND_GLOBAL.conc_login_id,
9704: p_attribute_category => p_acct_alloc_rec.attribute_category,

Line 9702: p_last_updated_by => FND_GLOBAL.USER_ID,

9698: px_object_version_number => l_object_version_number,
9699: p_creation_date => SYSDATE,
9700: p_created_by => FND_GLOBAL.USER_ID,
9701: p_last_update_date => SYSDATE,
9702: p_last_updated_by => FND_GLOBAL.USER_ID,
9703: p_last_update_login => FND_GLOBAL.conc_login_id,
9704: p_attribute_category => p_acct_alloc_rec.attribute_category,
9705: p_attribute1 => p_acct_alloc_rec.attribute1,
9706: p_attribute2 => p_acct_alloc_rec.attribute2,

Line 9703: p_last_update_login => FND_GLOBAL.conc_login_id,

9699: p_creation_date => SYSDATE,
9700: p_created_by => FND_GLOBAL.USER_ID,
9701: p_last_update_date => SYSDATE,
9702: p_last_updated_by => FND_GLOBAL.USER_ID,
9703: p_last_update_login => FND_GLOBAL.conc_login_id,
9704: p_attribute_category => p_acct_alloc_rec.attribute_category,
9705: p_attribute1 => p_acct_alloc_rec.attribute1,
9706: p_attribute2 => p_acct_alloc_rec.attribute2,
9707: p_attribute3 => p_acct_alloc_rec.attribute3,

Line 9739: p_created_by => FND_GLOBAL.USER_ID,

9735: p_target => p_time_alloc_rec.target,
9736: p_lysp_sales => p_time_alloc_rec.lysp_sales,
9737: px_object_version_number => l_object_version_number,
9738: p_creation_date => SYSDATE,
9739: p_created_by => FND_GLOBAL.USER_ID,
9740: p_last_update_date => SYSDATE,
9741: p_last_updated_by => FND_GLOBAL.USER_ID,
9742: p_last_update_login => FND_GLOBAL.conc_login_id,
9743: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 9741: p_last_updated_by => FND_GLOBAL.USER_ID,

9737: px_object_version_number => l_object_version_number,
9738: p_creation_date => SYSDATE,
9739: p_created_by => FND_GLOBAL.USER_ID,
9740: p_last_update_date => SYSDATE,
9741: p_last_updated_by => FND_GLOBAL.USER_ID,
9742: p_last_update_login => FND_GLOBAL.conc_login_id,
9743: p_attribute_category => p_time_alloc_rec.attribute_category,
9744: p_attribute1 => p_time_alloc_rec.attribute1,
9745: p_attribute2 => p_time_alloc_rec.attribute2,

Line 9742: p_last_update_login => FND_GLOBAL.conc_login_id,

9738: p_creation_date => SYSDATE,
9739: p_created_by => FND_GLOBAL.USER_ID,
9740: p_last_update_date => SYSDATE,
9741: p_last_updated_by => FND_GLOBAL.USER_ID,
9742: p_last_update_login => FND_GLOBAL.conc_login_id,
9743: p_attribute_category => p_time_alloc_rec.attribute_category,
9744: p_attribute1 => p_time_alloc_rec.attribute1,
9745: p_attribute2 => p_time_alloc_rec.attribute2,
9746: p_attribute3 => p_time_alloc_rec.attribute3,

Line 9885: aa.last_updated_by = FND_GLOBAL.USER_ID,

9881: AND ti.ALLOCATION_FOR_ID = aa.account_allocation_id
9882: ),
9883: aa.object_version_number = aa.object_version_number + 1,
9884: aa.last_update_date = SYSDATE,
9885: aa.last_updated_by = FND_GLOBAL.USER_ID,
9886: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9887: WHERE
9888: (aa.account_allocation_id = l_account_allocation_id)
9889: OR

Line 9886: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

9882: ),
9883: aa.object_version_number = aa.object_version_number + 1,
9884: aa.last_update_date = SYSDATE,
9885: aa.last_updated_by = FND_GLOBAL.USER_ID,
9886: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9887: WHERE
9888: (aa.account_allocation_id = l_account_allocation_id)
9889: OR
9890: (

Line 9923: p_created_by => FND_GLOBAL.USER_ID,

9919: p_lysp_sales => p_prod_alloc_rec.lysp_sales,
9920: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
9921: px_object_version_number => l_object_version_number,
9922: p_creation_date => SYSDATE,
9923: p_created_by => FND_GLOBAL.USER_ID,
9924: p_last_update_date => SYSDATE,
9925: p_last_updated_by => FND_GLOBAL.USER_ID,
9926: p_last_update_login => FND_GLOBAL.conc_login_id,
9927: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 9925: p_last_updated_by => FND_GLOBAL.USER_ID,

9921: px_object_version_number => l_object_version_number,
9922: p_creation_date => SYSDATE,
9923: p_created_by => FND_GLOBAL.USER_ID,
9924: p_last_update_date => SYSDATE,
9925: p_last_updated_by => FND_GLOBAL.USER_ID,
9926: p_last_update_login => FND_GLOBAL.conc_login_id,
9927: p_attribute_category => p_prod_alloc_rec.attribute_category,
9928: p_attribute1 => p_prod_alloc_rec.attribute1,
9929: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 9926: p_last_update_login => FND_GLOBAL.conc_login_id,

9922: p_creation_date => SYSDATE,
9923: p_created_by => FND_GLOBAL.USER_ID,
9924: p_last_update_date => SYSDATE,
9925: p_last_updated_by => FND_GLOBAL.USER_ID,
9926: p_last_update_login => FND_GLOBAL.conc_login_id,
9927: p_attribute_category => p_prod_alloc_rec.attribute_category,
9928: p_attribute1 => p_prod_alloc_rec.attribute1,
9929: p_attribute2 => p_prod_alloc_rec.attribute2,
9930: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 9960: p_created_by => FND_GLOBAL.USER_ID,

9956: p_target => p_time_alloc_rec.target,
9957: p_lysp_sales => p_time_alloc_rec.lysp_sales,
9958: px_object_version_number => l_object_version_number,
9959: p_creation_date => SYSDATE,
9960: p_created_by => FND_GLOBAL.USER_ID,
9961: p_last_update_date => SYSDATE,
9962: p_last_updated_by => FND_GLOBAL.USER_ID,
9963: p_last_update_login => FND_GLOBAL.conc_login_id,
9964: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 9962: p_last_updated_by => FND_GLOBAL.USER_ID,

9958: px_object_version_number => l_object_version_number,
9959: p_creation_date => SYSDATE,
9960: p_created_by => FND_GLOBAL.USER_ID,
9961: p_last_update_date => SYSDATE,
9962: p_last_updated_by => FND_GLOBAL.USER_ID,
9963: p_last_update_login => FND_GLOBAL.conc_login_id,
9964: p_attribute_category => p_time_alloc_rec.attribute_category,
9965: p_attribute1 => p_time_alloc_rec.attribute1,
9966: p_attribute2 => p_time_alloc_rec.attribute2,

Line 9963: p_last_update_login => FND_GLOBAL.conc_login_id,

9959: p_creation_date => SYSDATE,
9960: p_created_by => FND_GLOBAL.USER_ID,
9961: p_last_update_date => SYSDATE,
9962: p_last_updated_by => FND_GLOBAL.USER_ID,
9963: p_last_update_login => FND_GLOBAL.conc_login_id,
9964: p_attribute_category => p_time_alloc_rec.attribute_category,
9965: p_attribute1 => p_time_alloc_rec.attribute1,
9966: p_attribute2 => p_time_alloc_rec.attribute2,
9967: p_attribute3 => p_time_alloc_rec.attribute3,

Line 10019: p.last_updated_by = FND_GLOBAL.USER_ID,

10015: WHERE ti.ALLOCATION_FOR = 'PROD'
10016: AND ti.ALLOCATION_FOR_ID = p.product_allocation_id),
10017: p.object_version_number = p.object_version_number + 1,
10018: p.last_update_date = SYSDATE,
10019: p.last_updated_by = FND_GLOBAL.USER_ID,
10020: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10021: WHERE p.product_allocation_id = l_product_allocation_id;
10022:
10023: END LOOP; --- FOR p_prod_alloc_rec IN corr_prod_alloc_rec

Line 10020: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

10016: AND ti.ALLOCATION_FOR_ID = p.product_allocation_id),
10017: p.object_version_number = p.object_version_number + 1,
10018: p.last_update_date = SYSDATE,
10019: p.last_updated_by = FND_GLOBAL.USER_ID,
10020: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10021: WHERE p.product_allocation_id = l_product_allocation_id;
10022:
10023: END LOOP; --- FOR p_prod_alloc_rec IN corr_prod_alloc_rec
10024:

Line 10060: p_created_by => FND_GLOBAL.USER_ID,

10056: p_lysp_sales => p_prod_alloc_rec.lysp_sales,
10057: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
10058: px_object_version_number => l_object_version_number,
10059: p_creation_date => SYSDATE,
10060: p_created_by => FND_GLOBAL.USER_ID,
10061: p_last_update_date => SYSDATE,
10062: p_last_updated_by => FND_GLOBAL.USER_ID,
10063: p_last_update_login => FND_GLOBAL.conc_login_id,
10064: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 10062: p_last_updated_by => FND_GLOBAL.USER_ID,

10058: px_object_version_number => l_object_version_number,
10059: p_creation_date => SYSDATE,
10060: p_created_by => FND_GLOBAL.USER_ID,
10061: p_last_update_date => SYSDATE,
10062: p_last_updated_by => FND_GLOBAL.USER_ID,
10063: p_last_update_login => FND_GLOBAL.conc_login_id,
10064: p_attribute_category => p_prod_alloc_rec.attribute_category,
10065: p_attribute1 => p_prod_alloc_rec.attribute1,
10066: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 10063: p_last_update_login => FND_GLOBAL.conc_login_id,

10059: p_creation_date => SYSDATE,
10060: p_created_by => FND_GLOBAL.USER_ID,
10061: p_last_update_date => SYSDATE,
10062: p_last_updated_by => FND_GLOBAL.USER_ID,
10063: p_last_update_login => FND_GLOBAL.conc_login_id,
10064: p_attribute_category => p_prod_alloc_rec.attribute_category,
10065: p_attribute1 => p_prod_alloc_rec.attribute1,
10066: p_attribute2 => p_prod_alloc_rec.attribute2,
10067: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 10145: p_created_by => FND_GLOBAL.USER_ID,

10141: p_target => p_time_alloc_rec.target,
10142: p_lysp_sales => p_time_alloc_rec.lysp_sales,
10143: px_object_version_number => l_object_version_number,
10144: p_creation_date => SYSDATE,
10145: p_created_by => FND_GLOBAL.USER_ID,
10146: p_last_update_date => SYSDATE,
10147: p_last_updated_by => FND_GLOBAL.USER_ID,
10148: p_last_update_login => FND_GLOBAL.conc_login_id,
10149: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 10147: p_last_updated_by => FND_GLOBAL.USER_ID,

10143: px_object_version_number => l_object_version_number,
10144: p_creation_date => SYSDATE,
10145: p_created_by => FND_GLOBAL.USER_ID,
10146: p_last_update_date => SYSDATE,
10147: p_last_updated_by => FND_GLOBAL.USER_ID,
10148: p_last_update_login => FND_GLOBAL.conc_login_id,
10149: p_attribute_category => p_time_alloc_rec.attribute_category,
10150: p_attribute1 => p_time_alloc_rec.attribute1,
10151: p_attribute2 => p_time_alloc_rec.attribute2,

Line 10148: p_last_update_login => FND_GLOBAL.conc_login_id,

10144: p_creation_date => SYSDATE,
10145: p_created_by => FND_GLOBAL.USER_ID,
10146: p_last_update_date => SYSDATE,
10147: p_last_updated_by => FND_GLOBAL.USER_ID,
10148: p_last_update_login => FND_GLOBAL.conc_login_id,
10149: p_attribute_category => p_time_alloc_rec.attribute_category,
10150: p_attribute1 => p_time_alloc_rec.attribute1,
10151: p_attribute2 => p_time_alloc_rec.attribute2,
10152: p_attribute3 => p_time_alloc_rec.attribute3,

Line 10179: p.last_updated_by = FND_GLOBAL.USER_ID,

10175: UPDATE OZF_PRODUCT_ALLOCATIONS p
10176: SET p.lysp_sales = l_total_product_sales,
10177: p.object_version_number = p.object_version_number + 1,
10178: p.last_update_date = SYSDATE,
10179: p.last_updated_by = FND_GLOBAL.USER_ID,
10180: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10181: WHERE p.product_allocation_id = l_product_allocation_id;
10182:
10183: END LOOP account_product_loop;

Line 10180: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

10176: SET p.lysp_sales = l_total_product_sales,
10177: p.object_version_number = p.object_version_number + 1,
10178: p.last_update_date = SYSDATE,
10179: p.last_updated_by = FND_GLOBAL.USER_ID,
10180: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10181: WHERE p.product_allocation_id = l_product_allocation_id;
10182:
10183: END LOOP account_product_loop;
10184:

Line 10366: aa.last_updated_by = FND_GLOBAL.USER_ID,

10362: AND ti.ALLOCATION_FOR_ID = aa.account_allocation_id
10363: ),
10364: aa.object_version_number = aa.object_version_number + 1,
10365: aa.last_update_date = SYSDATE,
10366: aa.last_updated_by = FND_GLOBAL.USER_ID,
10367: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10368: WHERE aa.account_allocation_id = l_unalloc_acct_alloc_id;
10369: END;
10370:

Line 10367: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

10363: ),
10364: aa.object_version_number = aa.object_version_number + 1,
10365: aa.last_update_date = SYSDATE,
10366: aa.last_updated_by = FND_GLOBAL.USER_ID,
10367: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10368: WHERE aa.account_allocation_id = l_unalloc_acct_alloc_id;
10369: END;
10370:
10371: -- 2. ADJUSTING SHIP TO Time records. - Curr and Future Periods ...

Line 10413: aa.last_updated_by = FND_GLOBAL.USER_ID,

10409: ),
10410: aa.account_status = 'D',
10411: aa.object_version_number = aa.object_version_number + 1,
10412: aa.last_update_date = SYSDATE,
10413: aa.last_updated_by = FND_GLOBAL.USER_ID,
10414: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10415: WHERE
10416: aa.account_allocation_id = l_account_allocation_id;
10417: END;

Line 10414: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

10410: aa.account_status = 'D',
10411: aa.object_version_number = aa.object_version_number + 1,
10412: aa.last_update_date = SYSDATE,
10413: aa.last_updated_by = FND_GLOBAL.USER_ID,
10414: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10415: WHERE
10416: aa.account_allocation_id = l_account_allocation_id;
10417: END;
10418:

Line 10464: p.last_updated_by = FND_GLOBAL.USER_ID,

10460: AND ti.ALLOCATION_FOR_ID = p.product_allocation_id),
10461: p.account_status = 'D',
10462: p.object_version_number = p.object_version_number + 1,
10463: p.last_update_date = SYSDATE,
10464: p.last_updated_by = FND_GLOBAL.USER_ID,
10465: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10466: WHERE p.product_allocation_id IN (
10467: SELECT pp.product_allocation_id
10468: FROM ozf_product_allocations pp

Line 10465: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

10461: p.account_status = 'D',
10462: p.object_version_number = p.object_version_number + 1,
10463: p.last_update_date = SYSDATE,
10464: p.last_updated_by = FND_GLOBAL.USER_ID,
10465: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10466: WHERE p.product_allocation_id IN (
10467: SELECT pp.product_allocation_id
10468: FROM ozf_product_allocations pp
10469: WHERE pp.allocation_for = 'CUST'