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 691: t.last_updated_by = FND_GLOBAL.USER_ID,

687: UPDATE OZF_TIME_ALLOCATIONS t
688: SET t.TARGET = t.TARGET + l_diff_target,
689: t.object_version_number = t.object_version_number + 1,
690: t.last_update_date = SYSDATE,
691: t.last_updated_by = FND_GLOBAL.USER_ID,
692: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
693: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
694: FROM OZF_TIME_ALLOCATIONS x
695: WHERE x.allocation_for = 'PROD'

Line 692: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

688: SET t.TARGET = t.TARGET + l_diff_target,
689: t.object_version_number = t.object_version_number + 1,
690: t.last_update_date = SYSDATE,
691: t.last_updated_by = FND_GLOBAL.USER_ID,
692: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
693: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
694: FROM OZF_TIME_ALLOCATIONS x
695: WHERE x.allocation_for = 'PROD'
696: AND x.allocation_for_id IN ( SELECT max(p.product_allocation_id)

Line 743: p.last_updated_by = FND_GLOBAL.USER_ID,

739: UPDATE OZF_PRODUCT_ALLOCATIONS p
740: SET p.TARGET = p.TARGET + l_diff_target,
741: p.object_version_number = p.object_version_number + 1,
742: p.last_update_date = SYSDATE,
743: p.last_updated_by = FND_GLOBAL.USER_ID,
744: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
745: WHERE p.product_allocation_id = l_temp_product_allocation_id;
746:
747: IF (SQL%NOTFOUND) THEN

Line 744: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

740: SET p.TARGET = p.TARGET + l_diff_target,
741: p.object_version_number = p.object_version_number + 1,
742: p.last_update_date = SYSDATE,
743: p.last_updated_by = FND_GLOBAL.USER_ID,
744: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
745: WHERE p.product_allocation_id = l_temp_product_allocation_id;
746:
747: IF (SQL%NOTFOUND) THEN
748: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 762: t.last_updated_by = FND_GLOBAL.USER_ID,

758: UPDATE OZF_TIME_ALLOCATIONS t
759: SET t.TARGET = t.TARGET + l_diff_target,
760: t.object_version_number = t.object_version_number + 1,
761: t.last_update_date = SYSDATE,
762: t.last_updated_by = FND_GLOBAL.USER_ID,
763: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
764: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
765: WHERE x.allocation_for = 'PROD'
766: AND x.allocation_for_id IN ( SELECT p.product_allocation_id

Line 763: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

759: SET t.TARGET = t.TARGET + l_diff_target,
760: t.object_version_number = t.object_version_number + 1,
761: t.last_update_date = SYSDATE,
762: t.last_updated_by = FND_GLOBAL.USER_ID,
763: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
764: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
765: WHERE x.allocation_for = 'PROD'
766: AND x.allocation_for_id IN ( SELECT p.product_allocation_id
767: FROM OZF_PRODUCT_ALLOCATIONS p

Line 786: p.last_updated_by = FND_GLOBAL.USER_ID,

782: UPDATE OZF_PRODUCT_ALLOCATIONS p
783: SET p.TARGET = p.TARGET + l_diff_target,
784: p.object_version_number = p.object_version_number + 1,
785: p.last_update_date = SYSDATE,
786: p.last_updated_by = FND_GLOBAL.USER_ID,
787: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
788: WHERE p.allocation_for = 'CUST'
789: AND p.allocation_for_id = l_account_allocation_id
790: AND p.item_id = -9999;

Line 787: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

783: SET p.TARGET = p.TARGET + l_diff_target,
784: p.object_version_number = p.object_version_number + 1,
785: p.last_update_date = SYSDATE,
786: p.last_updated_by = FND_GLOBAL.USER_ID,
787: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
788: WHERE p.allocation_for = 'CUST'
789: AND p.allocation_for_id = l_account_allocation_id
790: AND p.item_id = -9999;
791:

Line 1261: p_created_by => FND_GLOBAL.USER_ID,

1257: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
1258: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
1259: px_object_version_number => l_object_version_number,
1260: p_creation_date => SYSDATE,
1261: p_created_by => FND_GLOBAL.USER_ID,
1262: p_last_update_date => SYSDATE,
1263: p_last_updated_by => FND_GLOBAL.USER_ID,
1264: p_last_update_login => FND_GLOBAL.conc_login_id,
1265: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 1263: p_last_updated_by => FND_GLOBAL.USER_ID,

1259: px_object_version_number => l_object_version_number,
1260: p_creation_date => SYSDATE,
1261: p_created_by => FND_GLOBAL.USER_ID,
1262: p_last_update_date => SYSDATE,
1263: p_last_updated_by => FND_GLOBAL.USER_ID,
1264: p_last_update_login => FND_GLOBAL.conc_login_id,
1265: p_attribute_category => p_prod_alloc_rec.attribute_category,
1266: p_attribute1 => p_prod_alloc_rec.attribute1,
1267: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 1264: p_last_update_login => FND_GLOBAL.conc_login_id,

1260: p_creation_date => SYSDATE,
1261: p_created_by => FND_GLOBAL.USER_ID,
1262: p_last_update_date => SYSDATE,
1263: p_last_updated_by => FND_GLOBAL.USER_ID,
1264: p_last_update_login => FND_GLOBAL.conc_login_id,
1265: p_attribute_category => p_prod_alloc_rec.attribute_category,
1266: p_attribute1 => p_prod_alloc_rec.attribute1,
1267: p_attribute2 => p_prod_alloc_rec.attribute2,
1268: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 1354: p_created_by => FND_GLOBAL.USER_ID,

1350: p_target => NVL(p_time_alloc_rec.target, 0),
1351: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
1352: px_object_version_number => l_object_version_number,
1353: p_creation_date => SYSDATE,
1354: p_created_by => FND_GLOBAL.USER_ID,
1355: p_last_update_date => SYSDATE,
1356: p_last_updated_by => FND_GLOBAL.USER_ID,
1357: p_last_update_login => FND_GLOBAL.conc_login_id,
1358: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 1356: p_last_updated_by => FND_GLOBAL.USER_ID,

1352: px_object_version_number => l_object_version_number,
1353: p_creation_date => SYSDATE,
1354: p_created_by => FND_GLOBAL.USER_ID,
1355: p_last_update_date => SYSDATE,
1356: p_last_updated_by => FND_GLOBAL.USER_ID,
1357: p_last_update_login => FND_GLOBAL.conc_login_id,
1358: p_attribute_category => p_time_alloc_rec.attribute_category,
1359: p_attribute1 => p_time_alloc_rec.attribute1,
1360: p_attribute2 => p_time_alloc_rec.attribute2,

Line 1357: p_last_update_login => FND_GLOBAL.conc_login_id,

1353: p_creation_date => SYSDATE,
1354: p_created_by => FND_GLOBAL.USER_ID,
1355: p_last_update_date => SYSDATE,
1356: p_last_updated_by => FND_GLOBAL.USER_ID,
1357: p_last_update_login => FND_GLOBAL.conc_login_id,
1358: p_attribute_category => p_time_alloc_rec.attribute_category,
1359: p_attribute1 => p_time_alloc_rec.attribute1,
1360: p_attribute2 => p_time_alloc_rec.attribute2,
1361: p_attribute3 => p_time_alloc_rec.attribute3,

Line 1386: p.last_updated_by = FND_GLOBAL.USER_ID,

1382: SET p.lysp_sales = l_total_lysp_sales,
1383: p.target = ROUND( l_total_quota, 0),
1384: p.object_version_number = p.object_version_number + 1,
1385: p.last_update_date = SYSDATE,
1386: p.last_updated_by = FND_GLOBAL.USER_ID,
1387: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1388: WHERE p.product_allocation_id = l_product_allocation_id;
1389:
1390: END LOOP;

Line 1387: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

1383: p.target = ROUND( l_total_quota, 0),
1384: p.object_version_number = p.object_version_number + 1,
1385: p.last_update_date = SYSDATE,
1386: p.last_updated_by = FND_GLOBAL.USER_ID,
1387: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1388: WHERE p.product_allocation_id = l_product_allocation_id;
1389:
1390: END LOOP;
1391:

Line 1419: t.last_updated_by = FND_GLOBAL.USER_ID,

1415: UPDATE OZF_TIME_ALLOCATIONS t
1416: SET t.TARGET = t.TARGET + l_diff_target,
1417: t.object_version_number = t.object_version_number + 1,
1418: t.last_update_date = SYSDATE,
1419: t.last_updated_by = FND_GLOBAL.USER_ID,
1420: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1421: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
1422: WHERE x.allocation_for = 'PROD'
1423: AND x.allocation_for_id IN ( SELECT p.product_allocation_id

Line 1420: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

1416: SET t.TARGET = t.TARGET + l_diff_target,
1417: t.object_version_number = t.object_version_number + 1,
1418: t.last_update_date = SYSDATE,
1419: t.last_updated_by = FND_GLOBAL.USER_ID,
1420: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1421: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
1422: WHERE x.allocation_for = 'PROD'
1423: AND x.allocation_for_id IN ( SELECT p.product_allocation_id
1424: FROM OZF_PRODUCT_ALLOCATIONS p

Line 1445: p.last_updated_by = FND_GLOBAL.USER_ID,

1441: UPDATE OZF_PRODUCT_ALLOCATIONS p
1442: SET p.TARGET = p.TARGET + l_diff_target,
1443: p.object_version_number = p.object_version_number + 1,
1444: p.last_update_date = SYSDATE,
1445: p.last_updated_by = FND_GLOBAL.USER_ID,
1446: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1447: WHERE p.allocation_for = 'FACT'
1448: AND p.allocation_for_id = l_fact_id
1449: AND p.item_id = -9999;

Line 1446: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

1442: SET p.TARGET = p.TARGET + l_diff_target,
1443: p.object_version_number = p.object_version_number + 1,
1444: p.last_update_date = SYSDATE,
1445: p.last_updated_by = FND_GLOBAL.USER_ID,
1446: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1447: WHERE p.allocation_for = 'FACT'
1448: AND p.allocation_for_id = l_fact_id
1449: AND p.item_id = -9999;
1450:

Line 1980: p_created_by => FND_GLOBAL.USER_ID,

1976: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
1977: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
1978: px_object_version_number => l_object_version_number,
1979: p_creation_date => SYSDATE,
1980: p_created_by => FND_GLOBAL.USER_ID,
1981: p_last_update_date => SYSDATE,
1982: p_last_updated_by => FND_GLOBAL.USER_ID,
1983: p_last_update_login => FND_GLOBAL.conc_login_id,
1984: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 1982: p_last_updated_by => FND_GLOBAL.USER_ID,

1978: px_object_version_number => l_object_version_number,
1979: p_creation_date => SYSDATE,
1980: p_created_by => FND_GLOBAL.USER_ID,
1981: p_last_update_date => SYSDATE,
1982: p_last_updated_by => FND_GLOBAL.USER_ID,
1983: p_last_update_login => FND_GLOBAL.conc_login_id,
1984: p_attribute_category => p_prod_alloc_rec.attribute_category,
1985: p_attribute1 => p_prod_alloc_rec.attribute1,
1986: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 1983: p_last_update_login => FND_GLOBAL.conc_login_id,

1979: p_creation_date => SYSDATE,
1980: p_created_by => FND_GLOBAL.USER_ID,
1981: p_last_update_date => SYSDATE,
1982: p_last_updated_by => FND_GLOBAL.USER_ID,
1983: p_last_update_login => FND_GLOBAL.conc_login_id,
1984: p_attribute_category => p_prod_alloc_rec.attribute_category,
1985: p_attribute1 => p_prod_alloc_rec.attribute1,
1986: p_attribute2 => p_prod_alloc_rec.attribute2,
1987: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 2077: p_created_by => FND_GLOBAL.USER_ID,

2073: p_target => NVL(p_time_alloc_rec.target, 0),
2074: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
2075: px_object_version_number => l_object_version_number,
2076: p_creation_date => SYSDATE,
2077: p_created_by => FND_GLOBAL.USER_ID,
2078: p_last_update_date => SYSDATE,
2079: p_last_updated_by => FND_GLOBAL.USER_ID,
2080: p_last_update_login => FND_GLOBAL.conc_login_id,
2081: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 2079: p_last_updated_by => FND_GLOBAL.USER_ID,

2075: px_object_version_number => l_object_version_number,
2076: p_creation_date => SYSDATE,
2077: p_created_by => FND_GLOBAL.USER_ID,
2078: p_last_update_date => SYSDATE,
2079: p_last_updated_by => FND_GLOBAL.USER_ID,
2080: p_last_update_login => FND_GLOBAL.conc_login_id,
2081: p_attribute_category => p_time_alloc_rec.attribute_category,
2082: p_attribute1 => p_time_alloc_rec.attribute1,
2083: p_attribute2 => p_time_alloc_rec.attribute2,

Line 2080: p_last_update_login => FND_GLOBAL.conc_login_id,

2076: p_creation_date => SYSDATE,
2077: p_created_by => FND_GLOBAL.USER_ID,
2078: p_last_update_date => SYSDATE,
2079: p_last_updated_by => FND_GLOBAL.USER_ID,
2080: p_last_update_login => FND_GLOBAL.conc_login_id,
2081: p_attribute_category => p_time_alloc_rec.attribute_category,
2082: p_attribute1 => p_time_alloc_rec.attribute1,
2083: p_attribute2 => p_time_alloc_rec.attribute2,
2084: p_attribute3 => p_time_alloc_rec.attribute3,

Line 2108: p.last_updated_by = FND_GLOBAL.USER_ID,

2104: UPDATE OZF_PRODUCT_ALLOCATIONS p
2105: SET p.lysp_sales = l_total_lysp_sales,
2106: p.object_version_number = p.object_version_number + 1,
2107: p.last_update_date = SYSDATE,
2108: p.last_updated_by = FND_GLOBAL.USER_ID,
2109: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2110: WHERE p.product_allocation_id = l_product_allocation_id;
2111:
2112: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;

Line 2109: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2105: SET p.lysp_sales = l_total_lysp_sales,
2106: p.object_version_number = p.object_version_number + 1,
2107: p.last_update_date = SYSDATE,
2108: p.last_updated_by = FND_GLOBAL.USER_ID,
2109: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2110: WHERE p.product_allocation_id = l_product_allocation_id;
2111:
2112: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;
2113:

Line 2132: t.last_updated_by = FND_GLOBAL.USER_ID,

2128: UPDATE OZF_TIME_ALLOCATIONS t
2129: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_multiplying_factor), 0),
2130: t.object_version_number = t.object_version_number + 1,
2131: t.last_update_date = SYSDATE,
2132: t.last_updated_by = FND_GLOBAL.USER_ID,
2133: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2134: WHERE t.allocation_for = 'PROD'
2135: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
2136: FROM OZF_PRODUCT_ALLOCATIONS p

Line 2133: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2129: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_multiplying_factor), 0),
2130: t.object_version_number = t.object_version_number + 1,
2131: t.last_update_date = SYSDATE,
2132: t.last_updated_by = FND_GLOBAL.USER_ID,
2133: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2134: WHERE t.allocation_for = 'PROD'
2135: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
2136: FROM OZF_PRODUCT_ALLOCATIONS p
2137: WHERE p.allocation_for = 'FACT'

Line 2156: p.last_updated_by = FND_GLOBAL.USER_ID,

2152: WHERE ti.ALLOCATION_FOR = 'PROD'
2153: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
2154: p.object_version_number = p.object_version_number + 1,
2155: p.last_update_date = SYSDATE,
2156: p.last_updated_by = FND_GLOBAL.USER_ID,
2157: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2158: WHERE p.allocation_for = 'FACT'
2159: AND p.allocation_for_id = l_fact_id;
2160:

Line 2157: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2153: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
2154: p.object_version_number = p.object_version_number + 1,
2155: p.last_update_date = SYSDATE,
2156: p.last_updated_by = FND_GLOBAL.USER_ID,
2157: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2158: WHERE p.allocation_for = 'FACT'
2159: AND p.allocation_for_id = l_fact_id;
2160:
2161: IF (SQL%NOTFOUND) THEN

Line 2185: p.last_updated_by = FND_GLOBAL.USER_ID,

2181: UPDATE OZF_PRODUCT_ALLOCATIONS p
2182: SET p.TARGET = ROUND(NVL(l_fact_rec.recommend_total_amount, 0),0),
2183: p.object_version_number = p.object_version_number + 1,
2184: p.last_update_date = SYSDATE,
2185: p.last_updated_by = FND_GLOBAL.USER_ID,
2186: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2187: WHERE p.allocation_for = 'FACT'
2188: AND p.allocation_for_id = l_fact_id
2189: AND p.item_id = -9999;

Line 2186: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2182: SET p.TARGET = ROUND(NVL(l_fact_rec.recommend_total_amount, 0),0),
2183: p.object_version_number = p.object_version_number + 1,
2184: p.last_update_date = SYSDATE,
2185: p.last_updated_by = FND_GLOBAL.USER_ID,
2186: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2187: WHERE p.allocation_for = 'FACT'
2188: AND p.allocation_for_id = l_fact_id
2189: AND p.item_id = -9999;
2190:

Line 2204: t.last_updated_by = FND_GLOBAL.USER_ID,

2200: UPDATE OZF_TIME_ALLOCATIONS t
2201: SET t.TARGET = ROUND((NVL(l_fact_rec.recommend_total_amount, 0) / l_denominator), 0),
2202: t.object_version_number = t.object_version_number + 1,
2203: t.last_update_date = SYSDATE,
2204: t.last_updated_by = FND_GLOBAL.USER_ID,
2205: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2206: WHERE t.allocation_for = 'PROD'
2207: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
2208: FROM OZF_PRODUCT_ALLOCATIONS p

Line 2205: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2201: SET t.TARGET = ROUND((NVL(l_fact_rec.recommend_total_amount, 0) / l_denominator), 0),
2202: t.object_version_number = t.object_version_number + 1,
2203: t.last_update_date = SYSDATE,
2204: t.last_updated_by = FND_GLOBAL.USER_ID,
2205: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2206: WHERE t.allocation_for = 'PROD'
2207: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
2208: FROM OZF_PRODUCT_ALLOCATIONS p
2209: WHERE p.allocation_for = 'FACT'

Line 2228: p.last_updated_by = FND_GLOBAL.USER_ID,

2224: WHERE ti.ALLOCATION_FOR = 'PROD'
2225: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
2226: p.object_version_number = p.object_version_number + 1,
2227: p.last_update_date = SYSDATE,
2228: p.last_updated_by = FND_GLOBAL.USER_ID,
2229: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2230: WHERE p.allocation_for = 'FACT'
2231: AND p.allocation_for_id = l_fact_id
2232: AND p.item_id = -9999;

Line 2229: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2225: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
2226: p.object_version_number = p.object_version_number + 1,
2227: p.last_update_date = SYSDATE,
2228: p.last_updated_by = FND_GLOBAL.USER_ID,
2229: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2230: WHERE p.allocation_for = 'FACT'
2231: AND p.allocation_for_id = l_fact_id
2232: AND p.item_id = -9999;
2233:

Line 2282: t.last_updated_by = FND_GLOBAL.USER_ID,

2278: UPDATE OZF_TIME_ALLOCATIONS t
2279: SET t.TARGET = t.TARGET + l_diff_target,
2280: t.object_version_number = t.object_version_number + 1,
2281: t.last_update_date = SYSDATE,
2282: t.last_updated_by = FND_GLOBAL.USER_ID,
2283: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2284: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
2285: WHERE x.allocation_for = 'PROD'
2286: AND x.allocation_for_id IN ( SELECT p.product_allocation_id

Line 2283: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2279: SET t.TARGET = t.TARGET + l_diff_target,
2280: t.object_version_number = t.object_version_number + 1,
2281: t.last_update_date = SYSDATE,
2282: t.last_updated_by = FND_GLOBAL.USER_ID,
2283: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2284: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
2285: WHERE x.allocation_for = 'PROD'
2286: AND x.allocation_for_id IN ( SELECT p.product_allocation_id
2287: FROM OZF_PRODUCT_ALLOCATIONS p

Line 2306: p.last_updated_by = FND_GLOBAL.USER_ID,

2302: UPDATE OZF_PRODUCT_ALLOCATIONS p
2303: SET p.TARGET = p.TARGET + l_diff_target,
2304: p.object_version_number = p.object_version_number + 1,
2305: p.last_update_date = SYSDATE,
2306: p.last_updated_by = FND_GLOBAL.USER_ID,
2307: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2308: WHERE p.allocation_for = 'FACT'
2309: AND p.allocation_for_id = l_fact_id
2310: AND p.item_id = -9999;

Line 2307: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2303: SET p.TARGET = p.TARGET + l_diff_target,
2304: p.object_version_number = p.object_version_number + 1,
2305: p.last_update_date = SYSDATE,
2306: p.last_updated_by = FND_GLOBAL.USER_ID,
2307: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2308: WHERE p.allocation_for = 'FACT'
2309: AND p.allocation_for_id = l_fact_id
2310: AND p.item_id = -9999;
2311:

Line 2751: p_created_by => FND_GLOBAL.USER_ID,

2747: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
2748: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
2749: px_object_version_number => l_object_version_number,
2750: p_creation_date => SYSDATE,
2751: p_created_by => FND_GLOBAL.USER_ID,
2752: p_last_update_date => SYSDATE,
2753: p_last_updated_by => FND_GLOBAL.USER_ID,
2754: p_last_update_login => FND_GLOBAL.conc_login_id,
2755: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 2753: p_last_updated_by => FND_GLOBAL.USER_ID,

2749: px_object_version_number => l_object_version_number,
2750: p_creation_date => SYSDATE,
2751: p_created_by => FND_GLOBAL.USER_ID,
2752: p_last_update_date => SYSDATE,
2753: p_last_updated_by => FND_GLOBAL.USER_ID,
2754: p_last_update_login => FND_GLOBAL.conc_login_id,
2755: p_attribute_category => p_prod_alloc_rec.attribute_category,
2756: p_attribute1 => p_prod_alloc_rec.attribute1,
2757: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 2754: p_last_update_login => FND_GLOBAL.conc_login_id,

2750: p_creation_date => SYSDATE,
2751: p_created_by => FND_GLOBAL.USER_ID,
2752: p_last_update_date => SYSDATE,
2753: p_last_updated_by => FND_GLOBAL.USER_ID,
2754: p_last_update_login => FND_GLOBAL.conc_login_id,
2755: p_attribute_category => p_prod_alloc_rec.attribute_category,
2756: p_attribute1 => p_prod_alloc_rec.attribute1,
2757: p_attribute2 => p_prod_alloc_rec.attribute2,
2758: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 2815: p_created_by => FND_GLOBAL.USER_ID,

2811: p_target =>NVL( p_time_alloc_rec.target, 0),
2812: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
2813: px_object_version_number => l_object_version_number,
2814: p_creation_date => SYSDATE,
2815: p_created_by => FND_GLOBAL.USER_ID,
2816: p_last_update_date => SYSDATE,
2817: p_last_updated_by => FND_GLOBAL.USER_ID,
2818: p_last_update_login => FND_GLOBAL.conc_login_id,
2819: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 2817: p_last_updated_by => FND_GLOBAL.USER_ID,

2813: px_object_version_number => l_object_version_number,
2814: p_creation_date => SYSDATE,
2815: p_created_by => FND_GLOBAL.USER_ID,
2816: p_last_update_date => SYSDATE,
2817: p_last_updated_by => FND_GLOBAL.USER_ID,
2818: p_last_update_login => FND_GLOBAL.conc_login_id,
2819: p_attribute_category => p_time_alloc_rec.attribute_category,
2820: p_attribute1 => p_time_alloc_rec.attribute1,
2821: p_attribute2 => p_time_alloc_rec.attribute2,

Line 2818: p_last_update_login => FND_GLOBAL.conc_login_id,

2814: p_creation_date => SYSDATE,
2815: p_created_by => FND_GLOBAL.USER_ID,
2816: p_last_update_date => SYSDATE,
2817: p_last_updated_by => FND_GLOBAL.USER_ID,
2818: p_last_update_login => FND_GLOBAL.conc_login_id,
2819: p_attribute_category => p_time_alloc_rec.attribute_category,
2820: p_attribute1 => p_time_alloc_rec.attribute1,
2821: p_attribute2 => p_time_alloc_rec.attribute2,
2822: p_attribute3 => p_time_alloc_rec.attribute3,

Line 2846: p.last_updated_by = FND_GLOBAL.USER_ID,

2842: UPDATE OZF_PRODUCT_ALLOCATIONS p
2843: SET p.lysp_sales = NVL(l_total_lysp_sales,0),
2844: p.object_version_number = p.object_version_number + 1,
2845: p.last_update_date = SYSDATE,
2846: p.last_updated_by = FND_GLOBAL.USER_ID,
2847: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2848: WHERE p.product_allocation_id = l_product_allocation_id;
2849:
2850: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;

Line 2847: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2843: SET p.lysp_sales = NVL(l_total_lysp_sales,0),
2844: p.object_version_number = p.object_version_number + 1,
2845: p.last_update_date = SYSDATE,
2846: p.last_updated_by = FND_GLOBAL.USER_ID,
2847: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2848: WHERE p.product_allocation_id = l_product_allocation_id;
2849:
2850: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;
2851: END LOOP;

Line 2888: p_created_by => FND_GLOBAL.USER_ID,

2884: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
2885: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
2886: px_object_version_number => l_object_version_number,
2887: p_creation_date => SYSDATE,
2888: p_created_by => FND_GLOBAL.USER_ID,
2889: p_last_update_date => SYSDATE,
2890: p_last_updated_by => FND_GLOBAL.USER_ID,
2891: p_last_update_login => FND_GLOBAL.conc_login_id,
2892: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 2890: p_last_updated_by => FND_GLOBAL.USER_ID,

2886: px_object_version_number => l_object_version_number,
2887: p_creation_date => SYSDATE,
2888: p_created_by => FND_GLOBAL.USER_ID,
2889: p_last_update_date => SYSDATE,
2890: p_last_updated_by => FND_GLOBAL.USER_ID,
2891: p_last_update_login => FND_GLOBAL.conc_login_id,
2892: p_attribute_category => p_prod_alloc_rec.attribute_category,
2893: p_attribute1 => p_prod_alloc_rec.attribute1,
2894: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 2891: p_last_update_login => FND_GLOBAL.conc_login_id,

2887: p_creation_date => SYSDATE,
2888: p_created_by => FND_GLOBAL.USER_ID,
2889: p_last_update_date => SYSDATE,
2890: p_last_updated_by => FND_GLOBAL.USER_ID,
2891: p_last_update_login => FND_GLOBAL.conc_login_id,
2892: p_attribute_category => p_prod_alloc_rec.attribute_category,
2893: p_attribute1 => p_prod_alloc_rec.attribute1,
2894: p_attribute2 => p_prod_alloc_rec.attribute2,
2895: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 2952: p_created_by => FND_GLOBAL.USER_ID,

2948: p_target => NVL(p_time_alloc_rec.target, 0),
2949: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
2950: px_object_version_number => l_object_version_number,
2951: p_creation_date => SYSDATE,
2952: p_created_by => FND_GLOBAL.USER_ID,
2953: p_last_update_date => SYSDATE,
2954: p_last_updated_by => FND_GLOBAL.USER_ID,
2955: p_last_update_login => FND_GLOBAL.conc_login_id,
2956: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 2954: p_last_updated_by => FND_GLOBAL.USER_ID,

2950: px_object_version_number => l_object_version_number,
2951: p_creation_date => SYSDATE,
2952: p_created_by => FND_GLOBAL.USER_ID,
2953: p_last_update_date => SYSDATE,
2954: p_last_updated_by => FND_GLOBAL.USER_ID,
2955: p_last_update_login => FND_GLOBAL.conc_login_id,
2956: p_attribute_category => p_time_alloc_rec.attribute_category,
2957: p_attribute1 => p_time_alloc_rec.attribute1,
2958: p_attribute2 => p_time_alloc_rec.attribute2,

Line 2955: p_last_update_login => FND_GLOBAL.conc_login_id,

2951: p_creation_date => SYSDATE,
2952: p_created_by => FND_GLOBAL.USER_ID,
2953: p_last_update_date => SYSDATE,
2954: p_last_updated_by => FND_GLOBAL.USER_ID,
2955: p_last_update_login => FND_GLOBAL.conc_login_id,
2956: p_attribute_category => p_time_alloc_rec.attribute_category,
2957: p_attribute1 => p_time_alloc_rec.attribute1,
2958: p_attribute2 => p_time_alloc_rec.attribute2,
2959: p_attribute3 => p_time_alloc_rec.attribute3,

Line 2983: p.last_updated_by = FND_GLOBAL.USER_ID,

2979: UPDATE OZF_PRODUCT_ALLOCATIONS p
2980: SET p.lysp_sales = NVL(l_total_lysp_sales, 0),
2981: p.object_version_number = p.object_version_number + 1,
2982: p.last_update_date = SYSDATE,
2983: p.last_updated_by = FND_GLOBAL.USER_ID,
2984: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2985: WHERE p.product_allocation_id = l_product_allocation_id;
2986:
2987: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;

Line 2984: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

2980: SET p.lysp_sales = NVL(l_total_lysp_sales, 0),
2981: p.object_version_number = p.object_version_number + 1,
2982: p.last_update_date = SYSDATE,
2983: p.last_updated_by = FND_GLOBAL.USER_ID,
2984: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2985: WHERE p.product_allocation_id = l_product_allocation_id;
2986:
2987: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;
2988: END LOOP;

Line 3021: p_created_by => FND_GLOBAL.USER_ID,

3017: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
3018: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
3019: px_object_version_number => l_object_version_number,
3020: p_creation_date => SYSDATE,
3021: p_created_by => FND_GLOBAL.USER_ID,
3022: p_last_update_date => SYSDATE,
3023: p_last_updated_by => FND_GLOBAL.USER_ID,
3024: p_last_update_login => FND_GLOBAL.conc_login_id,
3025: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 3023: p_last_updated_by => FND_GLOBAL.USER_ID,

3019: px_object_version_number => l_object_version_number,
3020: p_creation_date => SYSDATE,
3021: p_created_by => FND_GLOBAL.USER_ID,
3022: p_last_update_date => SYSDATE,
3023: p_last_updated_by => FND_GLOBAL.USER_ID,
3024: p_last_update_login => FND_GLOBAL.conc_login_id,
3025: p_attribute_category => p_prod_alloc_rec.attribute_category,
3026: p_attribute1 => p_prod_alloc_rec.attribute1,
3027: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 3024: p_last_update_login => FND_GLOBAL.conc_login_id,

3020: p_creation_date => SYSDATE,
3021: p_created_by => FND_GLOBAL.USER_ID,
3022: p_last_update_date => SYSDATE,
3023: p_last_updated_by => FND_GLOBAL.USER_ID,
3024: p_last_update_login => FND_GLOBAL.conc_login_id,
3025: p_attribute_category => p_prod_alloc_rec.attribute_category,
3026: p_attribute1 => p_prod_alloc_rec.attribute1,
3027: p_attribute2 => p_prod_alloc_rec.attribute2,
3028: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 3083: p_created_by => FND_GLOBAL.USER_ID,

3079: p_target => NVL(p_time_alloc_rec.target, 0),
3080: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
3081: px_object_version_number => l_object_version_number,
3082: p_creation_date => SYSDATE,
3083: p_created_by => FND_GLOBAL.USER_ID,
3084: p_last_update_date => SYSDATE,
3085: p_last_updated_by => FND_GLOBAL.USER_ID,
3086: p_last_update_login => FND_GLOBAL.conc_login_id,
3087: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 3085: p_last_updated_by => FND_GLOBAL.USER_ID,

3081: px_object_version_number => l_object_version_number,
3082: p_creation_date => SYSDATE,
3083: p_created_by => FND_GLOBAL.USER_ID,
3084: p_last_update_date => SYSDATE,
3085: p_last_updated_by => FND_GLOBAL.USER_ID,
3086: p_last_update_login => FND_GLOBAL.conc_login_id,
3087: p_attribute_category => p_time_alloc_rec.attribute_category,
3088: p_attribute1 => p_time_alloc_rec.attribute1,
3089: p_attribute2 => p_time_alloc_rec.attribute2,

Line 3086: p_last_update_login => FND_GLOBAL.conc_login_id,

3082: p_creation_date => SYSDATE,
3083: p_created_by => FND_GLOBAL.USER_ID,
3084: p_last_update_date => SYSDATE,
3085: p_last_updated_by => FND_GLOBAL.USER_ID,
3086: p_last_update_login => FND_GLOBAL.conc_login_id,
3087: p_attribute_category => p_time_alloc_rec.attribute_category,
3088: p_attribute1 => p_time_alloc_rec.attribute1,
3089: p_attribute2 => p_time_alloc_rec.attribute2,
3090: p_attribute3 => p_time_alloc_rec.attribute3,

Line 3114: p.last_updated_by = FND_GLOBAL.USER_ID,

3110: UPDATE OZF_PRODUCT_ALLOCATIONS p
3111: SET p.lysp_sales = NVL(l_total_lysp_sales, 0),
3112: p.object_version_number = p.object_version_number + 1,
3113: p.last_update_date = SYSDATE,
3114: p.last_updated_by = FND_GLOBAL.USER_ID,
3115: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3116: WHERE p.product_allocation_id = l_product_allocation_id;
3117:
3118: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;

Line 3115: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3111: SET p.lysp_sales = NVL(l_total_lysp_sales, 0),
3112: p.object_version_number = p.object_version_number + 1,
3113: p.last_update_date = SYSDATE,
3114: p.last_updated_by = FND_GLOBAL.USER_ID,
3115: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3116: WHERE p.product_allocation_id = l_product_allocation_id;
3117:
3118: l_grand_total_lysp_sales := l_grand_total_lysp_sales + l_total_lysp_sales;
3119:

Line 3149: p.last_updated_by = FND_GLOBAL.USER_ID,

3145: UPDATE OZF_PRODUCT_ALLOCATIONS p
3146: SET p.TARGET = ROUND( (NVL(p.LYSP_SALES, 0) * l_multiplying_factor), 0),
3147: p.object_version_number = p.object_version_number + 1,
3148: p.last_update_date = SYSDATE,
3149: p.last_updated_by = FND_GLOBAL.USER_ID,
3150: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3151: WHERE p.allocation_for = 'FUND'
3152: AND p.allocation_for_id = l_fund_id;
3153:

Line 3150: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3146: SET p.TARGET = ROUND( (NVL(p.LYSP_SALES, 0) * l_multiplying_factor), 0),
3147: p.object_version_number = p.object_version_number + 1,
3148: p.last_update_date = SYSDATE,
3149: p.last_updated_by = FND_GLOBAL.USER_ID,
3150: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3151: WHERE p.allocation_for = 'FUND'
3152: AND p.allocation_for_id = l_fund_id;
3153:
3154: IF (SQL%NOTFOUND) THEN

Line 3168: t.last_updated_by = FND_GLOBAL.USER_ID,

3164: UPDATE OZF_TIME_ALLOCATIONS t
3165: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_multiplying_factor), 0),
3166: t.object_version_number = t.object_version_number + 1,
3167: t.last_update_date = SYSDATE,
3168: t.last_updated_by = FND_GLOBAL.USER_ID,
3169: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3170: WHERE t.allocation_for = 'PROD'
3171: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
3172: FROM OZF_PRODUCT_ALLOCATIONS p

Line 3169: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3165: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_multiplying_factor), 0),
3166: t.object_version_number = t.object_version_number + 1,
3167: t.last_update_date = SYSDATE,
3168: t.last_updated_by = FND_GLOBAL.USER_ID,
3169: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3170: WHERE t.allocation_for = 'PROD'
3171: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
3172: FROM OZF_PRODUCT_ALLOCATIONS p
3173: WHERE p.allocation_for = 'FUND'

Line 3193: p.last_updated_by = FND_GLOBAL.USER_ID,

3189: WHERE ti.ALLOCATION_FOR = 'PROD'
3190: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
3191: p.object_version_number = p.object_version_number + 1,
3192: p.last_update_date = SYSDATE,
3193: p.last_updated_by = FND_GLOBAL.USER_ID,
3194: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3195: WHERE p.allocation_for = 'FUND'
3196: AND p.allocation_for_id = l_fund_id;
3197:

Line 3194: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3190: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
3191: p.object_version_number = p.object_version_number + 1,
3192: p.last_update_date = SYSDATE,
3193: p.last_updated_by = FND_GLOBAL.USER_ID,
3194: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3195: WHERE p.allocation_for = 'FUND'
3196: AND p.allocation_for_id = l_fund_id;
3197:
3198: IF (SQL%NOTFOUND) THEN

Line 3223: p.last_updated_by = FND_GLOBAL.USER_ID,

3219: UPDATE OZF_PRODUCT_ALLOCATIONS p
3220: SET p.TARGET = ROUND( l_total_root_quota, 0),
3221: p.object_version_number = p.object_version_number + 1,
3222: p.last_update_date = SYSDATE,
3223: p.last_updated_by = FND_GLOBAL.USER_ID,
3224: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3225: WHERE p.allocation_for = 'FUND'
3226: AND p.allocation_for_id = l_fund_id
3227: AND p.item_id = -9999;

