DBA Data[Home] [Help]

APPS.OE_PROCESS_OPTIONS_PVT dependencies on OE_SYS_PARAMETERS

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

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

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

1568: l_config_effective_date DATE;
1569: l_frozen_model_bill VARCHAR2(1) := 'Y';
1570: l_old_behavior VARCHAR2(1);
1571: l_validation_org NUMBER :=
1572: OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
1573: l_stdcompflag VARCHAR2(10)
1574: := OE_Config_Util.OE_BMX_OPTION_COMPS;
1575: l_top_item_id NUMBER;
1576: l_op_qty NUMBER;

Line 1612: ( p_validation_org => OE_SYS_PARAMETERS.VALUE

1608: FROM oe_order_lines
1609: WHERE line_id = p_top_model_line_id;
1610:
1611: OE_CONFIG_UTIL.Explode
1612: ( p_validation_org => OE_SYS_PARAMETERS.VALUE
1613: ('MASTER_ORGANIZATION_ID')
1614: , p_stdcompflag => l_stdcompflag
1615: , p_top_item_id => l_top_item_id
1616: , p_revdate => l_config_effective_date

Line 1648: AND organization_id = OE_SYS_PARAMETERS.VALUE

1644: AND explosion_type = Oe_Config_Util.OE_BMX_OPTION_COMPS
1645: AND top_bill_sequence_id = l_top_bill_sequence_id
1646: AND effectivity_date <= l_config_effective_date
1647: AND disable_date > l_config_effective_date
1648: AND organization_id = OE_SYS_PARAMETERS.VALUE
1649: ('MASTER_ORGANIZATION_ID')
1650: AND component_code = opt_rec.component_code;
1651:
1652: IF p_query_criteria in (1,2,4) THEN