DBA Data[Home] [Help]

APPS.OE_PROCESS_OPTIONS_PVT dependencies on OE_SYS_PARAMETERS

Line 1221: l_validation_org := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');

1217: END IF;
1218: RETURN;
1219: END IF;
1220:
1221: l_validation_org := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
1222:
1223: I := l_index_before_fill + 1;
1224: WHILE I is not null
1225: LOOP

Line 1571: OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');

1567: l_config_effective_date DATE;
1568: l_frozen_model_bill VARCHAR2(1) := 'Y';
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;

Line 1611: ( p_validation_org => OE_SYS_PARAMETERS.VALUE

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
1615: , p_revdate => l_config_effective_date

Line 1647: AND organization_id = OE_SYS_PARAMETERS.VALUE

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
1648: ('MASTER_ORGANIZATION_ID')
1649: AND component_code = opt_rec.component_code;
1650:
1651: IF p_query_criteria in (1,2,4) THEN