APPS.OE_DS_PVT dependencies on OE_MTL_SN_INTERFACE_S
Line 1111: SELECT to_char(oe_mtl_sn_interface_s.nextval)
1107: IF (p_sn_control_code = 6) THEN
1108: IF l_debug_level > 0 THEN
1109: oe_debug_pub.add( 'in for loop s.n control code = 6' , 1 ) ;
1110: END IF; 1111: SELECT to_char(oe_mtl_sn_interface_s.nextval) 1112: INTO v_serial_number_temp
1113: FROM dual ;
1114: IF p_as_alpha_prefix is not null THEN
1115: v_serial_number := p_as_alpha_prefix || v_serial_number_temp;