DBA Data[Home] [Help]

APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 115: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

111: BEGIN
112: IF (p_copy_inventory_item_Id IS NOT NULL) THEN
113: l_copy_from_organization_id := p_organization_id;
114: END IF;
115: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
116: ( SET_PROCESS_ID,
117: PROCESS_FLAG,
118: TRANSACTION_TYPE,
119: TEMPLATE_ID,

Line 312: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

308: l_org_assignment := 'N';
309: l_inventory_item_id := NULL;
310: END;
311:
312: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
313: ( SET_PROCESS_ID ,
314: PROCESS_FLAG ,
315: TRANSACTION_TYPE ,
316: TEMPLATE_ID ,

Line 455: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;

451: )
452: )
453: ORDER BY ATTR_EXT.ATTR_ID;
454:
455: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
456: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
457: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
458: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
459: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;

Line 456: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;

452: )
453: ORDER BY ATTR_EXT.ATTR_ID;
454:
455: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
456: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
457: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
458: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
459: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
460: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;

Line 457: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;

453: ORDER BY ATTR_EXT.ATTR_ID;
454:
455: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
456: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
457: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
458: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
459: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
460: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;
461: l_concat_value VARCHAR2(32000);

Line 458: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;

454:
455: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
456: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
457: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
458: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
459: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
460: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;
461: l_concat_value VARCHAR2(32000);
462: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 459: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;

455: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
456: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
457: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
458: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
459: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
460: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;
461: l_concat_value VARCHAR2(32000);
462: l_user_id NUMBER := FND_GLOBAL.USER_ID;
463: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

Line 460: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;

456: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
457: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
458: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
459: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
460: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;
461: l_concat_value VARCHAR2(32000);
462: l_user_id NUMBER := FND_GLOBAL.USER_ID;
463: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
464: l_delimeter EGO_DEFAULT_OPTIONS.OPTION_VALUE%TYPE;

Line 474: FROM MTL_SYSTEM_ITEMS_INTERFACE

470:
471: l_delimeter := NVL(EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_SKU_CONCAT_VA_DELIM'), '.');
472: SELECT SET_PROCESS_ID, INVENTORY_ITEM_ID, ITEM_NUMBER, ORGANIZATION_ID, ITEM_CATALOG_GROUP_ID, STYLE_ITEM_ID
473: INTO l_batch_id, l_sku_item_id, l_item_number, l_org_id, l_category_id, l_style_item_id
474: FROM MTL_SYSTEM_ITEMS_INTERFACE
475: WHERE ROWID = p_intf_row_id;
476:
477: Debug_Conc_Log('Batch_id, item_id, item_number, org_id, icc_id, style_item_id='||
478: l_batch_id||', '||l_sku_item_id||', '||l_item_number||', '||l_org_id||', '||

Line 740: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

736: ,x_return_status OUT NOCOPY VARCHAR2
737: ,x_msg_data OUT NOCOPY VARCHAR2)
738: IS
739: BEGIN
740: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
741: ( SET_PROCESS_ID,
742: PROCESS_FLAG,
743: TRANSACTION_TYPE,
744: ITEM_CATALOG_GROUP_ID,

Line 764: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,

760: p_organization_id,
761: p_item_number,
762: p_style_item_flag,
763: p_style_item_id,
764: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,
765: EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID,
766: 'FK'
767: );
768: