eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_GTIN_PVT dependencies on BOM_ROLLUP_PUB

Line 1371: l_action_map Bom_Rollup_Pub.Rollup_Action_Map := Bom_Rollup_Pub.G_EMPTY_ACTION_MAP;

1367:
1368: Canceled_Date CONSTANT VARCHAR2(100) := 'Canceled_Date';
1369: Discontinued_Date CONSTANT VARCHAR2(100) := 'Discontinued_Date';
1370:
1371: l_action_map Bom_Rollup_Pub.Rollup_Action_Map := Bom_Rollup_Pub.G_EMPTY_ACTION_MAP;
1372: l_structure_type_name VARCHAR2(200);
1373: x_error_message VARCHAR2(2000);
1374: l_rollup_reqd BOOLEAN := FALSE;
1375: l_gtin MTL_CROSS_REFERENCES.CROSS_REFERENCE%TYPE;

Line 2181: l_action_map Bom_Rollup_Pub.Rollup_Action_Map;

2177: , p_attr_group_id IN NUMBER DEFAULT NULL
2178: , x_error_message OUT NOCOPY VARCHAR2
2179: )
2180: IS
2181: l_action_map Bom_Rollup_Pub.Rollup_Action_Map;
2182: l_item_id NUMBER;
2183: l_organization_id NUMBER;
2184: l_structure_type_name VARCHAR2(200);
2185:

Line 2207: l_action_map := Bom_Rollup_Pub.G_EMPTY_ACTION_MAP;

2203:
2204: l_api_name := 'Item_Propagate_Attributes';
2205: WRITE_DEBUG_LOG(l_api_name || ': Started ');
2206: l_item_obj_name := 'EGO_ITEM';
2207: l_action_map := Bom_Rollup_Pub.G_EMPTY_ACTION_MAP;
2208: l_structure_type_name := 'Packaging Hierarchy';
2209:
2210: l_propagate_brand_info := FALSE;
2211: l_propagate_mfg_info := FALSE;

Line 2321: Bom_Rollup_Pub.Add_Rollup_Function

