[Home] [Help]
5222: END IF;
5223:
5224: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITM_USR_ATTR_INTRFC Processed rows='||SQL%ROWCOUNT);
5225:
5226: UPDATE EGO_AML_INTF eai
5227: SET PROCESS_FLAG = 10
5228: WHERE DATA_SET_ID = p_batch_id
5229: AND PROCESS_FLAG = 1
5230: AND EXISTS (SELECT NULL FROM MTL_SYSTEM_ITEMS_INTERFACE msii
5244: IF SQL%ROWCOUNT > 0 THEN
5245: EGO_WF_WRAPPER_PVT.Set_PostAml_Change_Event(p_true_false => p_enable_sku_processing);
5246: END IF;
5247:
5248: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_AML_INTF Processed rows='||SQL%ROWCOUNT);
5249:
5250: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
5251: SET PROCESS_FLAG = 10
5252: WHERE BATCH_ID = p_batch_id
5398: EGO_WF_WRAPPER_PVT.Set_PostAttr_Change_Event(p_true_false => p_enable_sku_processing);
5399: END IF;
5400: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITM_USR_ATTR_INTRFC Processed rows='||SQL%ROWCOUNT);
5401:
5402: UPDATE EGO_AML_INTF eai
5403: SET PROCESS_FLAG = 1
5404: WHERE DATA_SET_ID = p_batch_id
5405: AND PROCESS_FLAG = 10;
5406:
5413: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
5414: IF SQL%ROWCOUNT > 0 THEN
5415: EGO_WF_WRAPPER_PVT.Set_PostAml_Change_Event(p_true_false => p_enable_sku_processing);
5416: END IF;
5417: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_AML_INTF Processed rows='||SQL%ROWCOUNT);
5418:
5419: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
5420: SET PROCESS_FLAG = 1
5421: WHERE BATCH_ID = p_batch_id
5985: AND ITEM_NUMBER = p_old_item_number;
5986: END IF;
5987: -- Fix for bug#9660659 End
5988:
5989: UPDATE EGO_AML_INTF
5990: SET ITEM_NUMBER = p_item_number
5991: WHERE PROCESS_FLAG = 1
5992: AND DATA_SET_ID = p_batch_id
5993: AND SOURCE_SYSTEM_ID = p_ss_id