Line 3224: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3220: SET p.TARGET = ROUND( l_total_root_quota, 0),
3221: p.object_version_number = p.object_version_number + 1,
3222: p.last_update_date = SYSDATE,
3223: p.last_updated_by = FND_GLOBAL.USER_ID,
3224: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3225: WHERE p.allocation_for = 'FUND'
3226: AND p.allocation_for_id = l_fund_id
3227: AND p.item_id = -9999;
3228:

Line 3242: t.last_updated_by = FND_GLOBAL.USER_ID,

3238: UPDATE OZF_TIME_ALLOCATIONS t
3239: SET t.TARGET = ROUND((l_total_root_quota / l_denominator), 0),
3240: t.object_version_number = t.object_version_number + 1,
3241: t.last_update_date = SYSDATE,
3242: t.last_updated_by = FND_GLOBAL.USER_ID,
3243: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3244: WHERE t.allocation_for = 'PROD'
3245: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
3246: FROM OZF_PRODUCT_ALLOCATIONS p

Line 3243: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3239: SET t.TARGET = ROUND((l_total_root_quota / l_denominator), 0),
3240: t.object_version_number = t.object_version_number + 1,
3241: t.last_update_date = SYSDATE,
3242: t.last_updated_by = FND_GLOBAL.USER_ID,
3243: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3244: WHERE t.allocation_for = 'PROD'
3245: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
3246: FROM OZF_PRODUCT_ALLOCATIONS p
3247: WHERE p.allocation_for = 'FUND'

Line 3267: p.last_updated_by = FND_GLOBAL.USER_ID,

3263: WHERE ti.ALLOCATION_FOR = 'PROD'
3264: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
3265: p.object_version_number = p.object_version_number + 1,
3266: p.last_update_date = SYSDATE,
3267: p.last_updated_by = FND_GLOBAL.USER_ID,
3268: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3269: WHERE p.allocation_for = 'FUND'
3270: AND p.allocation_for_id = l_fund_id
3271: AND p.item_id = -9999;

Line 3268: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3264: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
3265: p.object_version_number = p.object_version_number + 1,
3266: p.last_update_date = SYSDATE,
3267: p.last_updated_by = FND_GLOBAL.USER_ID,
3268: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3269: WHERE p.allocation_for = 'FUND'
3270: AND p.allocation_for_id = l_fund_id
3271: AND p.item_id = -9999;
3272:

Line 3422: t.last_updated_by = FND_GLOBAL.USER_ID,

