DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_WF_WRAPPER_PVT

Line 5145: EGO_WF_WRAPPER_PVT.Set_Item_Bulkload_Bus_Event(p_true_false => p_enable_sku_processing);

5141: AND STYLE_ITEM_FLAG = 'N';
5142:
5143: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
5144: IF SQL%ROWCOUNT > 0 THEN
5145: EGO_WF_WRAPPER_PVT.Set_Item_Bulkload_Bus_Event(p_true_false => p_enable_sku_processing);
5146: END IF;
5147:
5148: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_SYSTEM_ITEMS_INTERFACE Processed rows='||SQL%ROWCOUNT);
5149:

Line 5169: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => p_enable_sku_processing);

5165: AND msik.STYLE_ITEM_FLAG = 'N'
5166: );
5167:
5168: IF SQL%ROWCOUNT > 0 THEN
5169: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => p_enable_sku_processing);
5170: END IF;
5171:
5172: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_REVISIONS_INTERFACE Processed rows='||SQL%ROWCOUNT);
5173:

Line 5194: EGO_WF_WRAPPER_PVT.Set_Category_Assign_Bus_Event(p_true_false => p_enable_sku_processing);

5190: );
5191:
5192: -- calling this unconditionally, because we will be going through processing SKUs always
5193: IF SQL%ROWCOUNT > 0 THEN
5194: EGO_WF_WRAPPER_PVT.Set_Category_Assign_Bus_Event(p_true_false => p_enable_sku_processing);
5195: END IF;
5196: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_CATEGORIES_INTERFACE Processed rows='||SQL%ROWCOUNT);
5197:
5198: -- for user defined attributes, all the process statuses are already in use i.e.

Line 5221: EGO_WF_WRAPPER_PVT.Set_PostAttr_Change_Event(p_true_false => p_enable_sku_processing);

5217: AND msik.STYLE_ITEM_FLAG = 'N'
5218: );
5219:
5220: IF SQL%ROWCOUNT > 0 THEN
5221: EGO_WF_WRAPPER_PVT.Set_PostAttr_Change_Event(p_true_false => p_enable_sku_processing);
5222: END IF;
5223:
5224: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITM_USR_ATTR_INTRFC Processed rows='||SQL%ROWCOUNT);
5225:

Line 5245: EGO_WF_WRAPPER_PVT.Set_PostAml_Change_Event(p_true_false => p_enable_sku_processing);

5241: AND msik.STYLE_ITEM_FLAG = 'N'
5242: );
5243:
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:

Line 5289: EGO_WF_WRAPPER_PVT.Set_Item_People_Event(p_true_false => p_enable_sku_processing);

5285: AND msik.STYLE_ITEM_FLAG = 'N'
5286: );
5287:
5288: IF SQL%ROWCOUNT > 0 THEN
5289: EGO_WF_WRAPPER_PVT.Set_Item_People_Event(p_true_false => p_enable_sku_processing);
5290: END IF;
5291:
5292: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_PEOPLE_INTF Processed rows='||SQL%ROWCOUNT);
5293:

Line 5298: EGO_WF_WRAPPER_PVT.Set_Item_Bulkload_Bus_Event(p_true_false => 'F');

5294: ELSIF p_enable_sku_processing = 'T' THEN
5295: Debug_Conc_Log('Enable_Disable_SKU_Processing: Enabling SKUs');
5296:
5297: --Maybe set to T if batch contains ONLY Styles, to prevent raising again in such cases
5298: EGO_WF_WRAPPER_PVT.Set_Item_Bulkload_Bus_Event(p_true_false => 'F');
5299:
5300: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
5301: SET PROCESS_FLAG = 1
5302: WHERE SET_PROCESS_ID = p_batch_id

Line 5314: EGO_WF_WRAPPER_PVT.Set_Item_Bulkload_Bus_Event(p_true_false => p_enable_sku_processing);

5310: -- Bug 9678667 : change end
5311:
5312: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
5313: IF SQL%ROWCOUNT > 0 THEN
5314: EGO_WF_WRAPPER_PVT.Set_Item_Bulkload_Bus_Event(p_true_false => p_enable_sku_processing);
5315: END IF;
5316: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_SYSTEM_ITEMS_INTERFACE Processed rows='||SQL%ROWCOUNT);
5317:
5318: IF SQL%ROWCOUNT > 0 THEN

Line 5362: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => p_enable_sku_processing);

5358: -- Bug 9678667 : change end
5359:
5360: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
5361: IF SQL%ROWCOUNT > 0 THEN
5362: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => p_enable_sku_processing);
5363: ELSE
5364: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => 'F'); -- Bug #9341964, make sure biz event is fired only once
5365: END IF;
5366: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_REVISIONS_INTERFACE Processed rows='||SQL%ROWCOUNT);

Line 5364: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => 'F'); -- Bug #9341964, make sure biz event is fired only once

5360: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
5361: IF SQL%ROWCOUNT > 0 THEN
5362: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => p_enable_sku_processing);
5363: ELSE
5364: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => 'F'); -- Bug #9341964, make sure biz event is fired only once
5365: END IF;
5366: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_REVISIONS_INTERFACE Processed rows='||SQL%ROWCOUNT);
5367:
5368: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

Line 5381: EGO_WF_WRAPPER_PVT.Set_Category_Assign_Bus_Event(p_true_false => p_enable_sku_processing);

5377: -- Bug 9678667 : change end
5378:
5379: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
5380: IF(SQL%ROWCOUNT > 0) THEN
5381: EGO_WF_WRAPPER_PVT.Set_Category_Assign_Bus_Event(p_true_false => p_enable_sku_processing);
5382: END IF;
5383: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_CATEGORIES_INTERFACE Processed rows='||SQL%ROWCOUNT);
5384:
5385: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

Line 5398: EGO_WF_WRAPPER_PVT.Set_PostAttr_Change_Event(p_true_false => p_enable_sku_processing);

5394: -- Bug 9678667 : change end
5395:
5396: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
5397: IF SQL%ROWCOUNT > 0 THEN
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

Line 5415: EGO_WF_WRAPPER_PVT.Set_PostAml_Change_Event(p_true_false => p_enable_sku_processing);

5411: -- Bug 9678667 : change end
5412:
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

Line 5445: EGO_WF_WRAPPER_PVT.Set_Item_People_Event(p_true_false => p_enable_sku_processing);

5441: -- Bug 9678667 : change end
5442:
5443: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
5444: IF SQL%ROWCOUNT > 0 THEN
5445: EGO_WF_WRAPPER_PVT.Set_Item_People_Event(p_true_false => p_enable_sku_processing);
5446: END IF;
5447: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_PEOPLE_INTF Processed rows='||SQL%ROWCOUNT);
5448: END IF;
5449: