DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_WF_WRAPPER_PVT

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

4442: AND STYLE_ITEM_FLAG = 'N';
4443:
4444: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
4445: IF SQL%ROWCOUNT > 0 THEN
4446: EGO_WF_WRAPPER_PVT.Set_Item_Bulkload_Bus_Event(p_true_false => p_enable_sku_processing);
4447: END IF;
4448:
4449: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_SYSTEM_ITEMS_INTERFACE Processed rows='||SQL%ROWCOUNT);
4450:

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

4466: AND msik.STYLE_ITEM_FLAG = 'N'
4467: );
4468:
4469: IF SQL%ROWCOUNT > 0 THEN
4470: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => p_enable_sku_processing);
4471: END IF;
4472:
4473: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_REVISIONS_INTERFACE Processed rows='||SQL%ROWCOUNT);
4474:

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

4490: AND msik.STYLE_ITEM_FLAG = 'N'
4491: );
4492:
4493: -- calling this unconditionally, because we will be going through processing SKUs always
4494: EGO_WF_WRAPPER_PVT.Set_Category_Assign_Bus_Event(p_true_false => p_enable_sku_processing);
4495:
4496: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_CATEGORIES_INTERFACE Processed rows='||SQL%ROWCOUNT);
4497:
4498: -- for user defined attributes, all the process statuses are already in use i.e.

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

4517: AND msik.STYLE_ITEM_FLAG = 'N'
4518: );
4519:
4520: IF SQL%ROWCOUNT > 0 THEN
4521: EGO_WF_WRAPPER_PVT.Set_PostAttr_Change_Event(p_true_false => p_enable_sku_processing);
4522: END IF;
4523:
4524: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITM_USR_ATTR_INTRFC Processed rows='||SQL%ROWCOUNT);
4525:

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

4541: AND msik.STYLE_ITEM_FLAG = 'N'
4542: );
4543:
4544: IF SQL%ROWCOUNT > 0 THEN
4545: EGO_WF_WRAPPER_PVT.Set_PostAml_Change_Event(p_true_false => p_enable_sku_processing);
4546: END IF;
4547:
4548: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_AML_INTF Processed rows='||SQL%ROWCOUNT);
4549:

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

4585: AND msik.STYLE_ITEM_FLAG = 'N'
4586: );
4587:
4588: IF SQL%ROWCOUNT > 0 THEN
4589: EGO_WF_WRAPPER_PVT.Set_Item_People_Event(p_true_false => p_enable_sku_processing);
4590: END IF;
4591:
4592: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_PEOPLE_INTF Processed rows='||SQL%ROWCOUNT);
4593:

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

4594: ELSIF p_enable_sku_processing = 'T' THEN
4595: Debug_Conc_Log('Enable_Disable_SKU_Processing: Enabling SKUs');
4596:
4597: --Maybe set to T if batch contains ONLY Styles, to prevent raising again in such cases
4598: EGO_WF_WRAPPER_PVT.Set_Item_Bulkload_Bus_Event(p_true_false => 'F');
4599:
4600: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
4601: SET PROCESS_FLAG = 1
4602: WHERE SET_PROCESS_ID = p_batch_id

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

4604: AND STYLE_ITEM_FLAG = 'N';
4605:
4606: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
4607: IF SQL%ROWCOUNT > 0 THEN
4608: EGO_WF_WRAPPER_PVT.Set_Item_Bulkload_Bus_Event(p_true_false => p_enable_sku_processing);
4609: END IF;
4610: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_SYSTEM_ITEMS_INTERFACE Processed rows='||SQL%ROWCOUNT);
4611:
4612: IF SQL%ROWCOUNT > 0 THEN

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

4642: AND PROCESS_FLAG = 10;
4643:
4644: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
4645: IF SQL%ROWCOUNT > 0 THEN
4646: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => p_enable_sku_processing);
4647: END IF;
4648: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_REVISIONS_INTERFACE Processed rows='||SQL%ROWCOUNT);
4649:
4650: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

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

4652: WHERE SET_PROCESS_ID = p_batch_id
4653: AND PROCESS_FLAG = 10;
4654:
4655: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
4656: EGO_WF_WRAPPER_PVT.Set_Category_Assign_Bus_Event(p_true_false => p_enable_sku_processing);
4657: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_CATEGORIES_INTERFACE Processed rows='||SQL%ROWCOUNT);
4658:
4659: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4660: SET PROCESS_STATUS = 1

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

4662: AND PROCESS_STATUS = 1.5;
4663:
4664: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
4665: IF SQL%ROWCOUNT > 0 THEN
4666: EGO_WF_WRAPPER_PVT.Set_PostAttr_Change_Event(p_true_false => p_enable_sku_processing);
4667: END IF;
4668: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITM_USR_ATTR_INTRFC Processed rows='||SQL%ROWCOUNT);
4669:
4670: UPDATE EGO_AML_INTF eai

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

4673: AND PROCESS_FLAG = 10;
4674:
4675: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
4676: IF SQL%ROWCOUNT > 0 THEN
4677: EGO_WF_WRAPPER_PVT.Set_PostAml_Change_Event(p_true_false => p_enable_sku_processing);
4678: END IF;
4679: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_AML_INTF Processed rows='||SQL%ROWCOUNT);
4680:
4681: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai

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

4691: AND PROCESS_STATUS = 10;
4692:
4693: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
4694: IF SQL%ROWCOUNT > 0 THEN
4695: EGO_WF_WRAPPER_PVT.Set_Item_People_Event(p_true_false => p_enable_sku_processing);
4696: END IF;
4697: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_PEOPLE_INTF Processed rows='||SQL%ROWCOUNT);
4698: END IF;
4699: