DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on FND_PROFILE

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

4511: WHERE inventory_item_id = P_Item_id
4512: AND organization_id = P_Org_Id
4513: AND cost_type_id = l_prim_cost_method;
4514:
4515: /* l_profile_exists := FND_PROFILE.DEFINED('CST_AVG_COSTING_OPTION');
4516:
4517: IF l_profile_exists THEN
4518: FND_PROFILE.GET ('CST_AVG_COSTING_OPTION',l_profile_val);
4519: END IF; Bug 4247149*/

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

4514:
4515: /* l_profile_exists := FND_PROFILE.DEFINED('CST_AVG_COSTING_OPTION');
4516:
4517: IF l_profile_exists THEN
4518: FND_PROFILE.GET ('CST_AVG_COSTING_OPTION',l_profile_val);
4519: END IF; Bug 4247149*/
4520:
4521: IF (l_prim_cost_method IN (2,5,6))
4522: /* AND l_profile_exists AND (l_profile_val = '2')) Bug 4247149*/

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

6027: update mtl_system_items_tl
6028: set description = ltrim(rtrim(x_description)),
6029: long_description = ltrim(rtrim(x_long_description)),
6030: source_lang = x_language,
6031: last_updated_by = fnd_profile.value('USER_ID'),
6032: last_update_login = fnd_profile.value('LOGIN_ID')
6033: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
6034: AND ORGANIZATION_ID = X_ORGANIZATION_ID;
6035:

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

6028: set description = ltrim(rtrim(x_description)),
6029: long_description = ltrim(rtrim(x_long_description)),
6030: source_lang = x_language,
6031: last_updated_by = fnd_profile.value('USER_ID'),
6032: last_update_login = fnd_profile.value('LOGIN_ID')
6033: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
6034: AND ORGANIZATION_ID = X_ORGANIZATION_ID;
6035:
6036: */

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

6040: update mtl_system_items_tl
6041: set description = ltrim(rtrim(x_description)),
6042: source_lang = x_language,
6043: last_update_date = sysdate,
6044: last_updated_by = fnd_profile.value('USER_ID'),
6045: last_update_login = fnd_profile.value('LOGIN_ID')
6046: where CURRENT OF Item_csr;
6047:
6048: end if;

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

6041: set description = ltrim(rtrim(x_description)),
6042: source_lang = x_language,
6043: last_update_date = sysdate,
6044: last_updated_by = fnd_profile.value('USER_ID'),
6045: last_update_login = fnd_profile.value('LOGIN_ID')
6046: where CURRENT OF Item_csr;
6047:
6048: end if;
6049:

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

6051: update mtl_system_items_tl
6052: set long_description = ltrim(rtrim(x_long_description)),
6053: source_lang = x_language,
6054: last_update_date = sysdate,
6055: last_updated_by = fnd_profile.value('USER_ID'),
6056: last_update_login = fnd_profile.value('LOGIN_ID')
6057: where CURRENT OF Item_csr;
6058:
6059: end if;

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

6052: set long_description = ltrim(rtrim(x_long_description)),
6053: source_lang = x_language,
6054: last_update_date = sysdate,
6055: last_updated_by = fnd_profile.value('USER_ID'),
6056: last_update_login = fnd_profile.value('LOGIN_ID')
6057: where CURRENT OF Item_csr;
6058:
6059: end if;
6060: end loop;