APPS.INV_ITEM_PVT dependencies on FND_PROFILE

Line 4780: /* l_profile_exists := FND_PROFILE.DEFINED('CST_AVG_COSTING_OPTION');

4776: WHERE inventory_item_id = P_Item_id
4777: AND organization_id = P_Org_Id
4778: AND cost_type_id = l_prim_cost_method;
4779:
4780: /* l_profile_exists := FND_PROFILE.DEFINED('CST_AVG_COSTING_OPTION');
4781:
4782: IF l_profile_exists THEN
4783: FND_PROFILE.GET ('CST_AVG_COSTING_OPTION',l_profile_val);
4784: END IF; Bug 4247149*/

Line 4783: FND_PROFILE.GET ('CST_AVG_COSTING_OPTION',l_profile_val);

4779:
4780: /* l_profile_exists := FND_PROFILE.DEFINED('CST_AVG_COSTING_OPTION');
4781:
4782: IF l_profile_exists THEN
4783: FND_PROFILE.GET ('CST_AVG_COSTING_OPTION',l_profile_val);
4784: END IF; Bug 4247149*/
4785:
4786: IF (l_prim_cost_method IN (2,5,6))
4787: /* AND l_profile_exists AND (l_profile_val = '2')) Bug 4247149*/

Line 6534: last_updated_by = fnd_profile.value('USER_ID'),

6530: update mtl_system_items_tl
6531: set description = ltrim(rtrim(x_description)),
6532: long_description = ltrim(rtrim(x_long_description)),
6533: source_lang = x_language,
6534: last_updated_by = fnd_profile.value('USER_ID'),
6535: last_update_login = fnd_profile.value('LOGIN_ID')
6536: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
6537: AND ORGANIZATION_ID = X_ORGANIZATION_ID;
6538:

Line 6535: last_update_login = fnd_profile.value('LOGIN_ID')

6531: set description = ltrim(rtrim(x_description)),
6532: long_description = ltrim(rtrim(x_long_description)),
6533: source_lang = x_language,
6534: last_updated_by = fnd_profile.value('USER_ID'),
6535: last_update_login = fnd_profile.value('LOGIN_ID')
6536: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
6537: AND ORGANIZATION_ID = X_ORGANIZATION_ID;
6538:
6539: */

Line 6547: last_updated_by = fnd_profile.value('USER_ID'),

6543: update mtl_system_items_tl
6544: set description = ltrim(rtrim(x_description)),
6545: source_lang = x_language,
6546: last_update_date = sysdate,
6547: last_updated_by = fnd_profile.value('USER_ID'),
6548: last_update_login = fnd_profile.value('LOGIN_ID')
6549: where CURRENT OF Item_csr;
6550:
6551: end if;

Line 6548: last_update_login = fnd_profile.value('LOGIN_ID')

6544: set description = ltrim(rtrim(x_description)),
6545: source_lang = x_language,
6546: last_update_date = sysdate,
6547: last_updated_by = fnd_profile.value('USER_ID'),
6548: last_update_login = fnd_profile.value('LOGIN_ID')
6549: where CURRENT OF Item_csr;
6550:
6551: end if;
6552:

Line 6558: last_updated_by = fnd_profile.value('USER_ID'),

6554: update mtl_system_items_tl
6555: set long_description = ltrim(rtrim(x_long_description)),
6556: source_lang = x_language,
6557: last_update_date = sysdate,
6558: last_updated_by = fnd_profile.value('USER_ID'),
6559: last_update_login = fnd_profile.value('LOGIN_ID')
6560: where CURRENT OF Item_csr;
6561:
6562: end if;

Line 6559: last_update_login = fnd_profile.value('LOGIN_ID')

6555: set long_description = ltrim(rtrim(x_long_description)),
6556: source_lang = x_language,
6557: last_update_date = sysdate,
6558: last_updated_by = fnd_profile.value('USER_ID'),
6559: last_update_login = fnd_profile.value('LOGIN_ID')
6560: where CURRENT OF Item_csr;
6561:
6562: end if;
6563: end loop;