DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_PVT dependencies on FND_GLOBAL

Line 426: , FND_GLOBAL.user_id

422: , p.organization_id
423: , p_category_set_id
424: , p_category_id
425: , SYSDATE
426: , FND_GLOBAL.user_id
427: , SYSDATE
428: , FND_GLOBAL.user_id
429: , FND_GLOBAL.login_id
430: , FND_GLOBAL.conc_request_id

Line 428: , FND_GLOBAL.user_id

424: , p_category_id
425: , SYSDATE
426: , FND_GLOBAL.user_id
427: , SYSDATE
428: , FND_GLOBAL.user_id
429: , FND_GLOBAL.login_id
430: , FND_GLOBAL.conc_request_id
431: FROM mtl_parameters p , mtl_system_items_b i
432: WHERE p.master_organization_id = p_master_org_id

Line 429: , FND_GLOBAL.login_id

425: , SYSDATE
426: , FND_GLOBAL.user_id
427: , SYSDATE
428: , FND_GLOBAL.user_id
429: , FND_GLOBAL.login_id
430: , FND_GLOBAL.conc_request_id
431: FROM mtl_parameters p , mtl_system_items_b i
432: WHERE p.master_organization_id = p_master_org_id
433: AND i.inventory_item_id = p_inventory_item_id

Line 430: , FND_GLOBAL.conc_request_id

426: , FND_GLOBAL.user_id
427: , SYSDATE
428: , FND_GLOBAL.user_id
429: , FND_GLOBAL.login_id
430: , FND_GLOBAL.conc_request_id
431: FROM mtl_parameters p , mtl_system_items_b i
432: WHERE p.master_organization_id = p_master_org_id
433: AND i.inventory_item_id = p_inventory_item_id
434: AND i.organization_id = p.organization_id

Line 463: , FND_GLOBAL.user_id

459: , p_organization_id
460: , p_category_set_id
461: , p_category_id
462: , SYSDATE
463: , FND_GLOBAL.user_id
464: , SYSDATE
465: , FND_GLOBAL.user_id
466: , FND_GLOBAL.login_id
467: , FND_GLOBAL.conc_request_id

Line 465: , FND_GLOBAL.user_id

461: , p_category_id
462: , SYSDATE
463: , FND_GLOBAL.user_id
464: , SYSDATE
465: , FND_GLOBAL.user_id
466: , FND_GLOBAL.login_id
467: , FND_GLOBAL.conc_request_id
468: );
469: END IF;

Line 466: , FND_GLOBAL.login_id

462: , SYSDATE
463: , FND_GLOBAL.user_id
464: , SYSDATE
465: , FND_GLOBAL.user_id
466: , FND_GLOBAL.login_id
467: , FND_GLOBAL.conc_request_id
468: );
469: END IF;
470: IF (l_debug = 1) THEN

Line 467: , FND_GLOBAL.conc_request_id

463: , FND_GLOBAL.user_id
464: , SYSDATE
465: , FND_GLOBAL.user_id
466: , FND_GLOBAL.login_id
467: , FND_GLOBAL.conc_request_id
468: );
469: END IF;
470: IF (l_debug = 1) THEN
471: INV_ITEM_MSG.Debug(Mctx, 'end INSERT INTO mtl_item_categories');

Line 1290: ,last_updated_by = FND_GLOBAL.user_id

1286: UPDATE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */
1287: Mtl_Item_Categories MIC
1288: SET Category_Id = p_category_id
1289: ,last_update_date = SYSDATE
1290: ,last_updated_by = FND_GLOBAL.user_id
1291: ,last_update_login = FND_GLOBAL.login_id
1292: ,request_id = FND_GLOBAL.conc_request_id -- 4105867
1293: WHERE category_set_id = p_category_set_id
1294: AND category_id = p_old_category_id

Line 1291: ,last_update_login = FND_GLOBAL.login_id

1287: Mtl_Item_Categories MIC
1288: SET Category_Id = p_category_id
1289: ,last_update_date = SYSDATE
1290: ,last_updated_by = FND_GLOBAL.user_id
1291: ,last_update_login = FND_GLOBAL.login_id
1292: ,request_id = FND_GLOBAL.conc_request_id -- 4105867
1293: WHERE category_set_id = p_category_set_id
1294: AND category_id = p_old_category_id
1295: AND inventory_item_id = p_inventory_item_id

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

1288: SET Category_Id = p_category_id
1289: ,last_update_date = SYSDATE
1290: ,last_updated_by = FND_GLOBAL.user_id
1291: ,last_update_login = FND_GLOBAL.login_id
1292: ,request_id = FND_GLOBAL.conc_request_id -- 4105867
1293: WHERE category_set_id = p_category_set_id
1294: AND category_id = p_old_category_id
1295: AND inventory_item_id = p_inventory_item_id
1296: AND organization_id =(SELECT organization_id

Line 1327: ,last_updated_by = FND_GLOBAL.user_id

1323: ELSE
1324: UPDATE Mtl_Item_Categories
1325: SET Category_Id = p_category_id
1326: ,last_update_date = SYSDATE
1327: ,last_updated_by = FND_GLOBAL.user_id
1328: ,last_update_login = FND_GLOBAL.login_id
1329: ,request_id = FND_GLOBAL.conc_request_id --4105867
1330: WHERE organization_id = p_organization_id
1331: AND inventory_item_id = p_inventory_item_id

Line 1328: ,last_update_login = FND_GLOBAL.login_id

1324: UPDATE Mtl_Item_Categories
1325: SET Category_Id = p_category_id
1326: ,last_update_date = SYSDATE
1327: ,last_updated_by = FND_GLOBAL.user_id
1328: ,last_update_login = FND_GLOBAL.login_id
1329: ,request_id = FND_GLOBAL.conc_request_id --4105867
1330: WHERE organization_id = p_organization_id
1331: AND inventory_item_id = p_inventory_item_id
1332: AND category_set_id = p_category_set_id

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

1325: SET Category_Id = p_category_id
1326: ,last_update_date = SYSDATE
1327: ,last_updated_by = FND_GLOBAL.user_id
1328: ,last_update_login = FND_GLOBAL.login_id
1329: ,request_id = FND_GLOBAL.conc_request_id --4105867
1330: WHERE organization_id = p_organization_id
1331: AND inventory_item_id = p_inventory_item_id
1332: AND category_set_id = p_category_set_id
1333: AND category_id = p_old_category_id;