2317: END IF; -- there exists attr diffs
2318: WRITE_DEBUG_LOG(l_api_name || ': using params ('||l_item_id||','||l_organization_id||','||l_structure_type_name||')');
2319:
2320: IF l_propagate_brand_info THEN
2321: Bom_Rollup_Pub.Add_Rollup_Function
2322: ( p_Object_Name => l_item_obj_name
2323: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPOGATE_BRAND_INFO
2324: , p_DML_Function => 'Bom_Compute_Functions.Set_Brand_Info'
2325: , p_DML_Delayed_Write => 'N'

Line 2323: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPOGATE_BRAND_INFO

2319:
2320: IF l_propagate_brand_info THEN
2321: Bom_Rollup_Pub.Add_Rollup_Function
2322: ( p_Object_Name => l_item_obj_name
2323: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPOGATE_BRAND_INFO
2324: , p_DML_Function => 'Bom_Compute_Functions.Set_Brand_Info'
2325: , p_DML_Delayed_Write => 'N'
2326: , x_Rollup_Action_Map => l_action_map
2327: );

Line 2331: Bom_Rollup_Pub.Add_Rollup_Function

2327: );
2328: END IF;
2329:
2330: IF l_propagate_mfg_info THEN
2331: Bom_Rollup_Pub.Add_Rollup_Function
2332: ( p_Object_Name => l_item_obj_name
2333: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_MULTI_ROW_ATTRS
2334: , p_DML_Function => 'Bom_Compute_Functions.Set_Multirow_Attributes'
2335: , p_DML_Delayed_Write => 'N'

Line 2333: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_MULTI_ROW_ATTRS

2329:
2330: IF l_propagate_mfg_info THEN
2331: Bom_Rollup_Pub.Add_Rollup_Function
2332: ( p_Object_Name => l_item_obj_name
2333: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_MULTI_ROW_ATTRS
2334: , p_DML_Function => 'Bom_Compute_Functions.Set_Multirow_Attributes'
2335: , p_DML_Delayed_Write => 'N'
2336: , x_Rollup_Action_Map => l_action_map
2337: );

Line 2341: Bom_Rollup_Pub.Add_Rollup_Function

2337: );
2338: END IF;
2339:
2340: IF l_trade_item_or_consumer_unit OR l_propagate_top_gtin THEN
2341: Bom_Rollup_Pub.Add_Rollup_Function
2342: ( p_Object_Name => l_item_obj_name
2343: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_TOP_GTIN_FLAG
2344: , p_DML_Function => 'Bom_Compute_Functions.Set_Top_GTIN_Flag'
2345: , p_DML_Delayed_Write => 'N'

Line 2343: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_TOP_GTIN_FLAG

2339:
2340: IF l_trade_item_or_consumer_unit OR l_propagate_top_gtin THEN
2341: Bom_Rollup_Pub.Add_Rollup_Function
2342: ( p_Object_Name => l_item_obj_name
2343: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_TOP_GTIN_FLAG
2344: , p_DML_Function => 'Bom_Compute_Functions.Set_Top_GTIN_Flag'
2345: , p_DML_Delayed_Write => 'N'
2346: , x_Rollup_Action_Map => l_action_map
2347: );

Line 2351: Bom_Rollup_Pub.Add_Rollup_Function

2347: );
2348: END IF;
2349:
2350: IF l_propagate_sh_temps THEN
2351: Bom_Rollup_Pub.Add_Rollup_Function
2352: ( p_Object_Name => l_item_obj_name
2353: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPAGATE_SH_TEMPS
2354: , p_DML_Function => 'Bom_Compute_Functions.Set_SH_Temps'
2355: , p_DML_Delayed_Write => 'N'

Line 2353: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPAGATE_SH_TEMPS

2349:
2350: IF l_propagate_sh_temps THEN
2351: Bom_Rollup_Pub.Add_Rollup_Function
2352: ( p_Object_Name => l_item_obj_name
2353: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPAGATE_SH_TEMPS
2354: , p_DML_Function => 'Bom_Compute_Functions.Set_SH_Temps'
2355: , p_DML_Delayed_Write => 'N'
2356: , x_Rollup_Action_Map => l_action_map
2357: );

Line 2361: Bom_Rollup_Pub.Add_Rollup_Function

2357: );
2358: END IF;
2359:
2360: IF l_propagate_unit_weight THEN
2361: Bom_Rollup_Pub.Add_Rollup_Function
2362: ( p_Object_Name => 'EGO_ITEM'
2363: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT
2364: , p_DML_Function => 'Bom_Compute_Functions.Set_Net_Weight'
2365: , p_DML_Delayed_Write => 'N'

Line 2363: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT

2359:
2360: IF l_propagate_unit_weight THEN
2361: Bom_Rollup_Pub.Add_Rollup_Function
2362: ( p_Object_Name => 'EGO_ITEM'
2363: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT
2364: , p_DML_Function => 'Bom_Compute_Functions.Set_Net_Weight'
2365: , p_DML_Delayed_Write => 'N'
2366: , x_Rollup_Action_Map => l_action_map
2367: );

Line 2378: WRITE_DEBUG_LOG(l_api_name || ': calling Bom_Rollup_Pub.Perform_Rollup');

2374: l_trade_item_or_consumer_unit OR
2375: l_propagate_sh_temps OR
2376: l_propagate_top_gtin OR
2377: l_propagate_unit_weight THEN
2378: WRITE_DEBUG_LOG(l_api_name || ': calling Bom_Rollup_Pub.Perform_Rollup');
2379: Bom_Rollup_Pub.Perform_Rollup
2380: ( p_item_id => l_item_id
2381: , p_organization_id => l_organization_id
2382: , p_structure_type_name => l_structure_type_name

Line 2379: Bom_Rollup_Pub.Perform_Rollup

2375: l_propagate_sh_temps OR
2376: l_propagate_top_gtin OR
2377: l_propagate_unit_weight THEN
2378: WRITE_DEBUG_LOG(l_api_name || ': calling Bom_Rollup_Pub.Perform_Rollup');
2379: Bom_Rollup_Pub.Perform_Rollup
2380: ( p_item_id => l_item_id
2381: , p_organization_id => l_organization_id
2382: , p_structure_type_name => l_structure_type_name
2383: , p_pk_column_name_value_pairs => p_pk_column_name_value_pairs

Line 2583: , p_data_level_name_value_pairs => Bom_Rollup_Pub.g_data_level_name_value_pairs

2579: , p_attr_group_name => p_attr_group_name
2580: , p_pk_column_name_value_pairs => l_pk_columns
2581: , p_class_code_name_value_pairs => l_class_code
2582: -- , p_data_level_name_value_pairs => l_data_level
2583: , p_data_level_name_value_pairs => Bom_Rollup_Pub.g_data_level_name_value_pairs
2584: , p_attr_name_value_pairs => l_attr_new_values
2585: -- this is very important, because otherwise, updates would trigger rollups, creating an infinite loop
2586: , p_debug_level => p_debug_level
2587: , p_bulkload_flag => FND_API.G_TRUE

Line 2778: ** Added by Amay - for getting of attribute diff objects (called by BOM_ROLLUP_PUB)

2774:
2775: --------------------------------
2776:
2777: /*
2778: ** Added by Amay - for getting of attribute diff objects (called by BOM_ROLLUP_PUB)
2779: */
2780: PROCEDURE Get_Attr_Diffs
2781: ( p_inventory_item_id IN NUMBER
2782: , p_org_id IN NUMBER