DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on OE_SYS_PARAMETERS

Line 2892: = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

2888: INTO l_bom_item_type
2889: FROM mtl_system_items
2890: WHERE inventory_item_id = l_line_rec.inventory_item_id
2891: AND organization_id
2892: = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2893:
2894: IF l_debug_level > 0 THEN
2895: oe_debug_pub.add('old Line Item exists '
2896: ||l_bom_item_type, 1);

Line 5544: l_auto_sch_flag:= Nvl(oe_sys_parameters.Value('ONT_AUTO_SCH_SETS',p_line_tbl(1).org_id),'Y');

5540: IF p_line_tbl.count>0 THEN
5541: IF l_debug_level > 0 THEN
5542: oe_debug_pub.add( 'get org id' , 1 ) ;
5543: END IF;
5544: l_auto_sch_flag:= Nvl(oe_sys_parameters.Value('ONT_AUTO_SCH_SETS',p_line_tbl(1).org_id),'Y');
5545:
5546: END IF ;
5547:
5548: --4241385

Line 11791: l_validation_org NUMBER := OE_SYS_PARAMETERS.VALUE

11787: ,p_process_partial IN BOOLEAN := FALSE)
11788: IS
11789: l_model_seq_id NUMBER;
11790: l_rev_date DATE;
11791: l_validation_org NUMBER := OE_SYS_PARAMETERS.VALUE
11792: ('MASTER_ORGANIZATION_ID');
11793: l_model_ordered_item VARCHAR2(2000);
11794: l_bom_item_type NUMBER;
11795: l_line_rec OE_Order_Pub.Line_Rec_Type;

Line 12079: l_validation_org NUMBER := OE_SYS_PARAMETERS.VALUE

12075: l_component_code VARCHAR2(1000);
12076: l_model_quantity NUMBER;
12077: l_model_seq_id NUMBER;
12078: l_rev_date DATE;
12079: l_validation_org NUMBER := OE_SYS_PARAMETERS.VALUE
12080: ('MASTER_ORGANIZATION_ID');
12081: l_ato_line_id NUMBER;
12082: l_option_index NUMBER;
12083: l_remember_index NUMBER;