3418: UPDATE OZF_TIME_ALLOCATIONS t
3419: SET t.TARGET = t.TARGET + l_diff_target,
3420: t.object_version_number = t.object_version_number + 1,
3421: t.last_update_date = SYSDATE,
3422: t.last_updated_by = FND_GLOBAL.USER_ID,
3423: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3424: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
3425: WHERE x.allocation_for = 'PROD'
3426: AND x.allocation_for_id IN ( SELECT p.product_allocation_id

Line 3423: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3419: SET t.TARGET = t.TARGET + l_diff_target,
3420: t.object_version_number = t.object_version_number + 1,
3421: t.last_update_date = SYSDATE,
3422: t.last_updated_by = FND_GLOBAL.USER_ID,
3423: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3424: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
3425: WHERE x.allocation_for = 'PROD'
3426: AND x.allocation_for_id IN ( SELECT p.product_allocation_id
3427: FROM OZF_PRODUCT_ALLOCATIONS p

Line 3598: p.last_updated_by = FND_GLOBAL.USER_ID,

3594: UPDATE ozf_product_allocations p
3595: SET p.fund_id = l_fund_id,
3596: p.object_version_number = p.object_version_number + 1,
3597: p.last_update_date = SYSDATE,
3598: p.last_updated_by = FND_GLOBAL.USER_ID,
3599: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3600: WHERE p.allocation_for = 'FACT'
3601: AND p.allocation_for_id = l_fact_id;
3602:

Line 3599: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

3595: SET p.fund_id = l_fund_id,
3596: p.object_version_number = p.object_version_number + 1,
3597: p.last_update_date = SYSDATE,
3598: p.last_updated_by = FND_GLOBAL.USER_ID,
3599: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
3600: WHERE p.allocation_for = 'FACT'
3601: AND p.allocation_for_id = l_fact_id;
3602:
3603:

Line 4268: p_created_by => FND_GLOBAL.USER_ID,

4264: p_lysp_sales => NVL(p_prod_alloc_rec.lysp_sales, 0),
4265: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
4266: px_object_version_number => l_object_version_number,
4267: p_creation_date => SYSDATE,
4268: p_created_by => FND_GLOBAL.USER_ID,
4269: p_last_update_date => SYSDATE,
4270: p_last_updated_by => FND_GLOBAL.USER_ID,
4271: p_last_update_login => FND_GLOBAL.conc_login_id,
4272: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 4270: p_last_updated_by => FND_GLOBAL.USER_ID,

4266: px_object_version_number => l_object_version_number,
4267: p_creation_date => SYSDATE,
4268: p_created_by => FND_GLOBAL.USER_ID,
4269: p_last_update_date => SYSDATE,
4270: p_last_updated_by => FND_GLOBAL.USER_ID,
4271: p_last_update_login => FND_GLOBAL.conc_login_id,
4272: p_attribute_category => p_prod_alloc_rec.attribute_category,
4273: p_attribute1 => p_prod_alloc_rec.attribute1,
4274: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 4271: p_last_update_login => FND_GLOBAL.conc_login_id,

4267: p_creation_date => SYSDATE,
4268: p_created_by => FND_GLOBAL.USER_ID,
4269: p_last_update_date => SYSDATE,
4270: p_last_updated_by => FND_GLOBAL.USER_ID,
4271: p_last_update_login => FND_GLOBAL.conc_login_id,
4272: p_attribute_category => p_prod_alloc_rec.attribute_category,
4273: p_attribute1 => p_prod_alloc_rec.attribute1,
4274: p_attribute2 => p_prod_alloc_rec.attribute2,
4275: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 4339: p_created_by => FND_GLOBAL.USER_ID,

4335: p_target => NVL(p_time_alloc_rec.target, 0),
4336: p_lysp_sales => NVL(p_time_alloc_rec.lysp_sales, 0),
4337: px_object_version_number => l_object_version_number,
4338: p_creation_date => SYSDATE,
4339: p_created_by => FND_GLOBAL.USER_ID,
4340: p_last_update_date => SYSDATE,
4341: p_last_updated_by => FND_GLOBAL.USER_ID,
4342: p_last_update_login => FND_GLOBAL.conc_login_id,
4343: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 4341: p_last_updated_by => FND_GLOBAL.USER_ID,

4337: px_object_version_number => l_object_version_number,
4338: p_creation_date => SYSDATE,
4339: p_created_by => FND_GLOBAL.USER_ID,
4340: p_last_update_date => SYSDATE,
4341: p_last_updated_by => FND_GLOBAL.USER_ID,
4342: p_last_update_login => FND_GLOBAL.conc_login_id,
4343: p_attribute_category => p_time_alloc_rec.attribute_category,
4344: p_attribute1 => p_time_alloc_rec.attribute1,
4345: p_attribute2 => p_time_alloc_rec.attribute2,

Line 4342: p_last_update_login => FND_GLOBAL.conc_login_id,

4338: p_creation_date => SYSDATE,
4339: p_created_by => FND_GLOBAL.USER_ID,
4340: p_last_update_date => SYSDATE,
4341: p_last_updated_by => FND_GLOBAL.USER_ID,
4342: p_last_update_login => FND_GLOBAL.conc_login_id,
4343: p_attribute_category => p_time_alloc_rec.attribute_category,
4344: p_attribute1 => p_time_alloc_rec.attribute1,
4345: p_attribute2 => p_time_alloc_rec.attribute2,
4346: p_attribute3 => p_time_alloc_rec.attribute3,

Line 4369: p.last_updated_by = FND_GLOBAL.USER_ID,

4365: UPDATE OZF_PRODUCT_ALLOCATIONS p
4366: SET p.lysp_sales = l_total_lysp_sales,
4367: p.object_version_number = p.object_version_number + 1,
4368: p.last_update_date = SYSDATE,
4369: p.last_updated_by = FND_GLOBAL.USER_ID,
4370: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4371: WHERE p.product_allocation_id = l_product_allocation_id;
4372:
4373: OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ': End - Adding Product and Time Allocations Records'

Line 4370: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

4366: SET p.lysp_sales = l_total_lysp_sales,
4367: p.object_version_number = p.object_version_number + 1,
4368: p.last_update_date = SYSDATE,
4369: p.last_updated_by = FND_GLOBAL.USER_ID,
4370: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4371: WHERE p.product_allocation_id = l_product_allocation_id;
4372:
4373: OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ': End - Adding Product and Time Allocations Records'
4374: || 'FOR Fact_ID = '|| l_fact_id || ' ; ');

Line 4701: t.last_updated_by = FND_GLOBAL.USER_ID,

4697: UPDATE ozf_time_allocations t -- Update Others Quota for Jul03, Aug03, Sep03 etc
4698: SET t.target = t.target + NVL(time_alloc_rec.target, 0),
4699: t.object_version_number = t.object_version_number + 1,
4700: t.last_update_date = SYSDATE,
4701: t.last_updated_by = FND_GLOBAL.USER_ID,
4702: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4703: WHERE
4704: t.time_id = time_alloc_rec.time_id
4705: AND t.allocation_for_id = l_others_prod_alloc_rec.product_allocation_id

Line 4702: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

4698: SET t.target = t.target + NVL(time_alloc_rec.target, 0),
4699: t.object_version_number = t.object_version_number + 1,
4700: t.last_update_date = SYSDATE,
4701: t.last_updated_by = FND_GLOBAL.USER_ID,
4702: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4703: WHERE
4704: t.time_id = time_alloc_rec.time_id
4705: AND t.allocation_for_id = l_others_prod_alloc_rec.product_allocation_id
4706: AND t.allocation_for = 'PROD';

Line 4714: p.last_updated_by = FND_GLOBAL.USER_ID,

4710: UPDATE ozf_product_allocations p -- Update Others Quota for Q3-03 etc
4711: SET p.target = p.target + NVL(l_prod_alloc_rec.target, 0),
4712: p.object_version_number = p.object_version_number + 1,
4713: p.last_update_date = SYSDATE,
4714: p.last_updated_by = FND_GLOBAL.USER_ID,
4715: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4716: WHERE p.product_allocation_id = l_others_prod_alloc_rec.product_allocation_id;
4717:
4718:

Line 4715: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

4711: SET p.target = p.target + NVL(l_prod_alloc_rec.target, 0),
4712: p.object_version_number = p.object_version_number + 1,
4713: p.last_update_date = SYSDATE,
4714: p.last_updated_by = FND_GLOBAL.USER_ID,
4715: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
4716: WHERE p.product_allocation_id = l_others_prod_alloc_rec.product_allocation_id;
4717:
4718:
4719: OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ': End - Updating OTHERS Product and Time Allocations Records'

Line 5499: p_created_by => FND_GLOBAL.USER_ID,

5495: p_lysp_sales => p_acct_alloc_rec.lysp_sales,
5496: p_parent_Account_allocation_id => p_acct_alloc_rec.parent_Account_allocation_id,
5497: px_object_version_number => l_object_version_number,
5498: p_creation_date => SYSDATE,
5499: p_created_by => FND_GLOBAL.USER_ID,
5500: p_last_update_date => SYSDATE,
5501: p_last_updated_by => FND_GLOBAL.USER_ID,
5502: p_last_update_login => FND_GLOBAL.conc_login_id,
5503: p_attribute_category => p_acct_alloc_rec.attribute_category,

Line 5501: p_last_updated_by => FND_GLOBAL.USER_ID,

5497: px_object_version_number => l_object_version_number,
5498: p_creation_date => SYSDATE,
5499: p_created_by => FND_GLOBAL.USER_ID,
5500: p_last_update_date => SYSDATE,
5501: p_last_updated_by => FND_GLOBAL.USER_ID,
5502: p_last_update_login => FND_GLOBAL.conc_login_id,
5503: p_attribute_category => p_acct_alloc_rec.attribute_category,
5504: p_attribute1 => p_acct_alloc_rec.attribute1,
5505: p_attribute2 => p_acct_alloc_rec.attribute2,

Line 5502: p_last_update_login => FND_GLOBAL.conc_login_id,

5498: p_creation_date => SYSDATE,
5499: p_created_by => FND_GLOBAL.USER_ID,
5500: p_last_update_date => SYSDATE,
5501: p_last_updated_by => FND_GLOBAL.USER_ID,
5502: p_last_update_login => FND_GLOBAL.conc_login_id,
5503: p_attribute_category => p_acct_alloc_rec.attribute_category,
5504: p_attribute1 => p_acct_alloc_rec.attribute1,
5505: p_attribute2 => p_acct_alloc_rec.attribute2,
5506: p_attribute3 => p_acct_alloc_rec.attribute3,

Line 5557: p_created_by => FND_GLOBAL.USER_ID,

5553: p_target => p_time_alloc_rec.target,
5554: p_lysp_sales => p_time_alloc_rec.lysp_sales,
5555: px_object_version_number => l_object_version_number,
5556: p_creation_date => SYSDATE,
5557: p_created_by => FND_GLOBAL.USER_ID,
5558: p_last_update_date => SYSDATE,
5559: p_last_updated_by => FND_GLOBAL.USER_ID,
5560: p_last_update_login => FND_GLOBAL.conc_login_id,
5561: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 5559: p_last_updated_by => FND_GLOBAL.USER_ID,

5555: px_object_version_number => l_object_version_number,
5556: p_creation_date => SYSDATE,
5557: p_created_by => FND_GLOBAL.USER_ID,
5558: p_last_update_date => SYSDATE,
5559: p_last_updated_by => FND_GLOBAL.USER_ID,
5560: p_last_update_login => FND_GLOBAL.conc_login_id,
5561: p_attribute_category => p_time_alloc_rec.attribute_category,
5562: p_attribute1 => p_time_alloc_rec.attribute1,
5563: p_attribute2 => p_time_alloc_rec.attribute2,

Line 5560: p_last_update_login => FND_GLOBAL.conc_login_id,

5556: p_creation_date => SYSDATE,
5557: p_created_by => FND_GLOBAL.USER_ID,
5558: p_last_update_date => SYSDATE,
5559: p_last_updated_by => FND_GLOBAL.USER_ID,
5560: p_last_update_login => FND_GLOBAL.conc_login_id,
5561: p_attribute_category => p_time_alloc_rec.attribute_category,
5562: p_attribute1 => p_time_alloc_rec.attribute1,
5563: p_attribute2 => p_time_alloc_rec.attribute2,
5564: p_attribute3 => p_time_alloc_rec.attribute3,

Line 5630: p_created_by => FND_GLOBAL.USER_ID,

5626: p_lysp_sales => p_prod_alloc_rec.lysp_sales,
5627: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
5628: px_object_version_number => l_object_version_number,
5629: p_creation_date => SYSDATE,
5630: p_created_by => FND_GLOBAL.USER_ID,
5631: p_last_update_date => SYSDATE,
5632: p_last_updated_by => FND_GLOBAL.USER_ID,
5633: p_last_update_login => FND_GLOBAL.conc_login_id,
5634: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 5632: p_last_updated_by => FND_GLOBAL.USER_ID,

5628: px_object_version_number => l_object_version_number,
5629: p_creation_date => SYSDATE,
5630: p_created_by => FND_GLOBAL.USER_ID,
5631: p_last_update_date => SYSDATE,
5632: p_last_updated_by => FND_GLOBAL.USER_ID,
5633: p_last_update_login => FND_GLOBAL.conc_login_id,
5634: p_attribute_category => p_prod_alloc_rec.attribute_category,
5635: p_attribute1 => p_prod_alloc_rec.attribute1,
5636: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 5633: p_last_update_login => FND_GLOBAL.conc_login_id,

5629: p_creation_date => SYSDATE,
5630: p_created_by => FND_GLOBAL.USER_ID,
5631: p_last_update_date => SYSDATE,
5632: p_last_updated_by => FND_GLOBAL.USER_ID,
5633: p_last_update_login => FND_GLOBAL.conc_login_id,
5634: p_attribute_category => p_prod_alloc_rec.attribute_category,
5635: p_attribute1 => p_prod_alloc_rec.attribute1,
5636: p_attribute2 => p_prod_alloc_rec.attribute2,
5637: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 5723: p_created_by => FND_GLOBAL.USER_ID,

5719: p_target => p_time_alloc_rec.target,
5720: p_lysp_sales => p_time_alloc_rec.lysp_sales,
5721: px_object_version_number => l_object_version_number,
5722: p_creation_date => SYSDATE,
5723: p_created_by => FND_GLOBAL.USER_ID,
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: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 5725: p_last_updated_by => FND_GLOBAL.USER_ID,

5721: px_object_version_number => l_object_version_number,
5722: p_creation_date => SYSDATE,
5723: p_created_by => FND_GLOBAL.USER_ID,
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: p_attribute_category => p_time_alloc_rec.attribute_category,
5728: p_attribute1 => p_time_alloc_rec.attribute1,
5729: p_attribute2 => p_time_alloc_rec.attribute2,

Line 5726: p_last_update_login => FND_GLOBAL.conc_login_id,

5722: p_creation_date => SYSDATE,
5723: p_created_by => FND_GLOBAL.USER_ID,
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: p_attribute_category => p_time_alloc_rec.attribute_category,
5728: p_attribute1 => p_time_alloc_rec.attribute1,
5729: p_attribute2 => p_time_alloc_rec.attribute2,
5730: p_attribute3 => p_time_alloc_rec.attribute3,

Line 5754: p.last_updated_by = FND_GLOBAL.USER_ID,

5750: UPDATE OZF_PRODUCT_ALLOCATIONS p
5751: SET p.lysp_sales = l_total_product_sales,
5752: p.object_version_number = p.object_version_number + 1,
5753: p.last_update_date = SYSDATE,
5754: p.last_updated_by = FND_GLOBAL.USER_ID,
5755: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
5756: WHERE p.product_allocation_id = l_product_allocation_id;
5757:
5758: END LOOP account_product_loop;

Line 5755: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

5751: SET p.lysp_sales = l_total_product_sales,
5752: p.object_version_number = p.object_version_number + 1,
5753: p.last_update_date = SYSDATE,
5754: p.last_updated_by = FND_GLOBAL.USER_ID,
5755: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
5756: WHERE p.product_allocation_id = l_product_allocation_id;
5757:
5758: END LOOP account_product_loop;
5759:

Line 5826: p_created_by => FND_GLOBAL.USER_ID,

5822: p_lysp_sales => p_acct_alloc_rec.lysp_sales,
5823: p_parent_Account_allocation_id => p_acct_alloc_rec.parent_Account_allocation_id,
5824: px_object_version_number => l_object_version_number,
5825: p_creation_date => SYSDATE,
5826: p_created_by => FND_GLOBAL.USER_ID,
5827: p_last_update_date => SYSDATE,
5828: p_last_updated_by => FND_GLOBAL.USER_ID,
5829: p_last_update_login => FND_GLOBAL.conc_login_id,
5830: p_attribute_category => p_acct_alloc_rec.attribute_category,

Line 5828: p_last_updated_by => FND_GLOBAL.USER_ID,

5824: px_object_version_number => l_object_version_number,
5825: p_creation_date => SYSDATE,
5826: p_created_by => FND_GLOBAL.USER_ID,
5827: p_last_update_date => SYSDATE,
5828: p_last_updated_by => FND_GLOBAL.USER_ID,
5829: p_last_update_login => FND_GLOBAL.conc_login_id,
5830: p_attribute_category => p_acct_alloc_rec.attribute_category,
5831: p_attribute1 => p_acct_alloc_rec.attribute1,
5832: p_attribute2 => p_acct_alloc_rec.attribute2,

Line 5829: p_last_update_login => FND_GLOBAL.conc_login_id,

5825: p_creation_date => SYSDATE,
5826: p_created_by => FND_GLOBAL.USER_ID,
5827: p_last_update_date => SYSDATE,
5828: p_last_updated_by => FND_GLOBAL.USER_ID,
5829: p_last_update_login => FND_GLOBAL.conc_login_id,
5830: p_attribute_category => p_acct_alloc_rec.attribute_category,
5831: p_attribute1 => p_acct_alloc_rec.attribute1,
5832: p_attribute2 => p_acct_alloc_rec.attribute2,
5833: p_attribute3 => p_acct_alloc_rec.attribute3,

Line 5875: p_created_by => FND_GLOBAL.USER_ID,

5871: p_target => p_time_alloc_rec.target,
5872: p_lysp_sales => p_time_alloc_rec.lysp_sales,
5873: px_object_version_number => l_object_version_number,
5874: p_creation_date => SYSDATE,
5875: p_created_by => FND_GLOBAL.USER_ID,
5876: p_last_update_date => SYSDATE,
5877: p_last_updated_by => FND_GLOBAL.USER_ID,
5878: p_last_update_login => FND_GLOBAL.conc_login_id,
5879: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 5877: p_last_updated_by => FND_GLOBAL.USER_ID,

5873: px_object_version_number => l_object_version_number,
5874: p_creation_date => SYSDATE,
5875: p_created_by => FND_GLOBAL.USER_ID,
5876: p_last_update_date => SYSDATE,
5877: p_last_updated_by => FND_GLOBAL.USER_ID,
5878: p_last_update_login => FND_GLOBAL.conc_login_id,
5879: p_attribute_category => p_time_alloc_rec.attribute_category,
5880: p_attribute1 => p_time_alloc_rec.attribute1,
5881: p_attribute2 => p_time_alloc_rec.attribute2,

Line 5878: p_last_update_login => FND_GLOBAL.conc_login_id,

5874: p_creation_date => SYSDATE,
5875: p_created_by => FND_GLOBAL.USER_ID,
5876: p_last_update_date => SYSDATE,
5877: p_last_updated_by => FND_GLOBAL.USER_ID,
5878: p_last_update_login => FND_GLOBAL.conc_login_id,
5879: p_attribute_category => p_time_alloc_rec.attribute_category,
5880: p_attribute1 => p_time_alloc_rec.attribute1,
5881: p_attribute2 => p_time_alloc_rec.attribute2,
5882: p_attribute3 => p_time_alloc_rec.attribute3,

Line 5939: t.last_updated_by = FND_GLOBAL.USER_ID,

5935: UPDATE OZF_TIME_ALLOCATIONS t
5936: SET t.TARGET = t.TARGET + l_diff_target,
5937: t.object_version_number = t.object_version_number + 1,
5938: t.last_update_date = SYSDATE,
5939: t.last_updated_by = FND_GLOBAL.USER_ID,
5940: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
5941: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
5942: WHERE x.allocation_for = 'CUST'
5943: AND x.allocation_for_id IN ( SELECT a.account_allocation_id

Line 5940: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

5936: SET t.TARGET = t.TARGET + l_diff_target,
5937: t.object_version_number = t.object_version_number + 1,
5938: t.last_update_date = SYSDATE,
5939: t.last_updated_by = FND_GLOBAL.USER_ID,
5940: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
5941: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
5942: WHERE x.allocation_for = 'CUST'
5943: AND x.allocation_for_id IN ( SELECT a.account_allocation_id
5944: FROM OZF_ACCOUNT_ALLOCATIONS a

Line 6611: p_created_by => FND_GLOBAL.USER_ID,

6607: p_lysp_sales => p_acct_alloc_rec.lysp_sales,
6608: p_parent_Account_allocation_id => p_acct_alloc_rec.parent_Account_allocation_id,
6609: px_object_version_number => l_object_version_number,
6610: p_creation_date => SYSDATE,
6611: p_created_by => FND_GLOBAL.USER_ID,
6612: p_last_update_date => SYSDATE,
6613: p_last_updated_by => FND_GLOBAL.USER_ID,
6614: p_last_update_login => FND_GLOBAL.conc_login_id,
6615: p_attribute_category => p_acct_alloc_rec.attribute_category,

Line 6613: p_last_updated_by => FND_GLOBAL.USER_ID,

6609: px_object_version_number => l_object_version_number,
6610: p_creation_date => SYSDATE,
6611: p_created_by => FND_GLOBAL.USER_ID,
6612: p_last_update_date => SYSDATE,
6613: p_last_updated_by => FND_GLOBAL.USER_ID,
6614: p_last_update_login => FND_GLOBAL.conc_login_id,
6615: p_attribute_category => p_acct_alloc_rec.attribute_category,
6616: p_attribute1 => p_acct_alloc_rec.attribute1,
6617: p_attribute2 => p_acct_alloc_rec.attribute2,

Line 6614: p_last_update_login => FND_GLOBAL.conc_login_id,

6610: p_creation_date => SYSDATE,
6611: p_created_by => FND_GLOBAL.USER_ID,
6612: p_last_update_date => SYSDATE,
6613: p_last_updated_by => FND_GLOBAL.USER_ID,
6614: p_last_update_login => FND_GLOBAL.conc_login_id,
6615: p_attribute_category => p_acct_alloc_rec.attribute_category,
6616: p_attribute1 => p_acct_alloc_rec.attribute1,
6617: p_attribute2 => p_acct_alloc_rec.attribute2,
6618: p_attribute3 => p_acct_alloc_rec.attribute3,

Line 6669: p_created_by => FND_GLOBAL.USER_ID,

6665: p_target => p_time_alloc_rec.target,
6666: p_lysp_sales => p_time_alloc_rec.lysp_sales,
6667: px_object_version_number => l_object_version_number,
6668: p_creation_date => SYSDATE,
6669: p_created_by => FND_GLOBAL.USER_ID,
6670: p_last_update_date => SYSDATE,
6671: p_last_updated_by => FND_GLOBAL.USER_ID,
6672: p_last_update_login => FND_GLOBAL.conc_login_id,
6673: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 6671: p_last_updated_by => FND_GLOBAL.USER_ID,

6667: px_object_version_number => l_object_version_number,
6668: p_creation_date => SYSDATE,
6669: p_created_by => FND_GLOBAL.USER_ID,
6670: p_last_update_date => SYSDATE,
6671: p_last_updated_by => FND_GLOBAL.USER_ID,
6672: p_last_update_login => FND_GLOBAL.conc_login_id,
6673: p_attribute_category => p_time_alloc_rec.attribute_category,
6674: p_attribute1 => p_time_alloc_rec.attribute1,
6675: p_attribute2 => p_time_alloc_rec.attribute2,

Line 6672: p_last_update_login => FND_GLOBAL.conc_login_id,

6668: p_creation_date => SYSDATE,
6669: p_created_by => FND_GLOBAL.USER_ID,
6670: p_last_update_date => SYSDATE,
6671: p_last_updated_by => FND_GLOBAL.USER_ID,
6672: p_last_update_login => FND_GLOBAL.conc_login_id,
6673: p_attribute_category => p_time_alloc_rec.attribute_category,
6674: p_attribute1 => p_time_alloc_rec.attribute1,
6675: p_attribute2 => p_time_alloc_rec.attribute2,
6676: p_attribute3 => p_time_alloc_rec.attribute3,

Line 6711: a.last_updated_by = FND_GLOBAL.USER_ID,

6707: UPDATE OZF_ACCOUNT_ALLOCATIONS a
6708: SET a.TARGET = l_total_account_target,
6709: a.object_version_number = a.object_version_number + 1,
6710: a.last_update_date = SYSDATE,
6711: a.last_updated_by = FND_GLOBAL.USER_ID,
6712: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6713: WHERE a.account_allocation_id = l_account_allocation_id;
6714:
6715: IF (SQL%NOTFOUND) THEN

Line 6712: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6708: SET a.TARGET = l_total_account_target,
6709: a.object_version_number = a.object_version_number + 1,
6710: a.last_update_date = SYSDATE,
6711: a.last_updated_by = FND_GLOBAL.USER_ID,
6712: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6713: WHERE a.account_allocation_id = l_account_allocation_id;
6714:
6715: IF (SQL%NOTFOUND) THEN
6716: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 6784: p_created_by => FND_GLOBAL.USER_ID,

6780: p_lysp_sales => p_prod_alloc_rec.lysp_sales,
6781: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
6782: px_object_version_number => l_object_version_number,
6783: p_creation_date => SYSDATE,
6784: p_created_by => FND_GLOBAL.USER_ID,
6785: p_last_update_date => SYSDATE,
6786: p_last_updated_by => FND_GLOBAL.USER_ID,
6787: p_last_update_login => FND_GLOBAL.conc_login_id,
6788: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 6786: p_last_updated_by => FND_GLOBAL.USER_ID,

6782: px_object_version_number => l_object_version_number,
6783: p_creation_date => SYSDATE,
6784: p_created_by => FND_GLOBAL.USER_ID,
6785: p_last_update_date => SYSDATE,
6786: p_last_updated_by => FND_GLOBAL.USER_ID,
6787: p_last_update_login => FND_GLOBAL.conc_login_id,
6788: p_attribute_category => p_prod_alloc_rec.attribute_category,
6789: p_attribute1 => p_prod_alloc_rec.attribute1,
6790: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 6787: p_last_update_login => FND_GLOBAL.conc_login_id,

6783: p_creation_date => SYSDATE,
6784: p_created_by => FND_GLOBAL.USER_ID,
6785: p_last_update_date => SYSDATE,
6786: p_last_updated_by => FND_GLOBAL.USER_ID,
6787: p_last_update_login => FND_GLOBAL.conc_login_id,
6788: p_attribute_category => p_prod_alloc_rec.attribute_category,
6789: p_attribute1 => p_prod_alloc_rec.attribute1,
6790: p_attribute2 => p_prod_alloc_rec.attribute2,
6791: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 6880: p_created_by => FND_GLOBAL.USER_ID,

6876: p_target => p_time_alloc_rec.target,
6877: p_lysp_sales => p_time_alloc_rec.lysp_sales,
6878: px_object_version_number => l_object_version_number,
6879: p_creation_date => SYSDATE,
6880: p_created_by => FND_GLOBAL.USER_ID,
6881: p_last_update_date => SYSDATE,
6882: p_last_updated_by => FND_GLOBAL.USER_ID,
6883: p_last_update_login => FND_GLOBAL.conc_login_id,
6884: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 6882: p_last_updated_by => FND_GLOBAL.USER_ID,

6878: px_object_version_number => l_object_version_number,
6879: p_creation_date => SYSDATE,
6880: p_created_by => FND_GLOBAL.USER_ID,
6881: p_last_update_date => SYSDATE,
6882: p_last_updated_by => FND_GLOBAL.USER_ID,
6883: p_last_update_login => FND_GLOBAL.conc_login_id,
6884: p_attribute_category => p_time_alloc_rec.attribute_category,
6885: p_attribute1 => p_time_alloc_rec.attribute1,
6886: p_attribute2 => p_time_alloc_rec.attribute2,

Line 6883: p_last_update_login => FND_GLOBAL.conc_login_id,

6879: p_creation_date => SYSDATE,
6880: p_created_by => FND_GLOBAL.USER_ID,
6881: p_last_update_date => SYSDATE,
6882: p_last_updated_by => FND_GLOBAL.USER_ID,
6883: p_last_update_login => FND_GLOBAL.conc_login_id,
6884: p_attribute_category => p_time_alloc_rec.attribute_category,
6885: p_attribute1 => p_time_alloc_rec.attribute1,
6886: p_attribute2 => p_time_alloc_rec.attribute2,
6887: p_attribute3 => p_time_alloc_rec.attribute3,

Line 6911: p.last_updated_by = FND_GLOBAL.USER_ID,

6907: UPDATE OZF_PRODUCT_ALLOCATIONS p
6908: SET p.lysp_sales = l_total_product_sales,
6909: p.object_version_number = p.object_version_number + 1,
6910: p.last_update_date = SYSDATE,
6911: p.last_updated_by = FND_GLOBAL.USER_ID,
6912: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6913: WHERE p.product_allocation_id = l_product_allocation_id;
6914:
6915: l_p_grand_total_lysp_sales := l_p_grand_total_lysp_sales + l_total_product_sales;

Line 6912: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6908: SET p.lysp_sales = l_total_product_sales,
6909: p.object_version_number = p.object_version_number + 1,
6910: p.last_update_date = SYSDATE,
6911: p.last_updated_by = FND_GLOBAL.USER_ID,
6912: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6913: WHERE p.product_allocation_id = l_product_allocation_id;
6914:
6915: l_p_grand_total_lysp_sales := l_p_grand_total_lysp_sales + l_total_product_sales;
6916:

Line 6938: t.last_updated_by = FND_GLOBAL.USER_ID,

6934: UPDATE OZF_TIME_ALLOCATIONS t
6935: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_prod_mltply_factor), 0),
6936: t.object_version_number = t.object_version_number + 1,
6937: t.last_update_date = SYSDATE,
6938: t.last_updated_by = FND_GLOBAL.USER_ID,
6939: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6940: WHERE t.allocation_for = 'PROD'
6941: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
6942: FROM OZF_PRODUCT_ALLOCATIONS p

Line 6939: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6935: SET t.TARGET = ROUND((NVL(t.LYSP_SALES, 0) * l_prod_mltply_factor), 0),
6936: t.object_version_number = t.object_version_number + 1,
6937: t.last_update_date = SYSDATE,
6938: t.last_updated_by = FND_GLOBAL.USER_ID,
6939: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6940: WHERE t.allocation_for = 'PROD'
6941: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
6942: FROM OZF_PRODUCT_ALLOCATIONS p
6943: WHERE p.allocation_for = 'CUST'

Line 6962: p.last_updated_by = FND_GLOBAL.USER_ID,

6958: WHERE ti.ALLOCATION_FOR = 'PROD'
6959: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
6960: p.object_version_number = p.object_version_number + 1,
6961: p.last_update_date = SYSDATE,
6962: p.last_updated_by = FND_GLOBAL.USER_ID,
6963: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6964: WHERE p.allocation_for = 'CUST'
6965: AND p.allocation_for_id = l_account_allocation_id;
6966:

Line 6963: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6959: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
6960: p.object_version_number = p.object_version_number + 1,
6961: p.last_update_date = SYSDATE,
6962: p.last_updated_by = FND_GLOBAL.USER_ID,
6963: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6964: WHERE p.allocation_for = 'CUST'
6965: AND p.allocation_for_id = l_account_allocation_id;
6966:
6967: IF (SQL%NOTFOUND) THEN

Line 6991: p.last_updated_by = FND_GLOBAL.USER_ID,

6987: UPDATE OZF_PRODUCT_ALLOCATIONS p
6988: SET p.TARGET = ROUND(NVL(l_total_account_target, 0),0),
6989: p.object_version_number = p.object_version_number + 1,
6990: p.last_update_date = SYSDATE,
6991: p.last_updated_by = FND_GLOBAL.USER_ID,
6992: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6993: WHERE p.allocation_for = 'CUST'
6994: AND p.allocation_for_id = l_account_allocation_id
6995: AND p.item_id = -9999;

Line 6992: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6988: SET p.TARGET = ROUND(NVL(l_total_account_target, 0),0),
6989: p.object_version_number = p.object_version_number + 1,
6990: p.last_update_date = SYSDATE,
6991: p.last_updated_by = FND_GLOBAL.USER_ID,
6992: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6993: WHERE p.allocation_for = 'CUST'
6994: AND p.allocation_for_id = l_account_allocation_id
6995: AND p.item_id = -9999;
6996:

Line 7011: t.last_updated_by = FND_GLOBAL.USER_ID,

7007: UPDATE OZF_TIME_ALLOCATIONS t
7008: SET t.TARGET = ROUND((NVL(l_total_account_target, 0) / l_p_denominator), 0),
7009: t.object_version_number = t.object_version_number + 1,
7010: t.last_update_date = SYSDATE,
7011: t.last_updated_by = FND_GLOBAL.USER_ID,
7012: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7013: WHERE t.allocation_for = 'PROD'
7014: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
7015: FROM OZF_PRODUCT_ALLOCATIONS p

Line 7012: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7008: SET t.TARGET = ROUND((NVL(l_total_account_target, 0) / l_p_denominator), 0),
7009: t.object_version_number = t.object_version_number + 1,
7010: t.last_update_date = SYSDATE,
7011: t.last_updated_by = FND_GLOBAL.USER_ID,
7012: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7013: WHERE t.allocation_for = 'PROD'
7014: AND t.allocation_for_id IN ( SELECT p.product_allocation_id
7015: FROM OZF_PRODUCT_ALLOCATIONS p
7016: WHERE p.allocation_for = 'CUST'

Line 7035: p.last_updated_by = FND_GLOBAL.USER_ID,

7031: WHERE ti.ALLOCATION_FOR = 'PROD'
7032: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
7033: p.object_version_number = p.object_version_number + 1,
7034: p.last_update_date = SYSDATE,
7035: p.last_updated_by = FND_GLOBAL.USER_ID,
7036: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7037: WHERE p.allocation_for = 'CUST'
7038: AND p.allocation_for_id = l_account_allocation_id
7039: AND p.item_id = -9999;

Line 7036: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7032: AND ti.ALLOCATION_FOR_ID = p.PRODUCT_ALLOCATION_ID),
7033: p.object_version_number = p.object_version_number + 1,
7034: p.last_update_date = SYSDATE,
7035: p.last_updated_by = FND_GLOBAL.USER_ID,
7036: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7037: WHERE p.allocation_for = 'CUST'
7038: AND p.allocation_for_id = l_account_allocation_id
7039: AND p.item_id = -9999;
7040:

Line 7095: t.last_updated_by = FND_GLOBAL.USER_ID,

7091: UPDATE OZF_TIME_ALLOCATIONS t
7092: SET t.TARGET = t.TARGET + l_diff_target,
7093: t.object_version_number = t.object_version_number + 1,
7094: t.last_update_date = SYSDATE,
7095: t.last_updated_by = FND_GLOBAL.USER_ID,
7096: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7097: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
7098: FROM OZF_TIME_ALLOCATIONS x
7099: WHERE x.allocation_for = 'PROD'

Line 7096: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7092: SET t.TARGET = t.TARGET + l_diff_target,
7093: t.object_version_number = t.object_version_number + 1,
7094: t.last_update_date = SYSDATE,
7095: t.last_updated_by = FND_GLOBAL.USER_ID,
7096: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7097: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
7098: FROM OZF_TIME_ALLOCATIONS x
7099: WHERE x.allocation_for = 'PROD'
7100: AND x.allocation_for_id IN ( SELECT max(p.product_allocation_id)

Line 7145: p.last_updated_by = FND_GLOBAL.USER_ID,

7141: UPDATE OZF_PRODUCT_ALLOCATIONS p
7142: SET p.TARGET = p.TARGET + l_diff_target,
7143: p.object_version_number = p.object_version_number + 1,
7144: p.last_update_date = SYSDATE,
7145: p.last_updated_by = FND_GLOBAL.USER_ID,
7146: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7147: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7148:
7149: IF (SQL%NOTFOUND) THEN

Line 7146: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7142: SET p.TARGET = p.TARGET + l_diff_target,
7143: p.object_version_number = p.object_version_number + 1,
7144: p.last_update_date = SYSDATE,
7145: p.last_updated_by = FND_GLOBAL.USER_ID,
7146: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7147: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7148:
7149: IF (SQL%NOTFOUND) THEN
7150: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 7164: t.last_updated_by = FND_GLOBAL.USER_ID,

7160: UPDATE OZF_TIME_ALLOCATIONS t
7161: SET t.TARGET = t.TARGET + l_diff_target,
7162: t.object_version_number = t.object_version_number + 1,
7163: t.last_update_date = SYSDATE,
7164: t.last_updated_by = FND_GLOBAL.USER_ID,
7165: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7166: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7167: WHERE x.allocation_for = 'PROD'
7168: AND x.allocation_for_id IN ( SELECT p.product_allocation_id

Line 7165: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7161: SET t.TARGET = t.TARGET + l_diff_target,
7162: t.object_version_number = t.object_version_number + 1,
7163: t.last_update_date = SYSDATE,
7164: t.last_updated_by = FND_GLOBAL.USER_ID,
7165: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7166: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7167: WHERE x.allocation_for = 'PROD'
7168: AND x.allocation_for_id IN ( SELECT p.product_allocation_id
7169: FROM OZF_PRODUCT_ALLOCATIONS p

Line 7188: p.last_updated_by = FND_GLOBAL.USER_ID,

7184: UPDATE OZF_PRODUCT_ALLOCATIONS p
7185: SET p.TARGET = p.TARGET + l_diff_target,
7186: p.object_version_number = p.object_version_number + 1,
7187: p.last_update_date = SYSDATE,
7188: p.last_updated_by = FND_GLOBAL.USER_ID,
7189: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7190: WHERE p.allocation_for = 'CUST'
7191: AND p.allocation_for_id = l_account_allocation_id
7192: AND p.item_id = -9999;

Line 7189: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7185: SET p.TARGET = p.TARGET + l_diff_target,
7186: p.object_version_number = p.object_version_number + 1,
7187: p.last_update_date = SYSDATE,
7188: p.last_updated_by = FND_GLOBAL.USER_ID,
7189: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7190: WHERE p.allocation_for = 'CUST'
7191: AND p.allocation_for_id = l_account_allocation_id
7192: AND p.item_id = -9999;
7193:

Line 7253: p_created_by => FND_GLOBAL.USER_ID,

7249: p_lysp_sales => p_acct_alloc_rec.lysp_sales,
7250: p_parent_Account_allocation_id => p_acct_alloc_rec.parent_Account_allocation_id,
7251: px_object_version_number => l_object_version_number,
7252: p_creation_date => SYSDATE,
7253: p_created_by => FND_GLOBAL.USER_ID,
7254: p_last_update_date => SYSDATE,
7255: p_last_updated_by => FND_GLOBAL.USER_ID,
7256: p_last_update_login => FND_GLOBAL.conc_login_id,
7257: p_attribute_category => p_acct_alloc_rec.attribute_category,

Line 7255: p_last_updated_by => FND_GLOBAL.USER_ID,

7251: px_object_version_number => l_object_version_number,
7252: p_creation_date => SYSDATE,
7253: p_created_by => FND_GLOBAL.USER_ID,
7254: p_last_update_date => SYSDATE,
7255: p_last_updated_by => FND_GLOBAL.USER_ID,
7256: p_last_update_login => FND_GLOBAL.conc_login_id,
7257: p_attribute_category => p_acct_alloc_rec.attribute_category,
7258: p_attribute1 => p_acct_alloc_rec.attribute1,
7259: p_attribute2 => p_acct_alloc_rec.attribute2,

Line 7256: p_last_update_login => FND_GLOBAL.conc_login_id,

7252: p_creation_date => SYSDATE,
7253: p_created_by => FND_GLOBAL.USER_ID,
7254: p_last_update_date => SYSDATE,
7255: p_last_updated_by => FND_GLOBAL.USER_ID,
7256: p_last_update_login => FND_GLOBAL.conc_login_id,
7257: p_attribute_category => p_acct_alloc_rec.attribute_category,
7258: p_attribute1 => p_acct_alloc_rec.attribute1,
7259: p_attribute2 => p_acct_alloc_rec.attribute2,
7260: p_attribute3 => p_acct_alloc_rec.attribute3,

Line 7302: p_created_by => FND_GLOBAL.USER_ID,

7298: p_target => p_time_alloc_rec.target,
7299: p_lysp_sales => p_time_alloc_rec.lysp_sales,
7300: px_object_version_number => l_object_version_number,
7301: p_creation_date => SYSDATE,
7302: p_created_by => FND_GLOBAL.USER_ID,
7303: p_last_update_date => SYSDATE,
7304: p_last_updated_by => FND_GLOBAL.USER_ID,
7305: p_last_update_login => FND_GLOBAL.conc_login_id,
7306: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 7304: p_last_updated_by => FND_GLOBAL.USER_ID,

7300: px_object_version_number => l_object_version_number,
7301: p_creation_date => SYSDATE,
7302: p_created_by => FND_GLOBAL.USER_ID,
7303: p_last_update_date => SYSDATE,
7304: p_last_updated_by => FND_GLOBAL.USER_ID,
7305: p_last_update_login => FND_GLOBAL.conc_login_id,
7306: p_attribute_category => p_time_alloc_rec.attribute_category,
7307: p_attribute1 => p_time_alloc_rec.attribute1,
7308: p_attribute2 => p_time_alloc_rec.attribute2,

Line 7305: p_last_update_login => FND_GLOBAL.conc_login_id,

7301: p_creation_date => SYSDATE,
7302: p_created_by => FND_GLOBAL.USER_ID,
7303: p_last_update_date => SYSDATE,
7304: p_last_updated_by => FND_GLOBAL.USER_ID,
7305: p_last_update_login => FND_GLOBAL.conc_login_id,
7306: p_attribute_category => p_time_alloc_rec.attribute_category,
7307: p_attribute1 => p_time_alloc_rec.attribute1,
7308: p_attribute2 => p_time_alloc_rec.attribute2,
7309: p_attribute3 => p_time_alloc_rec.attribute3,

Line 7374: t.last_updated_by = FND_GLOBAL.USER_ID,

7370: UPDATE OZF_TIME_ALLOCATIONS t
7371: SET t.TARGET = t.TARGET + l_diff_target,
7372: t.object_version_number = t.object_version_number + 1,
7373: t.last_update_date = SYSDATE,
7374: t.last_updated_by = FND_GLOBAL.USER_ID,
7375: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7376: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7377: WHERE x.allocation_for = 'CUST'
7378: AND x.allocation_for_id IN ( SELECT a.account_allocation_id

Line 7375: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7371: SET t.TARGET = t.TARGET + l_diff_target,
7372: t.object_version_number = t.object_version_number + 1,
7373: t.last_update_date = SYSDATE,
7374: t.last_updated_by = FND_GLOBAL.USER_ID,
7375: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7376: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7377: WHERE x.allocation_for = 'CUST'
7378: AND x.allocation_for_id IN ( SELECT a.account_allocation_id
7379: FROM OZF_ACCOUNT_ALLOCATIONS a

Line 7436: t.last_updated_by = FND_GLOBAL.USER_ID,

7432: UPDATE OZF_TIME_ALLOCATIONS t
7433: SET t.TARGET = t.TARGET + l_diff_target,
7434: t.object_version_number = t.object_version_number + 1,
7435: t.last_update_date = SYSDATE,
7436: t.last_updated_by = FND_GLOBAL.USER_ID,
7437: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7438: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7439: WHERE x.allocation_for = 'CUST'
7440: AND x.allocation_for_id IN ( SELECT a.account_allocation_id

Line 7437: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7433: SET t.TARGET = t.TARGET + l_diff_target,
7434: t.object_version_number = t.object_version_number + 1,
7435: t.last_update_date = SYSDATE,
7436: t.last_updated_by = FND_GLOBAL.USER_ID,
7437: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7438: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id) from OZF_TIME_ALLOCATIONS x
7439: WHERE x.allocation_for = 'CUST'
7440: AND x.allocation_for_id IN ( SELECT a.account_allocation_id
7441: FROM OZF_ACCOUNT_ALLOCATIONS a

Line 7460: a.last_updated_by = FND_GLOBAL.USER_ID,

7456: UPDATE OZF_ACCOUNT_ALLOCATIONS a
7457: SET a.TARGET = a.TARGET + l_diff_target,
7458: a.object_version_number = a.object_version_number + 1,
7459: a.last_update_date = SYSDATE,
7460: a.last_updated_by = FND_GLOBAL.USER_ID,
7461: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7462: WHERE a.allocation_for = 'FUND'
7463: AND a.allocation_for_id = l_fund_id
7464: AND a.parent_party_id = -9999;

Line 7461: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7457: SET a.TARGET = a.TARGET + l_diff_target,
7458: a.object_version_number = a.object_version_number + 1,
7459: a.last_update_date = SYSDATE,
7460: a.last_updated_by = FND_GLOBAL.USER_ID,
7461: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7462: WHERE a.allocation_for = 'FUND'
7463: AND a.allocation_for_id = l_fund_id
7464: AND a.parent_party_id = -9999;
7465:

Line 7494: t.last_updated_by = FND_GLOBAL.USER_ID,

7490: UPDATE OZF_TIME_ALLOCATIONS t
7491: SET t.TARGET = t.TARGET + l_diff_target,
7492: t.object_version_number = t.object_version_number + 1,
7493: t.last_update_date = SYSDATE,
7494: t.last_updated_by = FND_GLOBAL.USER_ID,
7495: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7496: WHERE t.time_allocation_id = (SELECT MAX(x.time_allocation_id)
7497: FROM OZF_TIME_ALLOCATIONS x
7498: WHERE x.allocation_for = 'CUST'

Line 7495: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7491: SET t.TARGET = t.TARGET + l_diff_target,
7492: t.object_version_number = t.object_version_number + 1,
7493: t.last_update_date = SYSDATE,
7494: t.last_updated_by = FND_GLOBAL.USER_ID,
7495: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7496: WHERE t.time_allocation_id = (SELECT MAX(x.time_allocation_id)
7497: FROM OZF_TIME_ALLOCATIONS x
7498: WHERE x.allocation_for = 'CUST'
7499: AND x.allocation_for_id IN ( SELECT MAX(a.account_allocation_id)

Line 7543: a.last_updated_by = FND_GLOBAL.USER_ID,

7539: UPDATE OZF_ACCOUNT_ALLOCATIONS a
7540: SET a.TARGET = a.TARGET + l_diff_target,
7541: a.object_version_number = a.object_version_number + 1,
7542: a.last_update_date = SYSDATE,
7543: a.last_updated_by = FND_GLOBAL.USER_ID,
7544: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7545: WHERE a.account_allocation_id = l_temp_account_allocation_id;
7546:
7547: IF (SQL%NOTFOUND) THEN

Line 7544: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7540: SET a.TARGET = a.TARGET + l_diff_target,
7541: a.object_version_number = a.object_version_number + 1,
7542: a.last_update_date = SYSDATE,
7543: a.last_updated_by = FND_GLOBAL.USER_ID,
7544: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7545: WHERE a.account_allocation_id = l_temp_account_allocation_id;
7546:
7547: IF (SQL%NOTFOUND) THEN
7548: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 7571: t.last_updated_by = FND_GLOBAL.USER_ID,

7567: UPDATE OZF_TIME_ALLOCATIONS t
7568: SET t.TARGET = t.TARGET + l_diff_target,
7569: t.object_version_number = t.object_version_number + 1,
7570: t.last_update_date = SYSDATE,
7571: t.last_updated_by = FND_GLOBAL.USER_ID,
7572: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7573: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
7574: FROM OZF_TIME_ALLOCATIONS x
7575: WHERE x.allocation_for = 'PROD'

Line 7572: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7568: SET t.TARGET = t.TARGET + l_diff_target,
7569: t.object_version_number = t.object_version_number + 1,
7570: t.last_update_date = SYSDATE,
7571: t.last_updated_by = FND_GLOBAL.USER_ID,
7572: t.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7573: WHERE t.time_allocation_id = (SELECT max(x.time_allocation_id)
7574: FROM OZF_TIME_ALLOCATIONS x
7575: WHERE x.allocation_for = 'PROD'
7576: AND x.allocation_for_id IN ( SELECT max(p.product_allocation_id)

Line 7621: p.last_updated_by = FND_GLOBAL.USER_ID,

7617: UPDATE OZF_PRODUCT_ALLOCATIONS p
7618: SET p.TARGET = p.TARGET + l_diff_target,
7619: p.object_version_number = p.object_version_number + 1,
7620: p.last_update_date = SYSDATE,
7621: p.last_updated_by = FND_GLOBAL.USER_ID,
7622: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7623: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7624:
7625: IF (SQL%NOTFOUND) THEN

Line 7622: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

7618: SET p.TARGET = p.TARGET + l_diff_target,
7619: p.object_version_number = p.object_version_number + 1,
7620: p.last_update_date = SYSDATE,
7621: p.last_updated_by = FND_GLOBAL.USER_ID,
7622: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7623: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7624:
7625: IF (SQL%NOTFOUND) THEN
7626: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 8270: a.last_updated_by = FND_GLOBAL.USER_ID,

8266: SET a.target = a.target + l_total_account_target,
8267: a.lysp_sales = a.lysp_sales + l_total_account_sales,
8268: a.object_version_number = a.object_version_number + 1,
8269: a.last_update_date = SYSDATE,
8270: a.last_updated_by = FND_GLOBAL.USER_ID,
8271: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8272: WHERE a.account_allocation_id = l_account_allocation_id;
8273:
8274: <>

Line 8271: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

8267: a.lysp_sales = a.lysp_sales + l_total_account_sales,
8268: a.object_version_number = a.object_version_number + 1,
8269: a.last_update_date = SYSDATE,
8270: a.last_updated_by = FND_GLOBAL.USER_ID,
8271: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8272: WHERE a.account_allocation_id = l_account_allocation_id;
8273:
8274: <>
8275: FOR l_idx IN l_period_tbl.first..l_period_tbl.last

Line 8307: p_created_by => FND_GLOBAL.USER_ID,

8303: p_target => p_time_alloc_rec.target,
8304: p_lysp_sales => p_time_alloc_rec.lysp_sales,
8305: px_object_version_number => l_object_version_number,
8306: p_creation_date => SYSDATE,
8307: p_created_by => FND_GLOBAL.USER_ID,
8308: p_last_update_date => SYSDATE,
8309: p_last_updated_by => FND_GLOBAL.USER_ID,
8310: p_last_update_login => FND_GLOBAL.conc_login_id,
8311: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 8309: p_last_updated_by => FND_GLOBAL.USER_ID,

8305: px_object_version_number => l_object_version_number,
8306: p_creation_date => SYSDATE,
8307: p_created_by => FND_GLOBAL.USER_ID,
8308: p_last_update_date => SYSDATE,
8309: p_last_updated_by => FND_GLOBAL.USER_ID,
8310: p_last_update_login => FND_GLOBAL.conc_login_id,
8311: p_attribute_category => p_time_alloc_rec.attribute_category,
8312: p_attribute1 => p_time_alloc_rec.attribute1,
8313: p_attribute2 => p_time_alloc_rec.attribute2,

Line 8310: p_last_update_login => FND_GLOBAL.conc_login_id,

8306: p_creation_date => SYSDATE,
8307: p_created_by => FND_GLOBAL.USER_ID,
8308: p_last_update_date => SYSDATE,
8309: p_last_updated_by => FND_GLOBAL.USER_ID,
8310: p_last_update_login => FND_GLOBAL.conc_login_id,
8311: p_attribute_category => p_time_alloc_rec.attribute_category,
8312: p_attribute1 => p_time_alloc_rec.attribute1,
8313: p_attribute2 => p_time_alloc_rec.attribute2,
8314: p_attribute3 => p_time_alloc_rec.attribute3,

Line 8435: p_created_by => FND_GLOBAL.USER_ID,

8431: p_target => p_time_alloc_rec.target,
8432: p_lysp_sales => p_time_alloc_rec.lysp_sales,
8433: px_object_version_number => l_object_version_number,
8434: p_creation_date => SYSDATE,
8435: p_created_by => FND_GLOBAL.USER_ID,
8436: p_last_update_date => SYSDATE,
8437: p_last_updated_by => FND_GLOBAL.USER_ID,
8438: p_last_update_login => FND_GLOBAL.conc_login_id,
8439: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 8437: p_last_updated_by => FND_GLOBAL.USER_ID,

8433: px_object_version_number => l_object_version_number,
8434: p_creation_date => SYSDATE,
8435: p_created_by => FND_GLOBAL.USER_ID,
8436: p_last_update_date => SYSDATE,
8437: p_last_updated_by => FND_GLOBAL.USER_ID,
8438: p_last_update_login => FND_GLOBAL.conc_login_id,
8439: p_attribute_category => p_time_alloc_rec.attribute_category,
8440: p_attribute1 => p_time_alloc_rec.attribute1,
8441: p_attribute2 => p_time_alloc_rec.attribute2,

Line 8438: p_last_update_login => FND_GLOBAL.conc_login_id,

8434: p_creation_date => SYSDATE,
8435: p_created_by => FND_GLOBAL.USER_ID,
8436: p_last_update_date => SYSDATE,
8437: p_last_updated_by => FND_GLOBAL.USER_ID,
8438: p_last_update_login => FND_GLOBAL.conc_login_id,
8439: p_attribute_category => p_time_alloc_rec.attribute_category,
8440: p_attribute1 => p_time_alloc_rec.attribute1,
8441: p_attribute2 => p_time_alloc_rec.attribute2,
8442: p_attribute3 => p_time_alloc_rec.attribute3,

Line 8467: p.last_updated_by = FND_GLOBAL.USER_ID,

8463: SET p.lysp_sales = p.lysp_sales + l_total_product_sales,
8464: p.target = p.target + l_total_product_target,
8465: p.object_version_number = p.object_version_number + 1,
8466: p.last_update_date = SYSDATE,
8467: p.last_updated_by = FND_GLOBAL.USER_ID,
8468: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8469: WHERE p.product_allocation_id = l_product_allocation_id;
8470:
8471: END LOOP account_product_loop;

Line 8468: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

8464: p.target = p.target + l_total_product_target,
8465: p.object_version_number = p.object_version_number + 1,
8466: p.last_update_date = SYSDATE,
8467: p.last_updated_by = FND_GLOBAL.USER_ID,
8468: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8469: WHERE p.product_allocation_id = l_product_allocation_id;
8470:
8471: END LOOP account_product_loop;
8472:

Line 8494: a.last_updated_by = FND_GLOBAL.USER_ID,

8490: UPDATE ozf_account_allocations a
8491: SET a.target = a.target + l_total_target_unalloc,
8492: a.object_version_number = a.object_version_number + 1,
8493: a.last_update_date = SYSDATE,
8494: a.last_updated_by = FND_GLOBAL.USER_ID,
8495: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8496: WHERE a.allocation_for = 'FUND'
8497: AND a.allocation_for_id = l_fund_id
8498: AND a.site_use_id = -9999

Line 8495: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

8491: SET a.target = a.target + l_total_target_unalloc,
8492: a.object_version_number = a.object_version_number + 1,
8493: a.last_update_date = SYSDATE,
8494: a.last_updated_by = FND_GLOBAL.USER_ID,
8495: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
8496: WHERE a.allocation_for = 'FUND'
8497: AND a.allocation_for_id = l_fund_id
8498: AND a.site_use_id = -9999
8499: RETURNING account_allocation_id INTO l_account_allocation_id;

Line 8527: p_created_by => FND_GLOBAL.USER_ID,

8523: p_target => p_time_alloc_rec.target,
8524: p_lysp_sales => p_time_alloc_rec.lysp_sales,
8525: px_object_version_number => l_object_version_number,
8526: p_creation_date => SYSDATE,
8527: p_created_by => FND_GLOBAL.USER_ID,
8528: p_last_update_date => SYSDATE,
8529: p_last_updated_by => FND_GLOBAL.USER_ID,
8530: p_last_update_login => FND_GLOBAL.conc_login_id,
8531: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 8529: p_last_updated_by => FND_GLOBAL.USER_ID,

8525: px_object_version_number => l_object_version_number,
8526: p_creation_date => SYSDATE,
8527: p_created_by => FND_GLOBAL.USER_ID,
8528: p_last_update_date => SYSDATE,
8529: p_last_updated_by => FND_GLOBAL.USER_ID,
8530: p_last_update_login => FND_GLOBAL.conc_login_id,
8531: p_attribute_category => p_time_alloc_rec.attribute_category,
8532: p_attribute1 => p_time_alloc_rec.attribute1,
8533: p_attribute2 => p_time_alloc_rec.attribute2,

Line 8530: p_last_update_login => FND_GLOBAL.conc_login_id,

8526: p_creation_date => SYSDATE,
8527: p_created_by => FND_GLOBAL.USER_ID,
8528: p_last_update_date => SYSDATE,
8529: p_last_updated_by => FND_GLOBAL.USER_ID,
8530: p_last_update_login => FND_GLOBAL.conc_login_id,
8531: p_attribute_category => p_time_alloc_rec.attribute_category,
8532: p_attribute1 => p_time_alloc_rec.attribute1,
8533: p_attribute2 => p_time_alloc_rec.attribute2,
8534: p_attribute3 => p_time_alloc_rec.attribute3,

Line 9735: p_created_by => FND_GLOBAL.USER_ID,

9731: p_lysp_sales => p_acct_alloc_rec.lysp_sales,
9732: p_parent_Account_allocation_id => p_acct_alloc_rec.parent_account_allocation_id,
9733: px_object_version_number => l_object_version_number,
9734: p_creation_date => SYSDATE,
9735: p_created_by => FND_GLOBAL.USER_ID,
9736: p_last_update_date => SYSDATE,
9737: p_last_updated_by => FND_GLOBAL.USER_ID,
9738: p_last_update_login => FND_GLOBAL.conc_login_id,
9739: p_attribute_category => p_acct_alloc_rec.attribute_category,

Line 9737: p_last_updated_by => FND_GLOBAL.USER_ID,

9733: px_object_version_number => l_object_version_number,
9734: p_creation_date => SYSDATE,
9735: p_created_by => FND_GLOBAL.USER_ID,
9736: p_last_update_date => SYSDATE,
9737: p_last_updated_by => FND_GLOBAL.USER_ID,
9738: p_last_update_login => FND_GLOBAL.conc_login_id,
9739: p_attribute_category => p_acct_alloc_rec.attribute_category,
9740: p_attribute1 => p_acct_alloc_rec.attribute1,
9741: p_attribute2 => p_acct_alloc_rec.attribute2,

Line 9738: p_last_update_login => FND_GLOBAL.conc_login_id,

9734: p_creation_date => SYSDATE,
9735: p_created_by => FND_GLOBAL.USER_ID,
9736: p_last_update_date => SYSDATE,
9737: p_last_updated_by => FND_GLOBAL.USER_ID,
9738: p_last_update_login => FND_GLOBAL.conc_login_id,
9739: p_attribute_category => p_acct_alloc_rec.attribute_category,
9740: p_attribute1 => p_acct_alloc_rec.attribute1,
9741: p_attribute2 => p_acct_alloc_rec.attribute2,
9742: p_attribute3 => p_acct_alloc_rec.attribute3,

Line 9774: p_created_by => FND_GLOBAL.USER_ID,

9770: p_target => p_time_alloc_rec.target,
9771: p_lysp_sales => p_time_alloc_rec.lysp_sales,
9772: px_object_version_number => l_object_version_number,
9773: p_creation_date => SYSDATE,
9774: p_created_by => FND_GLOBAL.USER_ID,
9775: p_last_update_date => SYSDATE,
9776: p_last_updated_by => FND_GLOBAL.USER_ID,
9777: p_last_update_login => FND_GLOBAL.conc_login_id,
9778: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 9776: p_last_updated_by => FND_GLOBAL.USER_ID,

9772: px_object_version_number => l_object_version_number,
9773: p_creation_date => SYSDATE,
9774: p_created_by => FND_GLOBAL.USER_ID,
9775: p_last_update_date => SYSDATE,
9776: p_last_updated_by => FND_GLOBAL.USER_ID,
9777: p_last_update_login => FND_GLOBAL.conc_login_id,
9778: p_attribute_category => p_time_alloc_rec.attribute_category,
9779: p_attribute1 => p_time_alloc_rec.attribute1,
9780: p_attribute2 => p_time_alloc_rec.attribute2,

Line 9777: p_last_update_login => FND_GLOBAL.conc_login_id,

9773: p_creation_date => SYSDATE,
9774: p_created_by => FND_GLOBAL.USER_ID,
9775: p_last_update_date => SYSDATE,
9776: p_last_updated_by => FND_GLOBAL.USER_ID,
9777: p_last_update_login => FND_GLOBAL.conc_login_id,
9778: p_attribute_category => p_time_alloc_rec.attribute_category,
9779: p_attribute1 => p_time_alloc_rec.attribute1,
9780: p_attribute2 => p_time_alloc_rec.attribute2,
9781: p_attribute3 => p_time_alloc_rec.attribute3,

Line 9920: aa.last_updated_by = FND_GLOBAL.USER_ID,

9916: AND ti.ALLOCATION_FOR_ID = aa.account_allocation_id
9917: ),
9918: aa.object_version_number = aa.object_version_number + 1,
9919: aa.last_update_date = SYSDATE,
9920: aa.last_updated_by = FND_GLOBAL.USER_ID,
9921: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9922: WHERE
9923: (aa.account_allocation_id = l_account_allocation_id)
9924: OR

Line 9921: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

9917: ),
9918: aa.object_version_number = aa.object_version_number + 1,
9919: aa.last_update_date = SYSDATE,
9920: aa.last_updated_by = FND_GLOBAL.USER_ID,
9921: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9922: WHERE
9923: (aa.account_allocation_id = l_account_allocation_id)
9924: OR
9925: (

Line 9958: p_created_by => FND_GLOBAL.USER_ID,

9954: p_lysp_sales => p_prod_alloc_rec.lysp_sales,
9955: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
9956: px_object_version_number => l_object_version_number,
9957: p_creation_date => SYSDATE,
9958: p_created_by => FND_GLOBAL.USER_ID,
9959: p_last_update_date => SYSDATE,
9960: p_last_updated_by => FND_GLOBAL.USER_ID,
9961: p_last_update_login => FND_GLOBAL.conc_login_id,
9962: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 9960: p_last_updated_by => FND_GLOBAL.USER_ID,

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

Line 9961: p_last_update_login => FND_GLOBAL.conc_login_id,

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

Line 9995: p_created_by => FND_GLOBAL.USER_ID,

9991: p_target => p_time_alloc_rec.target,
9992: p_lysp_sales => p_time_alloc_rec.lysp_sales,
9993: px_object_version_number => l_object_version_number,
9994: p_creation_date => SYSDATE,
9995: p_created_by => FND_GLOBAL.USER_ID,
9996: p_last_update_date => SYSDATE,
9997: p_last_updated_by => FND_GLOBAL.USER_ID,
9998: p_last_update_login => FND_GLOBAL.conc_login_id,
9999: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 9997: p_last_updated_by => FND_GLOBAL.USER_ID,

9993: px_object_version_number => l_object_version_number,
9994: p_creation_date => SYSDATE,
9995: p_created_by => FND_GLOBAL.USER_ID,
9996: p_last_update_date => SYSDATE,
9997: p_last_updated_by => FND_GLOBAL.USER_ID,
9998: p_last_update_login => FND_GLOBAL.conc_login_id,
9999: p_attribute_category => p_time_alloc_rec.attribute_category,
10000: p_attribute1 => p_time_alloc_rec.attribute1,
10001: p_attribute2 => p_time_alloc_rec.attribute2,

Line 9998: p_last_update_login => FND_GLOBAL.conc_login_id,

9994: p_creation_date => SYSDATE,
9995: p_created_by => FND_GLOBAL.USER_ID,
9996: p_last_update_date => SYSDATE,
9997: p_last_updated_by => FND_GLOBAL.USER_ID,
9998: p_last_update_login => FND_GLOBAL.conc_login_id,
9999: p_attribute_category => p_time_alloc_rec.attribute_category,
10000: p_attribute1 => p_time_alloc_rec.attribute1,
10001: p_attribute2 => p_time_alloc_rec.attribute2,
10002: p_attribute3 => p_time_alloc_rec.attribute3,

Line 10054: p.last_updated_by = FND_GLOBAL.USER_ID,

10050: WHERE ti.ALLOCATION_FOR = 'PROD'
10051: AND ti.ALLOCATION_FOR_ID = p.product_allocation_id),
10052: p.object_version_number = p.object_version_number + 1,
10053: p.last_update_date = SYSDATE,
10054: p.last_updated_by = FND_GLOBAL.USER_ID,
10055: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10056: WHERE p.product_allocation_id = l_product_allocation_id;
10057:
10058: END LOOP; --- FOR p_prod_alloc_rec IN corr_prod_alloc_rec

Line 10055: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

10051: AND ti.ALLOCATION_FOR_ID = p.product_allocation_id),
10052: p.object_version_number = p.object_version_number + 1,
10053: p.last_update_date = SYSDATE,
10054: p.last_updated_by = FND_GLOBAL.USER_ID,
10055: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10056: WHERE p.product_allocation_id = l_product_allocation_id;
10057:
10058: END LOOP; --- FOR p_prod_alloc_rec IN corr_prod_alloc_rec
10059:

Line 10095: p_created_by => FND_GLOBAL.USER_ID,

10091: p_lysp_sales => p_prod_alloc_rec.lysp_sales,
10092: p_parent_product_allocation_id => p_prod_alloc_rec.parent_product_allocation_id,
10093: px_object_version_number => l_object_version_number,
10094: p_creation_date => SYSDATE,
10095: p_created_by => FND_GLOBAL.USER_ID,
10096: p_last_update_date => SYSDATE,
10097: p_last_updated_by => FND_GLOBAL.USER_ID,
10098: p_last_update_login => FND_GLOBAL.conc_login_id,
10099: p_attribute_category => p_prod_alloc_rec.attribute_category,

Line 10097: p_last_updated_by => FND_GLOBAL.USER_ID,

10093: px_object_version_number => l_object_version_number,
10094: p_creation_date => SYSDATE,
10095: p_created_by => FND_GLOBAL.USER_ID,
10096: p_last_update_date => SYSDATE,
10097: p_last_updated_by => FND_GLOBAL.USER_ID,
10098: p_last_update_login => FND_GLOBAL.conc_login_id,
10099: p_attribute_category => p_prod_alloc_rec.attribute_category,
10100: p_attribute1 => p_prod_alloc_rec.attribute1,
10101: p_attribute2 => p_prod_alloc_rec.attribute2,

Line 10098: p_last_update_login => FND_GLOBAL.conc_login_id,

10094: p_creation_date => SYSDATE,
10095: p_created_by => FND_GLOBAL.USER_ID,
10096: p_last_update_date => SYSDATE,
10097: p_last_updated_by => FND_GLOBAL.USER_ID,
10098: p_last_update_login => FND_GLOBAL.conc_login_id,
10099: p_attribute_category => p_prod_alloc_rec.attribute_category,
10100: p_attribute1 => p_prod_alloc_rec.attribute1,
10101: p_attribute2 => p_prod_alloc_rec.attribute2,
10102: p_attribute3 => p_prod_alloc_rec.attribute3,

Line 10180: p_created_by => FND_GLOBAL.USER_ID,

10176: p_target => p_time_alloc_rec.target,
10177: p_lysp_sales => p_time_alloc_rec.lysp_sales,
10178: px_object_version_number => l_object_version_number,
10179: p_creation_date => SYSDATE,
10180: p_created_by => FND_GLOBAL.USER_ID,
10181: p_last_update_date => SYSDATE,
10182: p_last_updated_by => FND_GLOBAL.USER_ID,
10183: p_last_update_login => FND_GLOBAL.conc_login_id,
10184: p_attribute_category => p_time_alloc_rec.attribute_category,

Line 10182: p_last_updated_by => FND_GLOBAL.USER_ID,

10178: px_object_version_number => l_object_version_number,
10179: p_creation_date => SYSDATE,
10180: p_created_by => FND_GLOBAL.USER_ID,
10181: p_last_update_date => SYSDATE,
10182: p_last_updated_by => FND_GLOBAL.USER_ID,
10183: p_last_update_login => FND_GLOBAL.conc_login_id,
10184: p_attribute_category => p_time_alloc_rec.attribute_category,
10185: p_attribute1 => p_time_alloc_rec.attribute1,
10186: p_attribute2 => p_time_alloc_rec.attribute2,

Line 10183: p_last_update_login => FND_GLOBAL.conc_login_id,

10179: p_creation_date => SYSDATE,
10180: p_created_by => FND_GLOBAL.USER_ID,
10181: p_last_update_date => SYSDATE,
10182: p_last_updated_by => FND_GLOBAL.USER_ID,
10183: p_last_update_login => FND_GLOBAL.conc_login_id,
10184: p_attribute_category => p_time_alloc_rec.attribute_category,
10185: p_attribute1 => p_time_alloc_rec.attribute1,
10186: p_attribute2 => p_time_alloc_rec.attribute2,
10187: p_attribute3 => p_time_alloc_rec.attribute3,

Line 10214: p.last_updated_by = FND_GLOBAL.USER_ID,

10210: UPDATE OZF_PRODUCT_ALLOCATIONS p
10211: SET p.lysp_sales = l_total_product_sales,
10212: p.object_version_number = p.object_version_number + 1,
10213: p.last_update_date = SYSDATE,
10214: p.last_updated_by = FND_GLOBAL.USER_ID,
10215: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10216: WHERE p.product_allocation_id = l_product_allocation_id;
10217:
10218: END LOOP account_product_loop;

Line 10215: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

10211: SET p.lysp_sales = l_total_product_sales,
10212: p.object_version_number = p.object_version_number + 1,
10213: p.last_update_date = SYSDATE,
10214: p.last_updated_by = FND_GLOBAL.USER_ID,
10215: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10216: WHERE p.product_allocation_id = l_product_allocation_id;
10217:
10218: END LOOP account_product_loop;
10219:

Line 10401: aa.last_updated_by = FND_GLOBAL.USER_ID,

10397: AND ti.ALLOCATION_FOR_ID = aa.account_allocation_id
10398: ),
10399: aa.object_version_number = aa.object_version_number + 1,
10400: aa.last_update_date = SYSDATE,
10401: aa.last_updated_by = FND_GLOBAL.USER_ID,
10402: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10403: WHERE aa.account_allocation_id = l_unalloc_acct_alloc_id;
10404: END;
10405:

Line 10402: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

10398: ),
10399: aa.object_version_number = aa.object_version_number + 1,
10400: aa.last_update_date = SYSDATE,
10401: aa.last_updated_by = FND_GLOBAL.USER_ID,
10402: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10403: WHERE aa.account_allocation_id = l_unalloc_acct_alloc_id;
10404: END;
10405:
10406: -- 2. ADJUSTING SHIP TO Time records. - Curr and Future Periods ...

Line 10448: aa.last_updated_by = FND_GLOBAL.USER_ID,

10444: ),
10445: aa.account_status = 'D',
10446: aa.object_version_number = aa.object_version_number + 1,
10447: aa.last_update_date = SYSDATE,
10448: aa.last_updated_by = FND_GLOBAL.USER_ID,
10449: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10450: WHERE
10451: aa.account_allocation_id = l_account_allocation_id;
10452: END;

Line 10449: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

10445: aa.account_status = 'D',
10446: aa.object_version_number = aa.object_version_number + 1,
10447: aa.last_update_date = SYSDATE,
10448: aa.last_updated_by = FND_GLOBAL.USER_ID,
10449: aa.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10450: WHERE
10451: aa.account_allocation_id = l_account_allocation_id;
10452: END;
10453:

Line 10499: p.last_updated_by = FND_GLOBAL.USER_ID,

10495: AND ti.ALLOCATION_FOR_ID = p.product_allocation_id),
10496: p.account_status = 'D',
10497: p.object_version_number = p.object_version_number + 1,
10498: p.last_update_date = SYSDATE,
10499: p.last_updated_by = FND_GLOBAL.USER_ID,
10500: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10501: WHERE p.product_allocation_id IN (
10502: SELECT pp.product_allocation_id
10503: FROM ozf_product_allocations pp

Line 10500: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID

10496: p.account_status = 'D',
10497: p.object_version_number = p.object_version_number + 1,
10498: p.last_update_date = SYSDATE,
10499: p.last_updated_by = FND_GLOBAL.USER_ID,
10500: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
10501: WHERE p.product_allocation_id IN (
10502: SELECT pp.product_allocation_id
10503: FROM ozf_product_allocations pp
10504: WHERE pp.allocation_for = 'CUST'