DBA Data[Home] [Help]

APPS.OE_PROCESS_OPTIONS_PVT dependencies on OE_CONFIG_UTIL

Line 293: OE_Config_Util.Cascade_Updates_Deletes

289: IF l_debug_level > 0 THEN
290: oe_debug_pub.add( 'CALLING CASCADE_UPDATES_DELETES' , 1 ) ;
291: END IF;
292:
293: OE_Config_Util.Cascade_Updates_Deletes
294: ( p_model_line_id => p_top_model_line_id
295: ,p_model_component => l_model_line_rec.component_code
296: ,p_x_options_tbl => l_options_tbl
297: ,p_deleted_options_tbl => l_deleted_options_tbl

Line 765: OE_Config_Util.Default_Child_Line

761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add( 'DIRECT SAVE IS ON' , 3 ) ;
763: END IF;
764:
765: OE_Config_Util.Default_Child_Line
766: ( p_parent_line_rec => p_model_line_rec
767: ,p_x_child_line_rec => l_class_line_rec
768: ,p_direct_save => l_direct_save
769: ,x_return_status => l_return_status);

Line 1244: WHERE be.explosion_type = OE_Config_Util.OE_BMX_OPTION_COMPS

1240: p_x_options_tbl(I).order_quantity_uom,
1241: p_x_options_tbl(I).ordered_quantity,
1242: p_x_options_tbl(I).bom_item_type
1243: FROM bom_explosions be
1244: WHERE be.explosion_type = OE_Config_Util.OE_BMX_OPTION_COMPS
1245: AND be.top_bill_sequence_id = p_top_bill_sequence_id
1246: AND be.plan_level > 0
1247: AND be.effectivity_date <= p_effective_date
1248: AND be.disable_date > p_effective_date

Line 1573: := OE_Config_Util.OE_BMX_OPTION_COMPS;

1569: l_old_behavior VARCHAR2(1);
1570: l_validation_org NUMBER :=
1571: OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
1572: l_stdcompflag VARCHAR2(10)
1573: := OE_Config_Util.OE_BMX_OPTION_COMPS;
1574: l_top_item_id NUMBER;
1575: l_op_qty NUMBER;
1576: l_top_bill_sequence_id NUMBER;
1577: l_disable_code NUMBER := 1;

Line 1597: OE_Config_Util.Get_Config_Effective_Date

1593: IF p_caller is NOT NULL AND
1594: p_query_criteria > 1 AND
1595: OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
1596:
1597: OE_Config_Util.Get_Config_Effective_Date
1598: ( p_model_line_id => p_top_model_line_id
1599: ,x_old_behavior => l_old_behavior
1600: ,x_config_effective_date => l_config_effective_date
1601: ,x_frozen_model_bill => l_frozen_model_bill);

Line 1610: OE_CONFIG_UTIL.Explode

1606: INTO l_top_item_id, l_top_bill_sequence_id
1607: FROM oe_order_lines
1608: WHERE line_id = p_top_model_line_id;
1609:
1610: OE_CONFIG_UTIL.Explode
1611: ( p_validation_org => OE_SYS_PARAMETERS.VALUE
1612: ('MASTER_ORGANIZATION_ID')
1613: , p_stdcompflag => l_stdcompflag
1614: , p_top_item_id => l_top_item_id

Line 1643: AND explosion_type = Oe_Config_Util.OE_BMX_OPTION_COMPS

1639: SELECT 1
1640: INTO l_disable_code
1641: FROM bom_explosions
1642: WHERE component_item_id = opt_rec.inventory_item_id
1643: AND explosion_type = Oe_Config_Util.OE_BMX_OPTION_COMPS
1644: AND top_bill_sequence_id = l_top_bill_sequence_id
1645: AND effectivity_date <= l_config_effective_date
1646: AND disable_date > l_config_effective_date
1647: AND organization_id = OE_SYS_PARAMETERS.VALUE