DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_PVT dependencies on FND_GLOBAL

Line 436: , FND_GLOBAL.user_id

432: , p.organization_id
433: , p_category_set_id
434: , p_category_id
435: , SYSDATE
436: , FND_GLOBAL.user_id
437: , SYSDATE
438: , FND_GLOBAL.user_id
439: , FND_GLOBAL.login_id
440: , FND_GLOBAL.conc_request_id

Line 438: , FND_GLOBAL.user_id

434: , p_category_id
435: , SYSDATE
436: , FND_GLOBAL.user_id
437: , SYSDATE
438: , FND_GLOBAL.user_id
439: , FND_GLOBAL.login_id
440: , FND_GLOBAL.conc_request_id
441: FROM mtl_parameters p , mtl_system_items_b i
442: WHERE p.master_organization_id = p_master_org_id

Line 439: , FND_GLOBAL.login_id

435: , SYSDATE
436: , FND_GLOBAL.user_id
437: , SYSDATE
438: , FND_GLOBAL.user_id
439: , FND_GLOBAL.login_id
440: , FND_GLOBAL.conc_request_id
441: FROM mtl_parameters p , mtl_system_items_b i
442: WHERE p.master_organization_id = p_master_org_id
443: AND i.inventory_item_id = p_inventory_item_id

Line 440: , FND_GLOBAL.conc_request_id

436: , FND_GLOBAL.user_id
437: , SYSDATE
438: , FND_GLOBAL.user_id
439: , FND_GLOBAL.login_id
440: , FND_GLOBAL.conc_request_id
441: FROM mtl_parameters p , mtl_system_items_b i
442: WHERE p.master_organization_id = p_master_org_id
443: AND i.inventory_item_id = p_inventory_item_id
444: AND i.organization_id = p.organization_id

Line 473: , FND_GLOBAL.user_id

469: , p_organization_id
470: , p_category_set_id
471: , p_category_id
472: , SYSDATE
473: , FND_GLOBAL.user_id
474: , SYSDATE
475: , FND_GLOBAL.user_id
476: , FND_GLOBAL.login_id
477: , FND_GLOBAL.conc_request_id

Line 475: , FND_GLOBAL.user_id

471: , p_category_id
472: , SYSDATE
473: , FND_GLOBAL.user_id
474: , SYSDATE
475: , FND_GLOBAL.user_id
476: , FND_GLOBAL.login_id
477: , FND_GLOBAL.conc_request_id
478: );
479: END IF;

Line 476: , FND_GLOBAL.login_id

472: , SYSDATE
473: , FND_GLOBAL.user_id
474: , SYSDATE
475: , FND_GLOBAL.user_id
476: , FND_GLOBAL.login_id
477: , FND_GLOBAL.conc_request_id
478: );
479: END IF;
480: IF (l_debug = 1) THEN

Line 477: , FND_GLOBAL.conc_request_id

473: , FND_GLOBAL.user_id
474: , SYSDATE
475: , FND_GLOBAL.user_id
476: , FND_GLOBAL.login_id
477: , FND_GLOBAL.conc_request_id
478: );
479: END IF;
480: IF (l_debug = 1) THEN
481: INV_ITEM_MSG.Debug(Mctx, 'end INSERT INTO mtl_item_categories');

Line 1302: ,last_updated_by = FND_GLOBAL.user_id

1298: UPDATE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */
1299: Mtl_Item_Categories MIC
1300: SET Category_Id = p_category_id
1301: ,last_update_date = SYSDATE
1302: ,last_updated_by = FND_GLOBAL.user_id
1303: ,last_update_login = FND_GLOBAL.login_id
1304: ,request_id = FND_GLOBAL.conc_request_id -- 4105867
1305: WHERE category_set_id = p_category_set_id
1306: AND category_id = p_old_category_id

Line 1303: ,last_update_login = FND_GLOBAL.login_id

1299: Mtl_Item_Categories MIC
1300: SET Category_Id = p_category_id
1301: ,last_update_date = SYSDATE
1302: ,last_updated_by = FND_GLOBAL.user_id
1303: ,last_update_login = FND_GLOBAL.login_id
1304: ,request_id = FND_GLOBAL.conc_request_id -- 4105867
1305: WHERE category_set_id = p_category_set_id
1306: AND category_id = p_old_category_id
1307: AND inventory_item_id = p_inventory_item_id

Line 1304: ,request_id = FND_GLOBAL.conc_request_id -- 4105867

1300: SET Category_Id = p_category_id
1301: ,last_update_date = SYSDATE
1302: ,last_updated_by = FND_GLOBAL.user_id
1303: ,last_update_login = FND_GLOBAL.login_id
1304: ,request_id = FND_GLOBAL.conc_request_id -- 4105867
1305: WHERE category_set_id = p_category_set_id
1306: AND category_id = p_old_category_id
1307: AND inventory_item_id = p_inventory_item_id
1308: --Bug 12901485

Line 1357: ,last_updated_by = FND_GLOBAL.user_id

1353: ELSE
1354: UPDATE Mtl_Item_Categories
1355: SET Category_Id = p_category_id
1356: ,last_update_date = SYSDATE
1357: ,last_updated_by = FND_GLOBAL.user_id
1358: ,last_update_login = FND_GLOBAL.login_id
1359: ,request_id = FND_GLOBAL.conc_request_id --4105867
1360: WHERE organization_id = p_organization_id
1361: AND inventory_item_id = p_inventory_item_id

Line 1358: ,last_update_login = FND_GLOBAL.login_id

1354: UPDATE Mtl_Item_Categories
1355: SET Category_Id = p_category_id
1356: ,last_update_date = SYSDATE
1357: ,last_updated_by = FND_GLOBAL.user_id
1358: ,last_update_login = FND_GLOBAL.login_id
1359: ,request_id = FND_GLOBAL.conc_request_id --4105867
1360: WHERE organization_id = p_organization_id
1361: AND inventory_item_id = p_inventory_item_id
1362: AND category_set_id = p_category_set_id

Line 1359: ,request_id = FND_GLOBAL.conc_request_id --4105867

1355: SET Category_Id = p_category_id
1356: ,last_update_date = SYSDATE
1357: ,last_updated_by = FND_GLOBAL.user_id
1358: ,last_update_login = FND_GLOBAL.login_id
1359: ,request_id = FND_GLOBAL.conc_request_id --4105867
1360: WHERE organization_id = p_organization_id
1361: AND inventory_item_id = p_inventory_item_id
1362: AND category_set_id = p_category_set_id
1363: AND category_id = p_old_category_id;